ORA-01075: you are currently logged on

My mongouard was unable to log on to the Oracle database because of a ora-600 error that caused the slave machine to hang.

Refer:

Symptom
[Root @ skate01 ~] # Su-oracle
[Oracle @ skate01 ~] $ Sqlplus "/as sysdba"

SQL * Plus: Release 11.2.0.2.0 Production on Tue Feb 21 00:26:35 2012

Copyright (c) 1982,201 0, Oracle. All rights reserved.

ERROR:
ORA-01075: you are currently logged on

[Oracle @ skate01 ~] $

 

In order to quickly log on to oracle and quickly start oracle, this provides a method that is extremely violent.

1. Use the kill command in Linux to kill all oracle-related processes.
$ Ps-ef | grep $ ORACLE_SID | grep-v grep | awk '{print $2}' | xargs kill-9

2. Use the Linux ipcs and ipcsrm commands to release the shared memory occupied by oracle
$ Ipcs-m | grep oracle | awk '{print $2}' | xargs ipcrm shm

 

Procedure:
[Root @ skate01 ~] # Su-oracle
[Oracle @ skate01 ~] $ Sqlplus "/as sysdba"
SQL * Plus: Release 11.2.0.2.0 Production on Tue Feb 21 00:35:11 2012

Copyright (c) 1982,201 0, Oracle. All rights reserved.

ERROR:
ORA-01075: you are currently logged on

Enter user-name: sys
Enter password:
ERROR:
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x838000020], [], [],
[], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x838000020], [], [],
[], [], [], [], [], [], [], []

[Oracle @ skate01 ~] $
[Oracle @ skate01 ~] $

Kill oracle-related processes
[Oracle @ skate01 ~] $ Ps-ef | grep $ ORACLE_SID | grep-v grep | awk '{print $2 }'
1562
1564
1566
1570
1572
1574
1576
1578
1580
1582
1584
1586
1588
1592
1594
1596
3781
3862
3864
3866
3868
10085
10861
12321
12325
12327
12329
12331
12333
12335
12337
12339
12341
25253
25255
25311
29661

[Oracle @ skate01 ~] $ Ps-ef | grep $ ORACLE_SID | grep-v grep
Oracle 1562 1 0 2011? 00:01:38 ora_pmon_skate01
Oracle 1564 1 0 2011? 00:00:05 ora_psp0_skate01
Oracle 1566 1 0 2011? 00:00:00 ora_vktm_skate01
Oracle 1570 1 0 2011? 00:00:00 ora_gen0_skate01
Oracle 1572 1 0 2011? 00:00:15 ora_diag_skate01
Oracle 1574 1 0 2011? 00:00:00 ora_dbrm_skate01
Oracle 1576 1 0 2011? 05:27:59 ora_dia0_skate01
Oracle 1578 1 0 2011? 00:00:04 ora_mman_skate01
Oracle 1580 1 21 2011? 14 to 07:36:04 ora_dbw0_skate01
Oracle 1582 1 0 2011? 00:04:16 ora_lgwr_skate01
Oracle 1584 1 0 2011? 00:13:26 ora_ckpt_skate01
Oracle 1586 1 0 2011? 00:00:38 ora_smon_skate01
Oracle 1588 1 0 2011? 00:00:00 ora_reco_skate01
Oracle 1592 1 0 2011? 00:32:15 ora_mmnl_skate01
Oracle 1594 1 0 2011? 00:00:00 ora_d000_skate01
Oracle 1596 1 0 2011? 00:00:00 ora_s000_skate01
Avahi 3781 1 0 2011? 00:00:00 avahi-daemon: registering [skate01.local]
Oracle 3862 1 0 2011? 01:21:24 ora_arc0_skate01
Oracle 3864 1 0 2011? 01:20:30 ora_arc1_skate01
Oracle 3866 1 0 2011? 00:00:19 ora_arc2_skate01
Oracle 3868 1 0 2011? 01:20:49 ora_arc3_skate01
Oracle 10861 1 0 Feb20? 00:00:00 ora_mmon_skate01
Oracle 12321 1 0 2011? 00:00:01 ora_mrp0_skate01
Oracle 12325 1 4 2011? 3 To 00:19:33 ora_pr00_skate01
Oracle 12327 1 0 2011? 02:39:29 ora_pr01_skate01
Oracle 12329 1 0 2011? 02:21:16 ora_pr02_skate01
Oracle 12331 1 0 2011? 02:29:30 ora_pr03_skate01
Oracle 12333 1 0 2011? 02:30:53 ora_pr04_skate01
Oracle 12335 1 0 2011? 02:34:36 ora_pr05_skate01
Oracle 12337 1 0 2011? 02:17:54 ora_pr06_skate01
Oracle 12339 1 0 2011? 02:24:47 ora_pr07_skate01
Oracle 12341 1 0 2011? 02:22:16 ora_pr08_skate01
Oracle 25253 1 1 2011? At 18:28:18 oracleskate01 (LOCAL = NO)
Oracle 25255 1 0 2011? At 00:00:03 oracleskate01 (LOCAL = NO)
Oracle 25311 1 0 2011? At 00:02:45 oracleskate01 (LOCAL = NO)
Oracle 29661 1 0 Jan24? At 00:00:08 oracleskate01 (LOCAL = NO)

[Oracle @ skate01 ~] $ Ipcs-m | grep oracle | awk '{print $2 }'
2818055
[Oracle @ skate01 ~] $ Ps-ef | grep $ ORACLE_SID | grep-v grep | awk '{print $2}' | xargs kill-9
Kill 3781: Operation not permitted

1 2 Next Page