| Error code for ORA-12645 (merged 3) [message #349378] |
Sat, 20 September 2008 18:41  |
casttree
Messages: 83
Registered: August 2008
|
Member |
|
|
I saw a bug which have ora-12645 exception. Looks like it is related with encryption setting in Database connection "oracle.net.encryption_client = request ", from oracle doc, looks it should be OK as long as the encryption setting of other side is not set as "rejected".
ANy suggestions to avoid the ora-12645 execptions ?
Thanks,
| Quote: |
java.sql.SQLException: Io exception: Oracle Error ORA-12645
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:286)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:327)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:429)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:150)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:608)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:217)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:158)
]
|
[Updated on: Sat, 20 September 2008 18:42] Report message to a moderator |
|
|
|
|
|
|
|
| Re: ORA-12645 and oracle.net.encryption_client setting [message #349417 is a reply to message #349394] |
Sun, 21 September 2008 11:46  |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
1/ Oracle version (4 decimals) for both side
2/
ORA-12645: Parameter does not exist.
*Cause: A sqlnet.ora parameter from which a value was needed does not
exist.
*Action: Set the parameter in the parameter file.
So I'm not sure this comes from your JDBC code. Did you try it without this parameter?
3/ Do you use thin or OCI driver?
Regards
Michel
[Updated on: Sun, 21 September 2008 11:46] Report message to a moderator |
|
|
|
|
|
| Re: ORA-12645 and oracle.net.encryption_client setting [message #349421 is a reply to message #349417] |
Sun, 21 September 2008 13:33 |
casttree
Messages: 83
Registered: August 2008
|
Member |
|
|
oracle.net.encryption_client is set as "requested" , and it works with 10g DB, but failed with 9i (use thin driver) with expection ora-12645.
So for 9i DB with thin driver, do we need to add more configuration for it?
Also how does "Oracle version (4 decimals) for both side " affect the connection?
Thanks,
|
|
|
|
|
|
| Re: ORA-12645 and oracle.net.encryption_client setting [message #349426 is a reply to message #349423] |
Sun, 21 September 2008 14:14 |
casttree
Messages: 83
Registered: August 2008
|
Member |
|
|
Oh, sorry, I thought you asked to add oracle version in sqlnet.ora in both side.
In our case, client side is 10.2.0.5 and server is 9.2.0.7. In 9I db, the configuration without oracle.net.encryption_client or sqlnet.encryption_client. I undertsnad it is Ok if one side is "requested" and the other side is "accepted " as default value.
What else need we check for 9.2.0.7, also is there log file we can check for more information (liek which parameter are missed in sqlora.net) ?
Thanks,
|
|
|
|
|
|
|
|
|
|
| Error code for ORA-12645 [message #354679 is a reply to message #349378] |
Mon, 20 October 2008 15:08 |
casttree
Messages: 83
Registered: August 2008
|
Member |
|
|
I met the exeception ORA-12645 in java code, when I tried to check the error code when exeception happened, I got the error code 17002, is th execption 17002 wrapped the ORA-12645 execption? should we check the exception error code as 17002? as I don't get 12645 from e.getErrorCode().
Thanks,
OracleDataSource ods = new OracleDataSource();
ods.setURL(url);
ods.setConnectionProperties(p);
try {
c = ods.getConnection();
}
catch (SQLException e)
{
/**********************************************
**** Hope to fix the exception for ORA-12645,
*** but when I use e.getErrorCode() to check
*** the error code of execption, it shows 17002
**************************************************/
if( (e.getErrorCode() == 17002) ) {
//Code fix the issue
} else
throw e;
}
|
|
|
|
| Check exception code for ORA-12645 [message #354866 is a reply to message #349378] |
Tue, 21 October 2008 13:13 |
casttree
Messages: 83
Registered: August 2008
|
Member |
|
|
I met the exeception message ORA-12645 when connect DB in java code, I need to add the fix only for this kind of exception.
Before I assume the error code for execption will be 12645, but when I print out the error code for exception, it shows
e.getErrorCode() is 17002
e.getSQLcode()is null
e.getMessage() is " Io exception: Oracle Error ORA-12645" ,
e.getNextException() is null.
I don't know why the error code is 17002, but not 12645 for ora-12645 execption. How can we check if I put the correct fix for ORA-12645 execption. I hope to avoid the fix which may affect other exception than 12645.
Thanks,
OracleDataSource ods = new OracleDataSource();
ods.setURL(url);
ods.setConnectionProperties(p);
try {
c = ods.getConnection();
}
catch (SQLException e)
{
/**********************************************
**** Hope to fix the exception for ORA-12645,
*** but when I use e.getErrorCode() to check
*** the error code of execption, it shows 17002
**************************************************/
if( (e.getErrorCode() == 17002) ) {
//Code fix the issue
} else
throw e;
}
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
