IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
I will explain How to Find OMS Home and Start and Stop Enterprise Manager Cloud Control 13c in this post.
Find OMS Home and Start & Stop Enterprise Manager Cloud Control 13c
If you don’t know Enterprise manager cloud control architecture and its installation, you can read following article.
Find OMS Home
Sometimes you may need restart of Enterprise manager Cloud Control for maintenance, You should stop All Enterprise manager Cloud control services properly, then start them again like following steps.
You should firstly find OMS Home, then run start and stop command. But how to find oms home in oracle 13c ?
You can find it as follows.
[oracle@deveci01 ]$ echo $OMS_HOME
If OMS_HOME is not set, then you can find the emctl under the installation directory as follows.
[oracle@deveci01 ]$ find /u01 -name emctl
Start and Stop Enterprise Manager Cloud Control 13c
Firstly stop Cloud control agent
[oracle@deveci01 bin]$ ./emctl stop agent Oracle Enterprise Manager Cloud Control 12c Release 3 Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved. Stopping agent ... stopped.
Then stop all Enterprise manager cloud control services like following.
[oracle@deveci01 bin]$ [oracle@deveci01 bin]$ emctl stop oms -all Oracle Enterprise Manager Cloud Control 12c Release 3 Copyright (c) 1996, 2013 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
If Cloud control services are down, then shutdown database also.
[oracle@deveci01 bin]$ [oracle@deveci01 bin]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Fri Jun 27 15:48:43 2014 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> shut immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> exit Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options [oracle@deveci01 bin]$ lsnrctl stop LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 27-JUN-2014 15:49:11 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=deveci01.mehmetsalih.com)(PORT=1521))) The command completed successfully [oracle@deveci01 bin]$
Enterprise manager cloud control is stopped properly, you can perform all maintenance you want.
Now if you need start of Enterprise manager cloud control, perform following steps.
Firstly start listener and database like following.
[oracle@deveci01 bin]$ lsnrctl start LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 27-JUN-2014 15:49:34 Copyright (c) 1991, 2013, Oracle. All rights reserved. Starting /u01/app/oramon/product/12.1.0/db1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 12.1.0.1.0 - Production System parameter file is /u01/app/oramon/product/12.1.0/db1/network/admin/listener.ora Log messages written to /u01/app/oramon/diag/tnslsnr/deveci01/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=deveci01.mehmetsalih.com)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=deveci01.mehmetsalih.com)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production Start Date 27-JUN-2014 15:49:34 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oramon/product/12.1.0/db1/network/admin/listener.ora Listener Log File /u01/app/oramon/diag/tnslsnr/deveci01/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=deveci01.mehmetsalih.com)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) The listener supports no services The command completed successfully [oracle@deveci01 bin]$
Startup Oracle database.
[oracle@deveci01 bin]$ [oracle@deveci01 bin]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Fri Jun 27 15:49:38 2014 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 3256942592 bytes Fixed Size 2293640 bytes Variable Size 1744830584 bytes Database Buffers 1493172224 bytes Redo Buffers 16646144 bytes Database mounted. Database opened. SQL> exit Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options [oracle@deveci01 bin]$
Finally, start all Enterprise manager Cloud control services like following.
[oracle@deveci01 bin]$ emctl start oms Oracle Enterprise Manager Cloud Control 12c Release 3 Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved. Starting Oracle Management Server... Starting WebTier... WebTier Successfully Started Oracle Management Server Successfully Started Oracle Management Server is Up [oracle@deveci01 bin]$
You can check and query status of Cloud control like following.
[oracle@deveci01 bin]$ [oracle@deveci01 bin]$ [oracle@deveci01 bin]$ emctl status oms -details Oracle Enterprise Manager Cloud Control 12c Release 3 Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved. Enter Enterprise Manager Root (SYSMAN) Password : Console Server Host : deveci01.mehmetsalih.com HTTP Console Port : 7788 HTTPS Console Port : 7802 HTTP Upload Port : 4889 HTTPS Upload Port : 4903 EM Instance Home : /u01/app/oramon/gc_inst/em/EMGC_OMS1 OMS Log Directory Location : /u01/app/oramon/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://deveci01.mehmetsalih.com:7802/em Upload URL: https://deveci01.mehmetsalih.com:4903/empbs/upload WLS Domain Information Domain Name : GCDomain Admin Server Host : deveci01.mehmetsalih.com Admin Server HTTPS Port: 7102 Admin Server is RUNNING Managed Server Information Managed Server Instance Name: EMGC_OMS1 Managed Server Instance Host: deveci01.mehmetsalih.com WebTier is Up Oracle Management Server is Up [oracle@deveci01 bin]$
