Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: export utility question -
That is the database instance name.
I suppose the next question is how do you change it. Following are the steps
to do it.
hope it helps.
DR
Modifying a database to run under a new ORACLE_SID:
For example, search through disks and do a grep ORACLE_SID *
4. Change locations to the "dbs" directory
% cd $ORACLE_HOME/dbs
and rename the following files:
o init<sid>.ora (or use pfile to point to the init file.) o control file(s). This is optional if you do not rename any of the controlfiles, and the control_files parameter is used. The "control_files" parameter is set in the "init<SID>.ora" file or in a file it references with the ifile parameter. Make sure that the control_files parameter does not point to old file names, if you have renamed them. o "crdb<sid>.sql" & "crdb2<sid>.sql", This is optional. These are only used at database creation.
5. Change locations to the "rdbms/admin" directory
% cd $ORACLE_HOME/rdbms/admin and rename the file: o startup<sid>.sql. This is optional. On some platforms, this file may be in the "$ORACLE_HOME/rdbms/install" directory. Make sure that the contents of this file do not reference old init<SID>.ora files that have been renamed. This file simplifies the "startup exclusive" process to start your database. 6. To rename the database files and redo log files, you would follow the instructions in [NOTE:9560.1].
7. Change the ORACLE_SID environment variable to the new value.
8. Check in the "$ORACLE_HOME/dbs" directory to see if the password
file has been enabled. If enabled, the file "orapw<OLD_SID>" will exist and a new password file for the new SID must be createdReceived on Sat Aug 05 2000 - 00:00:00 CDT
(renaming the old file will not work). If "orapw<OLD_SID>" does not
exist, skip to step 9. To create a new password file, issue the following command as oracle owner: orapwd file=orapw<NEWSID> password=?? entries=<number of users to be granted permission to start the database instance> 9. Start up the database and verify that it works. Once you have done this, shutdown the database and take a final backup of all control, redo, and data files. 10. When the instance is started, the control file is updated with the current ORACLE_SID.