CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle Grid Control
Version 10.2.0.4
 
Resources
Links of Interest Download CDs

Grid Technology Center

Grid Agent Download

Enterprise Manager Grid Control Installation and Basic Configuration (10.1)

Enterprise Manager & Grid Control Frequently Asked Questions

Enterprise Manager - Grid Control (release 10.1.0.3) Read Me

Grid - Enterprise Extensions

Manually Configure the Enterprise Manager

Operating System RedHat Linux 3 Advanced Server Update 2
or
RedHat Linux 4 Advanced Server Update 2
OMR Database Version Enterprise Edition 10.1.0.4
OMR Parameters
aq_tm_processes

1

compatible 10.1.0.4
db_block_size 8192
db_cache_size 134217728
dispatchers NULL
fast_start_mttr_target 300
hash_area_size 1048576
job_queue_processes 10
large_pool_size 0
open_cursors 300
pga_aggregate_target 33554432
processes 150
remote_login_passwordfile EXCLUSIVE
session_cached_cursors 200
shared_pool_size 67108864
sort_area_size 1048576
timed_statistics TRUE
OMS Version If installing OMS against an existing database the following must be true:
  • Dispatchers set to 0
  • aq_tm_processes > 0
  • session_cache_cursors > 200
  • dbms_shared_pool built-in package must be previously installed
  • sysman schema does not already exist (preferred)
OMA Version  
OMA Download Source http://alpha1.psoug.org.com:4889/agent_download/
OMA Downloadable Switches
-d Do not automatically discover targets during installation.
-h Usage: Displays and describes the options that can be used with this script.
-i Inventory pointer location file: Can be used to point the installer to a non-default inventory.
-o ORACLE_HOME: Can be picked up from the environment or specified on the command line.
-s Installer stage directory: Points to an installer previously downloaded by the script. If defined, the local installer will be launched and the jarred installer will not be downloaded.
-t Do not automatically start the Agent at the end of installation.
-x Debug output: Turns on shell debugging.
Operating System Installation and Configuration
Option instructions for Oracle Unbreakable Linux 4 Click Here (10g) Click Here (11g)

As root: Append servers to hosts file

Do this on all servers
cd /etc

Note: the line:
127.0.0.1   omega#.psoug.org   omega#   localhost.localadmin localhost
must remain. If you delete it ... nothing will work properly.


vi hosts
192.168.1.211 alpha1 alpha1.psoug.org
192.168.1.212 alpha2 alpha2.psoug.org
192.168.1.221 beta1 beta1.psoug.org
192.168.1.222 beta2 beta2.psoug.org
192.168.1.231 gamma1 gamma1.psoug.org
192.168.1.232 gamma2 gamma2.psoug.org
192.168.1.241 delta1 delta1.psoug.org
192.168.1.242 delta2 delta2.psoug.org

-- ping all hosts (substitute actual node names for the "omega")

ping 192.168.1.1
ping www.oracle.com
ping omega1
ping omega2
ping omega1.psoug.org
ping omega2.psoug.org

Create hosts.equiv file and copy Grid Control CDs

Do this on all servers
cd /etc

vi hosts.equiv

-- for this example "bigdog" is the server with the Oracle CDs
bigdog.psoug.org     oracle

<Esc> qw

scp oracle@bigdog:/stage/Linux_Grid_Control_full_102010_disk1.zip /stage/Grid1.zip

yes

oracle1

also copy oracle@bigdog:/stage/Linux_Grid_Control_full_102010_disk2.zip
and oracle@bigdog:/stage/Linux_Grid_Control_full_102010_disk3.zip

-- Unzip all three files into the /stage directory
unzip Grid1.zip
unzip Grid2.zip
unzip Grid3.zip
Copy 10gR2 CD

Do this on only the target servers
scp oracle@delta1:/stage/unloader.zip /home/oracle/db.zip

yes

oracle1

unzip db.zip
Management Server (only)

OMR/OMS Server .bashrc as root (check out .profile file)

For PSOUG classes this goes on the "1" machine (alpha1, beta1) only.
# cd /home/oracle

vi .bashrc

-- append the following:
umask 022

ORACLE_BASE=/app/oracle/product/
ORACLE_HOME=/app/oracle/product/OracleHomes/db10g
ORACLE_SID=emrep
OMR_HOME=/app/oracle/product/OracleHomes/db10g
OMS_HOME=/app/oracle/product/OracleHomes/oms10g
OMA_HOME=/app/oracle/product/OracleHomes/agent10g
OPMN_HOME=/app/oracle/product/OracleHomes/oms10g/opmn
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
TMP=/tmp
TEMP=/tmp
TMPDIR=/tmp
PATH=$ORACLE_HOME/bin:$OMS_HOME/opmn/bin:$PATH
export PATH ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH
export PATH OMR_HOME OMS_HOME OMA_HOME OPMN_HOME
export TMP TEMP TMPDIR

alias oh='cd $ORACLE_HOME'
alias sql='sqlplus "/ as sysdba"'
Target Server (only)

Grid Node .bashrc as root

For PSOUG classes this goes on the "2" machine (gamma2, delta2) only.
# cd /home/oracle

vi .bashrc

-- append the following:
umask 022

ORACLE_BASE=/app/oracle/product
ORACLE_HOME=/app/oracle/product/10.1.0/db_1
ORACLE_SID=orcl
OMA_HOME=/app/oracle/product/OracleHomes/agent10g
TMP=/tmp
TEMP=/tmp
TMPDIR=/tmp
PATH=$PATH:$ORACLE_HOME/bin
export PATH ORACLE_BASE ORACLE_HOME ORACLE_SID OMA_HOME
export TMP TEMP TMPDIR
Management Server Installation

As root Mount NetApp
IF outside the PSOUG lab THEN
  http://otn.oracle.com ... click on downloads
ELSE ...

# mount -t nfs 192.168.10.100:/vol/stage /mnt

# cd /mnt/grid

# ls

# cp L* /stage
# cp p* /stage

# cd /stage

# 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 &
Shell Scripts

Sample Startup
$ORACLE_HOME/bin/lsnrctl start
sleep 15

$ORACLE_HOME/bin/sqlplus /nolog <<EOF1
connect / as sysdba
startup
EOF1
sleep 15

$OMA_HOME/bin/emctl start agent
$OMS_HOME/bin/emctl start oms

$OMS_HOME/opmn/bin/opmnctl startall

Sample Shutdown
$OMS_HOME/opmn/bin/opmnctl stopall
$OMA_HOME/bin/emctl stop agent
$OMS_HOME/bin/emctl stop oms

$ORACLE_HOME/bin/sqlplus /nolog <<EOF1
connect / as sysdba
shutdown immediate
EOF1

$ORACLE_HOME/bin/lsnrctl stop
 
ADDM Workout

ADDM Schema For Testing
conn / as sysdba

SELECT tablespace_name, contents
FROM dba_tablespaces
WHERE tablespace_name NOT IN ('SYSTEM', 'SYSAUX', 'UNDOTBS1', 'TEMP');

CREATE USER test
IDENTIFIED BY test
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp
QUOTA 0 ON SYSTEM
QUOTA 0 ON SYSAUX
QUOTA UNLIMITED ON users;

GRANT create session TO test;
GRANT create table TO test;
GRANT create procedure TO test;

GRANT select ON dba_indexes TO test;
GRANT select ON dba_segments TO test;
GRANT select ON dba_tables TO test;

conn test/test@orcl

CREATE TABLE i AS
SELECT * FROM dba_indexes;

CREATE TABLE s AS
SELECT * FROM dba_segments;

CREATE TABLE t AS
SELECT * FROM dba_tables;

CREATE TABLE z (
tablespace_name VARCHAR2(30));

OMS ADDM Navigation
  1. Start Browser
  2. Go to http://gamma1.psoug.org:4889/em
  3. Click on OK
  4. Enter User Name -> SYSMAN
    Enter Password --> oracle1
    Click on Login
  5. Click on Targets Tab
  6. Click on Databases
  7. Click on orcl target database
  8. Scroll to the bottom
    Click on Advisor Central link
  9. Database Login
    Enter Username ---> sys
    Enter Password ---> oracle1
    Enter Connect As -> SYSDBA
    Click on Login button
  10. Click on SQL Tuning Advisor link
  11. Click on SQL Tuning Sets link
ADDM Test Job INSERT INTO z
SELECT i.tablespace_name
FROM i, s, t
WHERE i.tablespace_name = s.tablespace_name
AND i.tablespace_name = t.tablespace_name;
 
Related Topics
DBMS_ADVISOR
DBMS_MONITOR
DBMS_SERVER_ALERT
DBMS_SQLTUNE
DBMS_XPLAN
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [143 users online]    © 2010 psoug.org