Re: Role of ORACLE_SID?

Frank wrote:
> Volker Hetzer wrote:
>> Hi!
>> I've been debugging a log on problem for the last few days and I
> D:\oracle\817\bin>set ORACLE_SID=web920
> D:\oracle\817\bin>sqlplus system/manager
> SQL*Plus: Release 8.1.7.0.0 - Production on Thu May 22 20:52:33 2003
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
> ERROR:
> ORA-12560: TNS:protocol adapter error
> Enter user-name:
> D:\oracle\817\bin>type sqlnet.log

Looks about what I get, only with a different error number. Anyways:

> (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleweb920)(ARGS='
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=web920)(C
> ID=(PROGRAM=D:\oracle\817\bin\SQLPLUS.EXE)(HOST=CS-FRANK02)(USER=frankbo))))
This beq-stuff is what I get from the trace too.

> So, it does not network, and cannot be used for remote connections.
Thanks for making that clear.
Seems I set the oracle support onto a wild goose chase.

Thanks a lot!!
Volker

--
While it is a known fact that programmers
never make mistakes, it is still a good idea
to humor the users by checking for errors at
critical points in your program.
-Robert D. Schneider, "Optimizing INFORMIX
 Applications"