OraFAQ Forum: Networking and Gateways » Not able to login to oracle 9.2.0.6

Home » RDBMS Server » Networking and Gateways » Not able to login to oracle 9.2.0.6 (windows,version,oracle 9.2.0.6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Not able to login to oracle 9.2.0.6 [message #424562]

Sat, 03 October 2009 16:59

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?

Report message to a moderator

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

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?

Report message to a moderator

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

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??

Report message to a moderator

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

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?

Report message to a moderator

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

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.

Report message to a moderator

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

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

Mahesh Rajendran
Messages: 10708
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

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.

Report message to a moderator

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

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?

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 10 03:21:44 CST 2024