| ORA-01089: immediate shutdown in progress - no operations are permitted [message #150125] |
Tue, 06 December 2005 08:01  |
tkiran4u
Messages: 13
Registered: December 2005
|
Junior Member |
|
|
Hi,
We have a database job running continuously in our Oracle 9i database.But suddenly it stopped for a while and shown the below message and started automatically.
ORA-01089: immediate shutdown in progress - no operations are permitted
Can anybody throw some light on this.
Thanks in advance.
|
|
|
|
|
|
|
|
|
|
| Re: ORA-01089: immediate shutdown in progress - no operations are permitted [message #150155 is a reply to message #150148] |
Tue, 06 December 2005 09:50  |
tkiran4u
Messages: 13
Registered: December 2005
|
Junior Member |
|
|
I don't have required privileges to see the log. I am requesting my superior for the alert_<SID>.log. Will putforth my queries once I get it.
By the way, can an oracle database instance itself get restarted? If so, what are the possible scenarios? If a process os running for very long time/expends much of the memory, will that situation lead to restarting the database? Sorry if my doubts are silly/stupid.
Thanks for your patience.
|
|
|
|
|
|
|
|
|
|
| Re: ORA-01089: immediate shutdown in progress - no operations are permitted [message #150675 is a reply to message #150216] |
Fri, 09 December 2005 00:34 |
tkiran4u
Messages: 13
Registered: December 2005
|
Junior Member |
|
|
Hi,
This is the alert log, when the database was restarted.
Can anybody help me.
Fri Dec 2 12:38:01 2005
Shutting down instance: further logons disabled
Fri Dec 2 12:38:03 2005
Completed checkpoint up to RBA [0x39fe.2.10], SCN: 0x0783.7362939d
Fri Dec 2 12:38:03 2005
Shutting down instance (immediate)
License high water mark = 140
Fri Dec 2 12:38:06 2005
ALTER DATABASE CLOSE NORMAL
Fri Dec 2 12:38:07 2005
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Dec 2 12:38:07 2005
Shutting down archive processes
Archiving is disabled
Fri Dec 2 12:38:07 2005
ARCH shutting down
Fri Dec 2 12:38:07 2005
ARCH shutting down
Fri Dec 2 12:38:07 2005
ARC0: Archival stopped
Fri Dec 2 12:38:07 2005
ARC1: Archival stopped
Fri Dec 2 12:38:07 2005
Thread 1 closed at log sequence 14846
Successful close of redo thread 1
Fri Dec 2 12:38:08 2005
Completed: ALTER DATABASE CLOSE NORMAL
Fri Dec 2 12:38:08 2005
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Dec 2 12:38:54 2005
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.5.0.
System parameters with non-default values:
processes = 300
timed_statistics = TRUE
resource_limit = TRUE
shared_pool_size = 268435456
shared_pool_reserved_size= 26214400
large_pool_size = 16777216
java_pool_size = 167772160
nls_date_format = HH24:MI DD/MM/YYYY
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
