3 Replies Latest reply: Apr 26, 2012 11:26 PM by User431215 RSS

    Installation with seperation of roles fails

    User431215
      I'm performing a clean install of Oracle grid (for ASM) + database (11gR2) on Oracle Linux R5U6. Both installs seem to go just fine. The ASM processes starts and runs just fine. But, when I try to create a database, I get the following errors:

      PRCR-1079: Failed to start resource ora.test.db
      ORA-01031: insufficient privileges
      ORA-01031: insufficient privileges
      CRS-2674: Start of 'ora.test.db' on 'asm' failed

      ORA-01034: ORACLE not available

      ORA-01034: ORACLE not available

      0

      Any ideas?

      Thanks
      Jim

      -----------Create Groups and Users--------------------------------------------------------------------

      groupadd oinstall
      groupadd dba
      groupadd oper
      groupadd asmdba
      groupadd asmoper
      groupadd asmadmin
      useradd -g oinstall -G asmdba,asmoper,asmadmin grid
      useradd -g oinstall -G dba,oper,asmdba,asmoper,asmadmin oracle
      passwd grid
      passwd oracle

      [root@asm asm]# id oracle
      uid=502(oracle) gid=502(oinstall) groups=502(oinstall),503(dba),504(oper),505(asmdba),506(asmoper),507(asmadmin)
      [root@asm asm]# id grid
      uid=501(grid) gid=502(oinstall) groups=502(oinstall),505(asmdba),506(asmoper),507(asmadmin)


      --------------------------------------------------------------------------------

      [root@asm asm]# uname -rm
      2.6.18-238.el5 i686
      [root@asm asm]# uname -a
      Linux asm.protoeffect.cxm 2.6.18-238.el5 #1 SMP Tue Jan 4 15:24:05 EST 2011 i686 i686 i386 GNU/Linux

      ----------------------ASM RPM Installs---------------------------------------------------------

      [root@asm asm]# rpm -Uvh oracleasm-support-2.1.7-1.el5.i386.rpm \
      oracleasm-2.6.18-238.el5-2.0.5-1.el5.i686.rpm \
      oracleasmlib-2.0.4-1.el5.i386.rpm

      warning: oracleasm-support-2.1.7-1.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
      Preparing... ########################################### [100%]
      1:oracleasm-support ########################################### [ 33%]
      2:oracleasm-2.6.18-238.el########################################### [ 67%]
      3:oracleasmlib ########################################### [100%]

      -------------------ASM Configure------------------------------------------------------------

      [root@asm asm]# /etc/init.d/oracleasm configure
      Configuring the Oracle ASM library driver.

      This will configure the on-boot properties of the Oracle ASM library
      driver. The following questions will determine whether the driver is
      loaded on boot and what permissions it will have. The current values
      will be shown in brackets ('[]'). Hitting <ENTER> without typing an
      answer will keep that current value. Ctrl-C will abort.

      Default user to own the driver interface []: grid
      Default group to own the driver interface []: asmadmin
      Start Oracle ASM library driver on boot (y/n) [n]: y
      Scan for Oracle ASM disks on boot (y/n) [y]: y
      Writing Oracle ASM library driver configuration: done
      Initializing the Oracle ASMLib driver: [ OK ]
      Scanning the system for Oracle ASMLib disks: [ OK ]

      -------------------Allocating Disks------------------------------------------------------------

      [root@asm asm]# /etc/init.d/oracleasm createdisk DISK1 /dev/sdb1
      Marking disk "DISK1" as an ASM disk: [ OK ]
      [root@asm asm]# /etc/init.d/oracleasm createdisk DISK2 /dev/sdc1
      Marking disk "DISK2" as an ASM disk: [ OK ]
      [root@asm asm]# /etc/init.d/oracleasm createdisk DISK3 /dev/sdd1
      Marking disk "DISK3" as an ASM disk: [ OK ]
      [root@asm asm]# /etc/init.d/oracleasm createdisk DISK4 /dev/sde1
      Marking disk "DISK4" as an ASM disk: [ OK ]
      [root@asm asm]# /etc/init.d/oracleasm createdisk DISK5 /dev/sdf1
      Marking disk "DISK5" as an ASM disk: [ OK ]
      [root@asm asm]# /etc/init.d/oracleasm createdisk DISK6 /dev/sdg1
      Marking disk "DISK6" as an ASM disk: [ OK ]
      [root@asm asm]# /etc/init.d/oracleasm createdisk DISK7 /dev/sdh1
      Marking disk "DISK7" as an ASM disk: [ OK ]
      [root@asm asm]# /etc/init.d/oracleasm createdisk DISK8 /dev/sdi1
      Marking disk "DISK8" as an ASM disk: [ OK ]
      [root@asm asm]#
      [root@asm asm]#
      [root@asm asm]# /etc/init.d/oracleasm listdisks
      DISK1
      DISK2
      DISK3
      DISK4
      DISK5
      DISK6
      DISK7
      DISK8

      ---------------------GRID Response File----------------------------------------------------------

      oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v11_2_0
      ORACLE_HOSTNAME=asm.protoeffect.cxm
      INVENTORY_LOCATION=/u01/app/oraInventory
      SELECTED_LANGUAGES=en
      oracle.install.option=HA_CONFIG
      ORACLE_BASE=/u01/app/oracle
      ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid
      oracle.install.asm.OSDBA=asmdba
      oracle.install.asm.OSOPER=asmoper
      oracle.install.asm.OSASM=asmadmin
      oracle.install.crs.config.gpnp.scanName=
      oracle.install.crs.config.gpnp.scanPort=0
      oracle.install.crs.config.clusterName=
      oracle.install.crs.config.gpnp.configureGNS=true
      oracle.install.crs.config.gpnp.gnsSubDomain=
      oracle.install.crs.config.gpnp.gnsVIPAddress=
      oracle.install.crs.config.autoConfigureClusterNodeVIP=false
      oracle.install.crs.config.clusterNodes=
      oracle.install.crs.config.privateInterconnects=
      oracle.install.crs.config.storageOption=
      oracle.install.crs.config.sharedFileSystemStorage.diskDriveMapping=
      oracle.install.crs.config.sharedFileSystemStorage.votingDiskLocations=
      oracle.install.crs.config.sharedFileSystemStorage.votingDiskRedundancy=NORMAL
      oracle.install.crs.config.sharedFileSystemStorage.ocrLocations=
      oracle.install.crs.config.sharedFileSystemStorage.ocrRedundancy=NORMAL
      oracle.install.crs.config.useIPMI=false
      oracle.install.crs.config.ipmi.bmcUsername=
      oracle.install.crs.config.ipmi.bmcPassword=
      oracle.install.asm.SYSASMPassword=
      oracle.install.asm.diskGroup.name=DATA
      oracle.install.asm.diskGroup.redundancy=NORMAL
      oracle.install.asm.diskGroup.disks=ORCL:DISK1,ORCL:DISK2,ORCL:DISK3,ORCL:DISK4
      oracle.install.asm.diskGroup.diskDiscoveryString=
      oracle.install.asm.monitorPassword=
      oracle.install.crs.upgrade.clusterNodes=
      oracle.install.asm.upgradeASM=false




      --------------------------------------------------------------------------------

      [grid@asm ~]$ ps -ef | grep pmon
      grid 9950 1 0 09:25 ? 00:00:00 asm_pmon_+ASM
      grid 10053 4345 0 09:26 pts/2 00:00:00 grep pmon

      ------------------------Database Software Install Response File-------------------------------------------------------

      oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
      oracle.install.option=INSTALL_DB_SWONLY
      ORACLE_HOSTNAME=asm.protoeffect.cxm
      UNIX_GROUP_NAME=oinstall
      INVENTORY_LOCATION=/u01/app/oraInventory
      SELECTED_LANGUAGES=en
      ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
      ORACLE_BASE=/u01/app/oracle
      oracle.install.db.InstallEdition=EE
      oracle.install.db.isCustomInstall=false
      oracle.install.db.customComponents=
      oracle.install.db.DBA_GROUP=dba
      oracle.install.db.OPER_GROUP=oper
      oracle.install.db.CLUSTER_NODES=
      oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
      oracle.install.db.config.starterdb.globalDBName=
      oracle.install.db.config.starterdb.SID=
      oracle.install.db.config.starterdb.characterSet=
      oracle.install.db.config.starterdb.memoryLimit=
      oracle.install.db.config.starterdb.memoryOption=false
      oracle.install.db.config.starterdb.installExampleSchemas=false
      oracle.install.db.config.starterdb.enableSecuritySettings=true
      oracle.install.db.config.starterdb.password.ALL=
      oracle.install.db.config.starterdb.password.SYS=
      oracle.install.db.config.starterdb.password.SYSTEM=
      oracle.install.db.config.starterdb.password.SYSMAN=
      oracle.install.db.config.starterdb.password.DBSNMP=
      oracle.install.db.config.starterdb.control=DB_CONTROL
      oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=
      oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false
      oracle.install.db.config.starterdb.dbcontrol.emailAddress=
      oracle.install.db.config.starterdb.dbcontrol.SMTPServer=
      oracle.install.db.config.starterdb.automatedBackup.enable=false
      oracle.install.db.config.starterdb.automatedBackup.osuid=
      oracle.install.db.config.starterdb.automatedBackup.ospwd=
      oracle.install.db.config.starterdb.storageType=
      oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=
      oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=
      oracle.install.db.config.asm.diskGroup=
      oracle.install.db.config.asm.ASMSNMPPassword=
      MYORACLESUPPORT_USERNAME=J
      MYORACLESUPPORT_PASSWORD=
      SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
      DECLINE_SECURITY_UPDATES=false
      PROXY_HOST=
      PROXY_PORT=

      -------------Database Creation Info------------------------------------------------------------------

      Name Value
      audit_file_dest {ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump
      audit_trail db
      compatible 11.2.0.0.0
      db_block_size 8KB
      db_create_file_dest +DATA
      db_domain
      db_name test
      diagnostic_dest {ORACLE_BASE}
      dispatchers (PROTOCOL=TCP) (SERVICE={SID}XDB)
      memory_target 1225MB
      open_cursors 300
      processes 150
      remote_login_passwordfile EXCLUSIVE
      undo_tablespace UNDOTBS1