Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-01031

Re: ORA-01031

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 22 Sep 2006 08:01:18 -0700
Message-ID: <1158937276.932772@bubbleator.drizzle.com>


calms wrote:
> Hi All,
> I installed the SQL Instant Client and tested the connection, it
> succeeds. But connection fails through my application, prompting the
> above error.
>
> Databse Name : FLAGDB
>
> TNSNAMES.ORA
> ==============================
> # tnsnames.ora Network Configuration File:
> C:\instantClient10_1\tnsnames.ora
> # Generated by Oracle configuration tools.
>
> FLAGDB =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 172.168.88.249)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = FLAgDB)
> )
> )
>
> ==============================
>
> SQLNET.ORA
> ==============================
> # sqlnet.ora Network Configuration File:
> C:\instantClient10_1\sqlnet.ora
> # Generated by Oracle configuration tools.
>
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
>
> NAMES.DIRECTORY_PATH= (TNSNAMES)
>
> ==============================
>
> thks
>
> Prasad.N.M

The install succeeds or is it the connection to SQL*Plus that succeeds? What are the values of ORACLE_SID and ORACLE_HOME when running the application that fails?

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group
Received on Fri Sep 22 2006 - 10:01:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US