Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

sqlplus prompt not displayed until return key hit.

SOLVED
Go to solution
Hai Nguyen_1
Honored Contributor

sqlplus prompt not displayed until return key hit.

Folks,

I have a two-node cluster running HP-UX 11.0. By default, Oracle (version 8.1.6) runs on the primary node. When I entered the following command at command prompt as Oracle user, I got different results.

# sqlplus user/password@$ORACLE_SID

One the primary node, the command would hang at the number 2 as if it was waiting for some input which I had to hit the enter key to get a sqlplus prompt. Whereas, on the secondary node, a sqlplus prompt was displayed right away and this was what I expected. Have anyone seen this hanging sqlplus? Please help. Thanks.

Hai
4 REPLIES
Aashish Raj
Valued Contributor
Solution

Re: sqlplus prompt not displayed until return key hit.

Hi,

What happens if you just give
sqlplus user/pass on the primary node.

Is the file $ORACLE_HOME/sqlplus/glogin.sql same on both boxes.

Thanks
AR

Yogeeraj_1
Honored Contributor

Re: sqlplus prompt not displayed until return key hit.

hi hai,

what happens when you do the following:

sqlplus /nolog

then

SQL> connect user/password@ORACLE_SID


Please let us know.

Best Regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
T G Manikandan
Honored Contributor

Re: sqlplus prompt not displayed until return key hit.

Yes,

Please check your glogin.sql file at $ORACLE_HOME/sqlplus/admin
This is the initialization file when invoking sqlplus.

REvert
Hai Nguyen_1
Honored Contributor

Re: sqlplus prompt not displayed until return key hit.

Folks,

Thanks for your help. The problem is fixed and the root cause is the inconsistency of the glogin.sql files.

Best Regards,
Hai