Menu
I forgot to feed sys, system and hr password while Oracle DB installation and hit OK but now for SQ*Plus it needs those credentials for login in command prompt.How to get default user name and password?
901
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.
List of default username and password for oracle : SYS/SYSTEM Username and password : The key username we require to start after installation of Oracle is Sys user or System user.
There is no default password but with this connection you can alter the password of any user to whatever you want.
You can simply login as :
sqlplus / as sysdba
Then give password to the respective users :
ALTER USER <username> IDENTIFIED BY <password>;
You can do that for all the three users.
I hope you are not on 12c. Else, you need to mention which CONTAINER are you working with. For example, if you are working on pluggable database, let's say PDBORCL, you need to do following steps :
connect / as sysdba;alter session to set the container of which the respective users are a part of.
alter session set container=PDBORCL;
Then follow the same steps to change the passwords for the users.
152
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
