Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
Hi James,
Here is my SQLNET.ORA
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
I do not use a domain setting
Chris
"James Williams" <techsup_at_mindspring.com> wrote in message
news:3b7440d6.171092640_at_nntp.mindspring.com...
> On Fri, 10 Aug 2001 12:04:41 -0500, "Christophe S. Borg"
> <chris.borg_at_messageone.com> wrote:
>
> Shouldn't it bee select from table_at_dblink. XXX in your example is the
> next service name. If you named it the same in both places I would
> check my SQLNET.ORA to review my domain setting.
>
> >Hi,
> >
> >I have verified tnsnames.ora,....
> >
> >XXX =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = 123)(PORT = 1521))
> > )
> > (CONNECT_DATA =
> > (SERVICE_NAME = XXX)
> > )
> > )
> >
> >I am able to TNSPING to 123
> >I am able to create the database link but when I try to connect with
"select
> >* from user.tbl_at_XXX" I get the above error.
> >
> >Thanks in advance for the help
> >Chris
> >
> >Note: Net services and host name conciled for security reasons
> >
> >
>
Received on Fri Aug 10 2001 - 15:44:26 CDT