| SYS password [message #64550] |
Mon, 07 February 2005 13:31  |
Kapil
Messages: 145
Registered: May 2002
|
Senior Member |
|
|
I forgot sys and system passwords and i am running oracle 9i db server. and all my oracle software if owned by oracle:oinstall and conn / as sysdba doesn't work, i heard that to make it "conn / as sysdba" i would have to change software ownership to oracle:dba and relink. but i am not quite sure about this process if anyone can help me with steps how to do this i would really appreciate it.
Thank you very much
|
|
|
|
| Re: SYS password [message #64553 is a reply to message #64550] |
Mon, 07 February 2005 23:11  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
I don't think you would need to relink the software at all. Just create a "dba" group on your systems and assign it to your "oracle" account. You can still keep "oinstall" as primary or secondary group.
Try it and let us know how it goes.
Best regards.
Frank
|
|
|
|
| Re: SYS password [message #64560 is a reply to message #64553] |
Tue, 08 February 2005 03:56 |
Kapil
Messages: 145
Registered: May 2002
|
Senior Member |
|
|
i did groups at unix prompt and i see oracle is already there in oinstall and dba, it first displayed oinstall and then dba. How do i change dba as the primary group id? and also i know a user who is assigned only dba group id and he cannot do "conn / as sysdba"
i have a password file under $oracle_home/dbs. is there any way that i could change the password in that orapwd utility? please help me with this
thanks a lot
|
|
|
|
| Re: SYS password [message #64561 is a reply to message #64553] |
Tue, 08 February 2005 04:29 |
Kapil
Messages: 145
Registered: May 2002
|
Senior Member |
|
|
I just logged in as system and was able to do
alter user SYS identified by newpass123; but couldn't shutdown the database as system so i tried log in as "sys as sysdba" with new password that i altered and couldn't log in sys. Whats going on here I have no clue. any help is appreciated. yes i tried as sysoper but not letting me in
Thanks
|
|
|
|
| Re: SYS password [message #64579 is a reply to message #64553] |
Thu, 10 February 2005 05:37 |
Sanjay
Messages: 236
Registered: July 2000
|
Senior Member |
|
|
Did you assign the "dba" group to "oracle" login id ?
If so, login as "oracle" and type "dbshut" at the prompt. This will shut down ALL the databases in the server (as defined in /etc/oratab).
% dbshut
FYI, similarly there is "dbstart" also.
|
|
|
|
| Re: SYS password [message #64605 is a reply to message #64560] |
Sun, 13 February 2005 19:59 |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Just because you belong to a group does not mean you
have all the permissions of that group. Use the
"newgrp dba" command to change the user's current
login group to "dba".
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
