By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,854 Members | 856 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,854 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Jun 27 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Jun 27 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.