Menu
I installed Oracle 11g. I didn't change the passwords for SYSTEM and SYS. However now I find that the default passwords do not work. Please help.
654
Once connected,you can enter the following query to get details of username and password: SQL> select username,password from dba_users; This will list down the usernames,but passwords would not be visible. But you can identify the particular username and then change the password for that user.
Default user name and password The installation program will install the SYSDBA user with the password masterkey (actually, it's masterke : characters after the eighth are ignored). If your server is exposed to the Internet at all, you should change this password immediately using the gsec command-line utility.
It is possible to connect to the database without specifying a password. Once you've done that you can then reset the passwords. I'm assuming that you've installed the database on your machine; if not you'll first need to connect to the machine the database is running on.
Ensure your user account is a member of the dba group. How you do this depends on what OS you are running.
Enter sqlplus / as sysdba in a Command Prompt/shell/Terminal window as appropriate. This should log you in to the database as SYS.
Once you're logged in, you can then enter
alter user SYS identified by "newpassword"; to reset the SYS password, and similarly for SYSTEM.
(Note: I haven't tried any of this on Oracle 12c; I'm assuming they haven't changed things since Oracle 11g.)
170
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
