Jdbc-Oci7 Error!

Jdbc-Oci7 Error!

Post by Sanjay Talrej » Thu, 15 Jan 1998 04:00:00



Hi!

I am trying to connect to Personel Oracle 7.3.2 database on NT 4.0 using
JDBC oci7 drivers from Oracle.

When running the JdbcCheckup program included in the installation kit ,
I
get errors of ORA-12705  ' invalid or unknown NLS parameter value
specified.

There is a connection made to oracle, because for an invalid
username/password
it exits with ORA-01017 ie invalid username/password; logon denied.

Do I need to set some NLS environment variables or ..?

I would appreciate for all the help!

- Sanjay

 
 
 

1. Get error when using jdbc/oci7

Hi,

        I work on SOLARIS2.5 (client).
        I try to connect with a NTserver 4.0 + oracle 7.3

        I got this when i try to run an example with jdbc/oci7 :

-- oracle.jdbc.oci7.OCIDBException: Error while trying to retrieve text
for error ORA-12154
 at oracle.jdbc.oci7.OCIDBAccess.check_error(OCIDBAccess.java:1365)
 at oracle.jdbc.oci7.OCIDBAccess.logon(OCIDBAccess.java:150)
 at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:93)
 at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:146)
 at java.sql.DriverManager.getConnection(DriverManager.java:90)
 at java.sql.DriverManager.getConnection(DriverManager.java:132)
 at Employee.main(Employee.java:22)

        And i've found a file : sqlnet.log in which i read :

***********************************************************************
Fatal OSN connect error 12546, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=oracle)(ARGV0=oracle)(ARGS='(DESCR
IPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PRO
GRAM=)(HOST=ipnsub)(USER=marec))))

  VERSION INFORMATION:
        TNS for Solaris: Version 2.3.3.0.0 - Production
        Oracle Bequeath NT Protocol Adapter for Solaris: Version
2.3.3.0.0 - Pro
duction
  Time: 09-JUL-97 17:48:03
  Tracing not turned on.
  Tns error struct:
    nr err code: 12206
    TNS-12206: Message 12206 not found; No message file for
product=NETWORK, fac
ility=TNS
    ns main err code: 12546
    TNS-12546: Message 12546 not found; No message file for
product=NETWORK, fac
ility=TNS
    ns secondary err code: 12560
    nt main err code: 516
    TNS-00516: Message 516 not found; No message file for
product=NETWORK, facility=TNS
    nt secondary err code: 13
    nt OS err code: 0

        HOW CAN I MODIFY THE TNS ATTRIBUTES ??????

Marec Erwan
IPN Orsay - Service Informatique
Bat 100A  - 91406 Orsay cedex.
01-69-15-51-89
+33-1-69-15-51-89

2. Help: Oracle 8.0.5 for NT

3. JDBC OCI7 Oracle driver

4. Copwatch database

5. Help with JDBC OCI7

6. Help Creating SQL Statement ...

7. Oracle OCI7 JDBC driver requires listener?

8. Team development environment for Progress V7/V8

9. JDBC and Oracle OCI7

10. Oracle JDBC-OCI7-driver throws SQLException: Exhausted Resultset

11. Oracle JDBC oci7 drivers having problems with NLS???

12. JDBC multi Connections in servlets with OCI7 driver