<<Back to DB Administration Main Page
ORA-01075: you are currently logged on while connecting to Oracle Database
$ sqlplus "/as sysdba"SQL*Plus: Release 12.1.0.2.0 Production on Thu Jan 3 13:03:23 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01075: you are currently logged on
Solution1:
Sometimes the issue can be resolved by just restarting the database.
Find the process id at OS level
$ps -ef|grep pmon
$kill -9 <PMON Process ID> <== if you have more than 1 database on the server choose the correct pmon process id, else you will make an outage for other database which you will never want
$ sqlplus "/as sysdba"
SQL> startup;
Solution2:
if solution 1 does not work.
Find the process id at OS level
$ps -ef|grep pmon
$kill -9 <PMON Process ID> <== if you have more than 1 database on the server choose the correct pmon process id, else you will make an outage for other database which you will never want
$ sqlplus "/as sysdba"
Connected to an idle instance.
SQL> create spfile from pfile;
File created.
Increase the value of sga_target
Create the spfile from pfile with increased sga_target
SQL> create spfile from pfile;
File created.
SQL> startup
ORACLE instance started.
Total System Global Area 1.0737E+10 bytes
Fixed Size 3722144 bytes
Variable Size 3581125728 bytes
Database Buffers 7113539584 bytes
Redo Buffers 39030784 bytes
Database mounted.
Database opened.
Comments
Post a Comment