Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12514 ...any idea how to resolve this ?
check if the tnsnames.ora file at your client is using is set as following::
your_host_instance_name =
(DESCRIPTION =
(SOURCE_ROUTE = OFF)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = your_host_ip)(PORT = 1521))
)
(CONNECT_DATA =
(SID = YOUR_ORACLE_INSTANCE)
)
)
HTH
SP
sidd <siddeb_at_hotmail.com> wrote in message
news:E4Q85.603$0L5.268429_at_news.uswest.net...
> When trying to test, connecting to a database form Net8 Configuration
> assisstant I am getting the following error :
>
> Connecting...ORA-12514: TNS:listener could not resolve SERVICE_NAME given
in
> connect descriptor
> The test did not succeed.
>
>
>
Received on Wed Jul 05 2000 - 00:00:00 CDT