shutdown abort

[elintrend]

Hi

prod db hung. I have to shutdown abort,
but it won't shutdown and it has been 5 mins

any suggestion

[sambavan]

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

[elintrend]

now i cant connect svrmgr30

[sambavan]

ctrl C / ctrl D the process window that hangs and then try connecting to svrmgrl and try issueing the abort option.

Sam

[elintrend]

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.

[sambavan]

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

[elintrend]

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.

[sambavan]

The ORA-1092 was due to the abort that you had issued. The problem could have been very much due to the select on the password file.

Wasn't there a thread earlier today, that discussed about the functionality problems on this select option?


Here is that thread for your reference:
http://dbasupport.com/forums/showthr...threadid=10301

Check the trace file and it would give you some information on what caused exactly the problem, but it i sonly oracle who can analyze the trace dump F:\Orant\rdbms80\trace\ORA04175.TRC


Sam

[Edited by sambavan on 05-07-2001 at 05:36 PM]

[elintrend]

Hi sam,

it is funny, I asked the question "how to check who has sysdba privs" and I become a vicitim.........

[sambavan]

Make sure that you don't make the mistake again.


Watch out in the future

Sam