From: "David" <davidnomorespam@fishy.ca>
Subject: Listener / tnsnames problems
X-Newsreader: Pyne 0.6.7 (Debian/GNU/Linux)
Content-Type: text/plain
MIME-Version: 1.0
Lines: 70
Newsgroups: comp.databases.oracle
Message-ID: <FmYq8.1378$dX4.84779@weber.videotron.net>
Date: Thu, 04 Apr 2002 13:14:08 +0000
NNTP-Posting-Host: 24.200.52.43
X-Complaints-To: abuse@videotron.ca
X-Trace: weber.videotron.net 1017926181 24.200.52.43 (Thu, 04 Apr 2002 08:16:21 EST)
NNTP-Posting-Date: Thu, 04 Apr 2002 08:16:21 EST


Hi,
	It seems I'm having some problems connecting to my Oracle server I've just
setup. I'm trying to connect while being on the same machine as the server,
however I would like to go through the network as I will want to grant access
to users over the network in the near future.

Although I doubt it makes a difference, I have to state I am using Linux:
Debian Woody with kernel 2.4.17 and my host name is "Fish".

Here are the values of some environment variables that are set:
ORACLE_HOME=/u01/app/oracle/product/8.1.7.0.1
ORACLE_SID=linux817

I've done multiple searches on google and based on what I found, I've constructed
the following listener.ora file:

====BEGIN HERE====
TEST=
        (ADDRESS_LIST=
                (ADDRESS=
                        (PROTOCOL=TCP)
                        (HOST=Fish)
                        (PORT=1521)
                )
        )

SID_LIST_TEST=
        (SID_LIST=
                (SID_DESC=
                        (SID_NAME=linux817)
                        (ORACLE_HOME=/u01/app/oracle/product/8.1.7.0.1)
                )
        )
====END HERE====


And here is my tnsnames.ora:

====BEGIN HERE====
Test =
(DESCRIPTION =
        (ADDRESS_LIST =
                (ADDRESS =
                        (PROTOCOL = TCP)
                        (HOST = 127.0.0.1)
                        (PORT = 1521)
                )
        )
        (CONNECT_DATA = (SID = linux817)
        )
)
====END HERE====

I'm using TOra (Toolkit Oracle) to connect to the oracle instance and I always
get an error: ORA-12154. I did some research on it and it seems that such
a problem would steem from the tnsnames.ora or by me not using the correct
name for the database while trying to connect.

With the above in mind, I've tried every possible string I could think of
as the database name (linux817, db, test, Test, TEST, Fish, fish, FISH) but
still none of them work.

I'm simply out of ideas and a bit frustrated. If anyone has an idea of what's
the problem, it would be extremely appreciated if you could 
reply and take out the "nomorespam" from my email address.

Thanks in advance!

David