-
PUT
-----------------------------------------------------
o ORA_SID_SHUTDOWN=true (this means it will go down when the system is going down normally.)
o ORA_SID_SHUTDOWN_TIMEOUT=30 (in secs. This is the time for which the system will wait for the OracleService to go down. After that its Shutdown abort.)
o ORA_SID_SHUTDOWNTYPE=i (for immediate) a(for abort)
---------------------------------------------------------
in regedit HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0
These are the default values. You can change them according to your needs...
where SID=SID of your database.
Amar
"There is a difference between knowing the path and walking the path."
-
Having same settings as told i.e.
ORA_SID_SHUTDOWN=true
ORA_SID_SHUTDOWN_TIMEOUT=30
ORA_SID_SHUTDOWNTYPE=i
Even then the database is not shuttingdown when I shut down the server.
Kindly note when shutdown the server I don't want to go to Control Panel-Service to stop the Oracle Service. I am looking for the method when I Shutdown the server the database will autometically shuts down.
vishal sood
OCP 8
-
Originally posted by vishal sood
Even then the database is not shuttingdown when I shut down the server.
Look in the alert log file for the following lines.
Shutting down instance: further logons disabled
Shutting down instance (immediate)
Or may be you can show the alert logfile output of last 30 lines or so...
Amar
"There is a difference between knowing the path and walking the path."
-
I would allow much more than 30 seconds for the shutdown. It's a question of how often you might have a big transaction to rollback . . . 5 minutes may not be excessive . . . it depends . . .
-
Look in your oradim.log.
If you are getting ORA-12638: Credential retrieval failed errors, it could be a problem with NTS. Oracle recommends setting sqlnet.authentication_services = (NONE) or (BEQ,NONE) if you want to keep using "/as sysdba".
It appears that if NTS isn't working properly, you can have this problem.
Good Luck!
Jodie
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|