cancel
Showing results for 
Search instead for 
Did you mean: 

connect system/manager hangs

connect system/manager hangs

Hi All,
Database is up.

SQL> select NAME, OPEN_MODE from v$database;

NAME OPEN_MODE
--------- ----------
TEST1 READ WRITE


I m not able to connect directly from the sqlplus . I have to connect as nolog and then internal. But when I do
connect system/manager
its just hangs
Please help


3 REPLIES
T G Manikandan
Honored Contributor

Re: connect system/manager hangs

Hello,
check the alert log file for messages.

This will help you in identifying the problem

Re: connect system/manager hangs

If you are running multiple Oracle versions on the same box, there will be clas on the library path.

Comment out SHLIB_PATH and LD_LIBRARY_PATH
OR point to correct path and try.

Raju
Volker Borowski
Honored Contributor

Re: connect system/manager hangs

Archiver Stuck !

Check your archive-log destination for enough freespace and make sure the archiver process is running.

Volker