Re: Can't connect to remote database

The fact that a "...._at_something" works and a "....nothing" doesn't strongly suggests that it is your tnsnames.ora that is up the spout.

The further fact that your ORACLE_SID is set to ORCL, but you then seek a connection to something called DB1 is also interesting -what the hell are you actually trying to connect to???!! Your Instance is clearly called DB1, yet you expect an unqualified connect string to somehow magically know that you are trying to connect to DB1, when the thing which provides the default Instance name (ORACLE_SID) is set to something completely different.

So: Step 1. If there really is an Instance called ORCL to which you wish to connect, it needs to be referenced in your tnsnames.ora (host, port and SID would do for a start).

Step 2. If there ISN'T an ORCL Instance, and the real thing is called DB1, try changing your ORACLE_SID environment variable to read DB1 (in Unix, type "export ORACLE_SID=DB1", no spaces, no quotes).

Remember: ORACLE_SID merely provides the default Instance name to which unqualified connect strings should attempt a connection. Either you rely on ORACLE_SID, or you use the @Something syntax to provide an explicit Instance Name to which a connection should be made.

Regards
HJR <paul_rogers6_at_my-deja.com> wrote in message news:95lqa0$b3m$1_at_nnrp1.deja.com...
> Dear All
>
> I have the following problem trying to connect to a remote database.
>
> The remote database is running Oracle 8.0 on an NT4 SP6 server.
>
> The client is running Oracle 8.1.7 on a linux Red Hat 6.0 2.2.5 server
>
> The install seems ok and I have set the following environment variables
>
>
> LD_LIBRARY_PATH=/oracle/home/OraHome1/lib
> ORACLE_BASE=/oracle/home/OraHome1
> ORACLE_HOME=/oracle/home/OraHome1
> ORACLE_SID=ORCL
> PATH=/oracle/home/OraHome1/bin:$PATH
>
>
> If I run sqlplus and enter the user as "user1"
> I get exactly the same error messages.
>
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
> Linux Error: 2: No such file or directory.
>
> If, however I enter the user as "user_at_db1" it works fine.
>
> There is obviuosly some thing wrong with my client installation. I did
> manage to find the error messages on the oracle web site but they are
> not particularly helpful.
>
> Does any one have any ideas what the problem is?
>
> Many thanks
>
> Paul
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Mon Feb 05 2001 - 03:32:02 CST