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
How do I find my Oracle 19c password? (Lost SYS password Tips)
login oracle user.
cd $ORACLE_HOME/network/admin.
ed(vi) file sqlnet.ora.
Remark by # at begining of line. SQLNET.AUTHENTICATION_SERVICES = (NONE) => #SQLNET.AUTHENTICATION_SERVICES = (NONE)
sqlplus /nolog or (svrmgrl) command.
connect sys as sysdba, or connect internal.