Listener / tnsnames problems
Date: Thu, 04 Apr 2002 13:14:08 +0000
Message-ID: <FmYq8.1378$dX4.84779_at_weber.videotron.net>
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 Received on Thu Apr 04 2002 - 15:14:08 CEST