Start/stop of Oracle Database not wokring from <sid>adm (SAP User)

[Fred Ruffet · Accepted solution]

hmmm ? Talking to me ? ;-)

As I need to add value to the thread (not only looking for points, noooo !) :
For the next time you will do this kind of operations, have a look at Oracle utility called nid in $ORACLE_HOME/bin (dbnewid). It changes a DB Name or DB ID in a more easy and secure way than using create database order.

Regards,

Fred

[Volker Borowski]

Hi,

glad you fixed it !

Watch it, with this procedure it is NOT supported to apply any further bugfixes or patches to Oracle-SW, because the ORACLE_HOME is spread throughout the entire Oracle-Inventory in ascii and binary files.

There are OSS Notes decribing the problem.

If you have to patch after a ORACLE_HOME rename, you need to delete the entire Oracle SW AND the inventory and do a reinstall of the software do get a correct inventory!
This will takes only some 20-40 minutes.

If you stay on the SW without applying patches/bugfixes, no problem !
I'd recommend to insert a note to the login-messages for orasid, just in case you need to patch in a year or so. Otherwise you might pull out your hair for inventory-mismatch-problems.

Volker

[Lourdes Ortiz Sada]

Hi Sanjay

Im see that you have one error similar that I have in this moments...

Could you send me the document that Indira sent to you?

Best Regards =)

[Yogeeraj_1]

hi lourdes,

just click on the "attachments" icon found to the left of the post (indira's) and download it from here itself.

regards
yogeeraj

[Sanjay Kumar Suri]

Hello Sada

Please find attached is another relevant SAP Note.

sks