topic Re: sqlplus prompt not displayed until return key hit. in Operating System - HP-UX

sqlplus prompt not displayed until return key hit.

Hai Nguyen_1 — Fri, 20 Dec 2002 21:06:42 GMT

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

Re: sqlplus prompt not displayed until return key hit.

Aashish Raj — Fri, 20 Dec 2002 22:52:38 GMT

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

Re: sqlplus prompt not displayed until return key hit.

Yogeeraj_1 — Sat, 21 Dec 2002 04:43:03 GMT

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

Re: sqlplus prompt not displayed until return key hit.

T G Manikandan — Sat, 21 Dec 2002 05:46:56 GMT

Yes,

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

REvert

Re: sqlplus prompt not displayed until return key hit.

Hai Nguyen_1 — Mon, 23 Dec 2002 15:19:06 GMT

Folks,

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

Best Regards,
Hai