Prev: Oracle 10g - db_recovery_file_dest and db_recovery_file_dest_size
Next: Oracle 11g: Java Stored Procedures - ORA 1031
From: G Quesnel on 5 Jan 2008 06:56 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 5 Jan 2008 10:24 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 5 Jan 2008 12:03 "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 5 Jan 2008 13:25 > > 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 5 Jan 2008 13:35
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. |