Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
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