Oracle windows - how to login reset OR can we know the sys- user password
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.
ASKER
thanks for your reply.
i have connected to admin user. but couldn't able to do the above as you mentioned above.
i have connected to admin user. but couldn't able to do the above as you mentioned above.
"couldn't able to do the above" isn't very helpful.
what happened when you tried? what messages or errors?
what happened when you tried? what messages or errors?
and "admin user" is not necessarily an ora_dba. Check your groups to ensure you have that specific group
ASKER
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?
please let me know any more inputs to resolve this issue?
what happens when you try
"sqlplus / as sysdba"
"sqlplus / as sysdba"
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.
just type orapwd at command prompt and it will give u more details.
ASKER
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.
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.
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
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
ASKER
please let me know , how to succeed connecting DB using SYS user if password is not known to us.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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;