OraFAQ Forum: Server Administration » SYS,SYSDBA accounts locked

Home » RDBMS Server » Server Administration » SYS,SYSDBA accounts locked (oracle 11g)

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

SYS,SYSDBA accounts locked [message #619965]

Sat, 26 July 2014 11:43

said001
Messages: 4
Registered: July 2014

Junior Member

Hi All,

SYS and SYSDBA and system accounts locked by mistake by me. Can any one help how to unlock?

do i need to uninstal?

Report message to a moderator

Re: SYS,SYSDBA accounts locked [message #619966 is a reply to message #619965]

Sat, 26 July 2014 12:00

Michel Cadot
Messages: 68510
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

SYS, SYSDBA can't be locked, NEVER.

Report message to a moderator

Re: SYS,SYSDBA accounts locked [message #619967 is a reply to message #619966]

Sat, 26 July 2014 12:05

said001
Messages: 4
Registered: July 2014

Junior Member

Sorry wrong inputs...

System account locked and i dont know the passwords for SYS, SYSDBA.. any suggestions how to login to SYS, SYSDBA

Report message to a moderator

Re: SYS,SYSDBA accounts locked [message #619968 is a reply to message #619967]

Sat, 26 July 2014 12:08

Michel Cadot
Messages: 68510
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Ask your DBA.

Report message to a moderator

Re: SYS,SYSDBA accounts locked [message #619969 is a reply to message #619968]

Sat, 26 July 2014 12:10

said001
Messages: 4
Registered: July 2014

Junior Member

I'm using oracle on my pc. I only have to solve this..Any sugestions?

Report message to a moderator

Re: SYS,SYSDBA accounts locked [message #619970 is a reply to message #619969]

Sat, 26 July 2014 12:18

Michel Cadot
Messages: 68510
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You should be able to connect "/ as sysdba" without any password if you put your user in the ORA_DBA OS group.

Report message to a moderator

Re: SYS,SYSDBA accounts locked [message #619971 is a reply to message #619970]

Sat, 26 July 2014 12:21

said001
Messages: 4
Registered: July 2014

Junior Member

I tried by giving above command. but it was saying "in sufficient priivilages"

Report message to a moderator

Re: SYS,SYSDBA accounts locked [message #619972 is a reply to message #619971]

Sat, 26 July 2014 12:27

Michel Cadot
Messages: 68510
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

if you put your user in the ORA_DBA OS group.

Report message to a moderator

Re: SYS,SYSDBA accounts locked [message #619973 is a reply to message #619971]

Sat, 26 July 2014 12:30

John Watson
Messages: 8880
Registered: January 2010
Location: Global Village

Senior Member

From a command prompt run these commands and copy/paste the results here:

where sqlplus
whoami /all
sqlplus / as sysdba

Be sure to enclose the paste in [code] tags.

And, to do the moderator bit:
Welcome to the forum. Please read our OraFAQ Forum Guide and please read How to use [code] tags and make your code easier to read

Report message to a moderator

Re: SYS,SYSDBA accounts locked [message #620044 is a reply to message #619973]

Mon, 28 July 2014 05:55

gazzag
Messages: 1114
Registered: November 2010
Location: Bedwas, UK

Senior Member

Do we know the version of Windows the OP is running?

Report message to a moderator

Previous Topic:	Archive log destination is generating more redo
Next Topic:	ORA-01882: timezone region %s not found

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Oct 01 06:23:32 CDT 2023