Oracle Instance Name changed in Local Database after that Unable to restart the Application Services.

[AbhinavSingh1]

Can somebody tell, which all configuration file we need to update the oracle Service name/Listener name. or any other suggestion.

[MHelmy]

Assuming you has been already update successfully and is already running, the look at the following files:

• Make sure the tnsnames.ora and listener.ora are point in the correct direction.
• /home/oracle/Aveksa_System.cfg will also contain the database identifier values in (ORACLE_SID, ORACLE_SERVICE_NAME, ORACLE_CONNECTION_ID).
• Finally assuming you are on wildfly then the configuration file /home/oracle/wildfly/standalone/configuration/aveksa-standalone-full.xml will contain the connection string for each datasource. It will look like this (<connection-url>jdbc:oracle:thin:@//localhost:1555/AVDB</connection-url>). Make sure it is also a valid connection string.

[AbhinavSingh1]

Thanks Mostafa. Yes we have updated the DB name in the above mentioned files, but still not able to restart the application.

Getting an error like "Cannot connect to the database. The watchdog will start the server when it can connect to the database."

Is there any other place we need to update?

[MHelmy]

What connection string did you try? Can you try the same connection string using SQL Plus and see if it works?

[AbhinavSingh1]

Hi Mostafa,

Yes, i have connected the Oracle DB local using sql client and it is working fine.

[RakheeTarar]

Hello Abhinav, 

Also System scripts may reference the Oracle SID

script name "setDeployEnv.sh"  this script located in /home/oracle/ , also in /home/admin , also in /root

[AbhinavSingh1]

Hi Rakhee,

Yes, few places we have changed and to update the other place its required root access. so will update the remaining in the setdeployEnv.sh script.