ORACLE_SID , DB_NAME , INSTANCE_NAME
JhilDec 4 2012 — edited Dec 14 2012Hello DBAs
Greeting to all ;
Some confusions with ORACLE DB Creation.
MY CONFUSIONS :-
I did n't mention ORACLE_SID name in 'init.ora' file.
I am very clear with ORACLE_SID=INSTANCE_NAME i.e. INSTANCE_NAME defaults to ORACLE_SID.
*[oracle@localhost ~]$ echo $ORACLE_SID*
test
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
test
SQL> select name from v$database;
NAME
---------
TEST
This is my confusion , when they may differ ? ( SID_NAME , DB_NAME )
ORACLE_SID may be or may not be the same as the database name.
Someone said :-
" DB_NAME value should be the same as the value of the ORACLE_SID environment variable "
but i disagree above statement.
Regards
Thiyagusham .G
Edited by: 952909 on Dec 4, 2012 11:39 AM
Edited by: 952909 on Dec 4, 2012 11:40 AM
Edited by: 952909 on Dec 4, 2012 11:41 AM
Edited by: 952909 on Dec 6, 2012 5:55 AM
Edited by: 952909 on Dec 12, 2012 6:07 AM