Oracle 11 g r1
Database these days always shut down automatically library, with the sysdba after login prompt is connected to the free routine, and then execute SQL
Startup pfile='D: \ \ Administrator \ admin \ app wouldn \ pfile \ init ora. 34201814100'
Can reload the database and open, this phenomenon is the basic two or three times a week,
I want to ask is, how to find the cause of the oracle automatically closed library, don't want to again and again startup, ask everybody greatly guide

CodePudding user response:

Find alert_SID log, there are a record, probably,

CodePudding user response:

reference 1st floor wmxcn2000 response:

find alert_SID. Log, there are a record, probably,

Can you specific points, where is the file about? I haven't found in the install directory to find

CodePudding user response:

\ \ Administrator \ diag \ app RDBMS, SID, SID, trace, like

CodePudding user response:

reference 1st floor wmxcn2000 response:

find alert_SID. Log, there are a record, probably,

I found this file,
Setting the Resource Manager to plan the SCHEDULER x2c0c [0] : DEFAULT_MAINTENANCE_PLAN via the SCHEDULER window
Setting the Resource Manager plan DEFAULT_MAINTENANCE_PLAN via the parameter
OER 7451 in the Load Indicator: the Error Code=OSD - 04500: specifies the illegal options
O/S - Error: (1) OS function is not correct,!
OER 7451 in the Load Indicator: the Error Code=OSD - 04500: specifies the illegal options
O/S - Error: (1) OS function is not correct,!
Thu May 10 22:00:02 2018
Thu May 10 22:00:02 2018
Logminer Bld: Lockdown Complete. DB_TXN_SCN is UnwindToSCN (LockdownSCN) is 475355919

CodePudding user response:

I am going to reinstall the oracle, see log, for the reason, my oracle digits do not match with the server

CodePudding user response:

reference 5 floor qq_37009657 reply:

I am going to reinstall the oracle, see the log, for the reason, my oracle digits do not match with the server

The good or reinstall, CPU number does not match sometimes have a problem

CodePudding user response:

reference 5 floor qq_37009657 reply:

I am going to reinstall the oracle, see the log, for the reason, my oracle digits do not match with the server

If only to 64 - bit OS installed 32 bit oracle RDBMS software, there is no problem, because the SGA is certainly not more than 2 g, performance is problematic,

You send the content of the alert log, seemingly no instance down off before and after the content, a look again?