Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Installation of Oracle_11g_RAC 11.2.0.4.0 under Sles11_sp1 64bit system

2025-04-07 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Required dependency package

Binutils-2.19

Gcc-4.3

Gcc-32bit-4.3

Gcc-c++-4.3

Glibc-2.9

Glibc-32bit-2.9

Glibc-devel-2.9

Glibc-devel-32bit-2.9

Ksh-93t

Libaio-0.3.104

Libaio-32bit-0.3.104

Libaio-devel-0.3.104

Libaio-devel-32bit-0.3.104

Libstdc++33-3.3.3

Libstdc++33-32bit-3.3.3

Libstdc++-devel-4.3

Libstdc++43-4.3.3mm 20081022

Libstdc++43-32bit-4.3.3_20081022

Libstdc++43-devel-4.3.3_20081022

Libstdc++43-devel-32bit-4.3.3_20081022

Libgcc43-4.3.3mm 20081022

Make-3.81

Sysstat-8.1.5

System missing patch pack installation is performed sequentially (the system I installed lacks the following packages)

Rpm-ivh linux-kernel-headers-2.6.32-1.4.13.noarch.rpm

Rpm-ivh glibc-devel-2.11.1-0.17.4.x86_64.rpm

Rpm-ivh gcc43-4.3.4mm 20091019-0.7.35.x86_64.rpm

Rpm-ivh libgomp43-32bit-4.3.4_20091019-0.7.35.x86_64.rpm

Rpm-ivh glibc-devel-32bit-2.11.1-0.17.4.x86_64.rpm

Rpm-ivh gcc43-32bit-4.3.4_20091019-0.7.35.x86_64.rpm

Rpm-ivh gcc-4.3-62.198.x86_64.rpm

Rpm-ivh gcc-32bit-4.3-62.198.x86_64.rpm

Rpm-ivh sysstat-8.1.5-7.9.56.x86_64.rpm

Rpm-ivh libstdc++43-devel-32bit-4.3.4_20091019-0.7.35.x86_64.rpm

Rpm-ivh libaio-devel-0.3.109-0.1.46.x86_64.rpm

Rpm-ivh libaio-devel-32bit-0.3.109-0.1.46.x86_64.rpm

Rpm-ivh libcap-progs-2.11-2.15.x86_64.rpm

Rpm-ivh libcap1-1.10-6.10.x86_64.rpm

Rpm-ivh libcap1-32bit-1.10-6.10.x86_64.rpm

Rpm-ivh libstdc++43-devel-4.3.4_20091019-0.7.35.x86_64.rpm

Rpm-ivh gcc43-c++-4.3.4_20091019-0.7.35.x86_64.rpm

Rpm-ivh gcc-c++-4.3-62.198.x86_64.rpm

Rpm-ivh libstdc++-devel-4.3-62.198.x86_64.rpm

Install the oracleasm patch pack

Rpm-ivh oracleasm-kmp-default-2.0.5_2.6.32.12_0.7-7.8.70.x86_64.rpm

Rpm-ivh oracleasm-2.0.5-7.8.70.x86_64.rpm

Rpm-ivh oracleasmlib-2.0.4-1.sle11.x86_64.rpm

Rpm-ivh oracleasm-support-2.1.8-1.SLE11.x86_64.rpm

Vim / etc/security/limits.conf

Grid soft nproc 2047

Grid hard nproc 16384

Grid soft nofile 1024

Grid hard nofile 65536

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

Vim / etc/hosts

# public ip

172.16.22.4 racdb1

172.16.22.5 racdb2

# priv ip

10.10.10.2 racdb1-priv

10.10.10.3 racdb2-priv

# virtual ip

172.16.22.21 racdb1-vip

172.16.22.22 racdb2-vip

# scan ip

172.16.22.20 racdbscan

Modify login

Vi / etc/pam.d/login

Add at the end:

Session required pam_limits.so

Vim / etc/sysctl.conf

# oracle setting

Fs.aio-max-nr = 1048576

Fs.file-max = 6815744

Kernel.shmall = 2097152

Kernel.shmmax = 4294967295

Kernel.shmmni = 4096

Kernel.sem = 250 32000 100 128

Net.ipv4.ip_local_port_range = 9000 65500

Net.core.rmem_default = 262144

Net.core.rmem_max = 4194304

Net.core.wmem_default = 262144

Net.core.wmem_max = 1048586

Sysctl-p

/ etc/init.d/ntp stop

Chkconfig ntp off

Mv / etc/ntp.conf / etc/ntp.org

Create a new nslookup script

Mv / usr/bin/nslookup / usr/bin/nslookup.original

Vi / usr/bin/nslookup

#! / bin/bash

HOSTNAME=$ {1}

If [[$HOSTNAME = "racdbscan"]]; then

Echo "Server: 172.16.22.21"

Echo "Address: 172.16.22.21 # 53"

Echo "Non-authoritative answer:"

Echo "Name: racdbscan"

Echo "Address: 172.16.22.20"

Else

/ usr/bin/nslookup.original $HOSTNAME

Fi

Configuration above db2

#! / bin/bash

HOSTNAME=$ {1}

If [[$HOSTNAME = "racdbscan"]]; then

Echo "Server: 172.16.22.22"

Echo "Address: 172.16.22.22 # 53"

Echo "Non-authoritative answer:"

Echo "Name: racdbscan"

Echo "Address: 172.16.22.20"

Else

/ usr/bin/nslookup.original $HOSTNAME

Fi

Chmod 755 / usr/bin/nslookup

/ usr/bin/nslookup racdbscan

Disk partition where Oracle is installed (executed by both nodes)

Fdisk / dev/sdb

Partprobe

Mkfs.ext3 / dev/sdb1

Mkdir-p / u01 /

Mount / dev/sdb1 / u01

Set up boot auto mount

Just add vim / etc/fstab to the end.

/ dev/sdb1 / u01 ext3 acl,user_xattr 1 2

Execute the following script on both nodes to create the user

/ usr/sbin/groupadd-g 501 oinstall

/ usr/sbin/groupadd-g 502 dba

/ usr/sbin/groupadd-g 503 oper

/ usr/sbin/groupadd-g 504 asmadmin

/ usr/sbin/groupadd-g 505 asmoper

/ usr/sbin/groupadd-g 506 asmdba

/ usr/sbin/useradd-g oinstall-G dba,asmdba,oper oracle

/ usr/sbin/useradd-g oinstall-G asmadmin,asmdba,asmoper,oper,dba grid

Mkdir-p / home/oracle

Mkdir-p / home/grid

Chown-R oracle:oinstall / home/oracle

Chown-R grid:oinstall / home/grid

Mkdir-p / u01/app

Chown-R grid:oinstall / u01/app/

Chmod-R 775 / u01/app/

Mkdir-p / u01/app/oraInventory

Chown-R grid:oinstall / u01/app/oraInventory

Chmod-R 775 / u01/app/oraInventory

Mkdir-p / u01/app/grid

Mkdir-p / u01/app/oracle

Chown-R grid:oinstall / u01/app/grid

Chown-R oracle:oinstall / u01/app/oracle

Chmod-R 775 / u01/app/oracle

Chmod-R 775 / u01/app/grid

Passwd grid password: grid

Passwd oracle password: oracle

. bash_profile settings for grid users

DB1 configuration

Vim .bash _ profile

Export ORACLE_SID=+ASM1

Export ORACLE_BASE=/u01/app/oracle

Export ORACLE_HOME=/u01/app/grid/product/11.2.0

Export PATH=$PATH:$ORACLE_HOME/bin

Export TMP=/tmp

Export TMPDIR=$TMP

Export NLS_DATE_FORMAT= "yyyy-mm-dd HH24:MI:SS"

Export THREADS_FLAG=native

Export PATH=$ORACLE_HOME/bin:$PATH

Export THREADS_FLAG=native

Export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

Export CVUQDISK GRP=oinstall

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

DB2 configuration

Export ORACLE_SID=+ASM2

Export ORACLE_BASE=/u01/app/oracle

Export ORACLE_HOME=/u01/app/grid/product/11.2.0

Export PATH=$PATH:$ORACLE_HOME/bin

Export TMP=/tmp

Export TMPDIR=$TMP

Export NLS_DATE_FORMAT= "yyyy-mm-dd HH24:MI:SS"

Export THREADS_FLAG=native

Export PATH=$ORACLE_HOME/bin:$PATH

Export THREADS_FLAG=native

Export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

Export CVUQDISK GRP=oinstall

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

Oracle .bash _ profile configuration

DB1

Vim .bash _ profile

Export ORACLE_SID=racdb1

Export ORACLE_BASE=/u01/app/oracle

Export ORACLE_HOME=$ORACLE_BASE/product/11.2.0

Export TMP=/tmp

Export TMPDIR=$TMP

Export PATH=/usr/sbin:$PATH

Export ORACLE_TERM=xterm

Export PATH=$ORACLE_HOME/bin:$PATH

Export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

Export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

Export NLS_DATE_FORMAT= "yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT

Export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

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

DB2

Export ORACLE_SID=racdb2

Export ORACLE_BASE=/u01/app/oracle

Export ORACLE_HOME=$ORACLE_BASE/product/11.2.0

Export TMP=/tmp

Export TMPDIR=$TMP

Export PATH=/usr/sbin:$PATH

Export ORACLE_TERM=xterm

Export PATH=$ORACLE_HOME/bin:$PATH

Export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

Export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

Export NLS_DATE_FORMAT= "yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT

Export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

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

Configure ASM

Follow the procedure below to configure asm:

/ etc/init.d/oracleasm configure

Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library

Driver. The following questions will determine whether the driver is

Loaded on boot and what permissions it will have. The current values

Will be shown in brackets ('[]'). Hitting without typing an

Answer will keep that current value. Ctrl-C will abort.

Default user to own the driver interface []: grid

Default group to own the driver interface []: asmadmin

Start Oracle ASM library driver on boot (yzone) [n]: y

Scan for Oracle ASM disks on boot (yzone) [y]: y

Writing Oracle ASM library driver configuration: done

Initializing the Oracle ASMLib driver: done

Scanning the system for Oracle ASMLib disks: done

Disk partition

Fdisk / dev/sdc

# partition results #

Fdisk / dev/sdc

Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel

Building a new DOS disklabel with disk identifier 0x86d96a24.

Changes will remain in memory only, until you decide to write them.

After that, of course, the previous content won't be recoverable.

Warning: invalid flag 0x0000 of partition table 4 will be corrected by w (rite)

Command (m for help): n

Command action

E extended

P primary partition (1-4)

P

Partition number (1-4): 1

First cylinder (1-133674, default 1):

Using default value 1

Last cylinder, + cylinders or + size {KMagne Mpeng} (1-133674, default 133674): + 3G

Command (m for help): n

Command action

E extended

P primary partition (1-4)

P

Partition number (1-4): 2

First cylinder (394-133674, default 394):

Using default value 394

Last cylinder, + cylinders or + size {Kjimm Magi G} (394-133674, default 133674): + 3G

Command (m for help): n

Command action

E extended

P primary partition (1-4)

P

Partition number (1-4): 3

First cylinder (787-133674, default 787):

Using default value 787

Last cylinder, + cylinders or + size {Kjimm Magi G} (787-133674, default 133674): + 3G

Command (m for help): n

Command action

E extended

P primary partition (1-4)

E

Selected partition 4

First cylinder (1180-133674, default 1180):

Using default value 1180

Last cylinder, + cylinders or + size {KMagne Mpeng} (1180-133674, default 133674):

Using default value 133674

Command (m for help): n

First cylinder (1180-133674, default 1180):

Using default value 1180

Last cylinder, + cylinders or + size {KMagne Mpeng} (1180-133674, default 133674): 67427

Command (m for help): n

First cylinder (67428-133674, default 67428):

Using default value 67428

Last cylinder, + cylinders or + size {KMagne Mpeng} (67428-133674, default 133674):

Using default value 133674

Command (m for help): P

Disk / dev/sdc: 1099.5 GB, 1099511626752 bytes

255 heads, 63 sectors/track, 133674 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Disk identifier: 0x86d96a24

Device Boot Start End Blocks Id System

/ dev/sdc1 1 393 3156741 83 Linux

/ dev/sdc2 394 786 3156772 + 83 Linux

/ dev/sdc3 787 1179 3156772 + 83 Linux

/ dev/sdc4 1180 133674 1064266087 + 5 Extended

/ dev/sdc5 1180 67427 532137028 + 83 Linux

/ dev/sdc6 67428 133674 532128996 83 Linux

Command (m for help): W

The partition table has been altered!

Calling ioctl () to re-read partition table.

Syncing disks.

# partition results #

Device Boot Start End Blocks Id System

/ dev/sdc1 1 393 3156741 83 Linux

/ dev/sdc2 394 786 3156772 + 83 Linux

/ dev/sdc3 787 1179 3156772 + 83 Linux

/ dev/sdc4 1180 133674 1064266087 + 5 Extended

/ dev/sdc5 1180 67427 532137028 + 83 Linux

/ dev/sdc6 67428 133674 532128996 83 Linux

# partition results #

Fdisk / dev/sdd

Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel

Building a new DOS disklabel with disk identifier 0x7ce3dacc.

Changes will remain in memory only, until you decide to write them.

After that, of course, the previous content won't be recoverable.

Warning: invalid flag 0x0000 of partition table 4 will be corrected by w (rite)

Command (m for help): n

Command action

E extended

P primary partition (1-4)

P

Partition number (1-4, default 1):

Using default value 1

First sector (2048-2147483645, default 2048):

Using default value 2048

Last sector, + sectors or + size {KMagne Mpeng} (2048-2147483645, default 2147483645): + 505G

Command (m for help): P

Disk / dev/sdd: 1099.5 GB, 1099511626752 bytes

255 heads, 63 sectors/track, 133674 cylinders, total 2147483646 sectors

Units = sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x7ce3dacc

Device Boot Start End Blocks Id System

/ dev/sdd1 2048 1059063807 529530880 83 Linux

Command (m for help): W

The partition table has been altered!

Calling ioctl () to re-read partition table.

Syncing disks.

Create an ASM disk

Oracleasm createdisk CRS1 / dev/sdc1

Oracleasm createdisk CRS2 / dev/sdc2

Oracleasm createdisk CRS3 / dev/sdc3

Oracleasm createdisk DATA1 / dev/sdc5

Oracleasm createdisk REC1 / dev/sdc6

Delete ASM disk

Oracleasm deletedisk CRS1

Oracleasm deletedisk CRS2

Oracleasm deletedisk CRS3

Oracleasm deletedisk DATA1

Oracleasm deletedisk REC1

Scan the disk (both nodes need to be executed)

/ etc/init.d/oracleasm scandisks

View a list of disks (can be seen by both nodes)

/ etc/init.d/oracleasm listdisks

To establish mutual trust, both grid and Oracle need to perform # this step can be replaced with a graphical interface operation (click ssh--- > setup after adding nodes during the graphical installation interface)

Ssh-keygen-t rsa

Ssh-keygen-t dsa

Cd .ssh /

Cat id_dsa.pub > > authorized_keys

Cat id_rsa.pub > > authorized_keys

DB1 execution

Ssh racdb2 cat / home/grid/.ssh/authorized_keys > > authorized_keys (grid user)

Ssh racdb2 cat / home/oracle/.ssh/authorized_keys > > authorized_keys (oracle user)

DB2 execution

Ssh racdb1 cat / home/grid/.ssh/authorized_keys > > authorized_keys (grid user)

Ssh racdb1 cat / home/oracle/.ssh/authorized_keys > > authorized_keys (oracle user)

ALL DB execution

Ssh racdb1 hostname

Ssh racdb2 hostname

Decompress the cluster package

Su-grid

Cd / usr/local/src/

Unzip p13390677_112040_Linux-x86-64_3of7.zip-d / home/grid/ (grid user)

(root users)

Cd / home/grid/grid/rpm/

Rpm-ivh cvuqdisk-1.0.9-1.rpm

(grid users)

Su-grid

Cd grid

. / runcluvfy.sh stage-pre crsinst-n racdb1,racdb2-fixup-verbose > crsinst_check.log

Vncserver

Vim / root/.vnc/xstartup is modified as follows

#! / bin/sh

Configure vncserver on one of them

Xrdb $HOME/.Xresources

# xsetroot-solid grey

# xterm-geometry 80x24+10+10-ls-title "$VNCDESKTOP Desktop" &

Gnome-session &

Vncserver-kill: 1

Vncserver

After connecting using the vnc client, do the following in the graphical interface

Xhost + (root users)

Echo $DISPLAY

Su-grid

Export DISPLAY=:1.0 (grid user)

The following two scripts are executed during installation (now locally and then on other nodes)

/ u01/app/oraInventory/orainstRoot.sh

/ u01/app/grid/product/11.2.0/root.sh allows / u01/app/grid/product/11.2.0/crs/install/rootcrs.pl-deconfig-verbose-force to delete the wrong configuration information if the error is reported

Performing root user operation for Oracle 11g

The following environment variables are set as:

ORACLE_OWNER= grid

ORACLE_HOME= / u01/app/grid/product/11.2.0

Enter the full pathname of the local bin directory: [/ usr/local/bin]:

Copying dbhome to / usr/local/bin...

Copying oraenv to / usr/local/bin...

Copying coraenv to / usr/local/bin...

Creating / etc/oratab file...

Entries will be added to the / etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Using configuration parameter file: / u01/app/grid/product/11.2.0/crs/install/crsconfig_params

Creating trace directory

User ignored Prerequisites during installation

Installing Trace File Analyzer

OLR initialization-successful

Root wallet

Root wallet cert

Root cert export

Peer wallet

Profile reader wallet

Pa wallet

Peer wallet keys

Pa wallet keys

Peer cert request

Pa cert request

Peer cert

Pa cert

Peer root cert TP

Profile reader root cert TP

Pa root cert TP

Peer pa cert TP

Pa peer cert TP

Profile reader pa cert TP

Profile reader peer cert TP

Peer user cert

Pa user cert

Adding Clusterware entries to inittab

CRS-2672: Attempting to start 'ora.mdnsd' on' racdb1'

CRS-2676: Start of 'ora.mdnsd' on' racdb1' succeeded

CRS-2672: Attempting to start 'ora.gpnpd' on' racdb1'

CRS-2676: Start of 'ora.gpnpd' on' racdb1' succeeded

CRS-2672: Attempting to start 'ora.cssdmonitor' on' racdb1'

CRS-2672: Attempting to start 'ora.gipcd' on' racdb1'

CRS-2676: Start of 'ora.cssdmonitor' on' racdb1' succeeded

CRS-2676: Start of 'ora.gipcd' on' racdb1' succeeded

CRS-2672: Attempting to start 'ora.cssd' on' racdb1'

CRS-2672: Attempting to start 'ora.diskmon' on' racdb1'

CRS-2676: Start of 'ora.diskmon' on' racdb1' succeeded

CRS-2676: Start of 'ora.cssd' on' racdb1' succeeded

ASM created and started successfully.

Disk Group CRS created successfully.

Clscfg:-install mode specified

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp' root'..

Operation successful.

CRS-4256: Updating the profile

Successful addition of voting disk 61bd6f05397a4f68bf9535ab4c475628.

Successfully replaced voting disk group with + CRS.

CRS-4256: Updating the profile

CRS-4266: Voting file (s) successfully replaced

# # STATE File Universal Id File Name Disk group

1. ONLINE 61bd6f05397a4f68bf9535ab4c475628 (ORCL:CRS1) [CRS]

Located 1 voting disk (s).

CRS-2672: Attempting to start 'ora.asm' on' racdb1'

CRS-2676: Start of 'ora.asm' on' racdb1' succeeded

CRS-2672: Attempting to start 'ora.CRS.dg' on' racdb1'

CRS-2676: Start of 'ora.CRS.dg' on' racdb1' succeeded

Configure Oracle Grid Infrastructure for a Cluster... Succeeded

/ u01/app/grid/product/11.2.0/oui/bin/runInstaller-updateNodeList ORACLE_HOME= "/ u01/app/grid/product/11.2.0" CRS=true allows hosts lowercase

The oc4j,gsd service is disable by default. If you want to start it, you can enable it.

Use the grid user to do the following

Rac1:/home # su-grid

Grid@rac1:~ > srvctl enable nodeapps

PRKO-2415: VIP is already enabled on node (s): udbdb1,udbdb2

PRKO-2416: Network resource is already enabled.

PRKO-2417: ONS is already enabled on node (s): udbdb1,udbdb2

PRKO-2418: eONS is already enabled on node (s): udbdb1,udbdb2

Check crs status

Crs_stat-t

Name Type Target State Host

Ora.CRS.dg ora....up.type ONLINE ONLINE racdb1

Ora.DATA.dg ora....up.type ONLINE ONLINE racdb1

Ora....ER.lsnr ora....er.type ONLINE ONLINE racdb1

Ora....N1.lsnr ora....er.type ONLINE ONLINE racdb1

Ora.REC.dg ora....up.type ONLINE ONLINE racdb1

Ora....SM1.asm application ONLINE ONLINE racdb1

Ora....B1.lsnr application ONLINE ONLINE racdb1

Ora....db1.gsd application OFFLINE OFFLINE

Ora....db1.ons application ONLINE ONLINE racdb1

Ora....db1.vip ora....t1.type ONLINE ONLINE racdb1

Ora....SM2.asm application ONLINE ONLINE racdb2

Ora....B2.lsnr application ONLINE ONLINE racdb2

Ora....db2.gsd application OFFLINE OFFLINE

Ora....db2.ons application ONLINE ONLINE racdb2

Ora....db2.vip ora....t1.type ONLINE ONLINE racdb2

Ora.asm ora.asm.type ONLINE ONLINE racdb1

Ora.cvu ora.cvu.type ONLINE ONLINE racdb2

Ora.gsd ora.gsd.type OFFLINE OFFLINE

Ora....network ora....rk.type ONLINE ONLINE racdb1

Ora.oc4j ora.oc4j.type ONLINE ONLINE racdb2

Ora.ons ora.ons.type ONLINE ONLINE racdb1

Ora....ry.acfs ora....fs.type ONLINE ONLINE racdb1

Ora.scan1.vip ora....ip.type ONLINE ONLINE racdb1

# oc4j startup method. Oc4j does not belong to the process that must be started.

Grid@rac1:~ > srvctl enable oc4j

Grid@rac1:~ > srvctl status oc4j

Grid@rac1:~ > srvctl start oc4j

Stop CRS

Crs_stop-all

Check the asm disk if the error is prompted

/ etc/init.d/oracleasm listdisks shows normal execution of the next command to shut down all cluster processes

/ u01/app/grid/product/11.2.0/bin/crsctl stop cluster-all (under root users)

/ u01/app/grid/product/11.2.0/bin/crsctl start cluster-all starts the cluster process

Then enter grid and use crs_start-all to start crs

Start CRS

Crs_start-all

Check resource group status

Crsctl status resource-t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

Ora.CRS.dg

ONLINE ONLINE racdb1

ONLINE ONLINE racdb2

Ora.LISTENER.lsnr

ONLINE ONLINE racdb1

ONLINE ONLINE racdb2

Ora.asm

ONLINE ONLINE racdb1 Started

ONLINE ONLINE racdb2 Started

Ora.gsd

OFFLINE OFFLINE racdb1

OFFLINE OFFLINE racdb2

Ora.net1.network

ONLINE ONLINE racdb1

ONLINE ONLINE racdb2

Ora.ons

ONLINE ONLINE racdb1

ONLINE ONLINE racdb2

Ora.registry.acfs

ONLINE ONLINE racdb1

ONLINE ONLINE racdb2

Cluster Resources

Ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE racdb1

Ora.racdb1.vip

1 ONLINE ONLINE racdb1

Ora.racdb2.vip

1 ONLINE ONLINE racdb2

Ora.cvu

1 ONLINE ONLINE racdb1

Ora.oc4j

1 ONLINE ONLINE racdb1

Ora.scan1.vip

1 ONLINE ONLINE racdb1

Check the monitoring status

Grid@udbDb1:~ > srvctl status listener

Listener LISTENER is enabled

Listener LISTENER is running on node (s): racdb1,racdb2

Check cluster nodes

Grid@udbDb1:~ > olsnodes-n

Racdb1 1

Racdb2 2

Grid@udbDb1:~ > ocrcheck

Status of Oracle Cluster Registry is as follows:

Version: 3

Total space (kbytes): 262120

Used space (kbytes): 2752

Available space (kbytes): 259368

ID: 280878502

Device/File Name: + CRS

Device/File integrity check succeeded

Device/File not configured

Device/File not configured

Device/File not configured

Device/File not configured

Cluster registry integrity check succeeded

Logical corruption check bypassed due to non-privileged user

Check the voting disk

Grid@udbDb1:~ > crsctl query css votedisk

# # STATE File Universal Id File Name Disk group

1. ONLINE 1f9347d3c6984fabbf742048d2f2f2ce (ORCL:CRS1) [CRS]

Located 1 voting disk (s).

Oracle Database installation

Cd / usr/local/src

Unzip p13390677_112040_Linux-x86-64_1of7.zip-d / home/oracle/

Unzip p13390677_112040_Linux-x86-64_2of7.zip-d / home/oracle/

Graphical interface installation

Su-oracle

Export DISPLAY=:1.0

. / runInstall

/ u01/app/oracle/product/11.2.0/root.sh (root user)

Dbca (oracle user)

Use a unified password during installation: oracle

Sys

System

Dbsnmp

Sysman

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report