RE: Instance name different from database name
- From: Michael Dinh <mdinh@xxxxxxxxx>
- To: "martin.a.berger@xxxxxxxxx" <martin.a.berger@xxxxxxxxx>, "s.cislaghi@xxxxxxxxx" <s.cislaghi@xxxxxxxxx>
- Date: Mon, 8 Nov 2010 05:26:12 -0800
What I read from Arup Nanda is to attach a sequence to db_name if there is a
consideration for RAC.
Here is an example.
Primary means I am on the primary versus standby database.
20101108 05:23:15 SYS@proddb06:PRIMARY> show parameter name
NAME TYPE VALUE
------------------------------------ --------------------------------
----------------------------------------------------------------------------------------------------
db_file_name_convert string
db_name string db06
db_unique_name string
savvis_db06
global_names boolean FALSE
instance_name string db061
lock_name_space string
log_file_name_convert string xxx, xxx
service_names string
savvis_db06
20101108 05:23:15 SYS@proddb06:PRIMARY> col value for a80
20101108 05:23:15 SYS@proddb06:PRIMARY> col name for a30
20101108 05:23:15 SYS@proddb06:PRIMARY> SELECT NAME, VALUE FROM V$DIAG_INFO;
NAME VALUE
------------------------------
--------------------------------------------------------------------------------
Diag Enabled TRUE
ADR Base /u01/app/oracle
ADR Home /u01/app/oracle/diag/rdbms/savvis_db06/db06
Diag Trace /u01/app/oracle/diag/rdbms/savvis_db06/db06/trace
Diag Alert /u01/app/oracle/diag/rdbms/savvis_db06/db06/alert
Diag Incident
/u01/app/oracle/diag/rdbms/savvis_db06/db06/incident
Diag Cdump /u01/app/oracle/admin/db06/cdump
Health Monitor /u01/app/oracle/diag/rdbms/savvis_db06/db06/hm
Default Trace File
/u01/app/oracle/diag/rdbms/savvis_db06/db06/trace/db06_ora_8768.trc
Active Problem Count 0
Active Incident Count 0
11 rows selected.
20101108 05:23:15 SYS@proddb06:PRIMARY>
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On Behalf
Of Martin Berger [martin.a.berger@xxxxxxxxx]
Sent: Monday, November 08, 2010 4:56 AM
To: s.cislaghi@xxxxxxxxx
Cc: Oracle L
Subject: Re: Instance name different from database name
Stefano,
please try to distinguish ORACLE_SID, INSTANCE_NAME, NAME and DB_UNIQUE_NAME.
the ARD Home is $ORACLE_HOME/diag/rdbms/db_unique_name/instance_name
if you run srvctl config database -d ... -a you will get
Database unique name: xxx
Database name: yyy
...
Database instances: inst1,inst2
...
the cluster resource name is also ora.db_unique_name.db
maybe you want to try to setup a small test-DB in your cluster where
DB_NAME differs DB_UNIQUE_NAME. (and instances are per node - so they
must differ also). This will show you all the combinations and their
effects.
hth
Martin
On Mon, Nov 8, 2010 at 11:10, Stefano Cislaghi <s.cislaghi@xxxxxxxxx> wrote:
> Hi all,
>
> does anybody know, or have consireded, any implication about having an
> instance name completely different from database name?
> I want to say, instance name maybe is D0EUNAME and database is DNAME ...
>
> I'm using a 2 nodes cluster with 11gR2 grid infrastrucre and database.
> During DB creation even if I've specified an instance name database
> starts using db name and dbname is registered in clusterware.
>
> In OFA I've have /admin/DNAME/ instead maybe admin/D0EUNAME
>
> Supposing that dbname maybe equals to sid in best practices, there're
> documents that suggest and explain why and how avoid this?
>
>
> Thanks
> Stefano
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
