-
Hi
prod db hung. I have to shutdown abort,
but it won't shutdown and it has been 5 mins
any suggestion
Elin@trend
-
Did you try issuing shutdown immediate. The shutdown abort has to be your last option. you have to wait for some time for oracle to close the transactions.
Check your alert logs before you start the database to see what had caused the problem.
Sam
Thanx
Sam
Life is a journey, not a destination!
-
now i cant connect svrmgr30
Elin@trend
-
ctrl C / ctrl D the process window that hangs and then try connecting to svrmgrl and try issueing the abort option.
Sam
Thanx
Sam
Life is a journey, not a destination!
-
Thanks Sam.
What scared me was I did ctl-c to kill cmd prompt and started a new cmd prompt, then I lost all control of database. svrmgr no responds at all. I tried for 20 mins, then I take a risk to reboot server and this time DB is luck to back to normal. I am working with oracle tech support to see what happened to cause db became unaccessable at all.
Elin@trend
-
Did you check the alert log file. That would have logged the information on the cause. One of them could have been that you might have run out of sessions or the processes. That could be why your db looked like it had hung.
Every thing would have been revealed in the alert log file for this db instance. Check your alert log and try to make the fix.
If you need any help let us know. We would be happy to help and learn.
Sam
Thanx
Sam
Life is a journey, not a destination!
-
Hi Sam,
thank you for your help.
Mon May 07 10:50:59 2001
Completed checkpoint up to RBA [0x32a0.2.10], SCN: 0x0000.01d340fc
Mon May 07 11:08:13 2001
Errors in file F:\Orant\rdbms80\trace\ORA04175.TRC:
ORA-00600: internal error code, arguments: [KSSRMP1], [], [], [], [], [], [], []
Mon May 07 11:44:20 2001
Shutting down instance (abort)
License high water mark = 737
Mon May 07 11:49:20 2001
USER: terminating instance due to error 1092
Mon May 07 11:49:20 2001
USER: terminating instance due to error 1092
Mon May 07 11:49:21 2001
Errors in file F:\Orant\rdbms80\trace\ORA04175.TRC:
ORA-01092: ORACLE instance terminated. Disconnection forced
Mon May 07 11:49:21 2001
USER: terminating instance due to error 1092
Mon May 07 11:49:21 2001
USER: terminating instance due to error 1092
Mon May 07 11:49:21 2001
USER: terminating instance due to error 1092
Mon May 07 11:49:21 2001
CKPT: terminating instance due to error 1092
Mon May 07 11:49:21 2001
LGWR: terminating instance due to error 1092
Mon May 07 11:49:22 2001
USER: terminating instance due to error 1092
Mon May 07 11:49:22 2001
USER: terminating instance due to error 1092
Mon May 07 11:49:22 2001
USER: terminating instance due to error 1092
Mon May 07 11:49:22 2001
PMON: terminating instance due to error 1092
Mon May 07 11:49:23 2001
USER: terminating instance due to error 1092
Mon May 07 11:49:23 2001
USER: terminating instance due to error 1092
Mon May 07 11:49:23 2001
DBW0: terminating instance due to error 1092
Mon May 07 11:49:23 2001
USER: terminating instance due to error 1092
Mon May 07 11:49:24 2001
USER: terminating instance due to error 1092
Mon May 07 11:49:50 2001
Instance terminated by PMON, pid = 383
Dump file F:\Orant\rdbms80\trace\berpALRT.LOG
I also noticed that before db hung, I issued the cmd
"select ... from v$pwfile_users" and get error then it was about the same time my db hung..... Could this cause the problem?
If you need to see .trc file, I will send it over to you.
Thanks in advance.
Elin@trend
-
-
Hi sam,
it is funny, I asked the question "how to check who has sysdba privs" and I become a vicitim.........
Elin@trend
-
Make sure that you don't make the mistake again.
Watch out in the future
Sam
Thanx
Sam
Life is a journey, not a destination!
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
|