| 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 |
- Start Browser
- Go to http://gamma1.psoug.org:4889/em
- Click on OK
- Enter User Name -> SYSMAN
Enter Password --> oracle1
Click on Login
- Click on Targets Tab
- Click on Databases
- Click on orcl target database
- Scroll to the bottom
Click on Advisor Central link
- Database Login
Enter Username ---> sys
Enter Password ---> oracle1
Enter Connect As -> SYSDBA
Click on Login button
- Click on SQL Tuning Advisor link
- 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; |
