Version: em12c12.1.0.4OS: redhat5.7x86 _ 64bit (CentOS6.2, tested, due to glibc *. i686 package installation has always reported an error, so I gave up) em12c installation, don't talk about it, click it online, or view the official documentation: here involves some parameter configuration: ChecktheCBOstatsgatheringjobDisablethe
Version: em12c 12.1.0.4 OS: redhat 5.7 x86_64bit (CentOS6.2, tested, due to glibc *. i686 package installation always reports an error, so give up) = em12c installation, don't talk about it, click it online, or view the official documentation: = here involves some parameter configurations: check the CBO stats gathering jobDisable
Version: em12c 12.1.0.4 OS: redhat 5.7 x86_64bit (CentOS6.2, tested. At that time, due to glibc *. i686 package installation error, I gave up)
==> After em12c is installed, you can skip this step. You can click here on the Internet or view the official documentation:
==> Here some parameter configurations are involved:
Check the CBO stats gathering jobDisable the stats gathering job 1.Check the processes instance parameter value The processes instance parameter needs to be set to at least 300. 2.Check the session_cached_cursors instance parameter value. The session_cached_cursors instance parameter should be set to 300. Any value between 200 and 500, inclusive, will be accepted. 3.Check the job_queue_processes instance parameter value. The job_queue_processes instance parameter should be set to 20. 4.Check the shared_pool_size instance parameter value. The shared_pool_size instance parameter should be set to at least 600 megabytes or roughly one third of the sga_target size. 5. Check the redo log size. The size of the EM database instance should be 300 megabytes or greater. Generally, there should be 3 or more redo logs available of this size. 6. Ensure that the EM tablespace has at least one datafile set to autoextensible Add at least one datafile with the autoextend attribute to the EM tablespace 7.Check the open_cursors instance parameter value. The open_cursors instance parameter should be set between 300 and 400, inclusive. 8.Check the sga_target instance parameter value. The sga_target instance parameter should be set to at least 2 gigabytes, and roughly twice the size of the pga_aggregate_target setting. 9.Check for invalid objects in the EM repository Compile all invalid objects in the EM repository
==> If you have installed EM in your db, this command can help you:
[Oracle @ em12c ~] $ Emca-deconfig dbcontrol db-repos drop-SYS_PWD password-SYSMAN_PWD passwordStarted emca at Jul 24,201 4 10:13:13 am em Configuration Assistant, Version 11.2.0.3.0 Production Copyright (c) 2003,201 1, Oracle. all rights reserved. enter the following information: Database SID: em12c Listener port number: 1521 running WARNING: While repository is dropped the database will be put in quiesce mode. ---------------- ------------------------------------------------------ Do you wish to continue? [Yes (Y)/no (N)]: Y Jul 24,201 4 10:13:22 AM oracle. sysman. emcp. EMConfig perform INFO: This operation is being logged at/dba/app/oracle/export toollogs/emca/em12c/emca_2014_07_24_10_13_12.log. jul 24,201 4 10:13:23 AM oracle. sysman. emcp. util. DBControlUtil stopOMS INFO: Stopping Database Control (this may take a while )... jul 24,201 4 10:13:46 AM oracle. sysman. emcp. EMReposConfig invoke INFO: Dropping the EM repository (this may take a while )... jul 24,201 4 10:15:57 AM oracle. sysman. emcp. EMReposConfig invoke INFO: Repository successfully dropped Enterprise Manager configuration completed successfully finished emca at Jul 24,201 4 10:16:00 AM
On the monitored server, set the sudo command: ---/usr/local/etc/sudoers #
# Allow root to run any commands anywhere root ALL = (ALL) ALL oracle ALL = (ALL) ALL --> Add a row
# Defaults requiretty --> comment out Defaults: oracle! Requiretty --> Add oracle # Refuse to run if unable to disable echo on the tty. this setting shoshould also be # changed in order to be able to use sudo without a tty. see requiretty above. # Defaults! Visiblepw --> comment out Defaults visiblepw --> Add
==> The monitored Server and agent are uninstalled. In fact, the EM12C master server is uninstalled in the same way. It involves some tablespaces in sysman and sysaux.) (1) uninstall the plug-in eg: [oracle @ dominic4 plugins] $ pwd
/Em12c/plugins
[Oracle @ dominic4 plugins] $ ls
Oracle. em. savf. discovery. plugin_12.1.0.2.0 oracle. sysman. emas. discovery in_12.1.0.6.0
Oracle. em. soav. discovery. plugin_12.1.0.4.0 oracle. sysman. oh. agent. plugin_12.1.0.4.0
Oracle. sysman. db. agent. plugin_12.1.0.6.0 oracle. sysman. oh. discovery. plugin_12.1.0.4.0
Oracle. sysman. db. discovery. plugin_12.1.0.6.0 oracle. sysman. xa. discovery. plugin_12.1.0.6.0
[Oracle @ dominic4 ~] $/Em12c/core/12.1.0.4.0/oui/bin/runInstaller-deinstall-silent "REMOVE_HOMES = {/em12c/plugins/oracle. sysman. xa. discovery. plugin_12.1.0.6.0,/em12c/plugins/oracle. sysman. db. discovery. plugin_12.1.0.6.0,/em12c/plugins/oracle. sysman. db. agent. plugin_12.1.0.6.0} "-removeALLFiles-invPtrLoc/etc/oraInst. loc
---- All oracle. * under plugins must be deleted.
(2) uninstall sbin
[Oracle @ dominic4 ~] $/Em12c/core/12.1.0.4.0/oui/bin/runInstaller-deinstall-silent "REMOVE_HOMES = {/em12c/sbin}"-removeALLFiles-invPtrLoc/etc/oraInst. loc
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 3498 MB Passed
Preparing to launch Oracle Universal Installer from/tmp/OraInstall2014-08-11_11-59-57AM. Please wait... [oracle @ dominic4 ~] $ Oracle Universal Installer, Version 11.1.0.12.0 Production
Copyright (C) 1999,201 4, Oracle. All rights reserved.
Starting deinstall
Deinstall in progress (Monday, August 11,201 4 12:00:01 pm cst)
........................................ ....................... 100% Done.
Deinstall successful
End of install phases. (Monday, August 11,201 4 12:00:02 pm cst)
End of deinstallations
Please check'/dba/app/oraInventory/logs/silentInstall2014-08-11_11-59-57AM.log 'for more details.
(3) uninstall the agent home [oracle @ dominic4 ~] $/Em12c/core/12.1.0.4.0/oui/bin/runInstaller-deinstall-silent "REMOVE_HOMES = {/em12c/core/12.1.0.4.0}"-removeALLFiles-invPtrLoc/etc/oraInst. loc
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 3498 MB Passed
Preparing to launch Oracle Universal Installer from/tmp/OraInstall2014-08-11_12-03-20PM. Please wait... [oracle @ dominic4 ~] $ Oracle Universal Installer, Version 11.1.0.12.0 Production
Copyright (C) 1999,201 4, Oracle. All rights reserved.
Starting deinstall
Deinstall in progress (Monday, August 11,201 4 12:03:23 pm cst)
Configuration assistant "Agent Deinstall Assistant" succeeded
........................................ ....................... 100% Done.
Deinstall successful
End of install phases. (Monday, August 11,201 4 12:04:18 pm cst) End of deinstallations Please check'/dba/app/oraInventory/logs/silentInstall2014-08-11_12-03-20PM.log 'for more details. (4) Delete A directory
Rm-rf/em12c /*
History-c