Re: sqlldr / as sysdba

From: Vsevolod Afanassiev <vafanassiev_at_yahoo.com>
Date: 21 Apr 2005 00:54:54 -0700
Message-ID: <1114070094.145384.107870@l41g2000cwc.googlegroups.com>

ORACLE_SID and database name do not have to be the same - this is just a convention to avoid confusion. On UNIX ORACLE_SID is used for: 1. Locating init.ora file in $ORACLE_HOME/dbs (also for other files like password file). 2. Appending SID to "ora_" or "oracle" when starting Oracle processes.

Shut down the instance, change ORACLE_SID by doing "export ORACLE_SID=test" (depending on the shell), and create symbolic link in $ORACLE_HOME/dbs pointing to the real init.ora Then start the instance. It will start under new name.

Database name is something you specify in CREATE DATABASE (or CREATE CONTROLFILE) statement, it gets written to datafile headers. To change database name you need to change value in init.ora (db_name = ) and execute CREATE CONTROLFILE. Received on Thu Apr 21 2005 - 02:54:54 CDT