Re: Production Database Open Fails after Mount

If Solaris it's either /usr/include/sys/errno.h or /usr/include/errno.h.

"Danisment Gazi Unal (ubTools)" wrote:
>
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suzy Vordos
  INET: lvordos_at_qwest.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).