3 Replies Latest reply on Mar 28, 2013 2:20 PM by JPADARO_CDE

    Two instances installation, grant sysdba failed because passwd file

    JPADARO_CDE
      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