System user login issue [message #520294] |
Sat, 20 August 2011 10:55 |
rajawin
Messages: 2 Registered: May 2008 Location: bangalore
|
Junior Member |
|
|
Dear friends,
I have created service for standalone database recently. After creation tried test connection
Eg:
Database : ORA
Servivce name: ORATEST.DT.COM
Tried from remote server:
Case 1:
sqlplus test/****@ORATEST.DT.COM
Result: Connecting fine.
Case 2:
sqlplus system/****@ORATEST.DT.COM
Result: Showing error ,User account locked
So , directly conneted to server and checked for user account status , its shows account status is open.
Also tried from server with same password its connecting fine. So ,its not working only for system user.
Please give some advise.
Regards,
Raja.
|
|
|
|
Re: System user login issue [message #520307 is a reply to message #520294] |
Sat, 20 August 2011 13:49 |
|
Michel Cadot
Messages: 68667 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:, directly conneted to server and checked for user account status , its shows account status is open.
This sentence, if correct, proves you didn't connect to the same database whatever you think.
Regards
Michel
|
|
|