| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12560: TNS:protocol adapter error
Try to set the environment Variable ORACLE_SID.
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
--
 |
 |