RE: Production Database Open Fails after Mount

For BACKGROUND_DUMP_DEST , USER_DUMP_DEST , CORE_DUMP_DEST , alert_$SID.log gave -rwxrwxrwx (chmod 777 ) permissions All Database & Oracle Software files Owned by $ORACLE_OWNER. oracle Exe having -rwsr-s--x Permissions

Did NOT seem a Permissions Issue

-----Original Message-----
Sent: Wednesday, June 05, 2002 5:19 PM
To: VIVEK_SHARMA

error 23 is an OS I/O error..

If I remember correctly, you may want to check the following: 1. The file name's on the file system match that for Oracle 2. The permissions of the file is correct so that the database owner/processes can access the file(s)
3. The individual files may have the correct permissions, yet the parent or current directory may have the incorrect permissions.

At the end of the day-Oracle can not open the files....

Greg

-----Original Message-----
Sent: Tuesday, June 04, 2002 4:35 PM
To: LazyDBA.com Discussion

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

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