Re: ORA-12560: TNS:protocol adapter error

From: GC <johnny_sanga_at_hotmail.com>
Date: Mon, 27 Dec 1999 00:42:45 GMT
Message-ID: <3866B669.F89C5C90@hotmail.com>

Roger Li wrote:
>
> Hi,
> When I installed Oracle 8i on PC, and I can connect DB from local using by
> "sqlplus system/manager".
> But after I restart this local machine, I can not connect DB using by
> "sqlplus system/manager" forever. I alwyas met oracle error :
> ORA-12560: TNS:protocol adapter error .....
> I only can connect DB by connect string :
> "sqlplus system/manager_at_o8test" (o8test is defined in tnsnames.ora)
> Can anybody tell me why?? Do I need set some environemnt ???
> (I had used Oracle Home selector to change Oracle Home,
> but it fail !!! )
>
> Roger Li

Are you running multiple instances? If so, run 'set ORACLE_SID=[whatever the instance name you want to connect to]' This will allow you to connect to that instance without the @ connect string.

Cheers,
GC Received on Sun Dec 26 1999 - 18:42:45 CST