Sys Passwords

[crdba]

I am using a windows 2000 box and I dont remember what my system password is. I want to log in as sysdba to change it but there is just one problem. SQLPLUS prompts me for a password. How do I work around that? I know it has something to do with the remote_login_password file and the orapaswd file, but not sure how to set it up. I am running Oracle 8.1.7. Can anyone please help.

Thank you

 

[SantaMufasa]

crdba,

You can even circumvent the "remote_login_password" setting if you log into the machine (that holds your Oracle server) as a user that is in the Oracle DBA group, then issue the following commands:

% sqlplus /nolog
(Oracle log-in banner)
SQL> connect / as sysdba
connected.
SQL> ALTER USER <et cetera>

Let us know the applicability of the above.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[crdba]

What about logging into svrmgrl because I was able to do that and connect as sysdba with a password, but when I used that same password for sqlplus, it didnt work. This whole issue came about because we thought there was a particular user in the database. We have come to find out that no user exist through svrmgrl.

Mufasa wrote:
You can even circumvent the "remote_login_password" setting if you log into the machine (that holds your Oracle server) as a user that is in the Oracle DBA group, then issue the following commands:

Are you saying if I put sys as a user in the Oracle DBA group, he will be able to login with out giving a password??

 

[SantaMufasa]

Exactly. That is the "back door"/"safety net" that Oracle leaves in case the DBA loses her/his mind and forgets the administrative password.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[crdba]

Thanks for clearing that up.

 

[Beilstwh]

You do NOT put the oracle SYS user into the DBA Group, you login as the OS user that was used to install the Oracle database on the database machine and use the commands that Dave showed you.

Bill
Oracle DBA/Developer
New York State, USA