text file is usually "/usr/include/sys/errno.h" on most UNIX platforms...
----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, June 04, 2002 4:09 PM > 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" <[EMAIL PROTECTED]> > > > To: "LazyDBA.com Discussion" <[EMAIL PROTECTED]> > > > 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 [EMAIL PROTECTED] > > To subscribe: send a blank email to [EMAIL PROTECTED] > > 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 [EMAIL PROTECTED] > > To subscribe: send a blank email to [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Tim Gorman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
