#acl merlyn:read,write All:read <> = Install Oracle in silent mode 11G Release 2 (11.2.0.4) on OEL6.6 = == 准备ISO REPO环境 TEST == {{{ rlwrap sed -i 's#localhost.localdomain#gowms#g' /etc/sysconfig/network ln -sfv /usr/bin/vim /bin/vi updatedb& mkdir /mnt/iso mount -o loop /media/software/OracleLinux-R6-U6-Server-x86_64-dvd.iso /mnt/iso cd /mnt createrepo . # 添加ISO源 mv /etc/yum.repos.d/public-yum-ol6.repo ~/ cat >> /etc/yum.repos.d/iso.repo <> /etc/sysctl.conf <> /etc/security/limits.conf <> /etc/security/limits.conf <> /etc/pam.d/login <> /etc/profile < /home/grid/.bash_profile <<"EOF" if [ -f ~/.bashrc ]; then . ~/.bashrc fi alias sqlplus='rlwrap sqlplus' alias rman='rlwrap rman' ORACLE_SID=+ASM; export ORACLE_SID JAVA_HOME=/usr/local/java; export JAVA_HOME ORACLE_BASE=/u01/app/grid; export ORACLE_BASE ORACLE_HOME=/u01/app/11.2.0/grid; export ORACLE_HOME ORACLE_TERM=xterm; export ORACLE_TERM NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"; export NLS_DATE_FORMAT TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN ORA_NLS11=$ORACLE_HOME/nls/data; export ORA_NLS11 PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin PATH=${PATH}:/u01/app/common/oracle/bin export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/JRE CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib export CLASSPATH THREADS_FLAG=native; export THREADS_FLAG export TEMP=/tmp export TMPDIR=/tmp umask 022 EOF }}} == Oracle Settings == # login with oracle user! {{{ su - oracle cat > /home/oracle/.bash_profile <<"EOF" export TMP=/tmp export PS1='\u@\h \w \$ ' export ORACLE_HOSTNAME=gowms export ORACLE_UNQNAME=gowms export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1 export ORACLE_SID=gowms PATH=/usr/sbin:$PATH:$ORACLE_HOME/bin export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; alias cdob='cd $ORACLE_BASE' alias cdoh='cd $ORACLE_HOME' alias tns='cd $ORACLE_HOME/network/admin' alias envo='env | grep ORACLE' umask 022 EOF }}} == Config ASM == {{{ root# /usr/sbin/oracleasm configure -i 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 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 }}} {{{#!highlight python # To avoid ASM issue with Multipath devices on Linux ORA-15186 # **** asm and multipath need special settings in /etc/sysconfig/oracleasm **** # for device mapper drives, scan dm at first # # ORACLEASM_SCANORDER=dm # ignore sd drives, because we have multipath, to avoid missconfigurations # # ORACLEASM_SCANEXCLUDE=sd }}} {{{ sed -i 's/ORACLEASM_SCANORDER="/ORACLEASM_SCANORDER="dm/' /etc/sysconfig/oracleasm sed -i 's/ORACLEASM_SCANEXCLUDE="/ORACLEASM_SCANEXCLUDE="sd/' /etc/sysconfig/oracleasm /usr/sbin/oracleasm init /etc/init.d/oracleasm stop; sleep 2 /etc/init.d/oracleasm start }}} == Creating ASM disk volumes == # parted /dev/sdc mklabel gpt disk >2TB === Check WWID(The World Wide Identifier) === {{{ #!highlight python #! /bin/bash # Usage: As root user run for DISK in `find /dev/ -name "sd*" | sort` do WWID=`/sbin/scsi_id --whitelisted --replace-whitespace --device=$DISK` echo $DISK " WWID is " $WWID done }}} === mklable for disk & auto parted disks === {{{ fdisk -l for i in sdb sdc sdd; do echo "parted" /dev/$i "mklabel gpt mkpart primary 0% 100%"; done parted /dev/sdc mklabel gpt mkpart primary 0% 100% parted /dev/sdb mklabel gpt mkpart primary 0% 100% awk '{ print "parted ", $0, "mklabel gpt mkpart primary 0% 100%" }' < /tmp/x > /tmp/xx parted /dev/sdb mklabel gpt mkpart primary 0% 100% parted /dev/sdc mklabel gpt mkpart primary 0% 100% parted /dev/sdd mklabel gpt mkpart primary 0% 100% parted /dev/sde mklabel gpt mkpart primary 0% 100% parted /dev/sdf mklabel gpt mkpart primary 0% 100% parted /dev/sdb print parted /dev/sdc print parted /dev/sdd print }}} === Reload udev rules === {{{ for DISK in `find /dev/ -name "sd?1"` ; do echo `udevadm info --query=all --name=$DISK | grep -i "DEVLINKS=" | awk -F"=" '{ print "ACTION==\"add|change\" ENV{DEVLINKS}==\""$2"\",OWNER=\"grid\",GROUP=\"asmadmin\",MODE=\"0660\"" }'`,SYMLINK+=\"oracleasm/\"; done }}} {{{ udevadm control --reload-rules #RHEL6 udevadm trigger --type=devices --action=change # RHEL7 udevadm trigger }}} === create ASM disk (Options) === # in gowms! {{{ /usr/sbin/oracleasm createdisk GOWMS_01 /dev/sdb1 /usr/sbin/oracleasm createdisk GOEC_01 /dev/sdc1 /usr/sbin/oracleasm createdisk GOWMS_CRS01 /dev/sdd1 /usr/sbin/oracleasm createdisk GOWMS_ARCH01 /dev/sde1 /usr/sbin/oracleasm createdisk GOWMS_REDO01 /dev/sdf1 /usr/sbin/oracleasm createdisk GOWMS_01 /dev/mapper/GO_WMS01p1 /usr/sbin/oracleasm createdisk GOWMS_ARCH01 /dev/mapper/GOWMS_ARCH01p1 /usr/sbin/oracleasm createdisk GOWMS_CRS01 /dev/mapper/GOWMS_CRS01p1 /usr/sbin/oracleasm createdisk GOWMS_REDO01 /dev/mapper/GOWMS_REDO01p1 /usr/sbin/oracleasm createdisk GO_EC01 /dev/mapper/GO_EC01p1 /usr/sbin/oracleasm scandisks /usr/sbin/oracleasm listdisks oracleasm-discover }}} # in gowms-stb!!! {{{ /usr/sbin/oracleasm createdisk GOWMSSTB_01 /dev/sdb1 /usr/sbin/oracleasm createdisk GOCARD_01 /dev/sdc1 /usr/sbin/oracleasm createdisk GOWMS_stb_CRS01 /dev/sdd1 /usr/sbin/oracleasm scandisks /usr/sbin/oracleasm listdisks }}} == install grid software == # login as grid user! # Notes #+ choose For A Standalone Server {{{ unzip /media/software/p13390677_112040_Linux-x86-64_3of7.zip ~/grid/runInstaller # Check it ps -ef | grep grid }}} === auto install grid with rsp file === ./grid/runInstaller -showProgress -ignorePrereq -silent -force -responseFile /home/grid/grid_silent.rsp As a root user, execute the following script(s): {{{ 1. /u01/app/oraInventory/orainstRoot.sh 2. /u01/app/11.2.0/grid/root.sh }}} == deinstall grid standalone == lsnrctl stop /u01/app/11.2.0/grid/deinstall/deinstall == Creating ASM disk groups for Oracle database installation == # login as grid user! {{{ asmca& create GOWMS_DATA GOPWS_ARCH GOPOWS_REDO CRS SQL> CREATE DISKGROUP GOPOS_DATA EXTERNAL REDUNDANCY DISK 'ORCL:GOPOS_DATA0001' SIZE 204799M ATTRIBUTE 'compatible.asm'='11.2.0.0.0','au_size'='1M'; CREATE DISKGROUP DATA EXTERNAL REDUNDANCY DISK '/dev/oracleasm/data*'; }}} == install database software == {{{ su - oracle cd /home/oracle -> unzip software 11.2.0.4 unizp p13390677_112040_Linux-x86-64_1of7.zip unzip p13390677_112040_Linux-x86-64_2of7.zip }}} === install Database with db_install.rsp === * ./runInstaller -showProgress -silent -ignoreSysPrereqs -ignorePrereq -responseFile ~/db_install.rsp {{{ [oracle@rac-01 database]$ ./runInstaller -showProgress -silent -ignoreSysPrereqs -ignorePrereq -responseFile ~/db.rsp Starting Oracle Universal Installer... Checking Temp space: must be greater than 120 MB. Actual 14496 MB Passed Checking swap space: must be greater than 150 MB. Actual 3071 MB Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2020-08-20_09-18-11AM. Please wait ...[oracle@rac-01 database]$ You can find the log of this install session at: /u01/app/oraInventory/logs/installActions2020-08-20_09-18-11AM.log Prepare in progress. .................................................. 9% Done. Prepare successful. Copy files in progress. .................................................. 15% Done. [oracle@rac-01 database]$ .................... 20% Done. .................................................. 30% Done. .................................................. 36% Done. .................................................. 41% Done. .................................................. 46% Done. .................................................. 51% Done. .................................................. 56% Done. Copy files successful. .......... Link binaries in progress. Link binaries successful. .................................................. 77% Done. Setup files in progress. .................................................. 94% Done. Setup files successful. The installation of Oracle Database 11g was successful. Please check '/u01/app/oraInventory/logs/silentInstall2020-08-20_09-18-11AM.log' for more details. Execute Root Scripts in progress. As a root user, execute the following script(s): 1. /u01/app/oracle/product/11.2.0/dbhome_1/root.sh Execute /u01/app/oracle/product/11.2.0/dbhome_1/root.sh on the following nodes: [rac-01, rac-02] .................................................. 100% Done. Execute Root Scripts successful. Successfully Setup Software. }}} {{{ oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0 oracle.install.option=INSTALL_DB_SWONLY ORACLE_HOSTNAME=gowms UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/u01/app/oraInventory SELECTED_LANGUAGES=en ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 ORACLE_BASE=/u01/app/oracle oracle.install.db.InstallEdition=EE oracle.install.db.EEOptionsSelection=false oracle.install.db.optionalComponents= oracle.install.db.DBA_GROUP=dba oracle.install.db.OPER_GROUP=oper oracle.install.db.CLUSTER_NODES= oracle.install.db.isRACOneInstall=false oracle.install.db.racOneServiceName= 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.memoryOption=false oracle.install.db.config.starterdb.memoryLimit= 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.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= MYORACLESUPPORT_PASSWORD= SECURITY_UPDATES_VIA_MYORACLESUPPORT=false DECLINE_SECURITY_UPDATES=true PROXY_HOST= PROXY_PORT= PROXY_USER= PROXY_PWD= PROXY_REALM= COLLECTOR_SUPPORTHUB_URL= oracle.installer.autoupdates.option=SKIP_UPDATES oracle.installer.autoupdates.downloadUpdatesLoc= AUTOUPDATES_MYORACLESUPPORT_USERNAME= AUTOUPDATES_MYORACLESUPPORT_PASSWORD= }}} complete it with following command: {{{ As a root user, execute the following script(s): 1. /u01/app/oraInventory/orainstRoot.sh 2. /u01/app/oracle/product/11.2.0/dbhome_1/root.sh Successfully Setup Software. }}} === uninstall database === /u01/app/oracle/product/11.2.0/db_1/deinstall/deinstall == Create Database with dbca command OR dbca_silent.rsp == # Pay attention to database control file location in initialization parameter configuration step (place control files on ASM disks +DATA and copy on +FRA): ("+DATA/{DB_UNIQUE_NAME}/control01.ctl", "+FRA/{DB_UNIQUE_NAME}/control02.ctl") {{{ dbca& dbca -silent \ -createDatabase \ -asmsnmpPassword Systec36 \ -characterSet ZHS16GBK \ -continueOnNonFatalErrors false \ -disableSecurityConfiguration ALL \ -diskGroupName GOWMS_DATA \ -emConfiguration NONE \ -gdbName gowms \ -listeners LISTENER \ -memoryPercentage 30 \ -recoveryAreaDestination none \ -sid gowms \ -SysPassword Systec36 \ -SystemPassword Systec36 \ -storageType ASM \ -sampleSchema true \ -templateName General_Purpose.dbc }}} # For RAC {{{ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname orcl -sid orcl -SysPassword Systec36 -SystemPassword Systec36 -responseFile NO_VALUE -characterSet AL32UTF8 -memoryPercentage 40 -emConfiguration NONE -redoLogFileSize 100 -recoveryAreaDestination FRA -storageType ASM -asmSysPassword Systec36 -diskGroupName DATA -characterSet AL32UTF8 -nationalCharacterSet AL16UTF16 $ORACLE_HOME/bin/dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName orcl -sid orcl -sysPassword Systec36 -systemPassword Systec36 -sysmanPassword Systec36 -dbsnmpPassword Systec36 -emConfiguration LOCAL -storageType ASM -diskGroupName DATA -datafileJarLocation $ORACLE_HOME/assistants/dbca/templates -nodeinfo rac-01,rac-02 -characterset AL32UTF8 -obfuscatedPasswords false -sampleSchema false -asmSysPassword Systec36 -automaticMemoryManagement true -memoryPercentage 40 -sampleSchema true Copying database files 1% complete 3% complete 9% complete 15% complete 21% complete 27% complete 30% complete Creating and starting Oracle instance 32% complete 36% complete 40% complete 44% complete 45% complete 48% complete 50% complete Creating cluster database views 52% complete 70% complete Completing Database Creation 73% complete 76% complete 85% complete 94% complete 100% complete Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details. }}} === The following commands will delete the databases we created earlier. === {{{ oracle@mrac01 ~ $ dbca -silent -deleteDatabase -sourceDB ddtest -sysDBAUserName sys -sysDBAPassword oracle Connecting to database 4% complete 9% complete 14% complete 19% complete 23% complete 28% complete 47% complete Updating network configuration files 52% complete Deleting instance and datafiles 76% complete 100% complete Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/ddtest.log" for further details. }}} === dbca_silent.rsp === {{{ --global database name GDBNAME = "gowms" --instance database name SID = "gowms" --template name used to create database TEMPLATENAME = "General_Purpose.dbc" --password for user sys SYSPASSWORD = "oracle" --password for user system SYSTEMPASSWORD = "oracle" --creates database console EMCONFIGURATION = "LOCAL" --password for sysman user SYSMANPASSWORD = "oracle" --password for dbsnmp user DBSNMPPASSWORD = "oracle" --storage used to create database --FS - it means OS data files STORAGETYPE=FS --default directory for oracle database datafiles DATAFILEDESTINATION=/rac-restore/oradata --default directory for flashback dataa RECOVERYAREADESTINATION=/rac-restore/flash_recovery_area STORAGETYPE=FS --database character set CHARACTERSET = "AL32UTF8" --national database character set NATIONALCHARACTERSET= "AL16UTF16" --listener name to register database to LISTENERS = "LISTENER" --force to install sample schemas on the database SAMPLESCHEMA=TRUE --specify database type --has influence on some instance parameters DATABASETYPE = "OLTP" --force to use autmatic mamory management AUTOMATICMEMORYMANAGEMENT = "TRUE" --defines size of memory used by the database }}} * dbca -silent -responseFile ~/db_install.rsp == edit /etc/oratab == gowms:/u01/app/oracle/product/11.2.0/db_1:Y = Troubleshooting = == Disk "GOEC_01" does not exist or is not instantiated == [root@gowms ~]# /usr/sbin/oracleasm deletedisk GOEC_01 {{{ dd if=/dev/zero of=/dev/oracleasm/disks/GO_EC01 bs=1024 count=100 /usr/sbin/oracleasm init /etc/init.d/oracleasm stop; sleep 2 /etc/init.d/oracleasm start }}} == oracle 11g dbca ORA-01031: insufficient privileges asm == {{{ [grid@gowms ~]$ srvctl start database -d gowms PRCR-1079 : Failed to start resource ora.gowms.db ORA-01031: insufficient privileges CRS-5017: The resource action "ora.gowms.db start" encountered the following error: ORA-01031: insufficient privileges . For details refer to "(:CLSN00107:)" in "/u01/app/11.2.0/grid/log/gowms/agent/ohasd/oraagent_grid/oraagent_grid.log". CRS-2674: Start of 'ora.gowms.db' on 'gowms' failed ORA-01031: insufficient privileges [grid@gowms ~]$ id grid uid=1100(grid) gid=1000(oinstall) groups=1000(oinstall),1200(asmadmin),1201(asmdba),1202(asmoper) }}} => add grid to dba group!!! {{{ [root@gowms ~]# usermod -G dba,asmadmin,asmdba,asmoper grid [root@gowms ~]# id grid uid=1100(grid) gid=1000(oinstall) groups=1000(oinstall),1200(asmadmin),1201(asmdba),1202(asmoper),1300(dba) [grid@gowms ~]$ srvctl start database -d gowms [grid@gowms ~]$ srvctl status database -d gowms Database is running. }}} == oracle 11g asm change hostname ERROR == {{{ [root@gowmsstb ~]# cd /u01/app/11.2.0/grid/crs/install/ [root@gowmsstb install]# ls cmdllroot.sh crsconfig_params.sbs inittab onsconfig paramfile.crs rootofs.sh tfa_setup.sh crsconfig_addparams.sbs crsdelete.pm install.excl oraacfs.pm preupdate.sh s_crsconfig_defs crsconfig_lib.pm crspatch.pm install.incl oracle-ohasd.conf rootcrs.pl s_crsconfig_gowms-stb_env.txt crsconfig_params hasdconfig.pl installRemove.excl oracss.pm roothas.pl s_crsconfig_lib.pm [root@gowmsstb install]# ./roothas.pl -deconfig -force Using configuration parameter file: ./crsconfig_params CRS-4639: Could not contact Oracle High Availability Services CRS-4000: Command Stop failed, or completed with errors. CRS-4639: Could not contact Oracle High Availability Services CRS-4000: Command Delete failed, or completed with errors. CLSU-00100: Operating System function: opendir failed with error data: 2 CLSU-00101: Operating System error message: No such file or directory CLSU-00103: error location: scrsearch1 CLSU-00104: additional error information: cant open scr home dir scls_scr_getval CRS-4544: Unable to connect to OHAS CRS-4000: Command Stop failed, or completed with errors. Successfully deconfigured Oracle Restart stack [root@gowmsstb install]# ./roothas.pl Using configuration parameter file: ./crsconfig_params LOCAL ADD MODE Creating OCR keys for user 'grid', privgrp 'oinstall'.. Operation successful. LOCAL ONLY MODE Successfully accumulated necessary OCR keys. Creating OCR keys for user 'root', privgrp 'root'.. Operation successful. CRS-4664: Node gowmsstb successfully pinned. Adding Clusterware entries to upstart gowmsstb 2016/07/19 16:55:42 /u01/app/11.2.0/grid/cdata/gowmsstb/backup_20160719_165542.olr Successfully configured Oracle Grid Infrastructure for a Standalone Server [grid@gowmsstb install]$ crsctl check has CRS-4638: Oracle High Availability Services is online [grid@gowmsstb install]$ asmcmd lsdg Connected to an idle instance. ASMCMD-8102: no connection to Oracle ASM; command requires Oracle ASM to run [grid@gowmsstb install]$ crs_st crs_start crs_start.bin crs_stat crs_stat.bin crs_stop crs_stop.bin [grid@gowmsstb install]$ crs_stat NAME=ora.cssd TYPE=ora.cssd.type TARGET=OFFLINE STATE=OFFLINE NAME=ora.diskmon TYPE=ora.diskmon.type TARGET=OFFLINE STATE=OFFLINE NAME=ora.evmd TYPE=ora.evm.type TARGET=ONLINE STATE=ONLINE on gowmsstb NAME=ora.ons TYPE=ora.ons.type TARGET=OFFLINE STATE=OFFLINE [grid@gowmsstb install]$ crsctl start resource "ora.cssd" CRS-2672: Attempting to start 'ora.cssd' on 'gowmsstb' CRS-2672: Attempting to start 'ora.diskmon' on 'gowmsstb' CRS-2676: Start of 'ora.diskmon' on 'gowmsstb' succeeded CRS-2676: Start of 'ora.cssd' on 'gowmsstb' succeeded [grid@gowmsstb install]$ [grid@gowmsstb install]$ crs_stat NAME=ora.cssd TYPE=ora.cssd.type TARGET=ONLINE STATE=ONLINE on gowmsstb NAME=ora.diskmon TYPE=ora.diskmon.type TARGET=OFFLINE STATE=OFFLINE NAME=ora.evmd TYPE=ora.evm.type TARGET=ONLINE STATE=ONLINE on gowmsstb NAME=ora.ons TYPE=ora.ons.type TARGET=OFFLINE STATE=OFFLINE [grid@gowmsstb install]$ asmcmd lsdg Connected to an idle instance. ASMCMD-8102: no connection to Oracle ASM; command requires Oracle ASM to run [grid@gowmsstb install]$ crsctl start resource "ora.diskmon" CRS-2672: Attempting to start 'ora.diskmon' on 'gowmsstb' CRS-2676: Start of 'ora.diskmon' on 'gowmsstb' succeeded [grid@gowmsstb ~]$ crsctl config has CRS-4622: Oracle High Availability Services autostart is enabled. [grid@gowmsstb ~]$ crs_stat NAME=ora.cssd TYPE=ora.cssd.type TARGET=ONLINE STATE=OFFLINE NAME=ora.diskmon TYPE=ora.diskmon.type TARGET=OFFLINE STATE=OFFLINE NAME=ora.evmd TYPE=ora.evm.type TARGET=ONLINE STATE=ONLINE on gowmsstb NAME=ora.ons TYPE=ora.ons.type TARGET=OFFLINE STATE=OFFLINE [grid@gowmsstb ~]$ crsctl start resource "ora.cssd" CRS-2672: Attempting to start 'ora.cssd' on 'gowmsstb' CRS-2672: Attempting to start 'ora.diskmon' on 'gowmsstb' CRS-2676: Start of 'ora.diskmon' on 'gowmsstb' succeeded CRS-2676: Start of 'ora.cssd' on 'gowmsstb' succeeded [grid@gowmsstb ~]$ crs_stat NAME=ora.cssd TYPE=ora.cssd.type TARGET=ONLINE STATE=ONLINE on gowmsstb NAME=ora.diskmon TYPE=ora.diskmon.type TARGET=OFFLINE STATE=OFFLINE NAME=ora.evmd TYPE=ora.evm.type TARGET=ONLINE STATE=ONLINE on gowmsstb NAME=ora.ons TYPE=ora.ons.type TARGET=OFFLINE STATE=OFFLINE [grid@gowmsstb ~]$ srvctl add listener -l LISTENER [grid@gowmsstb ~]$ srvctl start listener [grid@gowmsstb ~]$ srvctl status listener Listener LISTENER is enabled Listener LISTENER is running on node(s): gowmsstb }}} {{{ $ORACLE_HOME/bin/crsctl stat res -t $ORACLE_HOME/bin/crsctl stat res -p $ORACLE_HOME/bin/crsctl query css votedisk $ORACLE_HOME/bin/ocrcheck $ORACLE_HOME/bin/oifcfg getif $ORACLE_HOME/bin/srvctl config nodeapps -a $ORACLE_HOME/bin/srvctl config scan $ORACLE_HOME/bin/srvctl config asm -a $ORACLE_HOME/bin/srvctl config listener -l -a $DB_HOME/bin/srvctl config database -d -a $DB_HOME/bin/srvctl config service -d -s -v srvctl stop ASM -f srvctl start ASM }}} == ASM error02 == Doc ID 1084186.1 {{{ In case of role separation we typically have the following groups and users: Grid Infrastructure Home Owner : grid Primary Group : oinstall Secondary Groups : asmadmin, asmdba, asmoper RDBMS Home Owner : oracle Primary Group : oinstall Secondary Groups : dba, oper, asmdba In case of stand alone set up, if the 11.2 Database be managed by Oracle Restart ( srvctl stop/start ), then 'grid' user should also be a part of 'dba' group. The ASM Disks would be owned by grid:asmadmin 11.2 Database If we use 11.2 DBCA to create the database, everything will go through fine. If we create the 11.2 database manually, then before creating the database we need to run the following command: $ su - grid $ cd /bin $ ./setasmgidwrap o=<11.2 RDBMS Home>/bin/oracle If we do not do this, database creation will fail with ORA-15025 as it will not be able to access the ASM Disks. Note: Bug 9575578 is fixed in 11.2.0.2 GI release }}} == RMAN> duplicate target database to aux nofilenamecheck; == {{{ [root@anar bin]# ls -lrt oracle -rwxr-x--x 1 oracle asmadmin 163939510 Jan 14 17:20 oracle }}} https://anargodjaev.wordpress.com/2014/06/13/ora-17502-ksfdcre5-failed-to-create-file-data/ == INFO: Parsing ORA-15025: could not open disk "/dev/raw/rawctl" == {{{ INFO: INFO: Starting Output Reader Threads for process /tmp/OraInstall2016-07-20_08-22-44PM/ext/bin/kfod INFO: INFO: Parsing 317432 CANDIDATE ORCL:GOWMS_01 INFO: INFO: The process /tmp/OraInstall2016-07-20_08-22-44PM/ext/bin/kfod exited with code 0 INFO: INFO: Waiting for output processor threads to exit. INFO: INFO: Parsing 511993 CANDIDATE ORCL:GOWMS_ARCH01 INFO: INFO: Parsing 1023 CANDIDATE ORCL:GOWMS_CRS01 INFO: INFO: Parsing 61436 CANDIDATE ORCL:GOWMS_REDO01 INFO: INFO: Parsing 204799 CANDIDATE ORCL:GO_EC01 INFO: INFO: Parsing KFOD-00311: Error scanning device /dev/raw/rawctl INFO: INFO: Parsing ORA-15025: could not open disk "/dev/raw/rawctl" INFO: INFO: Parsing Linux-x86_64 Error: 13: Permission denied INFO: INFO: Parsing Additional information: 42 INFO: INFO: Parsing Additional information: 22608487 INFO: INFO: Parsing Additional information: 1598903119 INFO: INFO: Parsing KFOD-00602: Could not initialize sub heap kfodgpheap INFO: INFO: Output processor threads exited. }}} == xxx == {{{ NOTE: Loaded library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so NOTE: Loaded library: System SUCCESS: diskgroup GOWMS_DATA was mounted Errors in file /u01/app/oracle/diag/rdbms/gowms/gowms/trace/gowms_ora_9298.trc (incident=8572): ORA-00600: internal error code, arguments: [krhcvt_filhdr_v10_01], [], [], [], [], [], [], [], [], [], [], [] Incident details in: /u01/app/oracle/diag/rdbms/gowms/gowms/incident/incdir_8572/gowms_ora_9298_i8572.trc ERROR: failed to establish dependency between database gowms and diskgroup resource ora.GOWMS_DATA.dg Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Errors in file /u01/app/oracle/diag/rdbms/gowms/gowms/trace/gowms_ora_9298.trc: ORA-00600: internal error code, arguments: [krhcvt_filhdr_v10_01], [], [], [], [], [], [], [], [], [], [], [] ORA-1503 signalled during: Create controlfile reuse set database "gowms" MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 }}} == relink grid == {{{ grid@lnx01:[GRID]$ sudo /u01/app/11.2.0.3/grid/crs/install/rootcrs.pl -unlock grid@lnx01:[GRID]$ relink all sudo /u01/app/11.2.0.3/grid/crs/install/rootcrs.pl -patch }}} http://sosdba.blogspot.com/2013/06/dbca-for-rac-returns-ora-15025-could.html == References == https://anargodjaev.wordpress.com/2014/06/13/ora-17502-ksfdcre5-failed-to-create-file-data/ https://gruffdba.wordpress.com/2013/01/10/silent-install-of-oracle-11-2-0-3-on-redhat-6-0/ http://dbaora.com/install-oracle-in-silent-mode-11g-release-2-11-2/ https://emarcel.com/installing-oracle-database-11g-r2-on-linux-with-asm/ http://www.oracle-wiki.net/startdocshowtoinstalloracle11glinuxasm#Directory-Structure https://community.emc.com/docs/DOC-32190 https://blogs.oracle.com/linux/entry/oracle_rdbms_server_11gr2_pre https://orasteps.wordpress.com/tag/remove-grid-infrastructure/ http://www.databasesql.info/article/6122354324/ https://community.oracle.com/thread/1557361?tstart=0 https://orasg.com/2015/10/04/how-to-deconfigurereconfigurerebuild-ocr-or-deinstall-grid-infrastructure/