Re: sqlplus hangs

We had something similar here after a DB reboot recently. From particular workstations, some users could log in, others could not (I was in the NOT class on MY computer - bummer!). We spent a few hours running around and around trying to figure out what the problem was, even resorting to calling Oracle tech support.

I finally found a solution/workaround to the problem. In tnsnames.ora (or your equivalent Net8 configuration file) check the CONNECT_DATA portion.

Set to CONNECT_DATA = (SERVICE_NAME = name) would fail.

Set to CONNECT_DATA = (SID = name) worked!

According to our DBA types, we never had service name running so it should never have worked. All I know is I connected until the DB reboot and could only reconnect when I changed to SID=!

Bruce

EnderW wrote:

> Hi,
> I am on a an HP-UX with oracle 7.3.4 system. From one unix user id, I
> can log on to the database fine. From another, sqlplus simply hangs
> there ? What could be so radically different to cause that ? Oracle
> uses its own user creation mechanism. I supply the same userid/logon
> from both logins. Thnx
>
> --
> Ender Wiggin
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Jan 19 2000 - 15:55:54 CST