To set system password

ALTER USER system IDENTIFIED BY password;

EM Cloud control help

#To stop Oracle Management Service GUI only
emctl stop oms
 
# To stop all services
emctl stop oms -all
 
# To stop the Database Control
emctl stop dbconsole

EM cloud control process order

Step 1:
 cd /u01/app/oracle/middleware/gc_inst/WebTierIH1/bin
./opmnctl status
 
(check the status if it is alive then stop it)
 
./opmnctl stopall
 
Step:2
 
go this directory /u01/app/oracle/middleware/gc_inst/WebTierIH1/config/OPMN/opmn/states
 
create a backup folder move the file (starts with p...) move that file to backup folder
 
now issue the command ./opmnctl startall
 
Step:3
check for any emctl.log files and delete them (find / -name emctl.log -type f)
 
Step:4
then stop OMS and agent
 
/u01/app/oracle/Middleware/oms/bin/emctl stop oms -all
/u01/app/oracle/Middleware/agent/core/12.1.0.1.0/bin/emctl stop agent
then start OMS and agent
 
/u01/app/oracle/Middleware/oms/bin/emctl start oms -all
/u01/app/oracle/Middleware/agent/core/12.1.0.1.0/bin/emctl start agent
Best regards,
Karthik Reddivari

• In our environment

# Stop the agent
/u01/app/oracle/middleware/oms/bin/emctl stop oms -all
# Stop the agent
/u01/app/oracle/agent12c/agent_inst/bin/emctl stop agent
 
# Start OMS first
/u01/app/oracle/middleware/oms/bin/emctl start oms
# Start the agent
/u01/app/oracle/agent12c/agent_inst/bin/emctl start agent

How to deploy a plugin

• Example of F5 plugin

# First login with emcli
/u01/app/oracle/middleware/oms/bin/emcli login -username=usera
 
# unzip plugin, then point to *.opar file
/u01/app/oracle/middleware/oms/bin/emcli import_update -file="/tmp/f5/12.1.0.1.1_F5.BIGIP.LTM_2000_0.opar" -omslocal

To get default tablespace

select * from database_properties where property_name='DEFAULT_PERMANENT_TABLESPACE' 

To change the default tablespace from users to system

alter database default tablespace system;

To drop the users tablespace, you first need to change the defualt to system

drop tablespace USERS; 

Now re-create the SYSTEM tablespace

CREATE TABLESPACE USERS datafile; 

To Change back the default to users

alter database default tablespace system; 

To add another tablespace to users

alter tablespace users add datafile '+DATA'; 

To a all tablespcase files

select file_name from dba_data_files where tablespace_name='USRS'; 

To see a list of tablespacess

select * from v$tablespace; To gain space on the data collection table space in ops center SQL> truncate table RM_RESOURCE_DAILY_TREND; 

To check the size run

SQL>set linesize 899
SQL>select segment_name,bytes/1024/1024 from user_segments where tablespace_name='USERS' order by 2;
SQL>col SEGMENT_NAME for a30 select file_name from dba_data_files where tablespace_name='USERS';

References

EM cloud control
EM cloud control HA
em discuss help
How to upgrade EM12c cloud control