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

[michael ngong]

michael.john@gm x.at (Michael John) wrote in message news:<90cc4edd. 0306230900.2807 5193@posting.go ogle.com>...

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.AUTHENTI CATION_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=(A DDRESS=(PROTOCO L=TCP)(HOST=fre udenspender)(PO RT=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

MIchael
I you stated the OS and platform that could make it easier to address your issue

Michael Tubuo Ngong

[Michael John]

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

mngong@yahoo.co m (michael ngong) wrote:

I you stated the OS and platform that could make it easier to address your issue

Win 2000 Prof build 2195 SP 3

best regards,
Michael