This discussion is archived
3 Replies Latest reply: Mar 28, 2013 7:20 AM by JPADARO_CDE RSS

Two instances installation, grant sysdba failed because passwd file

JPADARO_CDE Newbie
Currently Being Moderated
Hi

I have a two instances Oracle 11g installation.

Instance 1: ORATEST
Instance 2: ORADESA

So, i want add SYSDBA grant to ORADESA system user.

[oracle@oracletesting dbs]$ echo $ORACLE_SID
ORADESA
[oracle@oracletesting dbs]$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0.3/desa/dbhome_1
[oracle@oracletesting dbs]$ sqlplus /nolog
SQL> conn /as sysdba
Connected.
SQL> show parameter password;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE

SQL> grant sysdba to system;
grant sysdba to system
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled

Ok, i recreate passwd file.

[oracle@oracletesting dbs]$ rm $ORACLE_HOME/dbs/orapworaDESA
[oracle@oracletesting dbs]$ orapwd file=$ORACLE_HOME/dbs/orapworaDESA password=xxx entries=5
[oracle@oracletesting dbs]$ ls -all
total 84
drwxr-xr-x. 2 oracle oinstall 4096 Mar 28 10:57 .
drwxr-xr-x. 71 oracle oinstall 4096 Mar 7 16:23 ..
-rw-rw----. 1 oracle oinstall 1544 Mar 26 15:45 hc_oradesa.dat
-rw-rw----. 1 oracle oinstall 1544 Mar 28 10:20 hc_ORADESA.dat
-rw-r--r--. 1 oracle oinstall 2851 May 15 2009 init.ora
-rw-r--r--. 1 oracle oinstall 68 Mar 26 15:45 initORADESA.ora
-rw-r-----. 1 oracle oinstall 24 Mar 26 11:17 lkORADESA
-rw-r-----.  1 oracle oinstall  2048 Mar 28 10:57 orapworaDESA
-rw-r--r--. 1 oracle oinstall 48880 Mar 26 14:15 rmdup_oradesa.dat
-rw-r-----. 1 oracle oinstall 3584 Mar 26 15:14 spfileoradesa.ora

[oracle@oracletesting dbs]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Thu Mar 28 10:59:54 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> grant sysdba to system;
grant sysdba to system
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled


Obviously something is wrong, but I do not know.

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points