Home » RDBMS Server » Networking and Gateways » Not able to login to oracle 9.2.0.6 (windows,version,oracle 9.2.0.6)
Not able to login to oracle 9.2.0.6 [message #424562] Sat, 03 October 2009 16:59 Go to next message
ranganathan1984
Messages: 11
Registered: April 2007
Location: 37,park terrace,bridgepor...
Junior Member

Hi i am trying to login to my database using sqlplus or toad and it gives me a message ORA-12660: Encryption or crypto-checksumthois still it gives me the same errorming parameters incompatible.
Solution:
Change the "REQUIRED" side to "REQUESTED" if the you want encryption or crypto-checksumming to be optional, or change the "REJECTED" side to "ACCEPTED" if you do not want the service to be optional.

I tried this still it gives me the same error.
The database is on a windows platform and its 9.2.0.6.
Can somebody help?
Re: Not able to login to oracle 9.2.0.6 [message #424565 is a reply to message #424562] Sat, 03 October 2009 18:12 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Can somebody help?
Most likely not, because most folks don't use encryption between client & DB.

When did this last work?
What changed?
Re: Not able to login to oracle 9.2.0.6 [message #424569 is a reply to message #424565] Sat, 03 October 2009 20:49 Go to previous messageGo to next message
ranganathan1984
Messages: 11
Registered: April 2007
Location: 37,park terrace,bridgepor...
Junior Member

There has been an encryption from the very beginning. It has been working but yesterday it stopped showing this message. Now can it be a firewall problem??
Re: Not able to login to oracle 9.2.0.6 [message #424570 is a reply to message #424569] Sat, 03 October 2009 21:02 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Now can it be a firewall problem??
It might be firewall.
It might be something else.
Has it stopped working for all remote clients?
Are you the only 1 impacted?
What/who continues to work from where?
Who/where is also seeing same failure?
Re: Not able to login to oracle 9.2.0.6 [message #424571 is a reply to message #424570] Sat, 03 October 2009 21:36 Go to previous messageGo to next message
ranganathan1984
Messages: 11
Registered: April 2007
Location: 37,park terrace,bridgepor...
Junior Member

The client is 9.2.0.6 version. I tried login through one machine it failed. It also failed in another machine.You can say that it has stoppe working for all remote clients.
Re: Not able to login to oracle 9.2.0.6 [message #424573 is a reply to message #424571] Sat, 03 October 2009 22:20 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>You can say that it has stoppe working for all remote clients.
Unfortunately, beyond the error code you have not provided any actionable information.
It appears to me that something has changed.
I suspect that in the near future as the real scope of the problem is more completely understood,
additional internal resources will be devoted to finding & fixing the root cause.

Good Luck

[Updated on: Sat, 03 October 2009 22:22]

Report message to a moderator

Re: Not able to login to oracle 9.2.0.6 [message #424574 is a reply to message #424562] Sat, 03 October 2009 22:23 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>I tried this still it gives me the same error.
Where and What exactly did you do?

[Updated on: Sat, 03 October 2009 22:25]

Report message to a moderator

Re: Not able to login to oracle 9.2.0.6 [message #424575 is a reply to message #424562] Sat, 03 October 2009 22:31 Go to previous messageGo to next message
ranganathan1984
Messages: 11
Registered: April 2007
Location: 37,park terrace,bridgepor...
Junior Member

Checked if there is a mismatch between the parameters SQLNET.CRYPTO_CHECKSUM_SERVER and SQLNET.CRYPTO_CHECKSUM_CLIENT. The client parameter is set to requested and the server is set to accepted.
Re: Not able to login to oracle 9.2.0.6 [message #424576 is a reply to message #424575] Sat, 03 October 2009 22:38 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
FYI -
http://download.oracle.com/docs/html/A95136_01/ch05.htm

Please post the last 30 - 40 lines from listener.log from DB server.

Just as a test, can you eliminate encryption to see if connection will succeed?




Previous Topic: ORA-12514 dblink as non oracle user
Next Topic: Problem starting up database
Goto Forum:
  


Current Time: Thu Mar 28 06:22:37 CDT 2024