Dsiable child listener process ..

More than two child listener started for one listener.

[oracle@test1 ~]$ ps -ef|grep tns
oracle 10461 1 0 00:04 ? 00:00:00 /u01/app/oracle/product/11.2.0.1/bin/tnslsnr think -inherit
oracle 10462 10461 0 00:04 ? 00:00:00 /u01/app/oracle/product/11.2.0.1/bin/tnslsnr think -inherit
oracle 10463 10462 0 00:04 ? 00:00:00 /u01/app/oracle/product/11.2.0.1/bin/tnslsnr think -inherit
oracle 10464 10462 0 00:04 ? 00:00:00 /u01/app/oracle/product/11.2.0.1/bin/tnslsnr think -inherit

Solution:

SUBSCRIBE_FOR_NODE_DOWN_EVENT_=OFF

Start/Stop OID

Start/ stop components

opmnctl stopall
opmnctl startall
opmnctl startproc ias-component=OID
opmnctl startproc ias-component=HTTP_Server
opmnctl startproc ias-component=OC4J
opmnctl startproc process-type=OC4J_SECURITY

How to use prelim option in sqlplus

1) sqlplus -prelim / as sysdba

2) sqlplus /nolog
set _prelim on
conn / as sysdba so I tried…

-bash-3.1$ sqlplus /nolog

SQL*Plus: Release 11.1.0.6.0 – Production on Thu Sep 25 18:04:28 2008

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

SQL> set _prelim on
SQL> conn / as sysdba
Prelim connection established
SQL> oradebug setmypid
Statement processed.
SQL> oradebug unlimit
Statement processed.
SQL> oradebug dump hanganalyze 1
Statement processed.
SQL> oradebug dump systemstate 10
Statement processed.
SQL> oradebug tracefile_name
/oracle/admin/diag/rdbms/demo11g/demo11g/trace/demo11g_ora_25010.trc

11gR2 RAC Commands

[oracle@vm14 ~]$ crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online


[oracle@vm14 ~]$ oifcfg getif
eth1 192.168.1.0 global cluster_interconnect
eth0 192.168.0.0 global public
[oracle@vm14 ~]$ oifcfg delif -global eth1
[oracle@vm14 ~]$ oifcfg setif -global eth1/192.168.1.0:cluster_interconnect
[oracle@vm14 ~]$ oifcfg getif
eth0 192.168.0.0 global public
eth1 192.168.1.0 global cluster_interconnect



[oracle@vm14 admin]$ crsctl check cluster
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[oracle@vm14 admin]$ crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online


[oracle@vm14 admin]$ crsctl check cluster -all
**************************************************************
vm14:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************


[oracle@vm14 admin]$ crsctl check ctss
CRS-4701: The Cluster Time Synchronization Service is in Active mode.
CRS-4702: Offset (in msec): 0

[root@vm14 bin]# ./crsctl config crs
CRS-4622: Oracle High Availability Services autostart is enabled.
[root@vm14 bin]#


[oracle@vm14 ~]$ crsctl get css
Usage:
crsctl get css
Displays the value of a Cluster Synchronization Services parameter

clusterguid
diagwait
disktimeout
misscount
reboottime
priority
logfilesize

crsctl get css ipmiaddr
Displays the IP address of the local IPMI device as set in the Oracle registry.
[oracle@vm14 ~]$ crsctl get css clusterguid
33ff95a9853c4f4afff46ad27062d6b6

[oracle@vm14 ~]$ crsctl get nodename
vm14
[oracle@vm14 ~]$


[oracle@vm14 ~]$ crsctl query crs administrator
CRS Administrator List: *
[oracle@vm14 ~]$ crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.1.0]
[oracle@vm14 ~]$ crsctl query crs releaseversion
Oracle High Availability Services release version on the local node is [11.2.0.1.0]
[oracle@vm14 ~]$ crsctl query crs softwareversion
Oracle Clusterware version on node [vm14] is [11.2.0.1.0]
[oracle@vm14 ~]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 02b2f2c970c74f4ebfe416312bb22451 (ORCL:DISK1) [DATA_OCRVOTE]
Located 1 voting disk(s).
[oracle@vm14 ~]$ crsctl query css ipmidevice
CRS-4218: IPMI device not found

[oracle@vm14 ~]$ crsctl status server
NAME=vm14
STATE=ONLINE

[oracle@vm14 ~]$ crsctl status serverpool
NAME=Free
ACTIVE_SERVERS=vm14

NAME=Generic
ACTIVE_SERVERS=



srvctl add service -d RAC -s rac_srv -P BASIC -e SELECT -r "RAC1" -a "RAC2"

How to install CRS in silent option?

[oracle@vm1 Disk1]$ ./runInstaller -silent \
> -responseFile /home/oracle/Disk1/response/patchset.rsp \
> ORACLE_HOME="/u02/crs/oracle/product/10.2.0/crs" \
> ORACLE_HOME_NAME="OraCrs10g_home"
Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5, redhat-6, UnitedLinux-1.0, asianux-1, asianux-2, asianux-3, enterprise-4, enterprise-5 or SuSE-11
Passed


All installer requirements met.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-10-11_01-43-39PM. Please wait ...[oracle@vm1 Disk1]$ Oracle Universal Installer, Version 10.2.0.5.0 Production
Copyright (C) 1999, 2010, Oracle. All rights reserved.

You can find a log of this install session at:
/u02/app/oracle/oraInventory/logs/installActions2011-10-11_01-43-39PM.log
.................................................................................................... 100% Done.


Loading Product Information
................................................................................................................. 100% Done.


Performing tests to see whether nodes vm2 are available
............................................................... 100% Done.


Starting execution of Prerequisites...
Total No of checks: 9

Performing check for Detect10.2CRS
Checking Oracle Clusterware version ...
Check complete. The overall result of this check is: Passed


Check complete: Passed
=======================================================================
Performing check for CertifiedVersions
Checking operating system requirements ...
Expected result: One of redhat-6,redhat-5,redhat-4,redhat-3,SuSE-11,SuSE-10,SuSE-9,asianux-3,asianux-2,asianux-1
Actual Result: redhat-4
Check complete. The overall result of this check is: Passed


Check complete: Passed
=======================================================================
Performing check for Packages
Checking operating system package requirements ...
Checking for make-3.79; found make-1:3.80-5. Passed
Checking for binutils-2.14; found binutils-2.15.92.0.2-10.EL4. Passed
Checking for gcc-3.2; found gcc-3.4.3-9.EL4. Passed
Checking for libaio-0.3.96; found libaio-0.3.102-1. Passed
Checking for libstdc++-3.2.3; found libstdc++-3.4.3-9.EL4. Passed
Check complete. The overall result of this check is: Passed


Check complete: Passed
=======================================================================
Performing check for Kernel
Checking kernel parameters
Checking for semmsl=250; found semmsl=250. Passed
Checking for semmns=32000; found semmns=32000. Passed
Checking for semopm=100; found semopm=100. Passed
Checking for semmni=128; found semmni=128. Passed
Checking for shmmax=536870912; found shmmax=2147483648. Passed
Checking for shmmni=4096; found shmmni=4096. Passed
Checking for shmall=2097152; found shmall=2097152. Passed
Checking for file-max=65536; found file-max=65536. Passed
Checking for VERSION=2.6.9; found VERSION=2.6.9-5.EL. Passed
Checking for ip_local_port_range=1024 - 65000; found ip_local_port_range=1024 - 65000. Passed
Checking for rmem_default=262144; found rmem_default=524288. Passed
Checking for rmem_max=262144; found rmem_max=16777216. Passed
Checking for wmem_default=262144; found wmem_default=524288. Passed
Checking for wmem_max=262144; found wmem_max=16777216. Passed
Check complete. The overall result of this check is: Passed


Check complete: Passed
=======================================================================
Performing check for GLIBC
Checking Recommended glibc version
Expected result: ATLEAST=2.3.2-95.27 NOT_EQUALS=2.3.4-2.39
Actual Result: 2.3.4-2
Check complete. The overall result of this check is: Passed


Check complete: Passed
=======================================================================
Performing check for TotalMemory
Checking physical memory requirements ...
Expected result: 922MB
Actual Result: 484MB
Check complete. The overall result of this check is: Failed <<<<


Check complete: Failed <<<<
Problem: The system does not have sufficient physical memory to perform the install.
Recommendation: Increase the amount of physical memory available to your system before continuing with the installation.

=======================================================================
Performing check for SwapSpace
Checking available swap space requirements ...
Expected result: 968MB
Actual Result: 1076MB
Check complete. The overall result of this check is: Passed


Check complete: Passed
=======================================================================
Performing check for checkToInstallCCR
Checking the Components installed in Oracle Home
Check complete. The overall result of this check is: Passed


Check complete: Passed
=======================================================================
Performing check for CompatibilityChecks
Checking for Oracle Home incompatibilities ...
Check complete. The overall result of this check is: Passed


Check complete: Passed
=======================================================================
PrereqChecks complete


Analyzing dependencies
...................................................................................................... 100% Done.


-----------------------------------------------------------------------------
Summary
Global Settings
Source: /home/oracle/Disk1/stage/products.xml
Oracle Home: /u02/crs/oracle/product/10.2.0/crs (OraCrs10g_home)
Node Name: vm1
Node Name: vm2
Product Languages
English
Space Requirements
/ Required 62MB (includes 29MB temporary) : Available 3.96GB
Remote Nodes
vm2
/: Required 32MB : Available 12.37GB
New Installations (4 products)
Enterprise Manager Minimal Integration 10.2.0.5.0
Parser Generator Required Support Files 10.2.0.5.0
Buildtools Common Files 10.2.0.5.0
Bali Share 1.1.19.0.0
Upgrades (23 products)
Oracle Notification Service Patch 10.2.0.5.0
Oracle Clusterware Patch 10.2.0.5.0
HAS Common Files Patch 10.2.0.5.0
Cluster Ready Services Files Patch 10.2.0.5.0
Oracle Clusterware RDBMS Files Patch 10.2.0.5.0
Oracle Net Required Support Files Patch 10.2.0.5.0
XDK Required Support Files Patch 10.2.0.5.0
Agent Required Support Files Patch 10.2.0.5.0
DBJAVA Required Support Files Patch 10.2.0.5.0
LDAP Required Support Files Patch 10.2.0.5.0
Precompiler Required Support Files Patch 10.2.0.5.0
Oracle RAC Required Support Files-HAS Patch 10.2.0.5.0
RDBMS Required Support Files for Instant Client Patch 10.2.0.5.0
RDBMS Required Support Files Patch 10.2.0.5.0
SQL*Plus Required Support Files Patch 10.2.0.5.0
SSL Required Support Files for InstantClient Patch 10.2.0.5.0
Oracle Globalization Support Patch 10.2.0.5.0
Oracle Core Required Support Files Patch 10.2.0.5.0
Platform Required Support Files 10.2.0.5.0
Oracle Universal Installer 10.2.0.5.0
Oracle One-Off Patch Installer 10.2.0.4.2
Installer SDK Component 10.2.0.5.0
Sun JDK 1.4.2.14.05
Already Installed (24 products)
Oracle Notification Service 10.1.0.3.0
Oracle Clusterware 10.2.0.1.0
HAS Common Files 10.2.0.1.0
Cluster Ready Services Files 10.2.0.1.0
Oracle Clusterware RDBMS Files 10.2.0.1.0
Oracle Net Required Support Files 10.2.0.1.0
XDK Required Support Files 10.2.0.1.0
Agent Required Support Files 10.2.0.1.0
DBJAVA Required Support Files 10.2.0.1.0
LDAP Required Support Files 10.2.0.1.0
Precompiler Required Support Files 10.2.0.1.0
Oracle RAC Required Support Files-HAS 10.2.0.1.0
RDBMS Required Support Files for Instant Client 10.2.0.1.0
RDBMS Required Support Files 10.2.0.1.0
SQL*Plus Required Support Files 10.2.0.1.0
SSL Required Support Files for InstantClient 10.2.0.1.0
Oracle Globalization Support 10.2.0.1.0
Oracle Core Required Support Files 10.2.0.1.0
Platform Required Support Files 10.2.0.1.0
Enterprise Manager Minimal Integration 10.2.0.1.0
Parser Generator Required Support Files 10.2.0.1.0
Buildtools Common Files 10.2.0.1.0
Bali Share 1.1.18.0.0
Java Runtime Environment 1.4.2.14.0
-----------------------------------------------------------------------------


Deinstall in progress (Tuesday, October 11, 2011 1:44:15 PM IST)
............................................................... 0% Done.
............................................................... 25% Done.
............................................................... 50% Done.
.............................................................. 100% Done.

Deinstall successful

Installation in progress (Tuesday, October 11, 2011 1:44:16 PM IST)
............................................................... 25% Done.
................................................. 44% Done.
Install successful

Linking in progress (Tuesday, October 11, 2011 1:45:37 PM IST)
.. 45% Done.
Link successful

Setup in progress (Tuesday, October 11, 2011 1:45:37 PM IST)
. 45% Done.
Setup successful

Remote operations in progress (Tuesday, October 11, 2011 1:45:42 PM IST)
............................................................... 70% Done.
.................. 100% Done.
Remote operations complete

End of install phases.(Tuesday, October 11, 2011 1:47:25 PM IST)
The installation of Oracle Database 10g Release 2 Patch Set 4 was successful.
Please check '/u02/app/oracle/oraInventory/logs/silentInstall2011-10-11_01-43-39PM.log' for more details.

[oracle@vm1 Disk1]$

How to upgrade CRS from 10g to 11gR1?

Step 1:

[root@vm1 upgrade]# ./preupdate.sh -crshome /u02/crs/oracle/product/10.2.0/crs -crsuser oracle
Shutting down Oracle Cluster Ready Services (CRS):
Jan 19 03:22:00.079 | INF | daemon shutting down
Stopping resources. This could take several minutes.
Successfully stopped CRS resources.
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
Shutdown has begun. The daemons should exit soon.
Checking to see if Oracle CRS stack is down...
Oracle CRS stack is down now.


[root@vm2 oracle]# ./preupdate.sh -crshome /u02/crs/oracle/product/10.2.0/crs -crsuser oracle
Shutting down Oracle Cluster Ready Services (CRS):
Jan 22 20:47:48.862 | INF | daemon shutting down
Stopping resources. This could take several minutes.
Successfully stopped CRS resources.
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
Shutdown has begun. The daemons should exit soon.
Checking to see if Oracle CRS stack is down...
Oracle CRS stack is down now.
[root@vm2 oracle]#

Step 3:

Execute runinstaller command from CRS software.

Step 4:

end of installation execute rootupgrade script

[root@vm1 logs]# /u02/crs/oracle/product/10.2.0/crs/install/rootupgrade
Checking to see if Oracle CRS stack is already up...

copying ONS config file to 11.1 CRS home
/bin/cp: `/u02/crs/oracle/product/10.2.0/crs/opmn/conf/ons.config' and `/u02/crs/oracle/product/10.2.0/crs/opmn/conf/ons.config' are the same file
/u02/crs/oracle/product/10.2.0/crs/opmn/conf/ons.config was copied successfully to /u02/crs/oracle/product/10.2.0/crs/opmn/conf/ons.config
WARNING: directory '/u02/crs/oracle/product/10.2.0' is not owned by root
WARNING: directory '/u02/crs/oracle/product' is not owned by root
WARNING: directory '/u02/crs/oracle' is not owned by root
WARNING: directory '/u02/crs' is not owned by root
WARNING: directory '/u02' is not owned by root
Oracle Cluster Registry configuration upgraded successfully
Adding daemons to inittab
Attempting to start Oracle Clusterware stack
Waiting for Cluster Synchronization Services daemon to start
Waiting for Cluster Synchronization Services daemon to start
Waiting for Cluster Synchronization Services daemon to start
Waiting for Cluster Synchronization Services daemon to start
Cluster Synchronization Services daemon has started
Waiting for Event Manager daemon to start
Event Manager daemon has started
Waiting for Cluster Ready Services daemon to start
Cluster Ready Services daemon has started
Oracle CRS stack is running under init(1M)
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node :
node 1: vm1 vm1-priv vm1
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
clscfg -upgrade completed successfully
CRS stack on this node, is successfully upgraded to 11.1.0.6.0
Checking the existence of nodeapps on this node
Creating '/u02/crs/oracle/product/10.2.0/crs/install/paramfile.crs' with data used for CRS configuration
Setting CRS configuration values in /u02/crs/oracle/product/10.2.0/crs/install/paramfile.crs




[root@vm2 oracle]# /u02/crs/oracle/product/10.2.0/crs/install/rootupgrade
Checking to see if Oracle CRS stack is already up...

copying ONS config file to 11.1 CRS home
/bin/cp: `/u02/crs/oracle/product/10.2.0/crs/opmn/conf/ons.config' and `/u02/crs/oracle/product/10.2.0/crs/opmn/conf/ons.config' are the same file
/u02/crs/oracle/product/10.2.0/crs/opmn/conf/ons.config was copied successfully to /u02/crs/oracle/product/10.2.0/crs/opmn/conf/ons.config
WARNING: directory '/u02/crs/oracle/product/10.2.0' is not owned by root
WARNING: directory '/u02/crs/oracle/product' is not owned by root
WARNING: directory '/u02/crs/oracle' is not owned by root
WARNING: directory '/u02/crs' is not owned by root
WARNING: directory '/u02' is not owned by root
Oracle Cluster Registry configuration upgraded successfully
Adding daemons to inittab
Attempting to start Oracle Clusterware stack
Waiting for Cluster Synchronization Services daemon to start
Waiting for Cluster Synchronization Services daemon to start
Waiting for Cluster Synchronization Services daemon to start
Waiting for Cluster Synchronization Services daemon to start
Cluster Synchronization Services daemon has started
Waiting for Event Manager daemon to start
Event Manager daemon has started
Cluster Ready Services daemon has started
Oracle CRS stack is running under init(1M)
clscfg: EXISTING configuration version 4 detected.
clscfg: version 4 is 11 Release 1.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node :
node 2: vm2 vm2-priv vm2
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
clscfg -upgrade completed successfully
CRS stack on this node, is successfully upgraded to 11.1.0.6.0
Checking the existence of nodeapps on this node
Creating '/u02/crs/oracle/product/10.2.0/crs/install/paramfile.crs' with data used for CRS configuration
Setting CRS configuration values in /u02/crs/oracle/product/10.2.0/crs/install/paramfile.crs
[root@vm2 oracle]#