Home » Other » General » ORA-00604/ORA-12705
ORA-00604/ORA-12705 [message #431551] Wed, 18 November 2009 01:33 Go to next message
kia_s_ce
Messages: 5
Registered: November 2009
Junior Member
Hi !!
I have a java application by JDBC that will convert two database in two machine...
Destination have Windows XP and oracle 10g, and source have linux and oracle 10g. I run my jar on destination. When i run my jar project i see this exceptions :

java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-12705: invalid or unknown NLS parameter value specified

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthentica
te.java:785)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:362)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:
414)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtensio
n.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.ptm.coding.convert.DBConnection.getOldConnection(DBConnection.jav
a:73)
at com.ptm.coding.convert.DBConnection.getOldStatement(DBConnection.java
:88)
at com.ptm.coding.convert.Initial.getSizeOfIndivcoding(Initial.java:234)

at com.ptm.coding.convert.Initial.<clinit>(Initial.java:18)
at Main.main(Main.java:23)
Exception in thread "main" java.lang.ExceptionInInitializerError
at Main.main(Main.java:23)
Caused by: java.lang.NullPointerException
at com.ptm.coding.convert.DBConnection.getOldStatement(DBConnection.java
:88)
at com.ptm.coding.convert.Initial.getSizeOfIndivcoding(Initial.java:234)

at com.ptm.coding.convert.Initial.<clinit>(Initial.java:18)
... 1 more

And when i query nls_database_parameters of source i see:

PARAMETER VALUE

NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET AR8MSWIN1256
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 9.2.0.1.0

I havent enough time, Please help me!!!

thanks.


Re: ORA-00604/ORA-12705 [message #431554 is a reply to message #431551] Wed, 18 November 2009 02:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12705: Cannot access NLS data files or invalid environment specified
 *Cause: Either an attempt was made to issue an ALTER SESSION command
         with an invalid NLS parameter or value; or the environment
         variable(s) NLS_LANG, ORA_NLSxx, or ORACLE_HOME was incorrectly
         specified, therefore the NLS data files cannot be located.
 *Action: Check the syntax of the ALTER SESSION command and the NLS
          parameter, correct the syntax and retry the statement, or
          specify the correct directory path/values in the environment
          variables.

Regards
Michel
Re: ORA-00604/ORA-12705 [message #431556 is a reply to message #431554] Wed, 18 November 2009 02:17 Go to previous messageGo to next message
kia_s_ce
Messages: 5
Registered: November 2009
Junior Member
Thanks for attention Michel,
But how i can check and set NLS parameters?
When i run my app in Windows how the Oracle of Source recognize my NLS parameter, charcterset,....??
Regards
Kia
Re: ORA-00604/ORA-12705 [message #431560 is a reply to message #431556] Wed, 18 November 2009 03:17 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ From NLS_LANG and other NLS environment parameters
2/ From registry

Regards
Michel
Previous Topic: Oracle Clinical
Next Topic: error ora-03113
Goto Forum:
  


Current Time: Thu Mar 28 06:20:39 CDT 2024