Re: Changing ORACLE_SID
From: Daren & Windy Davis <daren.davis_at_worldnet.att.net>
Date: 1997/12/09
Message-ID: <66l6pm$jhm_at_bgtnsc01.worldnet.att.net>#1/1
Date: 1997/12/09
Message-ID: <66l6pm$jhm_at_bgtnsc01.worldnet.att.net>#1/1
The oracle SID is kept in an environment variable ( usually something like ORACLE_SID ). To change this, shutdown the database instance completely, change and export the value of the variable ( this is a standard unix function ), and then restart the instance.
Caution, if you are using an external password file to track admin logins, you may need to recreate the password file so it matches the new SID. The SID is part of the name of the file, and you can forget trying to rename the file directly. It doesn't work.
Hope this helps. Received on Tue Dec 09 1997 - 00:00:00 CET