Home » RDBMS Server » Server Administration » chaning of SID oracle Database
chaning of SID oracle Database [message #487872] Mon, 03 January 2011 01:29 Go to next message
oradba123
Messages: 86
Registered: June 2009
Location: india
Member

Hi all,

i do know how change the database but can any one assist me how to chnage SID of database which in windows 2003 server?, thanks i advance., quick response will be higly appreciated.



BEST REGARDS

Re: chaning of SID oracle Database [message #487880 is a reply to message #487872] Mon, 03 January 2011 01:55 Go to previous message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just change the ORACLE_SID value when you start the database (if you start it locally) and change the name of the parameter file, if you don't want to name it on "startup" command.

Regards
Michel
Previous Topic: ORA-00600: LibraryCacheNotEmptyOnClose
Next Topic: oracle installation (merged 6)
Goto Forum:
  


Current Time: Wed May 08 02:36:10 CDT 2024