Thursday, 21 December 2017

ORA-01075: you are currently logged on

ERROR:

ORA-01075: you are currently logged on


ACTION:

~$ echo $ORACLE_SID
PROD

~$ ps -ef | grep prod

oracle    1943     1  0 23:16 ?        00:00:00 ora_pmon_prod

oracle    1947     1  0 23:16 ?        00:00:00 ora_psp0_prod

oracle    1951     1  0 23:16 ?        00:00:02 ora_vktm_prod

oracle    1957     1  0 23:16 ?        00:00:00 ora_gen0_prod

oracle    1961     1  0 23:16 ?        00:00:00 ora_diag_prod

oracle    1965     1  0 23:16 ?        00:00:00 ora_dbrm_prod

oracle    1969     1  0 23:16 ?        00:00:00 ora_dia0_prod

oracle    1973     1  0 23:16 ?        00:00:00 ora_mman_prod

oracle    1977     1  0 23:16 ?        00:00:00 ora_dbw0_prod

oracle    1981     1  0 23:16 ?        00:00:03 ora_lgwr_prod

oracle    1985     1  0 23:16 ?        00:00:00 ora_ckpt_prod


~$ kill -9 1943                    ( Solution: killed PMON,SMON pids )

$ sqlplus / as sysdba

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

No comments:

Post a Comment

relink a single executable (binary file) using ADADMIN utility

In this post, I would like to write something useful for patching and fine-tuning. When times, we have to relink a particular binary file ...