Monday, May 11, 2015

Useful EM12c Architecture Links

http://www.oracle.com/technetwork/oem/framework-infra/wp-em12c-security-best-practicesv2-1493383.pdf

http://www.slideshare.net/MaazAnjum/maaz-anjum-gouser-database-provisioning-in-em12c-provision-me-a-database-now

Sunday, May 10, 2015

emctl commands


-bash-3.2$ ./emctl status oms -details
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Enter Enterprise Manager Root (SYSMAN) Password :
Console Server Host        : vserv1144.us.oracle.com
HTTP Console Port          : 7789
HTTPS Console Port         : 7801
HTTP Upload Port           : 4890
HTTPS Upload Port          : 4901
EM Instance Home           : /u01/fmw/gc_inst/em/EMGC_OMS1
OMS Log Directory Location : /u01/fmw/gc_inst/em/EMGC_OMS1/sysman/log
OMS is not configured with SLB or virtual hostname
Agent Upload is locked.
OMS Console is locked.
Active CA ID: 1
Console URL: https://vserv1144.us.oracle.com:7801/em
Upload URL: https://vserv1144.us.oracle.com:4901/empbs/upload

WLS Domain Information
Domain Name      : GCDomain
Admin Server Host: vserv1144.us.oracle.com

Managed Server Information
Managed Server Instance Name: EMGC_OMS1
Managed Server Instance Host: vserv1144.us.oracle.com
WebTier is Down
Oracle Management Server is Down

Backend WLS or EM application seems to be down 

  1. Stop OMS

-bash-3.2$ ./stopOMS.sh
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Stopping WebTier...
WebTier Successfully Stopped
Stopping Oracle Management Server...
Oracle Management Server Successfully Stopped
AdminServer Successfully Stopped
Oracle Management Server is Down
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Stopping agent ..... stopped.

2. Validate all OMS processes are down

-bash-3.2$  ps -ef | grep EMGC_OMS1
orcloud  16481 14974  0 21:05 pts/0    00:00:00 grep EMGC_OMS1
-bash-3.2$ ps -ef | grep oms
orcloud  16496 14974  0 21:06 pts/0    00:00:00 grep oms
-bash-3.2$ ps -ef | grep EMGC_ADMINSERVER
orcloud  16547 14974  0 21:06 pts/0    00:00:00 grep EMGC_ADMINSERVER

3. Delete every lok file

-bash-3.2$ cd gc_inst/user_projects/domains/GCDomain/
-bash-3.2$ find . -name "*.lok"
./config/config.lok
./edit.lok

4. Start OMS

-bash-3.2$ ./startOMS.sh
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Starting Oracle Management Server...

Starting Cloud Control and All Its Components

  1. Set the ORACLE_HOME environment variable to the Management Repository database home directory.
  2. Set the ORACLE_SID environment variable to the Management Repository database SID
  3. Start the Net Listener:
    $ORACLE_HOME/bin/lsnrctl start <listener name>
    
  4. Start the Management Repository database instance:
    $ORACLE_HOME/bin/sqlplus /nolog
    SQL> connect SYS as SYSDBA
    SQL> startup
    SQL> quit
    Start the Oracle Management Service 
    $OMS_HOME/bin/emctl start oms
    Change directory to the home directory for the Oracle Management Agent and start the Management Agent:
    $AGENT_HOME/bin/emctl start agent
     
  5. Start webtier

-bash-3.2$ ./opmnctl startall
opmnctl startall: starting opmn and all managed processes...

Friday, May 8, 2015

Setting Up EM12C Cloud Control - Part 2

Installation

1. Download the software from OTN
2. Copy the following response file to local location:
<Software_Location>/response/new_install.rsp
3. Edit to change the values
4. Start the installer in silent Mode

$./runInstaller -silent -responseFile /u01/shiphome/em12.1.0.4/response_files/new_install.rsp
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 400 MB.   Actual 3690 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 18006 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-05-08_06-56-15PM. Please wait ...


Installing ORACLE_HOME /u01/fmw/jdk16
Installation in progress
....
Install successful
Linking in progress

Link successful
Setup in progress

Setup successful
Installing Oracle WebLogic Server




Installing ORACLE_HOME /u01/fmw/Oracle_BI1
Installation in progress
.....
Install successful
Linking in progress

Link successful
Setup in progress

Setup successful

Installing ORACLE_HOME /u01/fmw/oms
Installation in progress


Unable to find product oracle.swd.jre[1.5.0.0.0, 9.9.9] in Oracle Inventory
.
Install successful
Linking in progress

 Link successful
Setup in progress

Setup successful
Installing plug-in /u01/fmw/oms/install/tmp_installer/oracle.sysman.cfw/12.1.0.1.0/12.1.0.1.0_OMS_2000_0.zip
You can find the log of this install session at:
 /u01/em12c/oraInventory/logs/cloneActions2015-05-08_07-16-56-PM.log

Installing ORACLE_HOME /u01/fmw/plugins/oracle.sysman.cfw.oms.plugin_12.1.0.1.0
Installation in progress

Install successful
Linking in progress

Link successful
Setup in progress

Setup successful
Installing plug-in /u01/fmw/oms/install/tmp_installer/oracle.sysman.db/12.1.0.6.0/12.1.0.6.0_OMS_2000_0.zip
You can find the log of this install session at:
 /u01/em12c/oraInventory/logs/cloneActions2015-05-08_07-17-08-PM.log

Installing ORACLE_HOME /u01/fmw/plugins/oracle.sysman.db.oms.plugin_12.1.0.6.0
Installation in progress

Install successful
Linking in progress

Link successful
Setup in progress

Setup successful
Installing plug-in /u01/fmw/oms/install/tmp_installer/oracle.sysman.xa/12.1.0.6.0/12.1.0.6.0_OMS_2000_0.zip
You can find the log of this install session at:
 /u01/em12c/oraInventory/logs/cloneActions2015-05-08_07-18-59-PM.log

Installing ORACLE_HOME /u01/fmw/plugins/oracle.sysman.xa.oms.plugin_12.1.0.6.0
Installation in progress

Install successful
Linking in progress

Link successful
Setup in progress

Setup successful
Installing plug-in /u01/fmw/oms/install/tmp_installer/oracle.sysman.emas/12.1.0.6.0/12.1.0.6.0_OMS_2000_0.zip
You can find the log of this install session at:
 /u01/em12c/oraInventory/logs/cloneActions2015-05-08_07-19-10-PM.log

Installing ORACLE_HOME /u01/fmw/plugins/oracle.sysman.emas.oms.plugin_12.1.0.6.0
Installation in progress

Install successful
Linking in progress

Link successful
Setup in progress

Setup successful
Installing plug-in /u01/fmw/oms/sysman/install/plugins/oracle.sysman.oh/12.1.0.4.0/12.1.0.4.0_Agent_2000_0.zip
You can find the log of this install session at:
 /u01/em12c/oraInventory/logs/cloneActions2015-05-08_07-24-04-PM.log

Installing ORACLE_HOME /u01/agent12c/plugins/oracle.sysman.oh.agent.plugin_12.1.0.4.0
Installation in progress

Install successful
Linking in progress

Link successful
Setup in progress

Setup successful
Installing plug-in /u01/fmw/oms/sysman/install/plugins/oracle.sysman.csa/12.1.0.4.0/12.1.0.4.0_Agent_2000_0.zip
You can find the log of this install session at:
 /u01/em12c/oraInventory/logs/cloneActions2015-05-08_07-24-10-PM.log

Installing ORACLE_HOME /u01/agent12c/plugins/oracle.sysman.csa.agent.plugin_12.1.0.4.0
Installation in progress

Install successful
Linking in progress

Link successful
Setup in progress

Setup successful
Installing plug-in /u01/fmw/oms/sysman/install/plugins/oracle.sysman.db/12.1.0.6.0/12.1.0.6.0_Discovery_2000_0.zip
You can find the log of this install session at:
 /u01/em12c/oraInventory/logs/cloneActions2015-05-08_07-24-16-PM.log

Installing ORACLE_HOME /u01/agent12c/plugins/oracle.sysman.db.discovery.plugin_12.1.0.6.0
Installation in progress
.
Install successful
Linking in progress

Link successful
Setup in progress

Setup successful
Installing plug-in /u01/fmw/oms/sysman/install/plugins/oracle.sysman.oh/12.1.0.4.0/12.1.0.4.0_Discovery_2000_0.zip
You can find the log of this install session at:
 /u01/em12c/oraInventory/logs/cloneActions2015-05-08_07-24-22-PM.log

Installing ORACLE_HOME /u01/agent12c/plugins/oracle.sysman.oh.discovery.plugin_12.1.0.4.0
Installation in progress

Install successful
Linking in progress

Link successful
Setup in progress

Setup successful
Extracting WT.zip
You can find the log of this install session at:
 /u01/em12c/oraInventory/logs/cloneActions2015-05-08_07-24-49-PM.log

Installing ORACLE_HOME /u01/fmw/oracle_common
Installation in progress
....
Install successful
Linking in progress

Link successful
Setup in progress
.
Setup successful
You can find the log of this install session at:
 /u01/em12c/oraInventory/logs/cloneActions2015-05-08_07-31-43-PM.log

Installing ORACLE_HOME /u01/fmw/Oracle_WT
Installation in progress
....
Install successful
Linking in progress

Link successful
Setup in progress

Setup successful
Applying the required oneoff patches.
2015-05-08_07-40-02-PM: Configuration assistant "Plugins Prerequisites Check"  is in progress.

2015-05-08_07-40-45-PM: Configuration assistant "Plugins Prerequisites Check" has Succeeded.

2015-05-08_07-40-45-PM: Configuration assistant "Repository Out Of Box Configuration"  is in progress.

*** The installation was Successful, but some co

Warning: The following configuration scripts need to be executed as the "root" u
  /u01/fmw/oms/allroot.sh
To execute the configuration scripts:
 1. Open a new  terminal window
 2. Login in as "root"
 3. Run the scripts

Enterprise Manager Cloud Control Installation has finished.

# /u01/fmw/oms/allroot.sh

Starting to execute allroot.sh .........

Starting to execute /u01/fmw/oms/root.sh ......
Finished execution of  /u01/fmw/oms/root.sh ......


Starting to execute /u01/agent12c/core/12.1.0.4.0/root.sh ......
Finished product-specific root actions.
/etc exist
/u01/agent12c/core/12.1.0.4.0
Finished execution of  /u01/agent12c/core/12.1.0.4.0/root.sh ......

Setting Up EM12C Cloud Control - Part 1 

Pre-Requisites
Creating a Database Instance

While installing Enterprise Manager Cloud Control, you must provide the details of a database where Oracle Management Repository (Management Repository) can be configured to store all Enterprise Manager-related data.

1. Install DB 11.2.0.3 S/W only Install as follows:

 ./runInstaller -silent -force -responseFile /u01/shiphome/db11gr2/response_files/db_11gr2_sw.rsp

2. Download 11.2.0.3_Database_Template_for_EM12_1_0_4_<platform>.zip file specific to the platform on which you have installed Oracle Database 11g Release 2 (11.2.0.3). This ZIP file will work only with Oracle Database 11g Release 2 (11.2.0.3).

http://www.oracle.com/technetwork/oem/enterprise-manager/downloads/index.html

3. Copy the templates extracted from step # 2 onto ORACLE_HOME/assistants/dbca/templates

Example:
$cp *.* /u01/app/oracle/product/112/assistants/dbca/templates/



4. Start dbca to create the database


$ ./dbca -silent -responseFile /u01/shiphome/db11gr2/response_files/
db_11gr2_sw.rsp          db_install_11gr2.rsp     netca_11gr2.rsp
dbca.rsp                 db_install_11gr2_sw.rsp  netca.rsp
dbca.rsp.orig            db_install.rsp
[orcloud@pserv0264 bin]$ ./dbca -silent -responseFile /u01/shiphome/db11gr2/response_files/dbca.rsp
Copying database files
1% complete
3% complete
10% complete
16% complete
23% complete

30% complete
33% complete
Creating and starting Oracle instance
35% complete

40% complete
44% complete
49% complete
50% complete
53% complete
55% complete
Completing Database Creation
58% complete
62% complete
65% complete
75% complete

85% complete
88% complete
Running Custom Scripts
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/cloud/cloud.log" for further details.

 4. Configure Network Listener as follows:


$./netca -silent -responseFile /u01/shiphome/db11gr2/response_files/netca_11gr2.rsp

Fri May 08 14:34:05 PDT 2015 Oracle Net Configuration Assistant
Parsing command line arguments:
    Parameter "silent" = true
    Parameter "responsefile" = /u01/shiphome/db11gr2/response_files/netca_11gr2.rsp
    Parameter "log" = /u01/app/oracle/product/112/network/tools/log/netca.log
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Oracle Net Listener Startup:
    Running Listener Control:
      /u01/app/oracle/product/112/bin/lsnrctl start LISTENER
    Listener Control complete.
    Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0



Tuesday, May 5, 2015