-
Hello
I have 8.0.5 and 8.1.6 running on a NT machine.
I am trying to get 8.1.6 so that can connect to the db's that the 8.0.4 version can connect to.
There is no problem accessing db through the 804 version but cant access anything through 8.1.6
I have entered the appropriate tns entries but still get
ERROR:
ORA-12154: TNS:could not resolve service name
I can not get both of the listeners to start and am not sure if i have set the 8.1.6 listener up to allow two listeners to run.
I have supplied the listener files.
What steps do i need to take to get this problem solved
Thanks for any help you can offer
RJ
8.1.6 listener.ora file
ORACLEORACLEHOME816LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraking)(PORT = 1521))
)
)
ORACLETNSLISTENER80 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraking)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = oraking)(PORT = 1521))
)
)
8.0.5 listener.ora file
LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = oracle.world))
(ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(ADDRESS = (COMMUNITY = NMP.world)(PROTOCOL = NMP)(SERVER = ORAKING)(PIPE = ORAPIPE))
(ADDRESS = (PROTOCOL = TCP)(Host = oraking)(Port = 1521))
(ADDRESS = (PROTOCOL = TCP)(Host = oraking)(Port = 1526))
(ADDRESS = (PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))
(ADDRESS = (PROTOCOL=IPC)(KEY=RCV))
)
-
Don't know if this helps any or not, but in addition to starting the second listener on a different port than the first, you have to specify the name in the start command. So for the 8.1.6, set PORT=1522 (or any free port) in listener.ora, then try to start with:
lsnrctl start ORACLEORACLEHOME816LISTENER
Also, after upgrading from 8.0.5 to 8.1.6 on Sun, I was receiving the same ORA-12154 error when using sqlnet. However, commenting out the NAMES.DEFAULT_DOMAIN parameter in sqlnet.ora fixed this problem (suggestion taken from oracle doc #114085.1).
Good luck.
[Edited by lake612 on 12-14-2000 at 11:55 AM]
-
database links use TNSNAMES.ORA, what is important is to check TNSNAMES.ORA.
Use 2 different ports as well
-
Yes, you're right Pando, and I should have mentioned that too. However, in my case, my tnsnames.ora was correct and I never had to change it. Just removing that one parameter from sqlnet.ora completely solved my problem. But Rejoe could have a completely different problem than me. Anyway, that doc I mentioned gives many ways to troubleshoot the ORA-12154 error.
-
Hello
thanks for the help so far have manager to get the 816 listener running but still cannot get it to connect to other remote db's . i get this errror.
ERROR:
ORA-12154: TNS:could not resolve service name
I copied over my tns file from 805 which does connect the other remote db's so i think this is correct.
Any ideas on what is wrong.
Thanks
Rejoe
-
that simply means your tnsnames.ora is incorrect. DONT use tnsnames.ora from 8.0.5 for 8.1.6
