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:
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
Post a Comment