Pages

Tuesday, March 15, 2016

Create A Password File

Create A Password File

Enable SYSDBA remote login.
Set: remote_login_passwordfile= EXCLUSIVE
If this fails, check the passwordfile as follows:

1.Ensure REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE is set in the init.ora for the database.

2.Create a password file:
Unix: $
orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=first entries=5
Windows:
C:\> orapwd file=%ORACLE_HOME%\database\pwd%ORACLE_SID% password= fist entries=5

3.To synchronize the password for sys for normal connections and connections as sysdba connect as a sysdba user and reset the sys password:

$ sqlplus "/ as sysdba" SQL> ALTER USER SYS IDENTIFIED BY change_on_install;

No comments:

Post a Comment