ORA-12514: TNS:listener could not resolve SERVICE_NAME

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 Received on Mon Jun 23 2003 - 19:00:18 CEST