System user login issue [message #520294] |
Sat, 20 August 2011 10:55 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68659 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
|
|
|