|
|
| Re: Reasons for database hanging [message #51414 is a reply to message #51413] |
Wed, 22 May 2002 04:52   |
Alex
Messages: 190
Registered: August 1999
|
Senior Member |
|
|
Hi,
More info please.
1) What are you doing when it hangs i.e. shutdown/startup etc
2) Oracle version & Platform
3) Are any dumps produced.
4) One or all sessions
5) Can you login in as sys or system
6) Any messages in the alert file
7) One or all sessions hang
|
|
|
|
|
|
|
|
| Re: Reasons for database hanging [message #53792 is a reply to message #51413] |
Fri, 11 October 2002 04:44 |
Maria
Messages: 57
Registered: August 1999
|
Member |
|
|
1) What are you doing when it hangs i.e. shutdown/startup etc
connect internal
shutdown abort
startup mount
database recover
alter database open;
..... it hangs... :((
2) Oracle version & Platform
8.1.7 Linux RedHat 6.2
6) Any messages in the alert file
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
Fri Oct 11 16:33:28 2002
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 1 Seq 16956 Reading mem 0
Mem# 0 errs 0: /u01/app/oracle/oradata/ROSTOV/redo05.log
Fri Oct 11 16:33:33 2002
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 2717 redo blocks read
Crash recovery completed successfully
Fri Oct 11 16:33:35 2002
Thread 1 advanced to log sequence 16957
Thread 1 opened at log sequence 16957
Current log# 2 seq# 16957 mem# 0: /u01/app/oracle/oradata/ROSTOV/redo06.log
Successful open of redo thread 1.
Fri Oct 11 16:33:35 2002
SMON: enabling cache recovery
SMON: enabling tx recovery
Thread 1 advanced to log sequence 16958
Current log# 4 seq# 16958 mem# 0: /u01/app/oracle/oradata/ROSTOV/redo04.log
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
