Home » RDBMS Server » Security » Error code for ORA-12645 (merged 3)
Error code for ORA-12645 (merged 3) [message #349378] Sat, 20 September 2008 18:41 Go to next message
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 #349386 is a reply to message #349378] Sun, 21 September 2008 01:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In sqlnet.ora the parameter is SQLNET.ENCRYPTION_CLIENT.
"oracle.net.encryption_client" is a JDBC parameter.

Regards
Michel
Re: ORA-12645 and oracle.net.encryption_client setting [message #349394 is a reply to message #349386] Sun, 21 September 2008 05:53 Go to previous messageGo to next message
casttree
Messages: 83
Registered: August 2008
Member
Yeah, our issue is generated from JDBC.

There are several parameters related with encryption_client. How can we find what what is exactly missed or caused for "ORA-12645: Parameter does not exist"?
Re: ORA-12645 and oracle.net.encryption_client setting [message #349417 is a reply to message #349394] Sun, 21 September 2008 11:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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 #349418 is a reply to message #349417] Sun, 21 September 2008 11:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I forgot
4/ The 4 valid values are:
accepted
rejected
requested
required
"request" is not a valid value

Regards
Michel
Re: ORA-12645 and oracle.net.encryption_client setting [message #349421 is a reply to message #349417] Sun, 21 September 2008 13:33 Go to previous messageGo to next message
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 #349423 is a reply to message #349421] Sun, 21 September 2008 13:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Also how does "Oracle version (4 decimals) for both side " affect the connection?

Maybe one option is not valid for a version in one side.
So it is MANDATORY to ALWAYS post the version in ALL your posts. You think it is important or not does not matter. Post what we ask without thinking. You don't know what your don't know.

Now did you check the option is available in "9i" (this does not contain 4 decimals, do you think there was no difference between 9.0 and 9.2?)?

Regards
Michel
Re: ORA-12645 and oracle.net.encryption_client setting [message #349426 is a reply to message #349423] Sun, 21 September 2008 14:14 Go to previous messageGo to next message
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,
Re: ORA-12645 and oracle.net.encryption_client setting [message #349496 is a reply to message #349426] Mon, 22 September 2008 01:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
2/ ... Did you try it without this parameter?
3/ Do you use thin or OCI driver?

Quote:
did you check the option is available in "9i"?


Please answer these.

Regards
Michel
Re: ORA-12645 and oracle.net.encryption_client setting [message #349585 is a reply to message #349426] Mon, 22 September 2008 05:12 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

client side is 10.2.0.5

10.2.0.4 is a latest patchset for 10gr2. where you get 10.2.0.5.0 or it is typo.
Re: ORA-12645 and oracle.net.encryption_client setting [message #349691 is a reply to message #349496] Mon, 22 September 2008 12:54 Go to previous messageGo to next message
casttree
Messages: 83
Registered: August 2008
Member
the encryption_client is not set in 9i, It should be set as default value "accepted" right? From 9i doc, it should be OK if one side is requested and another side is accpted.

Also I tried to use "accepted" encryption in 10g, there is no error in sqlplus connection.

Error code for ORA-12645 [message #354679 is a reply to message #349378] Mon, 20 October 2008 15:08 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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;
          }

Re: Check exception code for ORA-12645 [message #354868 is a reply to message #354866] Tue, 21 October 2008 13:34 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is useless to repeat and repost your question.

Regards
Michel
Previous Topic: system username password
Next Topic: User SYS logged without password locally
Goto Forum:
  


Current Time: Thu Mar 28 04:53:10 CDT 2024