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>
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