Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-01031
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 GroupReceived on Fri Sep 22 2006 - 10:01:18 CDT
![]() |
![]() |