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).
