| could not resolve SERVICE_NAME given in connect descriptor [message #132257] |
Thu, 11 August 2005 10:26  |
shurley
Messages: 1
Registered: August 2005
Location: UK
|
Junior Member |
|
|
Sorry I know you've done this before. But I'm tearing my hair out with this
Just changed IP address on my SUSE Linux server to 192.168.0.11
Everything was ok before, my router is reporting the linux box as 192.168.0.11 ok. From my client PC I can ping 192.168.0.11 and TNSPING to it using Tnsping RVDP01.
As soon as I try to use ODBC from the client I get the dreaded ORA-12514 error.
My TNSNAMES.ORA ->
RVDP01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.11)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = RVDP01)
)
)
lsnrctl status on Linux box gives ->
...
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.11)(PORT=1521)))
STATUS of the LISTENER
----------------------
Alias LISTENER
...
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.11)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
PLEASE PLEASE PLEASE
I know a little knowledge is a dangerous thing ....
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
