| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Production Database Open Fails after Mount
Possibly yes
It would depend on how many datafiles in the "small" db compared to the
production db, I am guessing that the nfile and maxfile values you have
are too low for a production server.
Cheers
This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.
"VIVEK_SHARMA" <VIVEK_SHARMA_at_infosys.com>
Sent by: root_at_fatcity.com
05-06-2002 03:53 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Fax to:
Subject: RE: Production Database Open Fails after Mount
Kirthi
NOTE Point 3) (Bottom) We were able to OPEN a Small Dummy Database on the Failing Production Server .
If the system wide limit for the number of simultaneously open files is
exceeded
Would the Dummy Database OOEN Either ?
NOTE nfile = 200
max_files = 200
Approx 75 User processes All inclusive would exist on the machine
Thanks for responding
-----Original Message-----
Sent: Wednesday, June 05, 2002 5:58 AM
To: Multiple recipients of list ORACLE-L
Vivek,
You are right, this is an OS related issue, but a DBA must be aware of why
it happens ;)
Error 23 means 'File Table Overflow' and it is generated when the system
wide limit for the number of simultaneously open files is exceeded. It is
controlled by a kernel parameter 'nfile'. which defaults to a value
arrived
at by a formula that uses 'maxusers' (and a couple of other) kernel
parameters. You can check the values set for 'maxusers' and 'nfile' on
these
servers, and get your SA to increase those on the server where you had a
problem starting the database.
Use '/usr/sbin/kmtune -q <parameter>' command to check currently set value for 'nfile' and 'maxusers'.
Read more about 'nfile' at
http://docs.hp.com/hpux/onlinedocs/os/KCparam.Nfile.html.
HTH,
-----Original Message-----
Sent: Wednesday, June 05, 2002 3:11 AM
To: Multiple recipients of list ORACLE-L
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). -- 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).Received on Wed Jun 05 2002 - 01:23:19 CDTContent-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification. --=_mixed 001D3CEE4A256BCF_=-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Peter.McLarty_at_mincom.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).
- application/octet-stream attachment: STG61193
 |
 |