From: Ray Stell <stellr@cns.vt.edu>
To: ?????? <jwchoi@modernlimes.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: How I do from PostgreSQL to Oracle Db Link
Date: Mon, 6 Jun 2011 08:33:16 -0400
Message-ID: <20110606123316.GA4391@cns.vt.edu> (raw)
On Sat, Jun 04, 2011 at 10:05:46AM +0900, ?????? wrote:
>
> ERROR: odbclink: unsuccessful SQLConnect call: [S1000] [12514]
>
> [[unixODBC][Oracle][ODBC][Ora]ORA-12514: TNS:listener does not currently
> know of service requested in connect descripto
>
$ oerr ora 12514
12514, 00000, "TNS:listener does not currently know of service requested in connect descriptor"
// *Cause: The listener received a request to establish a connection to a
// database or other service. The connect descriptor received by the listener
// specified a service name for a service (usually a database service)
// that either has not yet dynamically registered with the listener or has
// not been statically configured for the listener. This may be a temporary
// condition such as after the listener has started, but before the database
// instance has registered with the listener.
// *Action:
// - Wait a moment and try to connect a second time.
// - Check which services are currently known by the listener by executing:
// lsnrctl services <listener name>
// - Check that the SERVICE_NAME parameter in the connect descriptor of the
// net service name used specifies a service known by the listener.
// - If an easy connect naming connect identifier was used, check that
// the service name specified is a service known by the listener.
// - Check for an event in the listener.log file.
sounds like you got to the listener, but didn't tell it the correct service name in
the connect string. Did you spell it correctly? You can use the oracle cmd
lsnrctl status on the oracle server to get the service names.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: stellr@cns.vt.edu, jwchoi@modernlimes.com
Subject: Re: How I do from PostgreSQL to Oracle Db Link
In-Reply-To: <20110606123316.GA4391@cns.vt.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox