HOW OMS IS TO BE CREATED
| Question ID: 3622 | |
| Created By: | 2009-MAY-14 13:06:12 [Pramod2203] |
| Updated By: | 2009-MAY-18 19:14:28 [Vitaliy] |
| Status: | Open |
| Severity: | Normal |
| Read Only: | No |
|
10157
2009-MAY-14 13:06:12
|
||||
|
FOR USING BACKUP RELATED ACTIVITIES THROUGH OEM, IT REQUIRES OMS, SO PLS. GUIDE TO CREATE OMS.
|
10162
2009-MAY-18 18:55:45
|
||||
|
Dude, this is like asking how to make 1 million $$! There are different number
of ways to do that and everyone does it differently. I installed OMS
(Enterprise Manager 10g Grid Control Release 4 (10.2.0.4)) on a two tier Linux
platform. Middle-tier went up on a 32-bit Enterprise Linux Enterprise Linux AS
release 4 (October Update 5) [ 2.6.9-55.0.0.0.2.ELsmp ] and back-end database
node went up on the same Linux release but 64-bit.
The process was lengthy and fairly painful -- I used Installing 'Software-Only'
and Configuring Later procedure from:
http://download.oracle.com/docs/cd/B16240_01/doc/install.102/e10953/installing_em.htm#CCHGBDCB
Note that I used the 10.2.0.4 documentation this is
the latest 10.2.0.5 so some things might have changed ...
Here's my own write-up of the process:
##
## Intall GRID Control
##
http://www.oracle.com/technology/software/products/oem/htdocs/gridR4_10204_readme.html
## install GRID Ctl 102040
##
## BASED ON:
## Installing 'Software-Only' and Configuring Later
## http://download.oracle.com/docs/cd/B16240_01/doc/em.102/e10953/installing_em.htm#CCHGBDCB
## install DBMS_SHARED_POOL (done on DB server)
##
sqlplus /nolog
connect / as sysdba
@$ORACLE_HOME/rdbms/admin/dbmspool.sql
exit
## next switch to init.ora and setup the following:
##
-- remove dispatchers line
*.session_cached_cursors=200
*.aq_tm_processes=1
*.undo_retention=10800
*._b_tree_bitmap_plans=false
## bounce the database
##
dbshut
dbstart
## install 102010 Grid control using existing database option
##
su - oracle
export DISPLAY=111.222.33.44:0.0
cd /binback/download/oracle/linux/grid-ctl/102010
unzip Linux_Grid_Control_full_102010_disk1.zip
unzip Linux_Grid_Control_full_102010_disk2.zip
unzip Linux_Grid_Control_full_102010_disk3.zip
./runInstaller -noconfig
Enterprise Manager 10g Grid Control Using Existing Database
Next
Parent Directory: /u01/app/oracle/product
Next
While on "Checking operating system package requirements ..."
IGNORE THE FOLLOWING (refer to Note:343364.1):
Checking for compat-libstdc++-296-2.96-132.7.2; found Not found. Failed <<<<
Checking for libstdc++devel-3.4.3-22.1; found Not found. Failed <<<<
Checking for openmotif-21-2.1.30-11; found openmotif-2.2.3-10.1.el4. Failed <<<<
Here's what we have and what it should've been looking for:
[root@oraem oracle]# rpm -q compat-libstdc++-33
compat-libstdc++-33-3.2.3-47.3
[root@oraem oracle]# rpm -q libstdc++-devel
libstdc++-devel-3.4.6-9.0.1
[root@oraem oracle]# rpm -q openmotif21
openmotif21-2.1.30-11.RHEL4.6
Next (Confirm you want to continue)
Database Hostname: oraemdb.yourdomain.com
Port: 1521
Service: PGRID.yourdomain.com
SYS Password: <PROD_system_pass>
Management tablespace location: /u02/oradata/PGRID/mgmt.dbf
Configuration Data Tablespace location: /u02/oradata/PGRID/mgmt_ecm_depot1.dbf
Next
Specify Optional Parameters
skip
Next
Specify Passwords
Registration Password: xxxxxxxxxx
[x] Require Secure Communication
SYSMAN Password: <PROD_system_password>
Next
Click Install
Run *root.sh scripts:
/u01/app/oracle/oraInventory/orainstRoot.sh
/u01/app/oracle/product/oms10g/allroot.sh
## ignore the warning about configuration assistants being skipped
## it's OK because we are just insatlling the software now
##
Ok
Next
Ok (To warning)
End of install screen shoot:
This information is also available at:
/u01/app/oracle/product/agent10g/sysman/setupinfo.txt
See below for information pertaining to your Enterprise Manager installation:
1. Use the following URL to access the Enterprise Manager Grid Control:
http://oraemgc.yourdomain.com:4889/em
2. The Enterprise Manager installation includes an Oracle Application Server instance, which is administered using a special "ias_admin" user account. The following information was defaulted for the embedded Application Server instance:
Instance Name: EnterpriseManager0.oraemgc.yourdomain.com
ias_admin password: This password is the same the SYSMAN account.
3. The connection details for the Enterprise Manager Repository are:
Host: oraemdb.yourdomain.com
Port: 1521
SID: NO_VALUE
4. The Enterprise Manager Release Notes are located at:
/u01/app/oracle/product/agent10g/relnotes/README_EM.txt
Exit
Yes
## After installing the base release, navigate to the OMS Home directory
## and run the following command before applying the 10.2.0.4 patch set. This
## is to stop all the running processes
export ORACLE_HOME=/u01/app/oracle/product/oms10g
/u01/app/oracle/product/oms10g/opmn/bin/opmnctl stopall
## configure patchset.rsp
##
cd /binback/download/oracle/linux/grid-ctl/10204
unzip GridControl_10.2.0.4_LINUX.zip
unzip p3731593_10204_LINUX.zip
cd ./3731593/Disk1
cp -p ./response/patchset.rsp ./response/patchset.rsp.bak
vi ./response/patchset.rsp
--------------- change as follows --------------
b_softwareonly=true
s_sysPassword="sys user password"
## apply the 10.2.0.4 patch set, run the patchset.rsp file:
##
export DISPLAY=111.222.33.44:0.0
./runInstaller -noconfig -responseFile /binback/download/oracle/linux/grid-ctl/10204/3731593/Disk1/response/patchset.rsp
Specify Home Details
Name: oms10g
Path: /u01/app/oracle/product/oms10g
Next
Prereq Checks
All OK
Next
Configuration Management
skip
Next
Summary
Install
Ignore Error about configuration assistants being skipped
Ok
Next
Ok
Exit
## run the ConfigureGC.pl script to
## configure Enterprise Manager Grid Control:
##
ORACLE_HOME=/u01/app/oracle/product/oms10g; export ORACLE_HOME
PERL5LIB=$ORACLE_HOME/perl/lib/5.6.1; export PERL5LIB
PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:$ORACLE_HOME/bin; export PATH
## ---------------------------------------------------------------
## NOTE: first time around I had an issue running ConfigureGC.pl
## becuase the database was also installed on the same host
## for a solution/workaround I used to solve it see:
##
## ORAEM-ConfigureGC.pl-FIRST-INSTALL-ERROR.txt
## ---------------------------------------------------------------
$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/sysman/install/ConfigureGC.pl /u01/app/oracle/product
## note the above script runs for a while ... (25 minutes)
##
## you can watch repository being created in the following logfile:
## /u01/app/oracle/product/oms10g/sysman/log/emca_repos_create18_00_13.log
##
## this logfile is generated by the following command (I got this command from ps -ef and formatted it with "\"):
## /u01/app/oracle/product/oms10g/sysman/admin/emdrep/bin/RepManager \
## -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oraem.yourdomain.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PGRID.yourdomain.com))) \
## -action create -repos_user SYSMAN \
## -metalink_username _NOT_AVAILABLE_ \
## -output_file /u01/app/oracle/product/oms10g/sysman/log/emca_repos_create18_00_13.log \
## -ecm_datafile /u02/oradata/PGRID/mgmt_ecm_depot1.dbf \
## -datafile /u02/oradata/PGRID/mgmt.dbf
##
## For more info on RepManager refer to:
## Note:278100.1 How To Drop, Create And Recreate DB Control In A 10g Database
##
Here's complete output of the above script (ConfigureGC.pl):
bash-3.00$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/sysman/install/ConfigureGC.pl /u01/app/oracle/product
Base Directory: /u01/app/oracle/productnoseed oms configuration:
Oraclehome is /u01/app/oracle/product/oms10g
Running Oms configuration using /u01/app/oracle/product/oms10g/oui/bin/runConfig.sh ORACLE_HOME=/u01/app/oracle/product/oms10g ACTION=configure MODE=perform COMPONENT_XML={oracle.sysman.top.oms.10_2_0_1_0.xml}
perform - mode is starting for action: configure
perform - mode finished for action: configure
You can see the log file: /u01/app/oracle/product/oms10g/cfgtoollogs/oui/configActions2008-05-13_06-33-11-PM.log
10201 OMS configuration done
Running Agent Configuration using /u01/app/oracle/product/agent10g/oui/bin/runConfig.sh ORACLE_HOME=/u01/app/oracle/product/agent10g ACTION=configure MODE=perform COMPONENT_XML={oracle.sysman.top.agent.10_2_0_1_0.xml} RESPONSE_FILE=/u01/app/oracle/product/agent10g/responsefile
perform - mode is starting for action: configure
perform - mode finished for action: configure
You can see the log file: /u01/app/oracle/product/agent10g/cfgtoollogs/oui/configActions2008-05-13_06-46-21-PM.log
10201 Agent configuration done
executing emctl command /u01/app/oracle/product/oms10g/bin/emctl status oms
Oracle Enterprise Manager 10g Release 4 Grid Control
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Oracle Management Server is Up.
Stopping the oms inorder to run 10204 oms patch configuration /u01/app/oracle/product/oms10g/opmn/bin/opmnctl stopall
opmnctl: stopping opmn and all managed processes...
Running OMS patch configuration using /u01/app/oracle/product/oms10g/oui/bin/runConfig.sh ORACLE_HOME=/u01/app/oracle/product/oms10g ACTION=patchsetConfigure MODE=perform COMPONENT_XML={oracle.sysman.top.oms.10_2_0_4_0.xml} RESPONSE_FILE=/u01/app/oracle/product/oms10g/config.rsp
perform - mode is starting for action: patchsetConfigure
The value of ReposSIDNO_VALUE
perform - mode finished for action: patchsetConfigure
You can see the log file: /u01/app/oracle/product/oms10g/cfgtoollogs/oui/configActions2008-05-13_06-51-32-PM.log
10.2.0.4 OMS patch configuration done
bash-3.00$
##
###
#### This concludes 10.2.0.4 Upgrade
##
## Phase IV - Configure Grid Control
##
http://oraemgc.yourdomain.com:4889/em
sysman/<prod_system_pass>
From the console, click Targets and then click All Targets:
select (*) Management Services and Repository
click Configure
Repository machine name: oraemdb.yourdomain.com
Repository port:
Repository SID:
Repository Connect Descriptor: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oraemdb.yourdomain.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PGRID.yourdomain.com)))
Repository username: SYSMAN
Repository password: <PROD_system_password>
Click "Ok"
## Upgrade Management Agent
##
export DISPLAY=111.222.33.44:0.0
ORACLE_HOME=/u01/app/oracle/product/agent10g; export ORACLE_HOME
PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:$ORACLE_HOME/bin; export PATH
## stop agent
/u01/app/oracle/product/agent10g/bin/emctl stop agent
## upgrade agent
cd /binback/download/oracle/linux/grid-ctl/10204
unzip 3822442.zip
cd ./3822442/Disk1
./runInstaller
Specify Home Details
Name: agent10g
Path: /u01/app/oracle/product/agent10g
Next
Pre-req checks -- all Ok
Next
Oracle Configuration Management - skip!
Next
Install
End - Exit
To stop agent:
/u01/app/oracle/product/agent10g/bin/emctl stop agent
To start agent:
/u01/app/oracle/product/agent10g/bin/emctl start agent
## now when you go to "Targets" you should see this host:
http://oraemgc.yourdomain.com:4889/em/console/targets
## resolve "Management Services and Repository" being shows as "Down"
## "Enterprise Manager Repository database is down. Error: 12545"
## REFERENCE:
## Note:456094.1 Problem: Enterprise Manager Repository Database Is Down. Error: 12154
##
Click "Setup":
http://oraemgc.yourdomain.com:4889/em/console/admin/rep/overview
Management Services and Repository > Related Links > Monitoring Configuration:
Repository machine name: oraem.yourdomain.com
Repository port:
Repository SID:
Repository Connect Descriptor: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oraem.yourdomain.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PGRID.yourdomain.com)))
Repository username: SYSMAN
Repository password: <PROD_system_password>
Click "Ok"
Once the change is made the following file is modified
(NOTE it's in agent10g OH not oms10g):
/u01/app/oracle/product/agent10g/sysman/emd/targets.xml
WARNING:
You must either use port:SID combo or remove it and provide
complete Connect Descriptor in the form of :
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host.domain.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=SIDNAME.domain.com)))
## startup/shutdown EM
/u01/app/oracle/product/oms10g/opmn/bin/opmnctl stopall
/u01/app/oracle/product/oms10g/opmn/bin/opmnctl startall
## stop/start agent
/u01/app/oracle/product/agent10g/bin/emctl stop agent
/u01/app/oracle/product/agent10g/bin/emctl start agent
## install mass agent deploy
##
## unzip agent_download files:
##
cd /u01/app/oracle/product/oms10g/sysman/agent_download/10.2.0.4.0/
mkdir old
mv * ./old/
## Linux Agent
unzip /binback/download/oracle/linux/grid-ctl/agent/Linux_x86_64_Grid_Control_agent_download_10_2_0_4_0.zip
mv agent_download.rsp.bak agent_download.rsp
## Solaris Agent
mv agentdeployroot.sh agentdeployroot.sh.LINUX
mv agent_download.rsp.bak agent_download.rsp.bak.LINUX
mv instructions.txt instructions.txt.LINUX
unzip /binback/download/oracle/linux/grid-ctl/agent/Solaris_Grid_Control_agent_download_10_2_0_4_0.zip
## FYI -- there's no difference between these files
## from LINUX and SOLARIS distros:
##
$ diff agent_download.rsp agent_download.rsp.bak.LINUX
$ diff agentdeployroot.sh agentdeployroot.sh.LINUX
$ ls -l
total 84
-rw-r--r-- 1 oracle oinstall 1874 Jun 22 2007 agentdeployroot.sh
-rw-r--r-- 1 oracle oinstall 1874 Jun 22 2007 agentdeployroot.sh.LINUX
-rw-r--r-- 1 oracle oinstall 20066 Sep 7 2007 agent_download.rsp
-rw-r--r-- 1 oracle oinstall 20066 Sep 7 2007 agent_download.rsp.bak
-rw-r--r-- 1 oracle oinstall 20066 Sep 7 2007 agent_download.rsp.bak.LINUX
-rw-r--r-- 1 oracle oinstall 3638 Nov 14 2007 instructions.txt
drwxrwxr-x 8 oracle oinstall 4096 Apr 10 21:24 linux_x64
drwxr-xr-x 3 oracle oinstall 4096 May 13 19:58 old
drwxrwxr-x 8 oracle oinstall 4096 Mar 3 20:22 solaris
## deploy agent to ORAEMDB (see agent_deploy.txt)
##
Deploy Logs are here:
http://oraemgc.yourdomain.com:4889/ap_logs/2008-05-13_20-02-04-PM/logs/oraemdb.yourdomain.com/
and here:
oraemdb.yourdomain.com.PGRID-> pwd
/u01/app/oracle/product
oraemdb.yourdomain.com.PGRID-> ls -l
total 12
drwxrwx--- 3 oracle oinstall 4096 May 9 15:44 10.2.0
drwxr-xr-x 39 oracle oinstall 4096 May 13 20:05 agent10g
-rw-r--r-- 1 oracle oinstall 3115 May 13 20:04 agentDownload.linux_x64051308200312.log
here's the summary:
Oracle Enterprise Manager 10g Release 4 Grid Control 10.2.0.4.0.
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 10.2.0.4.0
OMS Version : 10.2.0.4.0
Protocol Version : 10.2.0.4.0
Agent Home : /u01/app/oracle/product/agent10g
Agent binaries : /u01/app/oracle/product/agent10g
Agent Process ID : 20171
Parent Process ID : 20145
Agent URL : https://oraemdb.yourdomain.com:3872/emd/main/
Repository URL : https://oraemgc.yourdomain.com:1159/em/upload
Started at : 2008-05-13 20:04:54
Started by user : oracle
Last Reload : 2008-05-13 20:04:54
Last successful upload : 2008-05-13 20:05:00
Total Megabytes of XML files uploaded so far : 4.01
Number of XML files pending upload : 3
Size of XML files pending upload(MB) : 1.85
Available disk space on upload filesystem : 80.28%
Last successful heartbeat to OMS : 2008-05-13 20:04:56
---------------------------------------------------------------
Agent is Running and Ready
## Unlock DBSNMP account
##
sqlplus /nolog
connect / as sysdba
alter user dbsnmp account unlock;
alter user dbsnmp identified by xxxxxxx;
exit
## run agent's root.sh on oraemdb
##
su - oracle
/u01/app/oracle/product/agent10g/bin/emctl stop agent
exit
/u01/app/oracle/product/agent10g/root.sh
su - oracle
/u01/app/oracle/product/agent10g/bin/emctl start agent
## setup dbsnmp password in EMGC
##
go to All Targets -> PGRID.yourdomain.com
Monitor Password: xxxxxxx
##
## Fix the help system corruption
## http://dbatoolz.orapros.com/tp/3125.how-to_recreate_corrupted_ohwconfig-xml.html
##
cd /u01/app/oracle/product/oms10g/j2ee/OC4J_EM/applications/em/em/online_help/
vi build-ohwconfig.sh
------------- insert the following --------
#!/bin/ksh
for x in `find . -name *_help.jar`
do
bsn=`basename $x`
drn=`dirname $x`
id=`basename $drn`
jar="${id}/${bsn}"
location=`echo $bsn | sed 's/_help\.jar/\.hs/'`
echo " <helpSet id=\"${id}\" jar=\"${jar}\" location=\"${location}\"/>"
done
- - - - - - - - - - - - END - - - - - - - - - - -
## Make build-ohwconfig.sh executable and run-it:
##
chmod +x build-ohwconfig.sh
./build-ohwconfig.sh > ohwconfig.tmp
## Now modify ohwconfig.tmp by insterting the remaning XML "header" and "footer":
##
vi ohwconfig.tmp
------------ insert the following before and after the "helpSet id" block of code -----
<?xml version="1.0" encoding="UTF-8"?>
<helpConfiguration version="2.0" xmlns="http://xmlns.oracle.com/help/web/config">
<!-- Specify the branding information. You can specify
brandingText or brandingImage, if both are specified
brandingText will be used -->
<brandings>
<branding locales="en_US" text="Oracle Enterprise Manager Online Help" />
</brandings>
<!-- OHW automatically uses the system default Locale and
the default encoding for that Locale for Locale
sensitive operations. You can override this behavior
by filling out the localeSettings. Note that the encoding
for the content HTML files is specified in those files
directly.
Within each local definition specify the set of books for that locale.
The books element can contain any number of helpBook objects, helpSet
objects or a mixture of both.
-->
<locales>
<locale language="en" country="US">
<books>
helpSet id= ... goes here ...
helpSet id= ... goes here ...
helpSet id= ... goes here ...
</books>
</locale>
</locales>
<!-- Navigator aliases - to allow for legacy navigator names. -->
<navigatorAliases>
<alias name="oracle.help.navigator.tocNavigator.TOCNavigator"
value="oracle.help.web.navigator.tocNavigator.TOCTreeNavigator" />
</navigatorAliases>
<!-- The maxSearchThreads parameter determines the maximum
number of threads that will be spawned for searching.
This will be the maximum number of simultaneous
searches that OHW can perform. This value should be
carefully tuned to correspond to the estimated load
on the servlet.
Specify the merging behavior by providing values for the
combineBooks and useLabelInfo attributes.
-->
<parameters>
<combineBooks>true</combineBooks>
<useLabelInfo>false</useLabelInfo>
<maxSearchThreads>10</maxSearchThreads>
<defaultHomeID>myTopicID</defaultHomeID>
</parameters>
</helpConfiguration>
- - - - - - - - - - - - - - - - END - - - - - - - - - - - - - - - - - - -
## rename files
##
mv ohwconfig.xml ohwconfig.xml.old
mv ohwconfig.tmp ohwconfig.xml
## bounce EM
/u01/app/oracle/product/oms10g/opmn/bin/opmnctl stopall
/u01/app/oracle/product/oms10g/opmn/bin/opmnctl startall
##
## Setup SMTP
##
Setup -> Notification Methods
Outgoing Mail (SMTP) Server: mailhub1.yourdomain.com
Identify Sender As: EMGC
Sender's E-mail Address: oracle.dba@yourdomain.com
... continued below ...
[edited by: Vitaliy at 19:14 (CST) on May. 18, 2009]
|
10163
2009-MAY-18 18:57:34
|
||||
|
##
## Create Software Library
##
# OPatch Update - Error: Software Library directory has not been set.
The Software Library has not been configured. Deployment Procedures will
not work if the Software Library is not configured properly. To
configure the Software Library, click on the 'Provisioning' sub-tab and
set the path for the Software Library from the 'Administration' page.
After setting the path, run the following command from any one of the
OMShosts: "${OMS_ORACLE_HOME}/bin/PARDeploy -action deploy -parDir
${OMS_ORACLE_HOME}/sysman/prov/paf -force" on Unix, or
"${OMS_ORACLE_HOME}\bin\PARDeploy.bat -action deploy -parDir
${OMS_ORACLE_HOME}\sysman\prov\paf -force" on Windows.
[root@oraemgc oracle]# cd /binback/download/oracle
[root@oraemgc oracle]# mkdir emgc-soft-library
[root@oraemgc oracle]# chown oracle:oinstall emgc-soft-library
Deployment -> Provisioning -> Administration -> Software Library Configuration -> Add
/binback/download/oracle/emgc-soft-library
##
## Install OPatch 10.2.0.4.2
##
cd /binback/download/oracle/linux/Opatch
mv /u01/app/oracle/product/oms10g/OPatch \
/u01/app/oracle/product/oms10g/OPatch.bak
unzip -od /u01/app/oracle/product/oms10g p4898608_10204_Generic.zip
$ /u01/app/oracle/product/oms10g/OPatch/opatch version
Invoking OPatch 10.2.0.4.2
OPatch Version: 10.2.0.4.2
OPatch succeeded.
$
##
## Install Critical Patch Update April 2008 (Patch# 6867338) to oms APP server
##
/u01/app/oracle/product/oms10g/opmn/bin/opmnctl stopall
cd /u01/app/oracle/product/agent10g/EMStage/6867338/6867338
export ORACLE_HOME=/u01/app/oracle/product/oms10g
export PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:.
/u01/app/oracle/product/oms10g/OPatch/opatch apply
sh remove_demo.sh
/u01/app/oracle/product/oms10g/opmn/bin/opmnctl startall
## Login to GC and Refresh Configuration
##
Targets -> Host: oraemgc.yourdomain.com -> Configuration -> Click "Refresh"
... continued below ...
|
10164
2009-MAY-18 18:58:35
|
||||
|
##
## Install Provisioning Patches
##
##
## Note:427577.1 OMS Patches required for setting up Provisioning and Patching in 10.2.0.3 GC / 10.2.0.4 GC
##
## OMS Patches Required for Setting up Provisioning in Grid Control 10.2.0.4
## (only)
##
## 1. Patch 7240713 : Required for patching Databases through deployment
## procedures.
##
## 2. Patch 6646817 and Patch 6799925 : Required for advanced users who
## want to restrict access to the Deployment Procedures and Software
## library depending on the user profile.
##
## Applying July CPU 2008 from Grid Control 10.2.0.4 on to Database targets
## through Deployment Procedures:
##
## Apply Patch 7195612 to the OMS Home. Note 727020.1
##
login to oraemgc.yourdomain.com as oracle
## shutdown oms
##
/u01/app/oracle/product/oms10g/opmn/bin/opmnctl stopall
## setup tnsnames.ora in OMS
##
cd /u01/app/oracle/product/oms10g/network/admin
cat tnsnames.ora
-----------------------------
PGRID =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraemdb.yourdomain.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PGRID.yourdomain.com)
)
)
export ORACLE_HOME=/u01/app/oracle/product/oms10g
export TNS_ADMIN=/u01/app/oracle/product/oms10g/network/admin
sqlplus sysman/<prod_sys_pass>@PGRID
set lines 132
set trims on
col what format a75 trunc
SELECT what, broken
FROM dba_jobs
WHERE log_user = priv_user and
priv_user = (SELECT owner
FROM dba_procedures
WHERE object_name = 'MGMT_USER'
AND procedure_name = 'DROP_USER')
ORDER BY job;
SELECT object_name
FROM user_objects
WHERE status = 'INVALID'
order by object_name ;
## EXAMPLE:
## -----------
##
## SQL> r
## 1 SELECT what, broken
## 2 FROM dba_jobs
## 3 WHERE log_user = priv_user and
## 4 priv_user = (SELECT owner
## 5 FROM dba_procedures
## 6 WHERE object_name = 'MGMT_USER'
## 7 AND procedure_name = 'DROP_USER')
## 8* ORDER BY job
##
## WHAT B
## --------------------------------------------------------------------------- -
## MGMT_CNTR_TT.clean_up_old_ticket_recs; N
## EM_TASK.WORKER(1); N
## EM_TASK.WORKER(2); N
## EMD_LOADER.ROLLUP(); N
## EMD_NOTIFICATION.CHECK_FOR_SEVERITIES(); N
## EM_PING.MARK_NODE_STATUS(); N
## EM_SEVERITY_REPOS.EXECUTE_REPOS_SEVERITY_EVAL(); N
## MGMT_JOB_ENGINE.apply_purge_policies(); N
## emd_maintenance.analyze_emd_schema('SYSMAN'); N
## EMD_RT_ROLLUP.ROLLUP(); N
## EMD_E2E_ROLLUP.ROLLUP(); N
##
## WHAT B
## --------------------------------------------------------------------------- -
## MGMT_GENSVC_AVAIL.EXEC_AVAIL_JOB(); N
## EM_PURGE.APPLY_PURGE_POLICIES(); N
## MGMT_RCA.PURGE_RCA_RESULTS(); N
## BEGIN MGMT_BSLN_INTERNAL.PURGE_EXTRACT_RAWDATA;MGMT_BSLN.COMPUTE_ALL_STATIS N
## BEGIN MGMT_BSLN.SET_ALL_THRESHOLDS;/*GC*/END; N
## EM_POLICY.CLEAR_EXPIRED_SUPPRESSIONS; N
## EM_TASK.RESUBMIT_FAILED_TASK(); N
##
## 18 rows selected.
##
## SQL>
##
##
## SQL> SELECT object_name FROM user_objects WHERE status = 'INVALID' order by object_name ;
##
## no rows selected
-- Note down the value of job_queue_processes in init.ora parameter
SQL> show parameter job_queue_processes;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes integer 30
SQL>
-- turn off job_queue_processes
ALTER SYSTEM SET job_queue_processes = 0;
-- Make sure the following query returns 0 rows
-- if now wait few minutes ...
--
SELECT /*+ RULE */ * FROM DBA_JOBS_RUNNING ;
## apply 7240713
##
cd /binback/download/oracle/linux/grid-ctl/post_10204
unzip p7240713_10204_GENERIC.zip
cd 7240713
export ORACLE_HOME=/u01/app/oracle/product/oms10g
export TNS_ADMIN=/u01/app/oracle/product/oms10g/network/admin
export PATH=$ORACLE_HOME/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:.
/u01/app/oracle/product/oms10g/OPatch/opatch apply
## EXAMPLE
## ----------
##
## $ /u01/app/oracle/product/oms10g/OPatch/opatch apply
## Invoking OPatch 10.2.0.4.2
##
## Oracle Interim Patch Installer version 10.2.0.4.2
## Copyright (c) 2007, Oracle Corporation. All rights reserved.
##
##
## Oracle Home : /u01/app/oracle/product/oms10g
## Central Inventory : /u01/app/oracle/oraInventory
## from : /etc/oraInst.loc
## OPatch version : 10.2.0.4.2
## OUI version : 10.2.0.4.0
## OUI location : /u01/app/oracle/product/oms10g/oui
## Log file location : /u01/app/oracle/product/oms10g/cfgtoollogs/opatch/opatch2008-07-22_16-12-25PM.log
##
## ApplySession applying interim patch '7240713' to OH '/u01/app/oracle/product/oms10g'
##
## Running prerequisite checks...
##
## OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
##
## Backing up files and inventory (not for auto-rollback) for the Oracle Home
## Backing up files affected by the patch '7240713' for restore. This might take a while...
## Backing up files affected by the patch '7240713' for rollback. This might take a while...
##
## Patching component oracle.sysman.common, 10.2.0.4.0...
## Updating jar file "/u01/app/oracle/product/oms10g/sysman/jlib/j2ee/paALL.jar" with "/sysman/jlib/j2ee/paALL.jar/oracle/sysman/pp/pa/CRSPreProcessor.class"
## Updating jar file "/u01/app/oracle/product/oms10g/sysman/jlib/j2ee/paALL.jar" with "/sysman/jlib/j2ee/paALL.jar/oracle/sysman/pp/pa/RACPreProcessor.class"
## Updating jar file "/u01/app/oracle/product/oms10g/sysman/jlib/j2ee/paALL.jar" with "/sysman/jlib/j2ee/paALL.jar/oracle/sysman/pp/pa/ui/targetSel/RacMultipleSelUtil.class"
## Updating jar file "/u01/app/oracle/product/oms10g/sysman/jlib/j2ee/paALL.jar" with "/sysman/jlib/j2ee/paALL.jar/oracle/sysman/pp/pa/ui/ctlrs/ReviewCtlr.class"
## Updating jar file "/u01/app/oracle/product/oms10g/sysman/jlib/j2ee/paALL.jar" with "/sysman/jlib/j2ee/paALL.jar/oracle/sysman/pp/pa/ui/ctlrs/SelectTargetListCtlr.class"
## Updating jar file "/u01/app/oracle/product/oms10g/sysman/jlib/j2ee/paALL.jar" with "/sysman/jlib/j2ee/paALL.jar/oracle/sysman/pp/pa/ui/targetSel/TargetSelRB.class"
## Updating jar file "/u01/app/oracle/product/oms10g/sysman/jlib/j2ee/paALL.jar" with "/sysman/jlib/j2ee/paALL.jar/oracle/sysman/pp/pa/ui/targetSel/TargetSelRBID.class"
## Updating jar file "/u01/app/oracle/product/oms10g/sysman/jlib/j2ee/paALL.jar" with "/sysman/jlib/j2ee/paALL.jar/oracle/sysman/pp/pa/ui/targetSel/TargetSelSQL.class"
## Updating jar file "/u01/app/oracle/product/oms10g/sysman/jlib/j2ee/pafALL.jar" with "/sysman/jlib/j2ee/pafALL.jar/oracle/sysman/pp/paf/impl/BindingStepImpl$Binding.class"
## Updating jar file "/u01/app/oracle/product/oms10g/sysman/jlib/j2ee/pafALL.jar" with "/sysman/jlib/j2ee/pafALL.jar/oracle/sysman/pp/paf/impl/BindingStepImpl.class"
## Updating jar file "/u01/app/oracle/product/oms10g/sysman/jlib/j2ee/pafALL.jar" with "/sysman/jlib/j2ee/pafALL.jar/oracle/sysman/pp/paf/impl/DirectiveStepImpl.class"
## Updating jar file "/u01/app/oracle/product/oms10g/sysman/jlib/j2ee/pafALL.jar" with "/sysman/jlib/j2ee/pafALL.jar/oracle/sysman/pp/paf/impl/JobProducerImpl.class"
## Updating jar file "/u01/app/oracle/product/oms10g/sysman/jlib/j2ee/pafALL.jar" with "/sysman/jlib/j2ee/pafALL.jar/oracle/sysman/pp/paf/jobs/JobsConstants.class"
## Updating jar file "/u01/app/oracle/product/oms10g/sysman/jlib/j2ee/pafALL.jar" with "/sysman/jlib/j2ee/pafALL.jar/oracle/sysman/pp/paf/jobs/PAFStageComponentCommand$1.class"
## Updating jar file "/u01/app/oracle/product/oms10g/sysman/jlib/j2ee/pafALL.jar" with "/sysman/jlib/j2ee/pafALL.jar/oracle/sysman/pp/paf/jobs/PAFStageComponentCommand$PAFProvisioningJobContext.class"
## Updating jar file "/u01/app/oracle/product/oms10g/sysman/jlib/j2ee/pafALL.jar" with "/sysman/jlib/j2ee/pafALL.jar/oracle/sysman/pp/paf/jobs/PAFStageComponentCommand.class"
## Copying file to "/u01/app/oracle/product/oms10g/sysman/admin/emdrep/sql/pp/latest/deploymentProcs_sql/PatchCRSRolling.sql"
## Copying file to "/u01/app/oracle/product/oms10g/sysman/admin/emdrep/sql/pp/latest/deploymentProcs_sql/PatchRACDBAllNodes.sql"
## Copying file to "/u01/app/oracle/product/oms10g/sysman/admin/emdrep/sql/pp/latest/deploymentProcs_sql/PatchRACDBRolling.sql"
## Copying file to "/u01/app/oracle/product/oms10g/sysman/admin/emdrep/sql/pp/latest/deploymentProcs_sql/PatchStandaloneDB.sql"
## Copying file to "/u01/app/oracle/product/oms10g/sysman/admin/emdrep/sql/pp/latest/jobTypes_sql/StagePatches_PA.sql"
## Copying file to "/u01/app/oracle/product/oms10g/sysman/prov/paf/patchAdvisor_7240713.par"
## ApplySession adding interim patch '7240713' to inventory
##
## Verifying the update...
## Inventory check OK: Patch ID 7240713 is registered in Oracle Home inventory with proper meta-data.
## Files check OK: Files from Patch ID 7240713 are present in Oracle Home.
##
## OPatch succeeded.
## $
##
## connect to repository and run the following scripts
##
sqlplus sysman/<prod_sys_pass>@PGRID
@?/sysman/admin/emdrep/sql/pp/latest/jobTypes_sql/StagePatches_PA.sql
@?/sysman/admin/emdrep/sql/core/latest/admin/admin_recompile_invalid SYSMAN
ALTER SYSTEM SET job_queue_processes=30;
-- rerun this SQL and make sure it's exactly the same as it was prior to patch application
--
set lines 132
set trims on
col what format a75 trunc
SELECT what, broken
FROM dba_jobs
WHERE log_user = priv_user and
priv_user = (SELECT owner
FROM dba_procedures
WHERE object_name = 'MGMT_USER'
AND procedure_name = 'DROP_USER')
ORDER BY job;
SELECT object_name FROM user_objects WHERE status = 'INVALID' order by object_name ;
## EXAMPLE:
##
## SQL> r
## 1 SELECT what, broken
## 2 FROM dba_jobs
## 3 WHERE log_user = priv_user and
## 4 priv_user = (SELECT owner
## 5 FROM dba_procedures
## 6 WHERE object_name = 'MGMT_USER'
## 7 AND procedure_name = 'DROP_USER')
## 8* ORDER BY job
##
## WHAT B
## --------------------------------------------------------------------------- -
## MGMT_CNTR_TT.clean_up_old_ticket_recs; N
## EM_TASK.WORKER(1); N
## EM_TASK.WORKER(2); N
## EMD_LOADER.ROLLUP(); N
## EMD_NOTIFICATION.CHECK_FOR_SEVERITIES(); N
## EM_PING.MARK_NODE_STATUS(); N
## EM_SEVERITY_REPOS.EXECUTE_REPOS_SEVERITY_EVAL(); N
## MGMT_JOB_ENGINE.apply_purge_policies(); N
## emd_maintenance.analyze_emd_schema('SYSMAN'); N
## EMD_RT_ROLLUP.ROLLUP(); N
## EMD_E2E_ROLLUP.ROLLUP(); N
##
## WHAT B
## --------------------------------------------------------------------------- -
## MGMT_GENSVC_AVAIL.EXEC_AVAIL_JOB(); N
## EM_PURGE.APPLY_PURGE_POLICIES(); N
## MGMT_RCA.PURGE_RCA_RESULTS(); N
## BEGIN MGMT_BSLN_INTERNAL.PURGE_EXTRACT_RAWDATA;MGMT_BSLN.COMPUTE_ALL_STATIS N
## BEGIN MGMT_BSLN.SET_ALL_THRESHOLDS;/*GC*/END; N
## EM_POLICY.CLEAR_EXPIRED_SUPPRESSIONS; N
## EM_TASK.RESUBMIT_FAILED_TASK(); N
##
## 18 rows selected.
##
## SQL>
##
## SQL> SELECT object_name FROM user_objects WHERE status = 'INVALID' order by object_name ;
##
## no rows selected
##
## SQL>
##
18 jobs before and after -- no broken jobs -- looks good to me ...
## Run the below commond to deploy
##
$ORACLE_HOME/bin/PARDeploy -action deploy -parFile $ORACLE_HOME/sysman/prov/paf/patchAdvisor_7240713.par -force
## EXAMPLE:
## -----------
##
## $ loy -parFile $ORACLE_HOME/sysman/prov/paf/patchAdvisor_7240713.par -force <
##
## SQL*Plus: Release 10.1.0.5.0 - Production on Tue Jul 22 16:20:23 2008
##
## Copyright (c) 1982, 2005, Oracle. All rights reserved.
##
## Enter user-name:
## Connected to:
## Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
## With the Partitioning, OLAP, Data Mining and Real Application Testing options
##
## SQL>
## PL/SQL procedure successfully completed.
##
## SQL>
## PL/SQL procedure successfully completed.
##
## SQL>
## PL/SQL procedure successfully completed.
##
## SQL>
## PL/SQL procedure successfully completed.
##
## SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
## With the Partitioning, OLAP, Data Mining and Real Application Testing options
## 0 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForRevision
## 1 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForParameters
## 42 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForParameters
## 42 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForParameters
## 42 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForParameters
## 42 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getDocuments
## 47 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getDocuments
## 48 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForPlatforms
## 48 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForParameters
## 132 [main] DEBUG oracle.sysman.eml.swlib.bitstore.FileBitStore - Finding free space for '/binback/download/oracle/emgc-soft-library' location.
## 132 [main] DEBUG oracle.sysman.eml.swlib.bitstore.FileBitStore - Running following command to find space:'/u01/app/oracle/product/oms10g/perl/bin/perl /u01/app/oracle/product/oms10g/bin/findAvailableSpace.pl /binback/download/oracle/emgc-soft-library' for location '/binback/download/oracle/emgc-soft-library'.
## 140 [main] DEBUG oracle.sysman.eml.swlib.bitstore.FileBitStore - Freespace on location '/binback/download/oracle/emgc-soft-library' is:6879095328
## 140 [main] DEBUG oracle.sysman.eml.swlib.bitstore.FileBitStore - Free space available on '/binback/download/oracle/emgc-soft-library':6879095328
## 140 [main] DEBUG oracle.sysman.eml.swlib.bitstore.FileBitStore - Available bytes from inputstream:53806
## 575 [main] DEBUG oracle.sysman.eml.swlib.bitstore.FileBitStore - inserted input stream to /binback/download/oracle/emgc-soft-library/12/52A6118183B33C58E040FB8020154C46
## 615 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForRevision
## 616 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForParameters
## 616 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForParameters
## 616 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForParameters
## 616 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForParameters
## 616 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getDocuments
## 617 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getDocuments
## 618 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForPlatforms
## 618 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForParameters
## 623 [main] DEBUG oracle.sysman.eml.swlib.bitstore.FileBitStore - Finding free space for '/binback/download/oracle/emgc-soft-library' location.
## 623 [main] DEBUG oracle.sysman.eml.swlib.bitstore.FileBitStore - Running following command to find space:'/u01/app/oracle/product/oms10g/perl/bin/perl /u01/app/oracle/product/oms10g/bin/findAvailableSpace.pl /binback/download/oracle/emgc-soft-library' for location '/binback/download/oracle/emgc-soft-library'.
## 630 [main] DEBUG oracle.sysman.eml.swlib.bitstore.FileBitStore - Freespace on location '/binback/download/oracle/emgc-soft-library' is:6879095296
## 630 [main] DEBUG oracle.sysman.eml.swlib.bitstore.FileBitStore - Free space available on '/binback/download/oracle/emgc-soft-library':6879095296
## 630 [main] DEBUG oracle.sysman.eml.swlib.bitstore.FileBitStore - Available bytes from inputstream:46500
## 637 [main] DEBUG oracle.sysman.eml.swlib.bitstore.FileBitStore - inserted input stream to /binback/download/oracle/emgc-soft-library/13/52A6118183B43C58E040FB8020154C46
## $
##
## Connect to sqlplus as repository owner. Run
##
cd /binback/download/oracle/linux/grid-ctl/post_10204/7240713
sqlplus sysman/<prod_sys_pass>@PGRID
@./after_pardeploy.sql
exit
## apply Patch 6646817
##
cd /binback/download/oracle/linux/grid-ctl/post_10204
unzip p6646817_10204_GENERIC.zip
cd 6646817
/u01/app/oracle/product/oms10g/OPatch/opatch apply
## apply Patch 6799925
##
cd /binback/download/oracle/linux/grid-ctl/post_10204
unzip p6799925_10204_GENERIC.zip
cd 6799925
/u01/app/oracle/product/oms10g/OPatch/opatch apply
... continued below ...
|
10165
2009-MAY-18 18:58:51
|
||||
|
... continued below ...
## Apply Patch 7195612 to the OMS Home. Note 727020.1
##
cd /binback/download/oracle/linux/grid-ctl/post_10204
unzip p7195612_10204_GENERIC.zip
cd 7195612
/u01/app/oracle/product/oms10g/OPatch/opatch apply
$ORACLE_HOME/bin/PARDeploy -action deploy -parFile $ORACLE_HOME/sysman/prov/paf/patchAdvisor_7195612.par -force
## EXAMPLE:
## ---------
##
## $ loy -parFile $ORACLE_HOME/sysman/prov/paf/patchAdvisor_7195612.par -force <
## 0 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForRevision
## 1 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForParameters
## 41 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForParameters
## 41 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForParameters
## 41 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForParameters
## 41 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getDocuments
## 48 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getDocuments
## 48 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForPlatforms
## 49 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForParameters
## 82 [main] DEBUG oracle.sysman.eml.swlib.bitstore.FileBitStore - Finding free space for '/binback/download/oracle/emgc-soft-library' location.
## 82 [main] DEBUG oracle.sysman.eml.swlib.bitstore.FileBitStore - Running following command to find space:'/u01/app/oracle/product/oms10g/perl/bin/perl /u01/app/oracle/product/oms10g/bin/findAvailableSpace.pl /binback/download/oracle/emgc-soft-library' for location '/binback/download/oracle/emgc-soft-library'.
## 89 [main] DEBUG oracle.sysman.eml.swlib.bitstore.FileBitStore - Freespace on location '/binback/download/oracle/emgc-soft-library' is:6878974880
## 89 [main] DEBUG oracle.sysman.eml.swlib.bitstore.FileBitStore - Free space available on '/binback/download/oracle/emgc-soft-library':6878974880
## 89 [main] DEBUG oracle.sysman.eml.swlib.bitstore.FileBitStore - Available bytes from inputstream:46182
## 106 [main] DEBUG oracle.sysman.eml.swlib.bitstore.FileBitStore - inserted input stream to /binback/download/oracle/emgc-soft-library/60/52A67349E289DC12E040FB8020150468
## 176 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForRevision
## 176 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForParameters
## 176 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForParameters
## 176 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForParameters
## 176 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForParameters
## 176 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getDocuments
## 177 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getDocuments
## 178 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForPlatforms
## 178 [main] DEBUG oracle.sysman.eml.swlib.DBEntity - SWLIB getRepositoryFormatForParameters
## 183 [main] DEBUG oracle.sysman.eml.swlib.bitstore.FileBitStore - Finding free space for '/binback/download/oracle/emgc-soft-library' location.
## 183 [main] DEBUG oracle.sysman.eml.swlib.bitstore.FileBitStore - Running following command to find space:'/u01/app/oracle/product/oms10g/perl/bin/perl /u01/app/oracle/product/oms10g/bin/findAvailableSpace.pl /binback/download/oracle/emgc-soft-library' for location '/binback/download/oracle/emgc-soft-library'.
## 190 [main] DEBUG oracle.sysman.eml.swlib.bitstore.FileBitStore - Freespace on location '/binback/download/oracle/emgc-soft-library' is:6878974848
## 191 [main] DEBUG oracle.sysman.eml.swlib.bitstore.FileBitStore - Free space available on '/binback/download/oracle/emgc-soft-library':6878974848
## 191 [main] DEBUG oracle.sysman.eml.swlib.bitstore.FileBitStore - Available bytes from inputstream:25717
## 226 [main] DEBUG oracle.sysman.eml.swlib.bitstore.FileBitStore - inserted input stream to /binback/download/oracle/emgc-soft-library/52/52A67349E28ADC12E040FB8020150468
## $
##
## restart OMS
##
/u01/app/oracle/product/oms10g/opmn/bin/opmnctl startall
##
## Install the Oracle EM Plug-In for Pillar Axiom Systems
##
## download pillar_tp_storage_axiom.jar from:
##
http://www.oracle.com/technology/products/oem/extensions/index.html
## Setup preferred credentials for qarac
##
http://oraemgc.yourdomain.com:4889/em/console/pref/userPreferences
Click "Preferred Credentials"
Click "Set Credentials" next to "Agent"
enter credentials for the following agents:
qarac1.yourdomain.com:3872
qarac2.yourdomain.com:3872
qarac3.yourdomain.com:3872
qarac4.yourdomain.com:3872
Enter:
Normal Username: oracle
Normal Password: <prod_oracle_pass>
Click "Apply"
## install plugin
##
http://oraemgc.yourdomain.com:4889/em
Setup -> Management Plug-ins
Click Import
Click Browse next to "Management Plug-in Archive"
select "pillar_tp_storage_axiom.jar"
Click "List Archive"
Under "Management Plug-ins for Archive: pillar_tp_storage_axiom.jar" table
Check off Select field [x] next to pillar_storage_system_axiom_500
Click "OK" (top OK button do not use the one on the bottom)
It should give you a message:
"One Management Plug-in or Plug-in group has been successful imported."
Click "Deploy" button next to "pillar_storage_system_axiom_500"
Click "Add Agents"
In the search form enter "qarac" and click "Go"
[x] qarac1.yourdomain.com:3872
[x] qarac2.yourdomain.com:3872
[x] qarac3.yourdomain.com:3872
[x] qarac4.yourdomain.com:3872
Click "Select All" link
Click "Select" button
Click Next
Click Finish
You should receive the following message:
"Deploy operation completed. The status of the deployment can be found in
the Deployment Status page in the Related Link at the bottom of this page."
Click "Deployment Status"
Click "GO"
You should see the following table:
pillar_storage_system_axiom_500 1.0 qarac2.yourdomain.com:3872 8/21/08 Deployed 0 0
pillar_storage_system_axiom_500 1.0 qarac3.yourdomain.com:3872 8/21/08 Deployed 0 0
pillar_storage_system_axiom_500 1.0 qarac4.yourdomain.com:3872 8/21/08 Deployed 0 0
pillar_storage_system_axiom_500 1.0 qarac1.yourdomain.com:3872 8/21/08 Deployed 0 0
## Discover the Pillar Axiom System with Oracle EM Grid Control
##
Navidate to:
http://oraemgc.yourdomain.com:4889/em
Setup -> Agents
Click on "qarac1.yourdomain.com:3872"
Under "Monitored Targets"
Under "Add" dropdown menu select "Pillar Storage System: Axiom 500"
Click "Go"
Properties window will open
Enter the following values:
Name: qarac1-pillar-san
Host: XXX.XXX.XXX.XX
UserName: emgc-mon
Password: <prod_system_pass>
Namespace: /root/pillar1_2 (change the default to this value)
Click "OK"
You should receive a confirmation message:
"Target qarac1-pillar-san (Pillar Storage System: Axiom 500) has been added."
A few minutes after the Oracle EM plug-in for Pillar Axiom systems discovers the
target, Oracle Enterprise Manager begins to collect data.
1. On the Agent home page, find the Monitored Targets table.
2. Click the Pillar Data Systems: Axiom Target option.
The Pillar Data Systems: Axiom home page appears.
3. Verify that no metric collection errors have been reported in the Metrics table.
4. Ensure that you can see reports (after the metrics have been collected and
uploaded) and verify that no errors have been reported by clicking the
Reports Property page.
Note: If there are data collection errors reported, check the connection
options (such as the hostname, username, and password), the system
requirements, and the connectivity.
I received the foloowing collection error:
"Error connecting to the CIM Object Manager. Please ensure that the CIM
Object Manager is operational and that the client user credentials are
accurate."
Solution? NONE at this point WTF?
##
###
##### This concludes this installation
##
## Phase IV - Configuration Files
##
## repository connection configuration file
##
/u01/app/oracle/product/oms10g/sysman/config/emoms.properties
## Usefull log files
##
/u01/app/oracle/product/agent10g/sysman/emd/sqlnet.log
/u01/app/oracle/product/agent10g/sysman/log/emagent_perl.trc
/u01/app/oracle/product/oms10g/opmn/logs/*
--- from ./sysman/admin/scripts/emrepresp.pl ---
use strict;
use Oraperl;
use Time::HiRes;
require "emd_common.pl";
require "semd_common.pl";
my $targetname = "";
my $db_connect = "";
EMD_PERL_DEBUG("Connectdescriptor $ENV{CONNECTDESCRIPTOR}");
if ( $ENV{CONNECTDESCRIPTOR} ne "" )
{
$db_connect = $ENV{EM_REPOS_USER} . "/" . $ENV{EM_REPOS_PWD} . "@" . $ENV{CONNECTDESCRIPTOR};
$targetname = $ENV{EM_REPOS_USER}."test";
}
else
{
$db_connect = $ENV{EM_REPOS_USER} . "/" . $ENV{EM_REPOS_PWD} . "@" . $ENV{EM_TARGET_ADDRESS};
$targetname = $ENV{SID}.$ENV{PORT};
}
my $start_time = Time::HiRes::time;
my $lda;
my $targetname = $ENV{SID}.$ENV{PORT};
my $fn = get_tmp_filename ($targetname, "emrepresp");
EMD_PERL_DEBUG("$targetname, $fn");
unless ( $lda = &ora_login ('', $db_connect, '') )
{
EMD_PERL_DEBUG("ora_login");
print "em_result=0|Enterprise Manager Repository database is down. Error: $ora_errno\n$db_connect";
processfailure("Could not connect to Enterprise Manager Repository database: $ora_errno");
exit 0;
}
[edited by: Vitaliy at 19:00 (CST) on May. 18, 2009]