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

[michael ngong]

mi**********@gmx.at (Michael John) wrote in message news:<90**************************@posting.google. 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.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=freudens pender)(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

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

Michael Tubuo Ngong

[Michael John]

mn****@yahoo.com (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