Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: export utility question -

Re: export utility question -

From: DRODRIGU1 <drodrigu1_at_aol.com>
Date: 2000/08/05
Message-ID: <20000805112959.19491.00001680@ng-cn1.aol.com>#1/1

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:        

  1. Shutdown the instance
  2. Backup all control, redo, and data files.
  3. Go through the .profile, .cshrc, .login, oratab, tnsnames.ora,
    (for SQL*Net version 2), and redefine the ORACLE_SID environment
    variable to a new value.

      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 created  

(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.
Received on Sat Aug 05 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US