Shulou(Shulou.com)05/31 Report--

Editor to share with you how to install Oracle 11g R2 RAC in OEL5.5. I hope you will get something after reading this article. Let's discuss it together.

1. Preparation before installation:

Operating system: oracle linux 5.5 64bit

Cluster software: GI 11.2.0.1

Database: database rdbms 11.2.0.1

two。 Resource preparation:

Oracleasm-2.6.18-194.el5-2.0.5-1.el5.x86_64.rpm

Oracleasmlib-2.0.4-1.el5.x86_64.rpm

Oracleasm-support-2.1.7-1.el5.x86_64.rpm

Openfiler

3. Operating system installation:

DNS server:domain name

Db server:rac1 rac2

Storage server:openfiler

4.IP address Planning:

DNS server:192.168.192.168

Db node1:192.168.192.169 public

192.168.192.171 VIP

10.0.0.1 private

Db node2:192.168.192.170 public

192.168.192.172 VIP

10.0.0.2 private

Scan: 192.168.192.173

192.168.192.174

192.168.192.175

5. I won't say much about what DNS,DNS is. The main function here is to introduce a new feature, 11g R2, and then introduce the concept of SCAN IP, which is to add a virtual network service layer, namely SCAN IP and SCAP IP Listener, between the client and the database. In the tnsnames.ora configuration file of the client, you only need to configure the configuration information of SCAN IP, and the client accesses the database through SCAN IP and SCAN IP Listener. Compared with previous versions of RAC, the advantage of using SCAN IP is that when the background RAC database adds or deletes nodes, the client configuration information does not need to be modified. You can configure SCAN by configuring a DNS server or GNS, which we use DNS as an example.

6. Install the DNS server

# rpm-ivh bind-9.3.6-4.P1.el5_4.2.x86_64.rpm

# rpm-ivh bind-chroot-9.3.6-4.P1.el5_4.2.x86_64.rpm

# rpm-ivh caching-nameserver-9.3.6-4.P1.el5_4.2.x86_64.rpm

Configure the main area

/ /

/ / named.caching-nameserver.conf

/ /

/ / Provided by Red Hat caching-nameserver package to configure the

/ / ISC BIND named (8) DNS server as a caching only nameserver

/ (as a localhost DNS resolver only)

/ /

/ / See / usr/share/doc/bind*/sample/ for example named configuration files.

/ /

/ / DO NOT EDIT THIS FILE-use system-config-bind or an editor

/ / to create named.conf-edits to this file will be lost on

/ / caching-nameserver package upgrade.

/ /

Options {

Listen-on port 53 {any;}

Listen-on-v6 port 53 {:: 1;}

Directory "/ var/named"

Dump-file "/ var/named/data/cache_dump.db"

Statistics-file "/ var/named/data/named_stats.txt"

Memstatistics-file "/ var/named/data/named_mem_stats.txt"

Allow-query {any;}

Allow-query-cache {any;}

}

Logging {

Channel default_debug {

File "data/named.run"

Severity dynamic

}

}

View localhost_resolver {

Match-clients {any;}

Match-destinations {any;}

Recursion yes

Include "/ etc/named.zones"

}

Configure Zone file, modify / var/named/chroot/etc/named.rfc1912.zones file

Add as follows:

Zone "192.168.192.in-addr.arpa" IN {

Type master

File "192.168.192.in-addr.arpa"

Allow-update {none;}

}

Then configure the DNS forward and backward parsing file

/ var/named/chroot/var/named directory

Vi localdomain.zone, configured as

$TTL 86400

@ IN SOA localhost root (

42; serial (d. Adams)

3H; refresh

15m; retry

1W; expiry

1D); minimum

IN NS localhost

Localhost IN A 127.0.0.1

Scan-cluster IN A 192.168.192.173 (here is the configuration scan-ip)

Vi 192.168.168.in-addr-arpa (just generate one of your own)

$TTL 86400

@ IN SOA localhost. Root.localhost. (

1997022700; Serial

28800; Refresh

14400; Retry

3600000; Expire

86400); Minimum

IN NS localhost.

1 IN PTR localhost.

173 IN PTR scan-cluster.localdomain. (san IP is configured here)

Start the DNS service

[root@dns named] # / etc/init.d/named status

Number of zones: 1

Debug level: 0

Xfers running: 0

Xfers deferred: 0

Soa queries in progress: 0

Query logging is OFF

Recursive clients: 0/1000

Tcp clients: 0/100

Server is up and running

Named (pid 18907) is running..

Then modify / etc/resolv.conf for the two nodes of rac

Search localdomain

Nameserver 192.168.192.168

We have finished the configuration of DNS!

7. The configuration hosts file is configured on both nodes

[root@rac1 ~] # cat / etc/hosts

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1 localhost.localdomain localhost

192.168.192.169 rac1.xupeng.com rac1

192.168.192.170 rac2.xupeng.com rac2

10.0.0.1 rac1-priv.xupeng.com rac1-priv

10.0.0.2 rac2-priv.xupeng.com rac2-priv

192.168.192.171 rac1-vip.xupeng.com rac1-vip

192.168.192.172 rac2-vip.xupeng.com rac2-vip

8. Install the environment packages required for oracle 11g

This depends on how you install it, some people choose to install all packages (when installing the operating system), and some like to install the packages needed by oracle manually, it doesn't matter, I use YUM source here, .

This operation is done on two nodes

[root@rac1 ~] # vi / etc/yum.repos.d/my.repo

[Oracle]

Name=OEL-$releasever-Media

Baseurl= file:///mnt/Server

Gpgcheck=0

Enable=1

[root@rac1 ~] # yum-y install compat-libstdc++-33 elfutils-libelf-devel gcc gcc-c++ glibc-devel glibc-headers libaio-devel libstdc++-devel sysstat unixODBC unixODBC-devel

9. Parameter configuration

The following actions need to be configured on both nodes

[root@rac1 ~] # vi / etc/sysctl.conf

Fs.aio-max-nr = 1048576

Fs.file-max = 6815744

Kernel.shmmax = 4294967295

Kernel.shmall = 2097152

Kernel.shmmni = 4096

Kernel.sem = 250 32000 100 128

Net.ipv4.ip_local_port_range = 9000 65500

Net.core.rmem_default = 4194304

Net.core.rmem_max = 4194304

Net.core.wmem_default = 262144

Net.core.wmem_max = 1048586

To enable kernel parameters to take effect, the configuration of sysctl-p is the same as installing a single instance.

[root@rac1 ~] # vi / etc/security/limits.conf

Grid soft nofile 1024

Grid hard nofile 65536

Grid soft nproc 2047

Grid hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

Oracle soft nproc 2047

Oracle hard nproc 16384

[root@rac1 ~] # vi / etc/pam.d/login

Session required / lib64/security/pam_limits.so

10. Add users and groups, as well as oracle, grid user ssh equivalence

The following operations require both nodes to do the same

Groupadd-g 1000 oinstall

Groupadd-g 1300 dba

Groupadd-g 1301 oper

Groupadd-g 1201 asmdba

Groupadd-g 1200 asmadmin

Groupadd-g 1202 asmoper

Useradd-m-u 1100-g oinstall-G asmadmin,asmdba,asmoper-d / home/grid-s / bin/bash-c "Grid Infrastructure Owner" grid

Passwd grid

Useradd-m-u 1101-g oinstall-G dba,oper,asmdba-d / home/oracle-s / bin/bash-c "Oracle Software Owner" oracle

Passwd oracle

Set the mutual trust relationship. Remember here that both oracle and grid users should set mutual trust.

Su-grid

Mkdir / .ssh

Ssh-keygen-t rsa

Ssh-keygen-t dsa

The following operations can be performed on a node

Cat ~ / .ssh/id_rsa.pub > >. / .ssh / authorized_keys-- the public key is stored in the authorized_keys file and written to the local machine

Cat ~ / .ssh/id_dsa.pub > >. / .ssh / authorized_keys

Ssh rac2 cat ~ / .ssh/id_rsa.pub > > ~ / .ssh/authorized_keys-- the public key of the second node is written to the local machine

Ssh rac2 cat ~ / .ssh/id_dsa.pub > > ~ / .ssh/authorized_keys

Scp / .ssh/authorized_keys secdb2:~/.ssh/authorized_keys

Verification on both nodes

Ssh rac1 date

Ssh rac2 date

Ssh rac1-priv date

Ssh rac2-priv date

11. Create directories and authorizations

The following operations need to be done on both nodes

Mkdir-p / u01/app/grid

Mkdir-p / u01/app/11.2.0/grid

Chown-R grid:oinstall / U01

Mkdir-p / u01/app/oracle

Chown oracle:oinstall / u01/app/oracle

Chmod-R 775 / U01

twelve。 Environment variable

The following operations also need to be done on both nodes. It should be noted here that the SID of grid users and the SID of oracle users are different. If we understand the principle here, we will not make mistakes.

[root@rac1 ~] # su-grid

[grid@rac1 ~] $less .bash _ profile

# .bash _ profile

# Get the aliases and functions

If [- f ~ / .bashrc]; then

. ~ / .bashrc

Fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

ORACLE_SID=+ASM1; 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_PATH=/u01/app/oracle/common/oracle/sql; export ORACLE_PATH

ORACLE_TERM=xterm;export ORACLE_TERM

NLS_DATE_FORMAT= "YYYY-MM-DD 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

Export NLS_LANG=american_america.ZHS16GBK

Alias sqlplus= "rlwrap sqlplus"

Umask 022

[grid@rac1 ~] $su-oracle

Password:

[oracle@rac1 ~] $less .bash _ profile

# .bash _ profile

# Get the aliases and functions

If [- f ~ / .bashrc]; then

. ~ / .bashrc

Fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

ORACLE_SID=test1; export ORACLE_SID

ORACLE_UNQNAME=test; export ORACLE_UNQNAME

JAVA_HOME=/usr/local/java; export JAVA_HOME

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME

ORACLE_PATH=/u01/app/common/oracle/sql; export ORACLE_PATH

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

Export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

Umask 022

13.openfiler to divide the storage space

This software is very easy to use, installed in the vmware environment, is actually a linux system, we create vmdisk on the line. Configure to log in to a web page https://ip:446

I have divided it here, just look at the picture. As for the configuration of openfiler, you should be able to study it by yourself. it is very simple and belongs to the kind of mouse that clicks on the picture. Students who are slightly better at English can do it.

14. Configure ISCSI on two rac nodes

[root@rac1 ~] # yum-y install iscsi-initiator-utils

[root@rac1 ~] # service iscsid start

[root@rac1 ~] # chkconfig iscsid on

[root@rac1] # iscsiadm-m discovery-t sendtargets-p 192.168.192.111

Add iscsi disks:

[root@rac1] # iscsiadm-m node-T iqn.2006-01.com.openfiler:tsn.4849d1d582bc-p 192.168.192.111-l

Rac one of the nodes to do the following:

[root@rac1 ~] # fdisk / dev/sdb and so on I need to format 3 disks here!

When we're done, let's check it out, through fdisk-l.

[root@rac1 ~] # fdisk-l

Disk / dev/sda: 32.2 GB, 32212254720 bytes

255 heads, 63 sectors/track, 3916 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System

/ dev/sda1 * 1 25 200781 83 Linux

/ dev/sda2 26 547 4192965 82 Linux swap / Solaris

/ dev/sda3 548 3916 27061492 + 83 Linux

Disk / dev/sdb: 2113 MB, 2113929216 bytes

66 heads, 62 sectors/track, 1008 cylinders

Units = cylinders of 4092 * 512 = 2095104 bytes

Device Boot Start End Blocks Id System

/ dev/sdb1 10 1008 2043954 83 Linux

Disk / dev/sdc: 2113 MB, 2113929216 bytes

66 heads, 62 sectors/track, 1008 cylinders

Units = cylinders of 4092 * 512 = 2095104 bytes

Device Boot Start End Blocks Id System

/ dev/sdc1 10 1008 2043954 83 Linux

Disk / dev/sdd: 8556 MB, 8556380160 bytes

64 heads, 32 sectors/track, 8160 cylinders

Units = cylinders of 2048 * 512 = 1048576 bytes

Device Boot Start End Blocks Id System

/ dev/sdd1 10 8160 8346624 83 Linux

To another node.

Just enter partprobe to check the consistency between fdisk-l and other nodes!

15. Create an ASM disk

The following operations are done on the two and nodes respectively:

[root@rac1 ~] # rpm-ivh Oracleasm*

[root@rac1 ~] # / etc/init.d/oracleasm configure

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

The following operations are done on one of the nodes of rac, and I operate on rac1

[root@rac1] # / etc/init.d/oracleasm createdisk VOL1 / dev/sdb1

[root@rac1] # / etc/init.d/oracleasm createdisk VOL2 / dev/sdc1

[root@rac1] # / etc/init.d/oracleasm createdisk VOL3 / dev/sdd1

The following operations are performed on another node, on RAC2

[root@rac1 ~] # oracleasm scandisks

What I use here is asmlib for disk device management, and here you can also use UDEV to manage. Asmlib has been abandoned in RHEL6, and the world will be dominated by UDEV.

16, disable NTP server

This operation is also done on both nodes

[root@rac1 ~] # service ntpd stop

[root@rac1 ~] # chkconfig ntpd off

[root@rac1 ~] # mv / etc/ntp.conf / etc/ntp.conf.bak

17. Upload all installation software

# chown-R grid.oinstall / install/

# su-grid

$unzip linux.x64_11gR2_grid.zip

# chmod 775 / install

# chown oracle.oinstall / install/linux.x64_11gR2_database_ [1,2] of2.zip

# su-oracle

$unzip linux.x64_11gR2_database_1of2.zip

$unzip linux.x64_11gR2_database_2of2.zip

18. Install GI cluster software

[grid@rac1 grid] $. / runInstaller

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB. Actual 6888 MB Passed

Checking swap space: must be greater than 150 MB. Actual 2295 MB Passed

We select the first item "install and configure the cluster" and click "next"

We choose "Advanced installation" here and click "next"

Select "English" and click "Next"

Enter scan name here, which corresponds to the name written in our dns. Instead of selecting GNS, click "next".

Click add, add a second node, and when you are finished, click "next"

Here just need to confirm the network interface, the installation wizard has filled us in, in fact, this is similar to oracle 10g!

Select ASM storage method and click "Next"

Here let's create an asm disk group, give it a name "OCRVOTI", and select Redundancy External. Do not mirror data in ASM, use external

Storage arrays provide redundancy. Click "next"

Select the SYS and ASMSNMP users for ASM to be configured with the same password, and enter the password, Next: what you need to note here is that the password is a strength password!

Choose the second option here without using IPMI

Assign different groups to ASM. There is nothing to say here. Continue next.

The installation wizard will help you fill in the installation path of the cluster software. Let's continue with next. What we need to note here is that oracle_Home cannot be a subdirectory of oracle_base.

Select the default Inventory,Next:

It will be checked and passed in an instant. We come to this interface and continue to "finish".

Wait a little while, you can have a rest.

When you are finished, you need to execute two scripts manually under the root user and execute them sequentially. It will be slow to execute the second script, root.sh.

We will see this error report. In fact, I checked the mos knowledge base about this problem. It is rather vague. This error can be ignored and will not affect our installation and future use.

We directly finish, where our cluster software installation is complete.

19. Install the oracle 11.2.0.1 software

We su-oracle

Still unpack / install/oracle/database to run the installation script, let's install it in OUI mode, just like installing grid, start the installation wizard

It doesn't make sense for us not to fill in the mos account and not to connect to the Internet. Click next, and here we still install it on the rac1 node.

We only install database software here, click next

Select the cluster installation method here, select "select All", and click next

Or choose the language as "English" and click next

Select "Enterprise Edition" and click "next"

Here are oracle_base and oracle_home, click next

This corresponds to the group is fine, continue to next

This step will check your installation environment. We will have no problem as long as the configuration parameters are correct. Here are basically succeeded. Click next.

Summary, and we can finish.

Installation here will be faster, you can go to take a piss, just come back.

After completion, you also have to execute a script, which is also executed on two nodes by the root user.

Done.

20. Create an ASM disk group

We configured the asm disk when we installed the GI cluster software. Now we still have a disk partition that has not been added to the asm disk group, which is implemented through asmca.

Su-grid

Run the command asmca and we see the configuration wizard below. Here you can see the disk group that we configured before. After we click create,

When we come here, let's give disk group a name, choose redundancy External, check VOL3, and let's ok.

There will be a 10-second wait for the disk group to be created, which will indicate success when it is finished.

Here we can see there are two disk group! Just quit.

21. Configure oracle database

Let's directly su-oracle and run the dbca command to configure the database

After coming to the following interface, we select the first cluster mode, and then next

You don't have to think about this, just choose create a database and continue next.

This is also the choice of general purpose, continue to next

The configuration type is admin-managed,Global database name and sid are the same as test, at the bottom we choose "select all", and then next

Here we still choose the default recommended configuration. Both EM and amt choose the configuration to continue next.

Give sys, system and dbsnmp the same password, and you can give it yourself! And then next

Here we choose to use the storage type asm and use omf to manage the data files.

We do not choose the flashback recovery area here, I will not configure it here, and then manually change the spfile!

Install sample schemas, and you will have data to test and play! Continue next

Here our character set is set, ZHS16GBK-GBK, the international character set default on the line. Other tabs have no special configuration, so you can change spfile later. Let's continue with next.

This is the database storage configuration page, let's take a look at the control files and so on are about to be installed, next

Continue finish

Wait, this is also a long time, my SSD and cpu are more powerful, the speed is basically 10 minutes!

After installation, click exit

We will exit the installation and configuration wizard!

twenty-two。 Check

Check the status of crs resources

[grid@rac2] $crs_stat-t

Name Type Target State Host

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

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

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

Ora.OCRVOTI.dg ora....up.type ONLINE ONLINE rac1

Ora.asm ora.asm.type ONLINE ONLINE rac1

Ora.eons ora.eons.type ONLINE ONLINE rac1

Ora.gsd ora.gsd.type OFFLINE OFFLINE

Ora....network ora....rk.type ONLINE ONLINE rac1

Ora.oc4j ora.oc4j.type ONLINE ONLINE rac1

Ora.ons ora.ons.type ONLINE ONLINE rac1

Ora....SM1.asm application ONLINE ONLINE rac1

Ora....C1.lsnr application ONLINE ONLINE rac1

Ora.rac1.gsd application OFFLINE OFFLINE

Ora.rac1.ons application ONLINE ONLINE rac1

Ora.rac1.vip ora....t1.type ONLINE ONLINE rac1

Ora....SM2.asm application ONLINE ONLINE rac2

Ora....C2.lsnr application ONLINE ONLINE rac2

Ora.rac2.gsd application OFFLINE OFFLINE

Ora.rac2.ons application ONLINE ONLINE rac2

Ora.rac2.vip ora....t1.type ONLINE ONLINE rac2

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

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

Ora.test.db ora....se.type ONLINE ONLINE rac1

We can see that ora.gsd and ora.RAC2.gsd are offline statuses. In fact, the two processes have no effect on our database. We can just open them.

[grid@rac2] $srvctl status nodeapps-n rac2

-n option has been deprecated.

VIP rac2-vip is enabled

VIP rac2-vip is running on node: rac2

Network is enabled

Network is running on node: rac2

GSD is disabled

GSD is not running on node: rac2

ONS is enabled

ONS daemon is running on node: rac2

EONS is enabled

EONS daemon is running on node: rac2

[grid@rac2 ~] $srvctl enable nodeapps

PRKO-2415: VIP is already enabled on node (s): rac1,rac2

PRKO-2416: Network resource is already enabled.

PRKO-2417: ONS is already enabled on node (s): rac1,rac2

PRKO-2418: eONS is already enabled on node (s): rac1,rac2

[grid@rac2 ~] $srvctl status nodeapps

VIP rac1-vip is enabled

VIP rac1-vip is running on node: rac1

VIP rac2-vip is enabled

VIP rac2-vip is running on node: rac2

Network is enabled

Network is running on node: rac1

Network is running on node: rac2

GSD is enabled

GSD is not running on node: rac1

GSD is not running on node: rac2

ONS is enabled

ONS daemon is running on node: rac1

ONS daemon is running on node: rac2

EONS is enabled

EONS daemon is running on node: rac1

EONS daemon is running on node: rac2

[grid@rac2 ~] $srvctl start nodeapps

PRKO-2421: Network resource is already started on node (s): rac1,rac2

PRKO-2420: VIP is already started on node (s): rac1,rac2

PRKO-2420: VIP is already started on node (s): rac1,rac2

PRKO-2422: ONS is already started on node (s): rac1,rac2

PRKO-2423: eONS is already started on node (s): rac1,rac2

Let's check to see if all the components are online

[grid@rac2] $crs_stat-t

Name Type Target State Host

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

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

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

Ora.OCRVOTI.dg ora....up.type ONLINE ONLINE rac1

Ora.asm ora.asm.type ONLINE ONLINE rac1

Ora.eons ora.eons.type ONLINE ONLINE rac1

Ora.gsd ora.gsd.type ONLINE ONLINE rac1

Ora....network ora....rk.type ONLINE ONLINE rac1

Ora.oc4j ora.oc4j.type ONLINE ONLINE rac1

Ora.ons ora.ons.type ONLINE ONLINE rac1

Ora....SM1.asm application ONLINE ONLINE rac1

Ora....C1.lsnr application ONLINE ONLINE rac1

Ora.rac1.gsd application ONLINE ONLINE rac1

Ora.rac1.ons application ONLINE ONLINE rac1

Ora.rac1.vip ora....t1.type ONLINE ONLINE rac1

Ora....SM2.asm application ONLINE ONLINE rac2

Ora....C2.lsnr application ONLINE ONLINE rac2

Ora.rac2.gsd application ONLINE ONLINE rac2

Ora.rac2.ons application ONLINE ONLINE rac2

Ora.rac2.vip ora....t1.type ONLINE ONLINE rac2

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

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

Ora.test.db ora....se.type ONLINE ONLINE rac1

It is also emphasized here that a bug in version 11.2.0.1 is that the client cannot connect to the database through scan. The solution is as follows:

[oracle@rac2 ~] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Mar 19 11:29:58 2014

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP

Data Mining and Real Application Testing options

SQL > show parameter local_listener

NAME TYPE VALUE

-

Local_listener string (DESCRIPTION= (ADDRESS_LIST= (AD)

DRESS= (PROTOCOL=TCP) (HOST=rac2

-vip) (PORT=1521)

SQL > show parameter remot_listener

NAME TYPE VALUE

-

Remote_dependencies_mode string TIMESTAMP

Remote_listener string scan-cluster.localdomain:1521

Remote_login_passwordfile string EXCLUSIVE

Remote_os_authent boolean FALSE

Remote_os_roles boolean FALSE

Result_cache_remote_expiration integer 0

SQL > alter system set local_listener=' (DESCRIPTION= (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.192.173) (PORT = 1521) 'sid='test2'

System altered.

SQL > alter system set remote_listener='scan-cluster.localdomain:1521'

System altered.

SQL > alter system register

System altered.

Finally, the configuration client tnsname.ora file points to scan listener.

# tnsnames.ora.rac2 Network Configuration File: / u01/app/11.2.0/grid/network/admin/tnsnames.ora.rac2

# Generated by Oracle configuration tools.

TEST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.192.173) (PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = test)

)

)

After reading this article, I believe you have a certain understanding of "how to install Oracle 11g R2 RAC in OEL5.5". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

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.