Contents

  1. Install Oracle in silent mode 11G Release 2 (11.2.0.4) on OEL6.6
    1. 准备ISO REPO环境
    2. bond0
    3. install missing packages
    4. install Huawei Ultrapath
    5. add users/groups
    6. create directorys
    7. add kernel parameters ? no need!
    8. Some system parameters
    9. Grid Settings FOR ASM
    10. Oracle Settings
    11. Config ASM
    12. Creating ASM disk volumes
      1. mklable for disk & auto parted disks
      2. create ASM disk
    13. install grid software
      1. auto install grid with rsp file
    14. deinstall grid standalone
    15. Creating ASM disk groups for Oracle database installation
    16. install database software
      1. install Database with db_install.rsp
      2. uninstall database
    17. Create Database with dbca command OR dbca_silent.rsp
      1. dbca_silent.rsp
    18. edit /etc/oratab
  2. Troubleshooting
    1. oracle dbca cannot see asm diskgroup
    2. Disk "GOEC_01" does not exist or is not instantiated
    3. oracle 11g dbca ORA-01031: insufficient privileges asm
    4. oracle 11g asm change hostname ERROR
    5. ASM error02
    6. RMAN> duplicate target database to aux nofilenamecheck;
    7. INFO: Parsing ORA-15025: could not open disk "/dev/raw/rawctl"
    8. xxx
    9. relink grid
    10. References

Install Oracle in silent mode 11G Release 2 (11.2.0.4) on OEL6.6

准备ISO REPO环境

rlwrap

sed -i 's#localhost.localdomain#gopos#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 <<EOF
[IS0]
name=ISO
baseurl=file:///mnt
gpgcheck=0
enabled=1
EOF

bond0

DEVICE=bond0
IPADDR=192.168.81.11
NETMASK=255.255.255.0
GATEWAY=192.168.81.1
ONBOOT=yes
BOOTPROTO=none
USERCTL=no
NM_CONTROLLED=no
#BONDING_OPTS="miimon=100 mode=0 downdelay=200"
BONDING_OPTS="miimon=100 mode=1 primary=eth0 downdelay=0 primary_reselect=1"

ifcfg-eth0 

DEVICE=eth0
BOOTPROTO=none
ONBOOT=yes
MASTER=bond0
SLAVE=yes
USERCTL=no
NM_CONTROLLED=no
HWADDR=74:9d:8f:85:e2:b3
UUID="fd773dc7-c7a0-4292-94c3-0bb9aca10280"
TYPE="Ethernet"
MTU="1500"
IPV6INIT="no"

install missing packages

rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE}(%{ARCH})\n' binutils \
compat-libstdc++-33 \
elfutils-libelf \
elfutils-libelf-devel \
gcc \
gcc-c++ \
glibc \
glibc-common \
glibc-devel \
glibc-headers \
ksh \
libaio \
libaio-devel \
libgcc \
libstdc++ \
libstdc++-devel \
make \
sysstat \
unixODBC \
unixODBC-devel

rpm -Uvh /media/software/oracleasmlib-2.0.12-1.el6.x86_64.rpm 
yum install oracleasm-support.x86_64 oracle-rdbms-server-11gR2-preinstall
yum install elfutils-libelf-devel libaio-devel unixODBC  unixODBC-devel -y

install Huawei Ultrapath

sh /media/software/RHEL/install.sh

add users/groups

groupadd -g 1000 oinstall
groupadd -g 1200 asmadmin
groupadd -g 1201 asmdba
groupadd -g 1202 asmoper
groupadd -g 1300 dba 
groupadd -g 1301 oper

useradd -m -u 1101 -g oinstall -G dba,oper,asmdba,asmadmin -d /home/oracle -s /bin/bash oracle
passwd oracle

useradd -m -u 1100 -g oinstall -G dba,asmadmin,asmdba,asmoper -d /home/grid -s /bin/bash grid
passwd grid

OR:
usermod -a -G dba grid
usermod -a -G asmadmin,asmoper oracle

create directorys

mkdir -pv /u01/app/grid
mkdir -pv /u01/app/11.2.0/grid
chown -Rv grid:oinstall /u01

mkdir -pv /u01/app/oracle/product/11.2.0/db_1
chown -Rv oracle:oinstall /u01/app/oracle

add kernel parameters ? no need!

   1 cat >> /etc/sysctl.conf <<EOF
   2 kernel.shmmax = 68719476736
   3 kernel.shmall = 4294967296
   4 kernel.shmmni = 4096
   5 kernel.sem = 250 32000 100 128
   6 fs.file-max = 6815744
   7 net.ipv4.ip_local_port_range = 9000 65500
   8 net.core.rmem_default=262144
   9 net.core.rmem_max=4194304
  10 net.core.wmem_default=262144
  11 net.core.wmem_max=1048576
  12 fs.aio-max-nr=1048576
  13 EOF
  14 sysctl -p
  15 
  16 cat >> /etc/security/limits.conf <<EOF 
  17 oracle   soft   nproc    131072
  18 oracle   hard   nproc    131072
  19 oracle   soft   nofile   131072
  20 oracle   hard   nofile   131072
  21 oracle   soft   core     unlimited
  22 oracle   hard   core     unlimited
  23 oracle   soft   memlock  50000000
  24 oracle   hard   memlock  50000000
  25 grid soft nproc 2047 
  26 grid hard nproc 16384 
  27 grid soft nofile 1024 
  28 grid hard nofile 65536 
  29 EOF

Some system parameters

sed -i 's/OPTIONS="-u/OPTIONS="-x -u/' /etc/sysconfig/ntpd

service ntpd restart 

cat >> /etc/security/limits.conf <<EOF 
grid soft nproc 2047 
grid hard nproc 16384 
grid soft nofile 1024 
grid hard nofile 65536 
EOF

cat >> /etc/pam.d/login <<EOF  
session required pam_limits.so  
EOF

cat >> /etc/profile <<EOF
if [ \$USER = "oracle" ] || [ \$USER = "grid" ]; then
  if [ \$SHELL = "/bin/ksh" ]; then
    ulimit -p 16384
    ulimit -n 65536
  else
    ulimit -u 16384 -n 65536
  fi
umask 022
fi
EOF

Grid Settings FOR ASM

login with grid user! 

su - grid
cat > /home/grid/.bash_profile <<"EOF"
if [ -f ~/.bashrc ]; then
  . ~/.bashrc
fi
alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'
alias rman='rlwrap asmcmd'
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 \$ '

alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'
export ORACLE_HOSTNAME=gopos
export ORACLE_UNQNAME=gopos
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=gopos

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;
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

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 <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          

   1 # To avoid ASM issue with Multipath devices on Linux ORA-15186
   2 # **** asm and multipath need special settings in /etc/sysconfig/oracleasm ****
   3 
   4 # for device mapper drives, scan dm at first #
   5 # ORACLEASM_SCANORDER=dm
   6 
   7 # ignore sd drives, because we have multipath, to avoid missconfigurations #
   8 # 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

mklable for disk & auto parted disks

fdisk -l

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

create ASM disk

# in gopos!!! 

/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

#
# 20160727 added
#
$ awk '{ print "parted /dev/"$2, "mklabel msdos mkpart primary 0% 100%" }' < x > /tmp/xx
parted /dev/sdav mklabel msdos mkpart primary 0% 100%
parted /dev/sdaw mklabel msdos mkpart primary 0% 100%
parted /dev/sdax mklabel msdos mkpart primary 0% 100%
parted /dev/sday mklabel msdos mkpart primary 0% 100%
parted /dev/sdaz mklabel msdos mkpart primary 0% 100%
parted /dev/sdba mklabel msdos mkpart primary 0% 100%
parted /dev/sdbb mklabel msdos mkpart primary 0% 100%
parted /dev/sdbc mklabel msdos mkpart primary 0% 100%
parted /dev/sdbd mklabel msdos mkpart primary 0% 100%

$ awk '{ print "/usr/sbin/oracleasm createdisk ", $3, "/dev/"$2"1" }' < x 
 /usr/sbin/oracleasm createdisk  GOPOS_DATA0041 /dev/sdav1
 /usr/sbin/oracleasm createdisk  GOPOS_DATA0042 /dev/sdaw1
 /usr/sbin/oracleasm createdisk  GOPOS_DATA0043 /dev/sdax1
 /usr/sbin/oracleasm createdisk  GOPOS_DATA0044 /dev/sday1
 /usr/sbin/oracleasm createdisk  GOPOS_DATA0045 /dev/sdaz1
 /usr/sbin/oracleasm createdisk  GOPOS_DATA0046 /dev/sdba1
 /usr/sbin/oracleasm createdisk  GOPOS_DATA0047 /dev/sdbb1
 /usr/sbin/oracleasm createdisk  GOPOS_DATA0048 /dev/sdbc1
 /usr/sbin/oracleasm createdisk  GOPOS_Arch0004 /dev/sdbd1


 /usr/sbin/oracleasm createdisk  REDO_LOCAL01 /dev/sda6



/usr/sbin/oracleasm scandisks
/usr/sbin/oracleasm listdisks

oracleasm-discover

# in gopos-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 

# 20160727 added
#
$ awk '{ print "parted /dev/"$2, "mklabel msdos mkpart primary 0% 100%" }' < x > /tmp/xx
parted /dev/sdav mklabel msdos mkpart primary 0% 100%
parted /dev/sdaw mklabel msdos mkpart primary 0% 100%
parted /dev/sdax mklabel msdos mkpart primary 0% 100%
parted /dev/sday mklabel msdos mkpart primary 0% 100%
parted /dev/sdaz mklabel msdos mkpart primary 0% 100%
parted /dev/sdba mklabel msdos mkpart primary 0% 100%
parted /dev/sdbb mklabel msdos mkpart primary 0% 100%
parted /dev/sdbc mklabel msdos mkpart primary 0% 100%
parted /dev/sdbd mklabel msdos mkpart primary 0% 100%

$ awk '{ print "/usr/sbin/oracleasm createdisk ", $3, "/dev/"$2"1" }' < x 
/usr/sbin/oracleasm createdisk  GOPOS_stb_DATA0041 /dev/sdav1
/usr/sbin/oracleasm createdisk  GOPOS_stb_DATA0042 /dev/sdaw1
/usr/sbin/oracleasm createdisk  GOPOS_stb_DATA0043 /dev/sdax1
/usr/sbin/oracleasm createdisk  GOPOS_stb_DATA0044 /dev/sday1
/usr/sbin/oracleasm createdisk  GOPOS_stb_DATA0045 /dev/sdaz1
/usr/sbin/oracleasm createdisk  GOPOS_stb_DATA0046 /dev/sdba1
/usr/sbin/oracleasm createdisk  GOPOS_stb_DATA0047 /dev/sdbb1
/usr/sbin/oracleasm createdisk  GOPOS_stb_DATA0048 /dev/sdbc1
/usr/sbin/oracleasm createdisk  GOPOS_stb_Arch0004 /dev/sdbd1

 /usr/sbin/oracleasm createdisk  REDO_LOCAL01 /dev/sda6


/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 -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

rm -rf /etc/oraInst.loc
rm -rf /opt/ORCLfmap
rm -rf /etc/oratab

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';

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

/u01/app/oracle/product/11.2.0/db_1/root.sh 

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=gopos
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=

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 GOPOS_DATA \
-emConfiguration NONE \
-gdbName gopos \
-listeners LISTENER \
-memoryPercentage 50 \
-recoveryAreaDestination none \
-sid gopos \
-SysPassword Systec36 \
-SystemPassword Systec36 \
-storageType ASM \
-sampleSchema true \
-templateName General_Purpose.dbc

dbca_silent.rsp

--global database name
GDBNAME = "gopos"

--instance database name
SID = "gopos"

--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=/u01/app/oracle/oradata

--default directory for flashback dataa
RECOVERYAREADESTINATION=/u01/app/oracle/flash_recovery_area

STORAGETYPE=FS

--database character set
CHARACTERSET = "zhs16gbk"

--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

edit /etc/oratab

gopos:/u01/app/oracle/product/11.2.0/db_1:Y

Troubleshooting

oracle dbca cannot see asm diskgroup

Disk "GOEC_01" does not exist or is not instantiated

[root@gopos ~]# /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@gopos ~]$ srvctl start database -d gopos
PRCR-1079 : Failed to start resource ora.gopos.db
ORA-01031: insufficient privileges
CRS-5017: The resource action "ora.gopos.db start" encountered the following error: 
ORA-01031: insufficient privileges
. For details refer to "(:CLSN00107:)" in "/u01/app/11.2.0/grid/log/gopos/agent/ohasd/oraagent_grid/oraagent_grid.log".

CRS-2674: Start of 'ora.gopos.db' on 'gopos' failed
ORA-01031: insufficient privileges
[grid@gopos ~]$ id grid
uid=1100(grid) gid=1000(oinstall) groups=1000(oinstall),1200(asmadmin),1201(asmdba),1202(asmoper)

=> add grid to dba group!!! 

[root@gopos ~]# usermod -G dba,asmadmin,asmdba,asmoper  grid
[root@gopos ~]# id grid
uid=1100(grid) gid=1000(oinstall) groups=1000(oinstall),1200(asmadmin),1201(asmdba),1202(asmoper),1300(dba)

[grid@gopos ~]$ srvctl start database -d gopos
[grid@gopos ~]$ srvctl status database -d gopos
Database is running.

oracle 11g asm change hostname ERROR

[root@gopos ~]# cd /u01/app/11.2.0/grid/crs/install/
[root@gopos 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_gopos-stb_env.txt
crsconfig_params         hasdconfig.pl         installRemove.excl  oracss.pm          roothas.pl     s_crsconfig_lib.pm
[root@gopos 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@gopos 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 gopos successfully pinned.
Adding Clusterware entries to upstart

gopos     2016/07/19 16:55:42     /u01/app/11.2.0/grid/cdata/gopos/backup_20160719_165542.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server


[grid@gopos install]$ crsctl check has
CRS-4638: Oracle High Availability Services is online
[grid@gopos install]$ asmcmd lsdg
Connected to an idle instance.
ASMCMD-8102: no connection to Oracle ASM; command requires Oracle ASM to run
[grid@gopos install]$ crs_st
crs_start      crs_start.bin  crs_stat       crs_stat.bin   crs_stop       crs_stop.bin
[grid@gopos 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 gopos

NAME=ora.ons
TYPE=ora.ons.type
TARGET=OFFLINE
STATE=OFFLINE

[grid@gopos install]$ crsctl start resource "ora.cssd"
CRS-2672: Attempting to start 'ora.cssd' on 'gopos'
CRS-2672: Attempting to start 'ora.diskmon' on 'gopos'
CRS-2676: Start of 'ora.diskmon' on 'gopos' succeeded

CRS-2676: Start of 'ora.cssd' on 'gopos' succeeded
[grid@gopos install]$
[grid@gopos install]$ crs_stat
NAME=ora.cssd
TYPE=ora.cssd.type
TARGET=ONLINE
STATE=ONLINE on gopos

NAME=ora.diskmon
TYPE=ora.diskmon.type
TARGET=OFFLINE
STATE=OFFLINE

NAME=ora.evmd
TYPE=ora.evm.type
TARGET=ONLINE
STATE=ONLINE on gopos

NAME=ora.ons
TYPE=ora.ons.type
TARGET=OFFLINE
STATE=OFFLINE

[grid@gopos install]$ asmcmd lsdg
Connected to an idle instance.
ASMCMD-8102: no connection to Oracle ASM; command requires Oracle ASM to run
[grid@gopos install]$ crsctl start resource "ora.diskmon"
CRS-2672: Attempting to start 'ora.diskmon' on 'gopos'
CRS-2676: Start of 'ora.diskmon' on 'gopos' succeeded


[grid@gopos ~]$ crsctl config has
CRS-4622: Oracle High Availability Services autostart is enabled.
[grid@gopos ~]$ 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 gopos

NAME=ora.ons
TYPE=ora.ons.type
TARGET=OFFLINE
STATE=OFFLINE

[grid@gopos ~]$ crsctl start resource "ora.cssd"
CRS-2672: Attempting to start 'ora.cssd' on 'gopos'
CRS-2672: Attempting to start 'ora.diskmon' on 'gopos'
CRS-2676: Start of 'ora.diskmon' on 'gopos' succeeded
CRS-2676: Start of 'ora.cssd' on 'gopos' succeeded
[grid@gopos ~]$ crs_stat
NAME=ora.cssd
TYPE=ora.cssd.type
TARGET=ONLINE
STATE=ONLINE on gopos

NAME=ora.diskmon
TYPE=ora.diskmon.type
TARGET=OFFLINE
STATE=OFFLINE

NAME=ora.evmd
TYPE=ora.evm.type
TARGET=ONLINE
STATE=ONLINE on gopos

NAME=ora.ons
TYPE=ora.ons.type
TARGET=OFFLINE
STATE=OFFLINE

[grid@gopos ~]$ srvctl add listener -l LISTENER
[grid@gopos ~]$ srvctl start listener
[grid@gopos ~]$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): gopos

$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 <listener-name> -a
$DB_HOME/bin/srvctl config database -d <dbname> -a
$DB_HOME/bin/srvctl config service -d <dbname> -s <service-name> -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 <Grid Home>/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 <unknown> <unknown>
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 <unknown> <unknown>
INFO: INFO: Parsing 1023 CANDIDATE ORCL:GOWMS_CRS01 <unknown> <unknown>
INFO: INFO: Parsing 61436 CANDIDATE ORCL:GOWMS_REDO01 <unknown> <unknown>
INFO: INFO: Parsing 204799 CANDIDATE ORCL:GO_EC01 <unknown> <unknown>
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/gopos/gopos/trace/gopos_ora_9298.trc  (incident=8572):
ORA-00600: internal error code, arguments: [krhcvt_filhdr_v10_01], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/gopos/gopos/incident/incdir_8572/gopos_ora_9298_i8572.trc
ERROR: failed to establish dependency between database gopos 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/gopos/gopos/trace/gopos_ora_9298.trc:
ORA-00600: internal error code, arguments: [krhcvt_filhdr_v10_01], [], [], [], [], [], [], [], [], [], [], []
ORA-1503 signalled during: Create controlfile reuse set database "gopos"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100

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/

désert/Oracle/silent_install_gopos (last edited 2020-08-29 11:15:43 by merlyn)