Home > Software design >  Installed Oracle 19c. During install it did not ask for username/passwords. How do I sign into sqlpl
Installed Oracle 19c. During install it did not ask for username/passwords. How do I sign into sqlpl

Time:07-09

It never asked for default passwords. I have tried sysdba, sys, system. All ask for passwords.

CodePudding user response:

Start sqlplus with the User-Account, you had install Oracle. sqlplus should connect without username and password. After you are connected, you can ad new users.

sqlplus / as sysdba

CodePudding user response:

Try this on windows:

c:> sqlplus /nolog
SQL> connect / as sysdba
SQL> alter user sys identified by ,new password>;

If you get asked for a password when you log in as / you need to create or recreate the password file using orapw. Check the $ORACLE_HOME/database directory for a file called orapw. That is the password file for the database. Create (or recreate) it using:

c:\> orawpd file=$ORACLE_HOME/database/orapwd<SID> password=<password> entries=5

Lost SYS password Tips

How do I find my Oracle 19c password? (Lost SYS password Tips)

  1. login oracle user.

  2. cd $ORACLE_HOME/network/admin.

  3. ed(vi) file sqlnet.ora.

  4. Remark by # at begining of line. SQLNET.AUTHENTICATION_SERVICES = (NONE) => #SQLNET.AUTHENTICATION_SERVICES = (NONE)

  5. sqlplus /nolog or (svrmgrl) command.

  6. connect sys as sysdba, or connect internal.

  • Related