ORA-01075 you are currently logged on


$ sqlplus "/as sysdba"
 
SQL*Plus: Release 9.2.0.1.0 - Production on Tue Mar 9 14:05:49 2010
 
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
 
ERROR:
ORA-01075: you are currently logged on

ACTION

$ echo $ORACLE_SID
SSEAST1


$ ps -ef|grep SSEAST1


 oracle1  7597     1  0 13:15:35 ?         0:00 ora_lgwr_SSEAST1
 oracle1  7595     1  0 13:15:35 ?         0:00 ora_dbw0_SSEAST1
 oracle1  7593     1  0 13:15:35 ?         0:00 ora_pmon_SSEAST1
 oracle1 20020 16013  1 14:11:15 pts/ta    0:00 grep SSEAST1
 oracle1  7601     1  0 13:15:36 ?         0:00 ora_smon_SSEAST1
 oracle1  7599     1  0 13:15:35 ?         0:00 ora_ckpt_SSEAST1
 oracle1  7603     1  0 13:15:36 ?         0:00 ora_reco_SSEAST1
 oracle1 19341     1  0 14:10:46 ?         0:00 oracleSSEAST1 (LOCAL=NO)
 oracle1  7605     1  0 13:15:36 ?         0:00 ora_cjq0_SSEAST1

$ kill -9 7593

 Solution
Killed PMON ,SMON pids

Post a Comment

And that's all there is to it!

If anyone has any other questions or requests for future How To posts, you can either ask them in the comments or email me. Please don't feel shy at all!

I'm certainly not an expert, but I'll try my hardest to explain what I do know and research what I don't know.

Previous Post Next Post