Re: 11g upgrade - DBUA0 instance

"DA Morgan" <damorgan_at_psoug.org> schreef in bericht news:1199546644.73637_at_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

DA,

all objects ARE valid (as pointed out by the OP). It could not be VALIDATED. I don't think a sys.standard error will put one up with an extra instance (or did you get one when you invalidated it a while ago by trying to recompile it?).

GQ
Look like some post install action failed. Have googled around but no info about this. Are you using SLES (Enterprise Server?)

Shakespeare Received on Sat Jan 05 2008 - 11:03:36 CST