Re: ARG! Cannot resolve service name?????

"Chuck Carson" <chuckc_at_clinicomp.com> wrote in message news:<oVTH7.55$xW4.198763_at_news.uswest.net>...
> I have an 8.17 database running on Slaris 2.8. Here is the listener.ora
> file:
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = becka)(PORT = 1521))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> )
> )
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = /u01/app/oracle/product/8.1.7)
> (PROGRAM = extproc)
> )
> )
>
> The listener is running and I verified with netstat that it is indeed
> listenening on port 1521.
>
> I am trying to connect from a Win2K and Red Hat 7.2 machine with the 8.1.7
> client and I keep getting this:
> ERROR:
> ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
> descriptor
>
> Here is the tnsnames.ora file on the Red Hat machine:
> ERROR:
> ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
> descriptor
>
> I am trying to connect as this:
> sqlplus chuck_at_BECKA_OPS1
> I have also tried numerous other connection strings.
>
> On the Win2K machine I used the Net8 Config util to create the tnsnames file
> and same error. If I use tnsping, it works. The database host, becka, is in
> all system's hostsfile, both as a FQDN and as the alias becka. I have
> verified that it is pingable based on hostname.
>
>
> Anyone have any ideas?
>
>
> Thanks greatly,
> Chuck

Hallo Chuck
I guess that changing thie Line

OLD>      (ADDRESS_LIST =
OLD>        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

to
NEW>      (ADDRESS_LIST =
NEW>        (ADDRESS = (PROTOCOL = IPC)(KEY = PLSExtProc))

will solve your problem.

Best Regards
Jens Loebling Received on Tue Nov 13 2001 - 10:05:37 CST