From: G Quesnel on
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.
From: DA Morgan on
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(a)x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
From: shakespeare on

"DA Morgan" <damorgan(a)psoug.org> schreef in bericht
news:1199546644.73637(a)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(a)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


From: G Quesnel on
>
> GQ
> Look like some post install action failed.
> Have googled around but no info about this. Are you using SLES (Enterprise Server?)
>
> Shakespeare

I "think" I am using SLES - I downloaded Suse 10.2 from Novell (free
download)
and installed the server version (with lots of extra software).
After some tinkering, both 10g and 11g databases run on it.
From: G Quesnel on
Just a clarification.
The PLAY instance is in good shape in 11g. All objects are valid.
I was trying out Stream, to simulate an upgrade with virtually no down
time
(1. WORK instance -> stream/replication -> PLAY instance , both at 10g
2. suspend stream
3. upgrade PLAY database instance to 11g
4. restart stream )
And it all looks good - the DML happening in WORK during the 11g
upgrade was passed on to PLAY afterward.

I am just curious as to what is this new DBUA0 instance.
It probably wont be there when I reboot the server.