Re: ORA-12514: TNS:listener could not resolve SERVICE_NAME

Michael John wrote:
> Hi again,
>
> when trying to create an new database with Database Configuration
> Assistant, i'm getting "ORA-12514: TNS:listener could not resolve
> SERVICE_NAME".
>
> this is my listener.ora:
>
> # LISTENER.ORA Network Configuration File: listener.ora
> # Generated by Oracle configuration tools.
>
> LISTENER =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = freudenspender)(PORT = 1521))
> )
>
> my sqlnet.ora:
>
> # SQLNET.ORA Network Configuration File: sqlnet.ora
> # Generated by Oracle configuration tools.
>
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
>
> NAMES.DIRECTORY_PATH= (TNSNAMES)
>
> and finally, this is my tnsnames.ora:
>
> # TNSNAMES.ORA Network Configuration File: tnsnames.ora
> # Generated by Oracle configuration tools.
>
> ORA9 =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = freudenspender)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = ora9)
> (INSTANCE_NAME = fsp)
> )
> )
>
> a call of "lsnrctl status" states:
>
> Verbindung mit (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=freudenspender)(PORT=15
> 21))) wird aufgebaut
> STATUS des LISTENER
> ------------------------
> Alias LISTENER
> Startdatum 22-JUN-2003 15:33:50
> Uptime 1 Tage 3 Std. 22 Min. 10 Sek.
> Trace-Ebene off
> Sicherheit OFF
> SNMP OFF
>
> so, i suppose, there must be a configuration problem in tnsnames.ora.
>
> again, any hints?
> TIA,
> Michael

It depends.
It depends.
It might involve
either an initSID.ora parameter involving DOMAIN or it might involve sqlnet.ora & DOMAIN name in it.

Then again, it might be something else.

HTH & YMMV HAND! Received on Tue Jun 24 2003 - 02:11:25 CEST