Home » RDBMS Server » Security » Can only log onto db via server. (Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit on AIX Version 6.1)
Can only log onto db via server. [message #539711] Wed, 18 January 2012 03:42 Go to next message
irrational
Messages: 2
Registered: January 2012
Junior Member
I've a problem in that I cannot log onto one of our schemas on one of our databases via SQL*Plus, TOAD, SQL Developer etc...
Attempting to do so yields the following error message:
"ORA-01017: invalid username/password; logon denied"

However, if I try to log onto the same schema via any of the unix boxes using the sqlplus command, that works fine.

It's only this schema that is affected. For all other schemas (on that database and on others), I don't have this problem.

Any ideas what the DBAs have done?

[Updated on: Wed, 18 January 2012 03:46]

Report message to a moderator

Re: Can only log onto db via server. [message #539713 is a reply to message #539711] Wed, 18 January 2012 03:52 Go to previous messageGo to next message
Michel Cadot
Messages: 59407
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to post here (that is copy and paste, in text mode inside the post not with attahched images) the sqlplus sessions when it works and when it does not.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel
Re: Can only log onto db via server. [message #539717 is a reply to message #539713] Wed, 18 January 2012 04:18 Go to previous messageGo to next message
irrational
Messages: 2
Registered: January 2012
Junior Member
Apologies for that Michael. Please lock this thread and i'll set up a new one when I have the required info.
Re: Can only log onto db via server. [message #539725 is a reply to message #539717] Wed, 18 January 2012 04:47 Go to previous message
Michel Cadot
Messages: 59407
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can continue on this one (as anyway the new one will be merged to this one).

Regards
Michel
Previous Topic: Password Expire problem
Next Topic: SOX compliance
Goto Forum:
  


Current Time: Tue Oct 21 04:06:52 CDT 2014

Total time taken to generate the page: 0.12169 seconds