We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Oracle windows - how to login reset OR can we know the sys- user password

mansur_mca
mansur_mca asked
on
Medium Priority
711 Views
Last Modified: 2013-12-19
I had one DB that is down currently and its OS is windows platform . this DB has been set with the password while it is created using the oradim command. obviously, we couldnt login to DB just by setting oracle_sid  command at the OS prior to login, I would like to know password/ want to reset the password of the sys user for login. Can any one please assist with the simplified steps , how can login into this DB as sys user.
Comment
Watch Question

Sean StuberDatabase Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012

Commented:
you can't derive the sys password

you should be able to connect by logging into windows as a user with the ora_dba group
then set your oracle_sid and

c:\> sqlplus / as sysdba

SQL> alter user sys identified by your_new_password;




Author

Commented:
thanks for your reply.
i have connected to admin user. but couldn't able to do the above as you mentioned above.
Sean StuberDatabase Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012

Commented:
"couldn't able to do the above"  isn't very helpful.

what happened when you tried? what messages or errors?
Sean StuberDatabase Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012

Commented:
and "admin user" is not necessarily an ora_dba.  Check your groups to ensure you have that specific group

Author

Commented:
the same machine had two more different database for which i know the password  of the sys user and using the os-admin user to bring up the DB's.  means admin user also part of ora_dba group . hence we can conclude that user should not be issue in my case.

please let me know any more inputs to resolve this issue?
Sean StuberDatabase Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012

Commented:
what happens when you try

"sqlplus / as sysdba"

Commented:
if you want to change the sys password, then you can use orapwd utility.
just type orapwd at command prompt and it will give u more details.

Author

Commented:
when i type"sqlplus /as sysdba" at the command prompt it is giving as invalid username/password.

fayyaz,  i belive orapwd won't help me in this case  as this is just used to facilitate  to connect remotely for sys dba users.

Commented:
and when you connect to other dbs on the machine, do you always gave password for sys user or is it with "sqlplus / as sysdba" ?
if you are not able to connect to other dbs also with "sqlplus / as sysdba", then you will not be able to do the same for this 3rd database. you have to give password for sys user
 

Author

Commented:
please let me know , how to succeed connecting DB using SYS user if password is not known to us.
Commented:
create the new passowrd for SYS user using orapwd utility.
type below and windows command prompt c:\>
orapwd file=orapw<ORACLE_SID> password=<sys password> entries=5 force=y
replace <ORACLE_SID> with the SID of your database
replace <sys password> with the password, you want to put for sys user
try connecting with new sys password

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.