Re: OCIServerAttach returns ORA-12514


"Paul" <paul.flew@xxxxxxxxxxxxxxxxx> wrote in message
news:1155491394.373445.98770@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi

I have a small C application which connects to an Oracle database using
OCI. Please find a code snippet below. I currently have a problem that
the code works when connecting to certain database instances but not to
others (its all the same server version of Oracle). I have verified
that the connection details are correct, and other applications are
able to connect to the instance that my C program cannot.

The error I get returned from OCIServerAttach is ORA-12512:
TNS:listener does not currently know of the service requested in
connect descriptor.


You are probably using an incorrect service name in your tnsnames.ora file.
But you say that "other applications are able to connect" ? What other
applications ? How do they connect ? Do they use the same tnsnames.ora file
as the C application ? Have you tried connecting to the instance with
sql*plus ?

$ sqlplus username/password@connect_identifier


.

Relevant Pages

  • RE: Connecting to more than one oracle database
    ... In order to connect to an oracle database on a different machine ... I am currently connecting to an oracle database on a different ... CONFIDENTIALITY NOTICE This e-mail and any files or attachments may contain confidential and privileged information. ...
    (perl.dbi.users)
  • Re: oracle jdbc abd OpenOffice 2.0
    ... in the course of finding out how to connect an Oracle database ... Error while connecting to data source ... error code 17002 ... Server URL: localhost ...
    (comp.databases.oracle.server)
  • Intermittend ORA-12519, TNS:no appropriate service handler found
    ... connecting via JDBC we get intermittend ORA-12519 (reflected as TNS-12519 ... wise and memory wise). ... job scheduling to check whether there might be a job that eats up ... Oracle Database 10g Enterprise Edition ...
    (comp.databases.oracle.server)
  • Connect a Web Part to an Oracle db
    ... Can someone provide sample C# code for connecting a web part to an ... Oracle database? ... A simple example would suffice eg. selecting a couple of columns from a ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: Securely getting a password from a custom app into Oracle
    ... > applications into an Oracle database. ... workstations and Postgres database servers, I dont see why this would ...
    (SecProg)