Thera are several solutions to this issue, you can use one of the following methods:
- Make sure that the database and listener services are started. Then open a command prompt and log in as / as sysdba. Then change the sys password.
c:> sqlplus /nolog
SQL> connect / as sysdba
SQL> alter user sys identified by;
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/orapwdpassword= entries=5
Notice it is from the dos prompt - you may also try this method:
- 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
(not need input the password).