OraFAQ Forum: General » ORA-00604/ORA-12705

Home » Other » General » ORA-00604/ORA-12705

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00604/ORA-12705 [message #431551]

Wed, 18 November 2009 01:33

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.

Report message to a moderator

Re: ORA-00604/ORA-12705 [message #431554 is a reply to message #431551]

Wed, 18 November 2009 02:00

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: ORA-00604/ORA-12705 [message #431556 is a reply to message #431554]

Wed, 18 November 2009 02:17

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

Report message to a moderator

Re: ORA-00604/ORA-12705 [message #431560 is a reply to message #431556]

Wed, 18 November 2009 03:17

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ From NLS_LANG and other NLS environment parameters
2/ From registry

Regards
Michel

Report message to a moderator

Previous Topic:	Oracle Clinical
Next Topic:	error ora-03113

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 15:45:22 CST 2024