Contents

  1. Install Oracle in silent mode 11G Release 2 (11.2.0.4) on OEL6.6
    1. 准备ISO REPO环境 TEST
    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. Check WWID(The World Wide Identifier)
      2. mklable for disk & auto parted disks
      3. Reload udev rules
      4. create ASM disk (Options)
    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. The following commands will delete the databases we created earlier.
      2. dbca_silent.rsp
    18. edit /etc/oratab
  2. Troubleshooting
    1. Disk "GOEC_01" does not exist or is not instantiated
    2. oracle 11g dbca ORA-01031: insufficient privileges asm
    3. oracle 11g asm change hostname ERROR
    4. ASM error02
    5. RMAN> duplicate target database to aux nofilenamecheck;
    6. INFO: Parsing ORA-15025: could not open disk "/dev/raw/rawctl"
    7. xxx
    8. relink grid
    9. References

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

yum install `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 compat-libcap1 | grep not | awk '{ print $2 }' | fmt `

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
yum -y install xorg-x11-server-Xorg.x86_64 twm  xhost tigervnc-server.x86_64 xterm

install Huawei Ultrapath

sh /media/software/RHEL/install.sh

add users/groups

groupadd --gid 54321 oinstall
groupadd --gid 54322 dba
groupadd --gid 54323 asmdba
groupadd --gid 54324 asmoper
groupadd --gid 54325 asmadmin
groupadd --gid 54326 oper

useradd --uid 54321 --gid oinstall --groups dba,oper,asmdba,asmoper oracle
passwd oracle
useradd --uid 54322 --gid oinstall --groups dba,asmadmin,asmdba,asmoper grid
passwd grid


OR:
usermod -a -G dba grid
usermod -a -G asmdba 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
mkdir -pv /u01/app/oraInventory
chown -Rv oracle:oinstall /u01/app/oracle
chown -Rv oracle:oinstall /u01/app/oraInventory

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

Check WWID(The World Wide Identifier)

   1 #! /bin/bash
   2 # Usage: As root user run
   3 for DISK in `find /dev/ -name "sd*" | sort`
   4   do
   5     WWID=`/sbin/scsi_id --whitelisted --replace-whitespace --device=$DISK`
   6     echo $DISK " WWID is " $WWID
   7     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

[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

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

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 (last edited 2022-11-23 03:55:06 by merlyn)