We are currently updating our Oracle Databse and moving it to a different server. The name of the database will remain the same but the server name will be diferent. What would I have to do in order to reconnect the app (server) to the new database serve?

Hi Hetter,

If all that you are changing is the database server and all other information (database name, Oracle user ID, password ) will stay the same all you should need to do is edit your Oracle Service Name configuration in Oracle Net Manager on the application server to point to the new Server name. Once that is done go to eB System Management Console , right click on your eB Data Source and select "Test Connection". That will first test the Database connection and then the eB connection using COM+ to confirm all is correct.

Thank you for your help. I have another question/concern in that I am now being prompted put in a "new identifier" to ensure data integrity. Also how will coms++ play into this? Again thank you for your time

Hi Hetter,

The new identifier is to "sync" the application server entries with the new database server. This is normal when you link to new DB server. After this change is done , test the Community connection and that will confirm the COM+ objects are connecting properly.

Hi Hetter,

The new identifier is to "sync" the application server entries with the new database server. This is normal when you link to new DB server. After this change is done , test the Community connection and that will confirm the COM+ objects are connecting properly.

Thank you again for your help. I am having troubles getting COM+ to connect. I have tested the database and it is communicating but when testing the app through eB managment console it fails. Any suggestions?

Hetter, I assume your db server is a separate machine than the eB app server? In that case please make sure your COM+ package's identity is set to a domain account with local admin rights to both servers.

HTH

Thank you again. COM+ is set to a domain account. Should I restart services and if so what order would I use?

The order should be (1) stop eb manager service, (2) shut down the eB Insight COM+ package, (3) restart the eb manager service. No need to start the COM+ package. It will be started automatically.