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;

1 comment:

Anonymous said...

hi ,
i have created a password file and i am trying to login, but no luck.
check following:
[oracle@node1 dbs]$ orapwd file=$ORACLE_HOME/dbs/orapwHR85090 password=manager entries=50

[oracle@node1 dbs]$ sqlplus sys/manager@HR85090 as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 21 19:26:38 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


Enter user-name: sys
Enter password:
ERROR:

reply to : saireddysateesh@gmail.com