|
Size: 25513
Comment:
|
← Revision 127 as of 2022-11-23 03:55:06 ⇥
Size: 31829
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 5: | Line 5: |
| == 准备ISO REPO环境 == {{{ |
== 准备ISO REPO环境 TEST == {{{ |
| Line 86: | Line 85: |
| 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 ` }}} {{{ |
|
| Line 89: | Line 92: |
| yum -y install xorg-x11-server-Xorg.x86_64 twm xhost tigervnc-server.x86_64 xterm | |
| Line 99: | Line 103: |
| 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 |
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 |
| Line 108: | Line 112: |
useradd -m -u 1100 -g oinstall -G dba,asmadmin,asmdba,asmoper -d /home/grid -s /bin/bash grid |
useradd --uid 54322 --gid oinstall --groups dba,asmadmin,asmdba,asmoper grid |
| Line 111: | Line 114: |
| Line 114: | Line 118: |
| usermod -a -G asmadmin asmoper oracle | usermod -a -G asmdba oracle |
| Line 124: | Line 128: |
| mkdir -pv /u01/app/oraInventory | |
| Line 125: | Line 130: |
| chown -Rv oracle:oinstall /u01/app/oraInventory | |
| Line 301: | Line 307: |
| === 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 }}} |
|
| Line 304: | Line 322: |
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% |
|
| Line 318: | Line 341: |
| === create ASM disk === # in gowms!!! |
=== 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! |
| Line 363: | Line 403: |
| ./grid/runInstaller -silent -force -responseFile /home/grid/grid_silent.rsp | ./grid/runInstaller -showProgress -ignorePrereq -silent -force -responseFile /home/grid/grid_silent.rsp |
| Line 381: | Line 421: |
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*'; |
|
| Line 396: | Line 442: |
| * ./runInstaller -silent -force -responseFile ~/db_install.rsp /u01/app/oracle/product/11.2.0/db_1/root.sh |
* ./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. }}} |
| Line 456: | Line 552: |
| 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 |
|
| Line 467: | Line 575: |
| -characterSet AL32UTF8 \ | -characterSet ZHS16GBK \ |
| Line 472: | Line 580: |
| -gdbName gowms.local \ | -gdbName gowms \ |
| Line 484: | Line 592: |
| # 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. }}} |
|
| Line 515: | Line 675: |
| DATAFILEDESTINATION=/u01/app/oracle/oradata | DATAFILEDESTINATION=/rac-restore/oradata |
| Line 518: | Line 678: |
| RECOVERYAREADESTINATION=/u01/app/oracle/flash_recovery_area | RECOVERYAREADESTINATION=/rac-restore/flash_recovery_area |
| Line 844: | Line 1004: |
| == 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 |
Contents
-
Install Oracle in silent mode 11G Release 2 (11.2.0.4) on OEL6.6
- 准备ISO REPO环境 TEST
- bond0
- install missing packages
- install Huawei Ultrapath
- add users/groups
- create directorys
- add kernel parameters ? no need!
- Some system parameters
- Grid Settings FOR ASM
- Oracle Settings
- Config ASM
- Creating ASM disk volumes
- install grid software
- deinstall grid standalone
- Creating ASM disk groups for Oracle database installation
- install database software
- Create Database with dbca command OR dbca_silent.rsp
- edit /etc/oratab
-
Troubleshooting
- Disk "GOEC_01" does not exist or is not instantiated
- oracle 11g dbca ORA-01031: insufficient privileges asm
- oracle 11g asm change hostname ERROR
- ASM error02
- RMAN> duplicate target database to aux nofilenamecheck;
- INFO: Parsing ORA-15025: could not open disk "/dev/raw/rawctl"
- xxx
- relink grid
- 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- install missing...
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)
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/\"; doneudevadm 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 <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
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/
