我的环境时redhat5 + oracle10g
在linux中运行一个jar包,jar的作用是连接到数据库,并从数据库中导入有关数据.
使用java -jar 123.jar,但系统报如下错误,请各位哥哥姐姐帮帮忙,分析一下. 我怀疑是字符集的问题,可就是不知道怎么解决,谢谢大家了.
[oracle@server2 jingfenfile]$ java -jar WriteFile.jar
??????
2009?05?14? 11?20?13?
path = /jingfenfile
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:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:277)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:784)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:361)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:413)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:164)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:752)
at java.sql.DriverManager.getConnection(libgcj.so.7rh)
at java.sql.DriverManager.getConnection(libgcj.so.7rh)
at dmt.DBConn.ConnectionManager.getConnection(ConnectionManager.java:136)
at dmt.DBConn.DBConnection.Query(DBConnection.java:46)
at dmt.service.Service.getflag(Service.java:21)
at dmt.action.write.writestaticI(write.java:17)
at dmt.action.WriteFile.write(WriteFile.java:28)
at dmt.action.WriteFile.main(WriteFile.java:143)
Exception in thread "main" java.lang.NullPointerException
at dmt.DBConn.DBConnection.Query(DBConnection.java:47)
at dmt.service.Service.getflag(Service.java:21)
at dmt.action.write.writestaticI(write.java:17)
at dmt.action.WriteFile.write(WriteFile.java:28)
at dmt.action.WriteFile.main(WriteFile.java:143)
在linux中运行一个jar包,jar的作用是连接到数据库,并从数据库中导入有关数据.
使用java -jar 123.jar,但系统报如下错误,请各位哥哥姐姐帮帮忙,分析一下. 我怀疑是字符集的问题,可就是不知道怎么解决,谢谢大家了.
[oracle@server2 jingfenfile]$ java -jar WriteFile.jar
??????
2009?05?14? 11?20?13?
path = /jingfenfile
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:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:277)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:784)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:361)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:413)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:164)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:752)
at java.sql.DriverManager.getConnection(libgcj.so.7rh)
at java.sql.DriverManager.getConnection(libgcj.so.7rh)
at dmt.DBConn.ConnectionManager.getConnection(ConnectionManager.java:136)
at dmt.DBConn.DBConnection.Query(DBConnection.java:46)
at dmt.service.Service.getflag(Service.java:21)
at dmt.action.write.writestaticI(write.java:17)
at dmt.action.WriteFile.write(WriteFile.java:28)
at dmt.action.WriteFile.main(WriteFile.java:143)
Exception in thread "main" java.lang.NullPointerException
at dmt.DBConn.DBConnection.Query(DBConnection.java:47)
at dmt.service.Service.getflag(Service.java:21)
at dmt.action.write.writestaticI(write.java:17)
at dmt.action.WriteFile.write(WriteFile.java:28)
at dmt.action.WriteFile.main(WriteFile.java:143)
[oracle@server2 jingfenfile]$ echo $NLS_LANG
American.America.ZHS16GBK
[oracle@server2 jingfenfile]$ 我查了数据库的字符集
select * from nls_database_parameters
其中
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CHARACTERSET ZHS16GBK和linux系统的字符集一样啊.大家再帮帮我吧,谢谢大哥大姐了.
请问大家,要连接数据库,是否linux和oracle中的NLS_LANG参数一致才可以?
Oracle Content Services - Version: 10.1.2.2 to 10.1.2.3
This problem can occur on any platform.Symptoms
Applying Content Services patch 10.1.2.3 (Patch # 5049515) fails with the following error:--
*********************** Starting SetRecordCutOffDateAttribute
***********************
SetRecordCutOffDateAttribute script started...
Failed, IfsException in execute():
language
java.sql.SQLException: ORA-12705: invalid or unknown NLS parameter value
specified
.
language
java.sql.SQLException: ORA-12705: invalid or unknown NLS parameter value
specified
.
.
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:315)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:281)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:638)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:560)
at
085)
at
oracle.ifs.server.LibraryConnection.alterSessionLanguage(LibraryConnection.jav
a:741)
at
oracle.ifs.server.LibraryConnection.setSessionLanguage(LibraryConnection.java:
490)
at oracle.ifs.server.S_Search.open(S_Search.java:292)
at
oracle.ifs.server.S_LibrarySession.DMOpenSearch(S_LibrarySession.java:6957)
at oracle.ifs.beans.LibrarySession.DMOpenSearch(LibrarySession.java:13081)
at oracle.ifs.beans.Search.open(Search.java:541)
at oracle.ifs.beans.Search.open(Search.java:500)
at oracle.ifs.beans.Search.open(Search.java:452)
at
oracle.ifs.ecm.upgrade.v10_1_2_2_0.SetRecordCutOffDateAttribute.getRecordsMiss
ingCutoffDate(SetRecordCutOffDateAttribute.java:223)
at
oracle.ifs.ecm.upgrade.v10_1_2_2_0.SetRecordCutOffDateAttribute.execute(SetRec
ordCutOffDateAttribute.java:73)
at
oracle.ifs.admin.actions.LibrarySessionAction.perform(LibrarySessionAction.jav
a:228)
at oracle.ifs.utils.action.ActionQueue.performActions(ActionQueue.java:303)
at oracle.ifs.utils.action.ActionQueue.run(ActionQueue.java:229)
at java.lang.Thread.run(Thread.java:534)
.
Failed = oracle.ifs.utils.action.ActionFailedException:
language
java.sql.SQLException: ORA-12705: invalid or unknown NLS parameter value
specified
.
oracle.ifs.utils.action.ActionFailedException:
language
java.sql.SQLException: ORA-12705: invalid or unknown NLS parameter value
specified
.
at
oracle.ifs.admin.actions.LibrarySessionAction.perform(LibrarySessionAction.jav
a:235)
at oracle.ifs.utils.action.ActionQueue.performActions(ActionQueue.java:303)
at oracle.ifs.utils.action.ActionQueue.run(ActionQueue.java:229)
at java.lang.Thread.run(Thread.java:534)
oracle.ifs.utils.action.ActionFailedException:
language
java.sql.SQLException: ORA-12705: invalid or unknown NLS parameter value
specified
.
at
oracle.ifs.admin.actions.LibrarySessionAction.perform(LibrarySessionAction.jav
a:235)
at oracle.ifs.utils.action.ActionQueue.performActions(ActionQueue.java:303)
at oracle.ifs.utils.action.ActionQueue.run(ActionQueue.java:229)
at java.lang.Thread.run(Thread.java:534)
language
java.sql.SQLException: ORA-12705: invalid or unknown NLS parameter value
specified
.
.
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:315)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:281)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:638)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:560)
at
085)
at
oracle.ifs.server.LibraryConnection.alterSessionLanguage(LibraryConnection.jav
a:741)
at
oracle.ifs.server.LibraryConnection.setSessionLanguage(LibraryConnection.java:
490)
at oracle.ifs.server.S_Search.open(S_Search.java:292)
at
oracle.ifs.server.S_LibrarySession.DMOpenSearch(S_LibrarySession.java:6957)
at oracle.ifs.beans.LibrarySession.DMOpenSearch(LibrarySession.java:13081)
at oracle.ifs.beans.Search.open(Search.java:541)
at oracle.ifs.beans.Search.open(Search.java:500)
at oracle.ifs.beans.Search.open(Search.java:452)
at
oracle.ifs.ecm.upgrade.v10_1_2_2_0.SetRecordCutOffDateAttribute.getRecordsMiss
ingCutoffDate(SetRecordCutOffDateAttribute.java:223)
at
oracle.ifs.ecm.upgrade.v10_1_2_2_0.SetRecordCutOffDateAttribute.execute(SetRec
ordCutOffDateAttribute.java:73)
at
oracle.ifs.admin.actions.LibrarySessionAction.perform(LibrarySessionAction.jav
a:228)
at oracle.ifs.utils.action.ActionQueue.performActions(ActionQueue.java:303)
at oracle.ifs.utils.action.ActionQueue.run(ActionQueue.java:229)
at java.lang.Thread.run(Thread.java:534)
.
.
--Changes
No changes were done since installationCause
From sqlplus run the following command: SELECT value FROM NLS_SESSION_PARAMETERS WHERE PARAMETER = 'NLS_LANGUAGE'; It returns a value other than "AMERICAN". Most likely reason for this is the OS locale was not set correctly when Content Services was installed.Solution
1.Go into Enterprise Manager and follow the links:2.Farm - apps tier - Content - Service Configurations -3.Search for "DefaultLanguage"4.Ensure that is set to AMERICAN5.Apply patch now.