Last login: Tue Nov 13 04:03:36 2012 from 192.168.208.1 [root@oel63 ~]# su - oracle [oracle@oel63 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Nov 13 12:25:37 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
idle>startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+TESTDB2_DBAT/ractest1/spfileractest1.ora' ORA-17503: ksfdopn:2 Failed to open file +TESTDB2_DBAT/ractest1/spfileractest1.ora ORA-27140: attach to post/wait facility failed ORA-27300: OS system dependent operation:invalid_egid failed with status: 1 ORA-27301: OS failure message: Operation not permitted ORA-27302: failure occurred at: skgpwinit6 ORA-27303: additional information: startup egid = 54321 (oinstall), current egid = 504 (asmadmin) idle>exit Disconnected [oracle@oel63 ~]$ exit logout [root@oel63 ~]# cd /etc/init.d [root@oel63 init.d]# ls abrt-ccpp crond ipmi messagebus oddjobd PowerPath saslauthd udev-post abrtd cups ipmidetectd mysqld ohasd psacct sblim-sfcb uuidd abrt-oops dnsmasq ipmievd netcf-transaction openct qpidd single vncserver acpid edac ipsec netconsole openhpid quota_nld smartd vsftpd atd emcp_mond.sh iptables netfs openhpi-subagent rdisc snmpd watchdog auditd firstboot irqbalance network oracleasm restorecond snmptrapd wdaemon autofs functions kdump NetworkManager oracle-rdbms-server-11gR2-preinstall-firstboot rhnsd spice-vdagentd wpa_supplicant avahi-daemon gpm killall nfs pcscd rngd sshd xinetd bmc-watchdog haldaemon libvirt-guests nfslock portreserve rpcbind sssd ypbind certmonger halt lvm2-lvmetad ntpd postfix rpcgssd stap-server cgconfig hsqldb lvm2-monitor ntpdate PowerFcoe rpcidmapd svnserve cgred httpd matahari-broker numad PowerIscsi rpcsvcgssd sysstat conman init.ohasd mcelogd o2cb PowerMig rsyslog tcsd cpuspeed ip6tables mdmonitor ocfs2 PowerMigRecoverAll sandbox tog-pegasus [root@oel63 init.d]# ./oracleasm listdisks VOL1 VOL2 VOL3 VOL4 VOL5 VOL6 VOL7 [root@oel63 init.d]# ./oracleasm scandisk Usage: ./oracleasm {start|stop|restart|enable|disable|configure|createdisk|deletedisk|querydisk|listdisks|scandisks|status} [root@oel63 init.d]# ./oracleasm scandisks Scanning the system for Oracle ASMLib disks: [ OK ] [root@oel63 init.d]# su - oracle [oracle@oel63 ~]$ su - oracle ePassword:
su: incorrect password [oracle@oel63 ~]$ [oracle@oel63 ~]$ [oracle@oel63 ~]$ [oracle@oel63 ~]$ ^C [oracle@oel63 ~]$ [oracle@oel63 ~]$ [oracle@oel63 ~]$ export ORACLE_SID=ractest1 [oracle@oel63 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Nov 13 12:30:49 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
idle>startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+TESTDB2_DBAT/ractest1/spfileractest1.ora' ORA-17503: ksfdopn:2 Failed to open file +TESTDB2_DBAT/ractest1/spfileractest1.ora ORA-27140: attach to post/wait facility failed ORA-27300: OS system dependent operation:invalid_egid failed with status: 1 ORA-27301: OS failure message: Operation not permitted ORA-27302: failure occurred at: skgpwinit6 ORA-27303: additional information: startup egid = 54321 (oinstall), current egid = 504 (asmadmin) idle>exit Disconnected [oracle@oel63 ~]$ cd [oracle@oel63 ~]$ cd $ORACLE_HOE [oracle@oel63 ~]$ cd $ORACLE_HOME [oracle@oel63 dbhome_1]$ pd -bash: pd: command not found [oracle@oel63 dbhome_1]$ pwd /u01/app/oracle/product/11.2.0/dbhome_1 [oracle@oel63 dbhome_1]$ ls apex/ clone/ cv/ dv/ install/ jdev/ log/ oc4j/ oraInst.loc* plsql/ scheduler/ sysman/ wwg/ assistants/ config/ dbs/ emcli/ instantclient/ jdk/ md/ odbc/ ord/ precomp/ slax/ timingframework/ xdk/ bin/ crs/ dc_ocm/ EMStage/ inventory/ jlib/ mesg/ olap/ oui/ racg/ sqldeveloper/ ucp/ ccr/ csmig/ deinstall/ has/ j2ee/ jpub/ mgw/ OPatch/ owb/ rdbms/ sqlj/ uix/ cdata/ css/ demo/ hs/ javavm/ ldap/ network/ opmn/ owm/ relnotes/ sqlplus/ usm/ cfgtoollogs/ ctx/ diagnostics/ ide/ jdbc/ lib/ nls/ oracore/ perl/ root.sh* srvm/ utl/ [oracle@oel63 dbhome_1]$ cd dbs [oracle@oel63 dbs]$ ls hc_ractest1.dat* init.ora* initractest1.ora* install2012-09-13_06-59-26.log* lkRACTEST1* LOG_cat_owb.TXT* orapwractest1 [oracle@oel63 dbs]$ more initractest1.ora SPFILE='+TESTDB2_DBAT/ractest1/spfileractest1.ora' [oracle@oel63 dbs]$ more '+TESTDB2_DBAT/ractest1/spfileractest1.ora' usage: more [-dflpcsu] [+linenum | +/pattern] name1 name2 ... [oracle@oel63 dbs]$ id uid=501(oracle) gid=54321(oinstall) groups=54321(oinstall),503(oper),504(asmadmin),505(asmdba),506(asmoper),54322(dba) [oracle@oel63 dbs]$ export ORACLE_SID=+ASM1 [oracle@oel63 dbs]$ asmcmd |