Home » RDBMS Server » Security » SYS account is locked (merged)
SYS account is locked (merged) [message #264927] Wed, 05 September 2007 01:10 Go to next message
KBalu12
Messages: 4
Registered: September 2007
Junior Member
Hi,

We installed Oracle 10g in our system. Then we installed Oracle SQL Developer(V1.2.1) to connect the database. While installing itself the user name created by default as SYSTEM. Then we tried to connect to connect the database using that user name , we given correct pwd only eventhough the system account is locked. We don't have DBA role and how to unlock the account. Kindly let me know soon, waiting for your reply at the earliest.

Regards,
Balu.
Re: Sys Acct is locked [message #264935 is a reply to message #264927] Wed, 05 September 2007 01:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can connect as SYS which can't be locked.

Regards
Michel
Re: Sys Acct is locked [message #264939 is a reply to message #264927] Wed, 05 September 2007 01:29 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

@OP,
May be you made have wrong. You wrongly interpret system as sys.
By the way sys can't be locked but system can be locked.After 10 incorrect attempt to log on as system/ any other account the account is automatically locked . This is happened after Oracle 10g.

There is threshold time to unlock account, or manually you can unlock it.

Re: Sys Acct is locked [message #264940 is a reply to message #264927] Wed, 05 September 2007 01:31 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

To manually unlock system account connect as sys.

And then alter user system account unlock. Laughing
Re: Sys Acct is locked [message #264942 is a reply to message #264940] Wed, 05 September 2007 01:38 Go to previous messageGo to next message
KBalu12
Messages: 4
Registered: September 2007
Junior Member
Hi,

I tried that also that time also its giving same error that account is locked.

we given like this

connection : sys
username : SYSTEM
password : ORCLogin12

We selected role as default.

Suppose we are selecting role as SYSDBA means its giving invalid username/password.

What could be the problem and how to solve it. Kindly let me know soon.

Regards,
Balu.
Re: Sys Acct is locked [message #264948 is a reply to message #264927] Wed, 05 September 2007 01:47 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

From command prompt use

sqlplus / as sysdba
alter user system account unlock
exit
Re: Sys Acct is locked [message #264954 is a reply to message #264948] Wed, 05 September 2007 01:56 Go to previous messageGo to next message
KBalu12
Messages: 4
Registered: September 2007
Junior Member
Hi,

For SYSDBA, which pwd I can give ?

I given like this
SYSDBA / ORCLOgin12

But it's telling invalid username/pwd.

Regards,
Balu.
Re: Sys Acct is locked [message #264956 is a reply to message #264927] Wed, 05 September 2007 02:02 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
SYSDBA / ORCLOgin12


What I told??
Is sysdba is a user?
Re: Sys Acct is locked [message #264958 is a reply to message #264956] Wed, 05 September 2007 02:05 Go to previous messageGo to next message
KBalu12
Messages: 4
Registered: September 2007
Junior Member
Hi,

I said we don't have SYSDBA role, while installing the SQL Developer by default its created the username / pwd like SYSTEM / ORCLogin12. What to do now?

Regards,
Balu.
Re: Sys Acct is locked [message #265147 is a reply to message #264958] Wed, 05 September 2007 09:45 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
KBalu12 wrote on Wed, 05 September 2007 01:05
Hi,

I said we don't have SYSDBA role, while installing the SQL Developer by default its created the username / pwd like SYSTEM / ORCLogin12. What to do now?

Regards,
Balu.



Check the PLSQL developer manual.
Try to connect with your database USER,actually its providing you the interface to connect with your
database so try SCOTT or HR and may be it ask for service as well.And one more
thing you will need client as well if database server is not running at your pc.

[Updated on: Wed, 05 September 2007 09:49]

Report message to a moderator

Re: Sys Acct is locked [message #265920 is a reply to message #265147] Fri, 07 September 2007 20:49 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello KBalu12,

1) You have oracle database 10g installed;
2) You have oracle sql developer v1.2.1 installed;
3) You want to establish a connection from sql developer 1.2.1 onto oracle database 10g;

So you open sql developer tool and this tool offers to you a screen to register a new connection. Then you should provide:

connection = <your database SID, for example... any identifier>
username = SYS
password = <your SYS password>
role = SYSDBA
hostname = <ip of your 10g server>
port = <1521 for example>
SID = <your database SID>


or

connection = <your database SID, for example... any identifier>
username = SYSTEM
password = <your SYSTEM password>
role = default
hostname = <ip of your 10g server>
port = <1521 for example>
SID = <your database SID>



Once you filled out this connection register screen... you have options to "test", to "save" and to "login" as your convenience.

Regards


mson77

[Updated on: Fri, 07 September 2007 21:59]

Report message to a moderator

Unlocking Oracle 9i SYS user [message #266181 is a reply to message #264927] Mon, 10 September 2007 01:58 Go to previous messageGo to next message
tanveer40
Messages: 2
Registered: September 2007
Junior Member
i have installed oracle 9i but my SYS user is locked and i can't open it. can anyone help me out how to unlock this user?
Re: Unlocking Oracle 9i SYS user [message #266182 is a reply to message #266181] Mon, 10 September 2007 01:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SYS is NEVER locked.

Regards
Michel
Re: Unlocking Oracle 9i SYS user [message #266185 is a reply to message #266181] Mon, 10 September 2007 02:11 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

May be your system account is locked and to unlock this log as sys account and then unlock.

Questioner, SYS and system account is different.
Re: SYS account is locked (merged) [message #266210 is a reply to message #264927] Mon, 10 September 2007 03:52 Go to previous messageGo to next message
tanveer40
Messages: 2
Registered: September 2007
Junior Member
we have changed the name of computer and also changed from TNSnames.ORA file and brought this PC on domain. now we are logged onto by the domain user and the database is running ok and the normal system id of the oracle is also running but scott/tiger and sys dba is not working. kindly give me a solution for this.
Re: SYS account is locked (merged) [message #266219 is a reply to message #264927] Mon, 10 September 2007 04:06 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Search in this forum. This problem raise at least twice in a week.
Re: SYS account is locked (merged) [message #269448 is a reply to message #264927] Sat, 22 September 2007 06:33 Go to previous message
toofee82
Messages: 2
Registered: September 2007
Junior Member

thanks for all Razz
Previous Topic: user unable to connect
Next Topic: Regarding password file authentication
Goto Forum:
  


Current Time: Thu Mar 28 09:22:06 CDT 2024