11g upgrade - DBUA0 instance

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: Sat, 5 Jan 2008 03:56:56 -0800 (PST)
Message-ID: <1626dec8-2e53-46d5-81df-7e9ffc5146b0@i7g2000prf.googlegroups.com>


Could someone tell me what is this DBUA0 instance ?

I am playing around with Suse Linux 10.2, using dbua to upgrade a 10.2 instance to 11g. The instance is pretty basic, it doesn't even have the sample schemas installed and partitioning is the only extra featured installed. OEM was configured to run locally. Everything upgrades fine (with one small error that I ignore - ORA-04023: Object Sys.Standard could not be validated) and all objects are valid after the upgrade.

I have a couple of instances on my server, but I shut them all down while I do the upgrade on one instance - called "play". I am really puzzle by what looks like a new instance/DB being created by the upgrade process. "ps -ef|grep oracle" brings back

oracle    9578     1  0 Jan04 ?        00:00:00 ora_pmon_DBUA0
oracle    9580     1  0 Jan04 ?        00:00:00 ora_vktm_DBUA0
oracle    9584     1  0 Jan04 ?        00:00:00 ora_diag_DBUA0
oracle    9586     1  0 Jan04 ?        00:00:00 ora_dbrm_DBUA0
oracle    9588     1  0 Jan04 ?        00:00:00 ora_psp0_DBUA0
oracle    9592     1  0 Jan04 ?        00:00:02 ora_dia0_DBUA0
oracle    9594     1  0 Jan04 ?        00:00:00 ora_mman_DBUA0
oracle    9596     1  0 Jan04 ?        00:00:00 ora_dbw0_DBUA0
oracle    9598     1  0 Jan04 ?        00:00:00 ora_lgwr_DBUA0
oracle    9600     1  0 Jan04 ?        00:00:00 ora_ckpt_DBUA0
oracle    9602     1  0 Jan04 ?        00:00:00 ora_smon_DBUA0
oracle    9604     1  0 Jan04 ?        00:00:00 ora_reco_DBUA0
...
There is no reference in /etc/oratab
There is one file in $ORACLE_HOME/dbs ... hc_DBUA0.dat When I connect to the database in sqlplus, I get a message that the instance is not up.
I am wondering if this could be a special instance (somewhat similar to +ASM), but I can't find any information about it in tahiti or metalink.

Comments, clues or opinions would be appreciated Thanks. Received on Sat Jan 05 2008 - 05:56:56 CST

Original text of this message