CODEWITHSUNDEEP
databaseoracle-database
beginner-life
beginner-life

Reputation: 145

Default username and password for Oracle database

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?

Upvotes: 6

Views: 76934

Answers (2)

Swapnil Boralkar
Swapnil Boralkar

Reputation: 308

CHANGE_ON_INSTALL is default password for sys and system.

You can directly login to database as sysdba from host machine and using installation user of oracle and execute below command to change system or sys password.

sqlplus "/as sysdba"
alter user sys identified by passwd;

Alternatively you can create password file to from host server

go to directory

$ORACLE_HOME\database (windows)
$ORACLE_HOME\dbs (unix\linux)

and execute

    orapwd password=password file=orapwSID force=y entries=5

and login to database.

Upvotes: 3

Lalit Kumar B
Lalit Kumar B

Reputation: 49082

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 :

  1. connect / as sysdba;

  2. alter session to set the container of which the respective users are a part of.

    alter session set container=PDBORCL;

  3. Then follow the same steps to change the passwords for the users.

Upvotes: 5

Related Questions