On Windows
sqlplus "/as sysdba"
or
On linux/unix
sqlplus '/as sysdba'
type the command "sqlplus /nolog "
SQL> ALTER USER username IDENTIFIED BY "mypassword";
Once logged in successfully you can change password for the users created and use orapwd utility to generate a password file for sys/system user
orapwd example
Create a new password file:
orapwd file=orapwSID password=oracle entries=5
If the password file already exists:
orapwd file=orapwSID password=oracle entries=5 FORCE=Y
Whatever topic has been discussed on this blog is my own finding and views, not necessary match with others. I strongly recommend you to do a test before you implement the piece of advice given at my blog.
Sunday, November 17, 2013
Default passwords of Oracle 11g?
Subscribe to:
Post Comments (Atom)
wow super...,
ReplyDelete