Home » RDBMS Server » Server Administration » SYS,SYSDBA accounts locked (oracle 11g)
SYS,SYSDBA accounts locked [message #619965] Sat, 26 July 2014 11:43 Go to next message
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?
Re: SYS,SYSDBA accounts locked [message #619966 is a reply to message #619965] Sat, 26 July 2014 12:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

SYS, SYSDBA can't be locked, NEVER.

Re: SYS,SYSDBA accounts locked [message #619967 is a reply to message #619966] Sat, 26 July 2014 12:05 Go to previous messageGo to next message
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
Re: SYS,SYSDBA accounts locked [message #619968 is a reply to message #619967] Sat, 26 July 2014 12:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Ask your DBA.

Re: SYS,SYSDBA accounts locked [message #619969 is a reply to message #619968] Sat, 26 July 2014 12:10 Go to previous messageGo to next message
said001
Messages: 4
Registered: July 2014
Junior Member
I'm using oracle on my pc. I only have to solve this..Any sugestions?
Re: SYS,SYSDBA accounts locked [message #619970 is a reply to message #619969] Sat, 26 July 2014 12:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
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.

Re: SYS,SYSDBA accounts locked [message #619971 is a reply to message #619970] Sat, 26 July 2014 12:21 Go to previous messageGo to next message
said001
Messages: 4
Registered: July 2014
Junior Member
I tried by giving above command. but it was saying "in sufficient priivilages"
Re: SYS,SYSDBA accounts locked [message #619972 is a reply to message #619971] Sat, 26 July 2014 12:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
if you put your user in the ORA_DBA OS group.


Re: SYS,SYSDBA accounts locked [message #619973 is a reply to message #619971] Sat, 26 July 2014 12:30 Go to previous messageGo to next message
John Watson
Messages: 8919
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
Re: SYS,SYSDBA accounts locked [message #620044 is a reply to message #619973] Mon, 28 July 2014 05:55 Go to previous message
gazzag
Messages: 1114
Registered: November 2010
Location: Bedwas, UK
Senior Member
Do we know the version of Windows the OP is running?
Previous Topic: Archive log destination is generating more redo
Next Topic: ORA-01882: timezone region %s not found
Goto Forum:
  


Current Time: Mon Mar 18 23:21:38 CDT 2024