Re: Production Database Open Fails after Mount

Hi,

As I remember "Error Num 23" is OS error code. Contact your system admin. There should be a text file which defines OS error codes.

VIVEK_SHARMA wrote:

> Solved
>
> Database OPENed Successfully on another HP-UX Box Without any ORA-1092
> The Same Oracle & OS Versions Existed on Both HP-UX Boxes .
>
> NOTE Though ORA-1092 was often succeeded by the message :-
> "Error Num 23"
> NO Idea what Error Num 23 Stands for ?
> Thus This seems to be Some OS /Hardware Issue with the Previous Production Database
> on which the Database would NOT Open after OS RE_Installation .
>
> For Problem Details Go Below .
> For Complete Details Either E-mail me Or See Tar Nums - 2263888.995 , 9505435.7
> (If accessible)
>
> Thanks to All & List
>
> Vivek
>
> -----Original Message-----
> Sent: Monday, June 03, 2002 11:57 PM
> To: LazyDBA.com Discussion
>
> Hi Gopal,List
>
> What are those UNdocumented Events ?
>
> Thanks again
>
> Vivek
>
> -----Original Message-----
> Sent: Monday, June 03, 2002 4:51 PM
> To: LazyDBA.com Discussion
>
> Vivek:
>
> I guess SMON runs the command to get the details for regular cleanup.
> You can use few undocumented events to get the things done depending
> on the seriousness of the database. These events just asks the SMON to
> skip few things during recovery and pretty harmless.
>
> Best Regards,
> K Gopalakrishnan
>
> >
> >
> > ----- Original Message -----
> > From: "VIVEK_SHARMA" <VIVEK_SHARMA_at_infosys.com>
> > To: "LazyDBA.com Discussion" <oracledba_at_lazydba.com>
> > Sent: Monday, June 03, 2002 4:29 PM
> > Subject: RE: Production Database Open Fails after Mount
> >
> >
> > Problem Still Existing .
> >
> > ora_3263.trc file :-
> >
> > ORA-01092: ORACLE instance terminated. Disconnection forced
> >
> > Current SQL statement for this session:
> > select line#, sql_text from bootstrap$ where obj# != :1
> >
> > "bootstrap$" seems to tbe the CAUSE .
> >
> > Any Advice ?
> >
> > 1) "STATUS" in V$LOG shows 2 Groups as INACTIVE & the 3rd as CURRENT
> > NOTE - Log Switches are Happening even in Mount State due to
> > some internal Database Activity at the rate of about 5 Switched in 12
> Hours
> > .
> > Size of Redo Logfile = 5M
> >
> > 2) RECOVER DATABASE UNTIL CANCEL Succeeds , But "ALTER DATABASE OPEN
> > RESETLOGS" Also Fails
> > with ORA-1092 like "ALTER DATABASE OPEN"
> >
> > 3) We Created a SMALL Dummy Database on the Same machine using the Same
> > ORACLE_HOME which
> > we were able to open eith the Same SGA as the Production Database . Thus
> > Prima-facie the O.S.
> > & Oracle S/w seem OK . We relinked the network & rdbms Components of
> Oracle
> > 7.3.4.0
> > too though
> >
> > 4) Due to Root Disk Crash OS was RE-Installed , But Oracle Software
> Existed
> > Existed on another
> > Hard Disk & was Simply Mounted back without any Change after the OS
> > RE-Installation
> >
>
> --------
> Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> To subscribe: send a blank email to oracledba-subscribe_at_LAZYDBA.com
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
> --------
> Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> To subscribe: send a blank email to oracledba-subscribe_at_LAZYDBA.com
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: VIVEK_SHARMA
> INET: VIVEK_SHARMA_at_infosys.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

--
Danisment Gazi Unal
http://www.ubTools.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (ubTools)
  INET: dunal_at_ubTools.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).