OraFAQ Forum: Server Administration » System user login issue

Home » RDBMS Server » Server Administration » System user login issue (Oracle ,10G , Linux)

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

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.

Report message to a moderator

Re: System user login issue [message #520298 is a reply to message #520294]

Sat, 20 August 2011 11:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

both examples utilize SQL*Net in attempt to connect to DB;
therefore listener.log should contain record recording the connection request.

post excerpt from listener.log that proves listener serviced the individual connection requests

[Updated on: Sat, 20 August 2011 11:13]

Report message to a moderator

Re: System user login issue [message #520307 is a reply to message #520294]

Sat, 20 August 2011 13:49

Michel Cadot
Messages: 68645
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

Report message to a moderator

Previous Topic:	Rename a partitioned table
Next Topic:	oracle, root and brother are constantly conflicting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 06:24:32 CDT 2024