Contents
To set system password
1 |
ALTER USER system IDENTIFIED BY password; |
EM Cloud control help
1 2 3 4 5 6 7 8 |
#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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
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
1 2 3 4 5 6 7 8 9 |
# 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
1 2 3 4 5 |
# 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
1 |
select * from database_properties where property_name='DEFAULT_PERMANENT_TABLESPACE' |
To change the default tablespace from users to system
1 |
alter database default tablespace system; |
To drop the users tablespace, you first need to change the defualt to system
1 |
drop tablespace USERS; |
Now re-create the SYSTEM tablespace
1 |
CREATE TABLESPACE USERS datafile; |
To Change back the default to users
1 |
alter database default tablespace system; |
To add another tablespace to users
1 |
alter tablespace users add datafile '+DATA'; |
To a all tablespcase files
1 |
select file_name from dba_data_files where tablespace_name='USRS'; |
To see a list of tablespacess
1 |
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
1 2 3 |
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<rn> 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
Leave a Reply