Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

We are getting Invalid arguments in call when we try to establish the connection with Oracle DB occasionally ( One hour in a day).

I did some research about this in Internet, still i am not getting clear understanding about the root cause of this exception.

Please note:

This is happens in PROD environment for sometime, after which its getting resolved without any code fix, the major concern here for us is that we don't have a clear understanding on its root cause.

Question 1

Invalid arguments in call : is this message talking about the connection parameters that is sent to establish connection?

Question 2 If question 1 is true, why is it happening occasionally? Its highly unlikely that our application sends different parameter for establishing connection as its a binary (Connection parameters are constant).

NOTE: Documentation for ORA-17068 this error code is not available in oracle site *EDIT:*

Complete Exception trace:

java.sql.SQLException: invalid arguments in call at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:236) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:414) at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at org.apache.tomcat.dbcp.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(DriverAdapterCPDS.java:205) at org.apache.tomcat.dbcp.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(DriverAdapterCPDS.java:150) at org.apache.tomcat.dbcp.dbcp.datasources.InstanceKeyDataSource.testCPDS(InstanceKeyDataSource.java:836) at org.apache.tomcat.dbcp.dbcp.datasources.PerUserPoolDataSource.registerPool(PerUserPoolDataSource.java:492) at org.apache.tomcat.dbcp.dbcp.datasources.PerUserPoolDataSource.getPooledConnectionAndInfo(PerUserPoolDataSource.java:382) at org.apache.tomcat.dbcp.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:701) at org.apache.tomcat.dbcp.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:676)

Thanks in advance. Subin.

share|improve this question
What Oracle server version are you connecting to and what client version? – Phil Feb 17 at 23:51
2  
To be honest, seeing as this is such an odd/rare error, you should open a support ticket with Oracle. That's why you pay the $$$$ for your support contract. – Phil Feb 18 at 0:09
@Phil Thanks for your suggestion. But do you have idea when we will get Invalid arugments in the call exception, i mean the reason ? – Subin_Learner Feb 18 at 11:05
What versions?? See my first comment. – Phil Feb 18 at 11:43
@Phil : Please find the version details Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production PL/SQL Release 11.2.0.2.0 - Production CORE 11.2.0.2.0 Production TNS for Linux: Version 11.2.0.2.0 - Production NLSRTL Version 11.2.0.2.0 - Production – Subin_Learner Feb 19 at 11:02
show 8 more comments

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.