password

[sripalli]

if password for system sys/internal is changed then how i can break that and give anather password

thanks in advance

sridhar

[jdorlon]

connect as some other user with the 'alter user' privilege
and issue :

alter user sys identified by new_password;

[sripalli]

thanks for reply but with this command any one can change my sys password na

so just i want to put a password which can not be break by any of the user

plz help me out
sridhar

[sambavan]

No, that was a wrong reply. If you were to loose the system/sys password, untill 8i you can connect through the server manager and then isssue "alter user sys identified by password". Once after loging into server manager you have to connect internal. If you cannot succeed there, then you could use the orapwd to recreate your password file and start working inwards from there.

Hope this would help you.
Sam

[sripalli]

Dear Sambavan

Sir I am not clear

plz tell me bit of clearly

thanks for reply
sridhar

[santoshym]

Hi Sridhar,

Sambhavan meant

You can change any password by connecting as user

Internal

from server manager for example

set ORACLE_SID=youroraclesid

svrmgrl

svrmgrl> connect internal

svrmgrl> alter user sys identified by newpassword;

If you are not able to change the password thru the above procedure you can use the following utility

orapwd

the filename of this utility changes from version to version.
This utiliy creates a password file which will be stored on your hard drive.The above utility can be executed from command prompt or from $ prompt if you are on unix

If you are not familiar with orapwd utility perform a search on this forum you will find tons of Info.You will find search option on the top right hand corner

If you still have any question keep posting

Regards,

[hbk_emp]

Hello,
I would strongly you to use orapwd.exe to change the internal passwod rather than using the alter statement

Harsh