Re: Instance name different from database name
- From: Martin Berger <martin.a.berger@xxxxxxxxx>
- To: s.cislaghi@xxxxxxxxx
- Date: Mon, 8 Nov 2010 13:56:48 +0100
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
Other related posts:
