• Der Agent auf der OMS-Maschine
• Der Agent auf einem Zielsystem

$ ./emctl stop oms
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
Stopping WebTier...
WebTier Successfully Stopped
Stopping Oracle Management Server...
Oracle Management Server Successfully Stopped
Oracle Management Server is Down

$ cd cloud_control_download_dir
$ ./runInstaller

• Drei Redo Loggruppen mit je 300MB Dateigröße
• SGA Größe mit 2GB
• Parameter shared_pool_size auf mindestens 600MB

[oracle@sccloud046 bin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Dec 19 16:49:22 2011

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> grant execute on dbms_random to dbsnmp,sysman;

Grant succeeded.

SQL> alter user oracle_ocm account unlock;

User altered.

SQL> alter system set shared_pool_size=600M scope=spfile;

System altered.

SQL> alter system set sga_target=2G scope=spfile;

System altered.

SQL> alter database add logfile '/oracle/oradata/emrep/redo04.log' size 300m;

Database altered.

SQL> alter database add logfile '/oracle/oradata/emrep/redo05.log' size 300m;

Database altered.

SQL> alter database add logfile '/oracle/oradata/emrep/redo06.log' size 300m;

Database altered.

SQL> alter system switch logfile;

System altered.

SQL> select group#,bytes,status,archived from v$log;

    GROUP#      BYTES STATUS           ARC
---------- ---------- ---------------- ---
         1   52428800 INACTIVE         NO
         2   52428800 INACTIVE         NO
         3   52428800 INACTIVE         NO
         4  314572800 ACTIVE           NO
         5  314572800 CURRENT          NO
         6  314572800 INACTIVE         NO

6 rows selected.

SQL> alter database drop logfile group 1;

Database altered.

SQL> alter database drop logfile group 2;

Database altered.

SQL> alter database drop logfile group 3;

Database altered.

SQL> select group#,bytes,status,archived from v$log;

    GROUP#      BYTES STATUS           ARC
---------- ---------- ---------------- ---
         4  314572800 INACTIVE         NO
         5  314572800 INACTIVE         NO
         6  314572800 CURRENT          NO

SQL> startup force
ORACLE instance started.

Total System Global Area 2137886720 bytes
Fixed Size                  2230072 bytes
Variable Size             671090888 bytes
Database Buffers         1442840576 bytes
Redo Buffers               21725184 bytes
Database mounted.
Database opened.