Active Sessions more than 3 hrs

col USERNAME for a10

 

col MACHINE for a15

 

col PROGRAM for a25

 

set line 400

 

SELECT USERNAME,machine,inst_id,sid,serial#,

 

PROGRAM,

 

to_char(logon_time,'dd-mm-yy hh:mi:ss AM')"Logon Time",

 

ROUND((SYSDATE-LOGON_TIME)*(24*60),1) as MINUTES_LOGGED_ON,

 

ROUND(LAST_CALL_ET/60,1) as Minutes_FOR_CURRENT_SQL

 

From gv$session

 

WHERE STATUS='ACTIVE'

 

AND USERNAME IS NOT NULL  and ROUND((SYSDATE-LOGON_TIME)*(24*60),1) > 180

 

ORDER BY MINUTES_LOGGED_ON DESC;

ggsci: error while loading shared libraries: libnnz10.so

Error:

[oracle@test2 gg]$ ggsci
ggsci: error while loading shared libraries: libnnz10.so: cannot open shared object file: No such file or directory

Workaround:





[oracle@test2 gg]$  ln -s /u01/app/oracle/product/11.1.0.7/lib/libclntsh.so.10.1 libnnz10.so

ORA-03113 ORA-07445 RMAN-06429 errors on 11.2.0.2

SQL> select status from dba_registry;
select status from dba_registry
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 12168
Session ID: 1 Serial number: 21



[oracle@test2 dbs]$ rman target sys/oracle@samp auxiliary sys/oracle@samt

Recovery Manager: Release 11.2.0.2.0 - Production on Sat Dec 1 17:51:06 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

ORACLE error from target database:
ORA-03113: end-of-file on communication channel
Process ID: 8729
Session ID: 33 Serial number: 61

error executing package DBMS_RCVMAN in TARGET database
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-06429: TARGET database is not compatible with this version of RMAN

Alert Log Errors:



Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x74] [PC:0xFDF42B6, pevm_icd_call_common()+638] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/samp/samp/trace/samp_ora_11729.trc  (incident=5797):
ORA-07445: exception encountered: core dump [pevm_icd_call_common()+638] [SIGSEGV] [ADDR:0x74] [PC:0xFDF42B6] [Address not mapped to object] []
ORA-04067: not executed, package body "GGS_OWNER.DDLREPLICATION" does not exist
ORA-06508: PL/SQL: could not find program unit being called: "GGS_OWNER.DDLREPLICATION"
ORA-04067: not executed, package body "GGS_OWNER.DDLREPLICATION" does not exist
ORA-06508: PL/SQL: could not find program unit being called: "GGS_OWNER.DDLREPLICATION"
Incident details in: /u01/app/oracle/diag/rdbms/samp/samp/incident/incdir_5797/samp_ora_11729_i5797.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2012-12-01 18:07:30.908000 +05:30
Dumping diagnostic data in directory=[cdmp_20121201180730], requested by (instance=1, osid=11729), summary=[incident=5797].


Workaround:

1.Startup database in upgrade mode "startup upgrade"
2.Then run catalog & catproc

ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled

Issue :

alter database open resetlogs;
*
ERROR at line 1:
ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled

Cause:   When try to open database with resetlogs option after restoring rac db on non rac db.  

Workaround:
 1._no_recovery_through_resetlogs=TRUE set in pfile
 2.startup mount
 3.alter database open resetlogs;

Patchset Silent Installation

Method 1:

../runInstaller -silent  -ignoreSysprereqs  \
-responseFile /u01/Disk1/response/patchset.rsp  \
ORACLE_HOME="/u01/app/oracle/product/10.2.0.5" \
ORACLE_HOME_NAME="Ora10gHome" \
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \
DECLINE_SECURITY_UPDATES=true


Method 2:

Update below setting on response file

ORACLE_HOME=/u01/app/oracle/product/10.2.0.5
ORACLE_HOME_NAME=Ora10gHome
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true

Then invoke runinstaller


./runInstaller -silent -responseFile  /u01/Disk1/response/patchset.rsp  -ignoreSysprereqs







Error & Workaround:

If you don't modify SECURITY_UPDATES_VIA_MYORACLESUPPORT & DECLINE_SECURITY_UPDATES values then below error will be encountered

SEVERE:Values for the following variables could not be obtained from the command line or response file(s):
  MYORACLESUPPORT_USERNAME(MyOracleSupportUsername)
Silent install cannot continue.

Oracle 11gR2 Silent Installation

Please modify db_install.rsp response like below.




oracle.install.option=INSTALL_DB_SWONLY

ORACLE_HOSTNAME=vm1.domain.com

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/u01/app/oraInventory

SELECTED_LANGUAGES=en

ORACLE_HOME=/u01/app/oracle/product/11.2.0.3

ORACLE_BASE=/u01/app/oracle

oracle.install.db.InstallEdition=EE

oracle.install.db.DBA_GROUP=dba

DECLINE_SECURITY_UPDATES=TRUE

oracle.installer.autoupdates.downloadUpdatesLoc=SKIP_UPDATES



Run below command :



./runInstaller -silent -executePrereqs -responseFile "/u01/database/response/db_install.rsp"

PSU auto patch on 10g CRS_HOME

1.Opatch version should be earlier version (>11)
2.Configuare ocm.rsp file
     cd /u03/crs/OPatch/ocm/bin
   
      ls -lrt
     total 16
     -rwxr-----  1 oracrs oinstall 8486 Dec  7  2010 emocmrsp

    execute emocmrsp 

     ./emocmrsp

 [oracle@vm1 bin]$ ls -lrt

total 16

-rwxr-----  1 oracrs oinstall 8486 Dec  7  2010 emocmrsp

-rwxrwxr-x  1 oracrs oinstall  623 Nov 13 09:35 ocm.rsp

[oracle@vm1 bin]$

[root@vm1 9952245]# opatch auto /home/oracrs/psu/9952245 -oh /u03/crs

auto_patch.pl: log file is /home/oracrs/psu/9952245/opatchauto_2012-11-13_10:33:35.log

Discovering environment to patch

Checking if Clusterware is up

Looking for configured cluster nodes

vm1 vm2

Getting Local node name

Looking for configured databases on node vm1

Databases configured on node vm1 are: CAR

Determining ORACLE_HOME paths for configured databases

Retrieving configured services for Database CAR

There are 1 services configured for Database CAR

asm home is /u02/app/oracle/product/10.2.0/db_1

Oracle Home /u02/app/oracle/product/10.2.0/db_1 is configured with Database(s)-> CAR

opatch version is 11.2.0.1.4

/u03/crs/OPatch/opatch is bundled with OCM, Enter the absolute OCM response file path:

/u03/crs/OPatch/ocm/bin/ocm.rsp

Oracle CRS user is oracrs

Cluster nodes are vm1 vm2

Node to patch is vm1

Using /u03/crs/OPatch/opatch for opatch

The patch is applicable for this CRS Home /u03/crs

Patch node vm1? (y/n/abort/N/N1-N2/help):

y

Applying patch 9952245 on node vm1

 stopping instance on vm1 with /u02/app/oracle/product/10.2.0/db_1/bin/srvctl stop instance -d CAR -i CAR1

 stopping ASM on vm1 with /u03/crs/bin/srvctl stop asm -n vm1

 stopping listener on vm1 with /u03/crs/bin/srvctl stop listener -n vm1

 stopping nodeapps on vm1 with /u03/crs/bin/srvctl stop nodeapps -n vm1

 shutting  down CRS stack on vm1 with /u03/crs/bin/crsctl stop crs

Sleeping 15 second(s)

Failure 1 contacting CSS daemon

Cannot communicate with EVM

Cannot communicate with CRS

 Executing /home/oracrs/psu/9952245/custom/scripts/prerootpatch.sh -crshome /u03/crs -crsuser oracrs as root on vm1

 Executing /home/oracrs/psu/9952245/custom/scripts/prepatch.sh -crshome /u03/crs as oracrs on vm1

 Executing /u03/crs/OPatch/opatch napply -local -silent -ocmrf /u03/crs/OPatch/ocm/bin/ocm.rsp -oh /u03/crs -id 9952245 as oracrs on vm1

 Executing /home/oracrs/psu/9952245/custom/scripts/postpatch.sh -crshome /u03/crs as oracrs on vm1

 Executing /home/oracrs/psu/9952245/custom/scripts/postrootpatch.sh -crshome /u03/crs as root on vm1

 Starting services for CAR on vm1

List of patched nodes:  vm1

auto_patch.pl finished

Errors & Workarounds:

Error 1:

Using /u03/crs/OPatch/opatch for opatch

Failed to load the patch object.  Possible causes are:

  The specified path is not an interim Patch shiphome

  Meta-data files are missing from the patch area

  Patch location = /home/oracrs/psu

  Details = Input metadata files are missing.

.....

 Executing /home/oracrs/psu/custom/scripts/prerootpatch.sh -crshome /u03/crs -crsuser oracrs as root on vm1

verify failure: exit code 32512 for prerootpatch_crs

Action failed, do you want to retry it? (y/n/abort/N/N1-N2/help):

Solution:

         Unzipped patch location should be vaild location

 

Invalid Path: /home/oracrs/psu

 

Valid Path : /home/oracrs/psu/9952245

 

Error 2:

 Executing /u03/crs/OPatch/opatch napply -local -silent -ocmrf /u03/crs/OPatch/ocm/bin/ocm.rsp -oh /u03/crs -id 9952245 as oracrs on vm1

verify failure: exit code 18688 for patch_crs

Action failed, do you want to retry it? (y/n/abort/N/N1-N2/help):

Solution :

          Required amount of space(557321672) is not available.

         CRS_HOME free space should be >600mb

 

expdp fails with ORA-31626 ORA-31637 ORA-06512 ORA-31635 errors

Error:

 ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 798
ORA-31635: unable to establish job resource synchronization

Workaround:

AQ_TM_PROCESSES process should be 1.

Set  AQ_TM_PROCESSES = 1 parameter and bounce the database will resolve issue.


Issue:

 V$XML_AUDIT_TRAIL Returns No Rows :

Workaround :

This is bug on 11.2.0.2

Refer Metalink ID  (Doc ID 1267954.1) .Have to Apply Patch 9438890 to solve this problem.

Showing Idle Instance xe

Issue Description :

  XE database is running fine but while login to database it is showing idle instance.

$sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 12 18:32:49 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to Idle Instance.

SQL>   Workaround:   LIB path is caused for this issue. you have run to oracle_env.sh script from ORACLE_HOME/bin location.   add  script on .bash_profile   $ cat .bash_profile

. /opt/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh

$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 12 18:32:49 2012

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

Connected to:

Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL>

User Equivalence

Node1:

mkdir -p ~/.ssh
chmod 700 ~/.ssh
/usr/bin/ssh-keygen -t rsa
/usr/bin/ssh-keygen -t dsa

Node2:

mkdir -p ~/.ssh
chmod 700 ~/.ssh
/usr/bin/ssh-keygen -t rsa
/usr/bin/ssh-keygen -t dsa

Node 1:

ssh vm11 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
ssh vm11 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
scp /home/oracrs/.ssh/authorized_keys oracrs@vm12:~/.ssh/


Node2:
ssh vm12 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
ssh vm12 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
scp /home/oracrs/.ssh/authorized_keys oracrs@vm11:~/.ssh/

Failure at final check of Oracle CRS stack.10

Issue:

root.sh is failed with below on node2

Failure at final check of Oracle CRS stack.10

Workaround:

Please verify network configuration on /etc/hosts

/u03/app/crs/jdk/jre//bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory

Issue :
root.sh failed with below errors

Running vipca(silent) for configuring nodeapps
/u03/app/crs/jdk/jre//bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory
[root@vm12 crs]# ls

Workaround :

Modify vipca file:

vi /u03/app/crs/vipca

if [ "$arch" = "i686" -o "$arch" = "ia64" ]
then
      LD_ASSUME_KERNEL=2.4.19
      export LD_ASSUME_KERNEL
fi
unset LD_ASSUME_KERNEL
#End workaround

Modify srvctl:

vi /u03/app/crs/srvctl


./vipca
Error 0(Native: listNetInterfaces:[3])
  [Error 0(Native: listNetInterfaces:[3])]

 Workaround :

./oifcfg getif
./oifcfg setif -global eth0/192.168.0.0:public
./oifcfg setif -global eth1/192.168.1.0:cluster_interconnect
[root@vm12 bin]# ./oifcfg getif
eth0  192.168.0.0  global  public
eth1  192.168.1.0  global  cluster_interconnect

sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

Issue:

$ sqlplus
sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

when invoking sqlplus as non oracle user

Workaround:

chmod -R a+rX $ORACLE_HOME or chmod -R 755 $ORACLE_HOME

Recovering datafile missed in CREATE CONTROLFILE

It is not possible to recover missing datafile .

Error:

ORA-00600: internal error code, arguments: [krhpfh_03-1202], [fno =], [6], [fhcr
t =], [772638946], [cptim =], [0], []

Solution:

this is bug . it is fixed in 11.2.0.3 (Refer 1269082.1)

Redo thread 1: Not able to establish initial position for sequence 219, rba 632848

solution:

 alter extract ext3 begin now

Access windows folder from VM Machine

Create a new local mount point, eg:

mkdir /tmp/smbmnt

Enable netfs:

chkconfig netfs on
service netfs start


mount -t cifs -o username=user,password=Welcome //192.168.0.4/audit /tmp/smbmnt/


ln -s /myMountFolder/MyMountPoint /PathOfSymlink

username=user
password=Welcome

chmod 600 /root/smbpass.txt


//192.168.0.4/audit /tmp/smbmnt/ cifs credentials=/root/smbpass.txt 0 0

mount //192.168.0.4/audit

Access windows folder from VM Machine

Create a new local mount point, eg:

mkdir /tmp/smbmnt

Enable netfs:

chkconfig netfs on
service netfs start


mount -t cifs -o username=user,password=Welcome //192.168.0.4/audit /tmp/smbmnt/


ln -s /myMountFolder/MyMountPoint /PathOfSymlink

username=user
password=Welcome

chmod 600 /root/smbpass.txt


//192.168.0.4/audit /tmp/smbmnt/ cifs credentials=/root/smbpass.txt 0 0

mount //192.168.0.4/audit

Gather Stats

10g

SQL> select
DBMS_STATS.GET_PARAM ('AUTOSTATS_TARGET'),
DBMS_STATS.GET_PARAM ('CASCADE'),
DBMS_STATS.GET_PARAM ('DEGREE'),
DBMS_STATS.GET_PARAM ('ESTIMATE_PERCENT'),
DBMS_STATS.GET_PARAM ('METHOD_OPT'),
DBMS_STATS.GET_PARAM ('NO_INVALIDATE'),
DBMS_STATS.GET_PARAM ('GRANULARITY')
from dual;


11g

SQL> select
DBMS_STATS.GET_PREFS ('AUTOSTATS_TARGET'),
DBMS_STATS.GET_PREFS ('CASCADE'),
DBMS_STATS.GET_PREFS ('DEGREE'),
DBMS_STATS.GET_PREFS ('ESTIMATE_PERCENT'),
DBMS_STATS.GET_PREFS ('METHOD_OPT'),
DBMS_STATS.GET_PREFS ('NO_INVALIDATE'),
DBMS_STATS.GET_PREFS ('GRANULARITY'),
DBMS_STATS.GET_PREFS ('PUBLISH'),
DBMS_STATS.GET_PREFS ('INCREMENTAL'),
DBMS_STATS.GET_PREFS ('STALE_PERCENT')
from dual;

10g:

select * from dba_scheduler_jobs where job_name = 'GATHER_STATS_JOB';
select * from dba_scheduler_job_run_details where job_name = 'GATHER_STATS_JOB';
select * from dba_scheduler_job_log where job_name = 'GATHER_STATS_JOB';

SQL> exec dbms_auto_task_admin.enable(client_name => 'auto optimizer stats collection', operation => null, window_name => null);
PL/SQL procedure successfully completed

SQL> exec dbms_auto_task_admin.disable(client_name => 'auto optimizer stats collection', operation => null, window_name => null);

10g:

DBMS_STATS.GET_PARAM('ESTIMATE_PERCENT')
---------------
DBMS_STATS.AUTO_SAMPLE_SIZE

SQL> exec dbms_stats.set_param('ESTIMATE_PERCENT','100');

PL/SQL procedure successfully completed.

SQL> SELECT dbms_stats.get_param('ESTIMATE_PERCENT') FROM dual;

DBMS_STATS.GET_PARAM('ESTIMATE_PERCENT')
---------------
100

SQL> exec dbms_stats.RESET_PARAM_DEFAULTS();

PL/SQL procedure successfully completed.

SQL> SELECT dbms_stats.get_param('ESTIMATE_PERCENT') FROM dual;

DBMS_STATS.GET_PARAM('ESTIMATE_PERCENT')
-------------------------------------------------------------------------------------
DBMS_STATS.AUTO_SAMPLE_SIZE

ADRCI

ADRCI 11g utility:

adrci> show alert -tail -f
adrci> show problem
adrci> show incident
adrci> show incident -mode detail -p "incident_id="incident_id""
adrci> show trace "trace file name"

create packages and zip files for oracle support:

It gather all the required information with a method called “Incident Packaging Service” (IPS):
adrci> ips create package problem 1 correlate all
adrci> ips generate package 1 in "/home/oracle"

Purging trace files automatically:

adrci> show tracefile -rt
adrci> show control

SHORTP_POLICY :Retention for ordinary trace files
LONGP_POLICY :Retention for like incident files

adrci> set control (SHORTP_POLICY = 360) ===>15days
adrci> set control (LONGP_POLICY = 2160) ===>90 Days
adrci> show control

Purging Trace files manually:

Following command will manually purge all tracefiles older than 2 days (2880 minutes):
adrci> purge -age 2880 -type trace
adrci> purge -age 129600 -type ALERT ===> purging ALERT older than 90 days
adrci> purge -age 43200 -type INCIDENT ===> purging INCIDENT older than 30 days
adrci> purge -age 43200 -type TRACE ===> purging TRACE older than 30 days
adrci> purge -age 43200 -type CDUMP ===> purging CDUMP older than 30 days
adrci> purge -age 43200 -type HM ===> purging HM older than 30 days
adrci> show tracefile -rt

Apps 11i

How to get Apps version?

SQL> select release_name from apps.fnd_product_groups;

RELEASE_NAME
--------------------------------------------------
11.5.10.2


Webserver/Apache Version:

[avis11i@apps VIS_apps]$ $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version
Server version: Oracle HTTP Server Powered by Apache/1.3.19 (Unix)
Server built: Feb 22 2005 18:51:19 (iAS 1.0.2.2.2 rollup 5)

Forms Version:

[avis11i@apps VIS_apps]$ $ORACLE_HOME/bin/f60run | grep Version | grep Forms
Forms 6.0 (Forms Runtime) Version 6.0.8.28.0 (Production)


Report Version:



Jinitiator Version:

[avis11i@apps VIS_apps]$ grep jinit_ver_comma $CONTEXT_FILE
1.6.0_24

Workflow version

SQL> select TEXT Version from apps.WF_RESOURCES where NAME = 'WF_VERSION';

VERSION
--------------------------------------------------------------------------------
2.6.0

Apps Scripts

To get Log and out file location:

select
req.request_id,req.logfile_name LOG, req.outfile_name OUT
FROM v$process pid,
v$session ses,apps.fnd_concurrent_requests req, fnd_concurrent_programs_tl prg ,
fnd_user fu
WHERE req.request_id IN (SELECT request_id
FROM fnd_conc_req_summary_v
WHERE phase_code IN ('R')
AND status_code IN ('R'))
AND req.oracle_process_id = pid.spid(+)
AND pid.addr = ses.paddr(+)
AND req.concurrent_program_id = prg.concurrent_program_id
AND req.requested_by = fu.user_id
and req.request_id=&request_id
ORDER
BY SID ;

How to apply psu patch on GI HOME using auto option?

[root@vm14 psu]# export PATH=/u01/app/11.2.0/grid/OPatch/:$PATH
[root@vm14 psu]# export GRID_HOME=/u01/app/11.2.0/grid
[root@vm14 psu]# opatch version

OPatch Version: 11.2.0.1.9

OPatch succeeded.
[root@vm14 oracle]# opatch auto /home/oracle/psu -oh /u01/app/11.2.0/grid

Executing /usr/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch112.pl -patchdir /home/oracle -patchn psu -oh /u01/app/11.2.0/grid -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params
opatch auto log file location is /u01/app/11.2.0/grid/OPatch/crs/../../cfgtoollogs/opatchauto2012-02-29_09-38-06.log
Detected Oracle Clusterware install
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
OPatch is bundled with OCM, Enter the absolute OCM response file path:
/u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
Successfully unlock /u01/app/11.2.0/grid

patch /home/oracle/psu/13653086 apply successful for home /u01/app/11.2.0/grid
patch /home/oracle/psu/13343424 apply successful for home /u01/app/11.2.0/grid
ACFS-9300: ADVM/ACFS distribution files found.
ACFS-9312: Existing ADVM/ACFS installation detected.
ACFS-9314: Removing previous ADVM/ACFS installation.
ACFS-9315: Previous ADVM/ACFS components successfully removed.
ACFS-9307: Installing requested ADVM/ACFS software.
ACFS-9308: Loading installed ADVM/ACFS drivers.
ACFS-9321: Creating udev for ADVM/ACFS.
ACFS-9323: Creating module dependencies - this may take some time.
ACFS-9327: Verifying ADVM/ACFS devices.
ACFS-9309: ADVM/ACFS installation correctness verified.
CRS-4123: Oracle High Availability Services has been started.

Golden Gate Commands : Part3

Syntax:

GGSCI (test1.domain.com) 77> help STATUS EXTRACT


Use STATUS EXTRACT to determine whether or not Extract is running.

Syntax:
STATUS EXTRACT
[, TASKS]
[, ALLPROCESSES]


The name of an Extract group or a wildcard (*) to specify multiple
groups. For example, T* returns status for all Extract groups
whose names start with T.

TASKS
Displays status only for Extract tasks. By default, tasks are not
displayed unless you specify a single Extract group (without
wildcards).

ALLPROCESSES
Displays status for all Extract groups, including tasks.

Example 1: STATUS EXTRACT finance
Example 2: STATUS EXTRACT fin*




GGSCI (test1.domain.com) 69> STATUS MANAGER

Manager is running (IP port test1.domain.com.7809).


GGSCI (test1.domain.com) 70> STATUS EXTRACT ext3
EXTRACT EXT3: RUNNING


GGSCI (test1.domain.com) 71> STATUS EXTRACT ext3,tasks


GGSCI (test1.domain.com) 72> STATUS EXTRACT ext3,allprocesses
EXTRACT EXT3: RUNNING


GGSCI (test1.domain.com) 73> STATUS EXTRACT ext*,tasks


GGSCI (test1.domain.com) 74> STATUS EXTRACT ext*,allprocesses
EXTRACT EXT1: STOPPED
EXTRACT EXT2: STOPPED
EXTRACT EXT3: RUNNING


****************************************************************************

GGSCI (test1.domain.com) 79> help STATUS REPLICAT


Use STATUS REPLICAT to determine whether or not Replicat is running.

Syntax:
STATUS REPLICAT
[, TASKS]
[, ALLPROCESSES]


The name of a Replicat group or a wildcard (*) to specify multiple
groups. For example, T* returns status for all Replicat groups
whose names start with T.

TASKS
Displays status only for Replicat tasks. By default, tasks are not
displayed unless you specify a single Replicat group (without
wildcards).

ALLPROCESSES
Displays status for all Replicat groups, including tasks.

Example 1: STATUS REPLICAT finance
Example 2: STATUS REPLICAT fin*

Goldden Gate Commands :Part 2

Syntax:
*********************************************************************************
SEND MANAGER [CHILDSTATUS [DEBUG]] [GETPORTINFO [DETAIL]] [GETPURGEOLDEXTRACTS]
*********************************************************************************

GGSCI (test1.domain.com) 61> send manager childstatus

Sending CHILDSTATUS request to MANAGER ...

Child Process Status - 1 Entries

ID Group Process Retry Retry Time Start Time
---- -------- ---------- ----- ------------------ -----------
0 EXT3 7819 0 None 2012/03/03 18:26:55



GGSCI (test1.domain.com) 62> send manager childstatus debug

Sending CHILDSTATUS, request to MANAGER ...

Child Process Status - 1 Entries

ID Group Process Retry Retry Time Start Time Port
---- -------- ---------- ----- ------------------ ----------- ----
0 EXT3 7819 0 None 2012/03/03 18:26:55 7840



GGSCI (test1.domain.com) 63> send manager getportinfo

Sending GETPORTINFO request to MANAGER ...

No Dynamic Ports In Use or Configured


GGSCI (test1.domain.com) 64> send manager getportinfo detail

Sending GETPORTINFO, request to MANAGER ...

No Dynamic Ports In Use or Configured


GGSCI (test1.domain.com) 65> send manager getpurgeoldextracts

Sending GETPURGEOLDEXTRACTS request to MANAGER ...

PurgeOldExtracts Rules
Fileset MinHours MaxHours MinFiles MaxFiles UseCP
/home/oracle/gg/dirdat/t* 48 0 0 0 Y
OK
No extract trails



GGSCI (test1.domain.com) 66>

Golden Gate Commands : Part1

GGSCI (test1.domain.com) 32> info mgr
Manager is running (IP port test1.domain.com.7809).
GGSCI (test1.domain.com) 34> INFO marker
GGSCI (test1.domain.com) 35> info extract ext3
GGSCI (test1.domain.com) 36> info extract ext3,detail
GGSCI (test1.domain.com) 37> VIEW GGSEVT
*************************************************************************************
VIEW REPORT {group_name[n] | file_name}
GGSCI (test1.domain.com) 44> view report ext3/view report rep3
GGSCI (test1.domain.com) 45> lag extract ext3 --Sending GETLAG request to EXTRACT EXT3
GGSCI (test1.domain.com) 48> dumpddl show
GGSCI (test1.domain.com) 48> history
GGSCI (test1.domain.com) 50> history 5
GGSCI (test1.domain.com) 51> VERSIONS
Operating System:
Linux
Version #1 Wed Jan 5 19:22:18 EST 2005, Release 2.6.9-5.EL
Node: test1.domain.com
Machine: i686

Database:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

**********************************************************************

GGSCI (test1.domain.com) 52> fc
GGSCI (test1.domain.com) 52> VERSIONS
GGSCI (test1.domain.com) 52..
GGSCI (test1.domain.com) 53> fc 9
GGSCI (test1.domain.com) 53> info all
GGSCI (test1.domain.com) 53..
GGSCI (test1.domain.com) 57> shell ls -lrt /home/oracle/gg
GGSCI (test1.domain.com) 58> obey /home/oracle/golden.txt --run command from external file
GGSCI (test1.domain.com) 59> info all
GGSCI (test1.domain.com) 60> view report ext3
[oracle@test1 ~]$ cat golden.txt
info all
view report ext3

Install ASM lib on Linux 5

[root@vm14 ~]# rpm -Uvh oracleasm-support-2.1.7-1.el5.i386.rpm
warning: oracleasm-support-2.1.7-1.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
1:oracleasm-support ########################################### [100%]
[root@vm14 ~]# rpm -Uvh oracleasm-2.6.18-8.el5xen-2.0.4-1.el5.i686
error: open of oracleasm-2.6.18-8.el5xen-2.0.4-1.el5.i686 failed: No such file or directory
[root@vm14 ~]# rpm -Uvh oracleasm-2.6.18-8.el5xen-2.0.4-1.el5.i686*
Preparing... ########################################### [100%]
1:oracleasm-2.6.18-8.el5x########################################### [100%]
[root@vm14 ~]# rpm -Uvh oracleasmlib-2.0.4-1.el5.i386.rpm
warning: oracleasmlib-2.0.4-1.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
1:oracleasmlib ########################################### [100%]
[root@vm14 ~]#

Scripts

Check Fragmented Space:

select owner,table_name,blocks,num_rows,avg_row_len,round(((blocks*8/1024)),2)||'MB' "TOTAL_SIZE", round((num_rows*avg_row_len/1024/1024),2)||'Mb' "ACTUAL_SIZE", round(((blocks*8/1024)-(num_rows*avg_row_len/1024/1024)),2) ||'MB' "FRAGMENTED_SPACE" from dba_tables where owner='SCOTT';

How to find last updates on table (oracle 10g)

SQL> SELECT SCN_TO_TIMESTAMP(MAX(ora_rowscn)) from scott.emp;
SCN_TO_TIMESTAMP(MAX(ORA_ROWSCN))
---------------------------------------------------------------------------
10-FEB-12 02.58.54.000000000 AM

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