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
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;


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 Production on Mon Oct 21 19:26:38 2013

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

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

Enter user-name: sys
Enter password:

reply to :

Sridevi Koduru said...

Sridevi Koduru (Senior Oracle Apps Trainer
LinkedIn profile -
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at | +91 - 9581017828.