Re: ORA-12514: TNS:listener could not resolve SERVICE_NAME
From: rob <rob_at_dsdelft.nl>
Date: Wed, 25 Jun 2003 13:20:45 +0200
Message-ID: <bdc0ig$4h8$1_at_news.tudelft.nl>
)
)
Date: Wed, 25 Jun 2003 13:20:45 +0200
Message-ID: <bdc0ig$4h8$1_at_news.tudelft.nl>
John,
I think the problem is in your listener.ora.
> # LISTENER.ORA Network Configuration File: listener.ora
> # Generated by Oracle configuration tools.
>
> LISTENER =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = freudenspender)(PORT = 1521))
> )
Where is your SID List section?
You've defined a listener but there are no databases services configured in
it.
On UNIX using netmgr GUI adding a new database service to your listener adds
something like the following to your listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = Oracle8.dto.tudelft.nl) (ORACLE_HOME = /app/oracle/product/9.2.0) (SID_NAME = ORCL)
)
)
HTH
Rob.
Received on Wed Jun 25 2003 - 13:20:45 CEST