Re: 11g upgrade - DBUA0 instance

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 05 Jan 2008 07:24:29 -0800
Message-ID: <1199546644.73637@bubbleator.drizzle.com>


G Quesnel wrote:
> 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.

I suspect your upgrade failed. SYS.STANDARD not being valid is no small matter and could have caused numerous things to go poorly. I would suggest opening an SR at metalink.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sat Jan 05 2008 - 09:24:29 CST

Original text of this message