Honestly speaking, I do not use OEM as they seem not so helpful to me? Or I am just blinded?
The Database Control URL is https://localhost:1158/em Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed in the file: c:/app/titanic.com/product/11.2.0/dbhome_1/localhost_orcl/sysman/config/emkey.ora. Please ensure this file is backed up as the encrypted data will become unusable if this file is lost. Enterprise Manager Database Control URL - (orcl) : https://localhost:1158/em
How do I add here the sql to install oem?
startup nomount; create database PROD logfile group 1 ('/oradata/PROD/redo01.log', '/oradata/PROD/redo01b.log') size 50M, group 2 ('/oradata/PROD/redo02.log', '/oradata/PROD/redo02b.log') size 50M, group 3 ('/oradata/PROD/redo03.log', '/oradata/PROD/redo03b.log') size 50M, group 4 ('/oradata/PROD/redo04.log', '/oradata/PROD/redo04b.log') size 50M character set AL32UTF8 datafile '/oradata/PROD/sysPROD.dbf' size 500M sysaux datafile '/oradata/PROD/auxPROD.dbf' size 300M undo tablespace undo datafile '/oradata/PROD/undoPROD.dbf' size 100M default temporary tablespace temp tempfile '/oradata/PROD/tempPROD.dbf' size 150M; @/opt/app/oracle/product/10.2.0/db_1/rdbms/admin/catalog.sql; @/opt/app/oracle/product/10.2.0/db_1/rdbms/admin/catproc.sql; connect system/manager; @/opt/app/oracle/product/10.2.0/db_1/sqlplus/admin/pupbld.sql; exit;
oracle@sdb51:~> emca -config dbcontrol db -repos createBut I got SEVERE error :( and not minor.
Apr 3, 2013 10:53:26 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /u01/app/oracle/product/10g/db_1/cfgtoollogs/emca/test1/emca_2013-04-03_10-49-20-PMlog. Apr 3, 2013 10:53:28 PM oracle.sysman.emcp.util.DBControlUtil stopOMS INFO: Stopping Database Control (this may take a while) ... Apr 3, 2013 10:53:32 PM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... Apr 3, 2013 10:53:32 PM oracle.sysman.emcp.EMReposConfig invoke SEVERE: Error creating the repository Apr 3, 2013 10:53:32 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Refer to the log file at /u01/app/oracle/product/10g/db_1/cfgtoollogs/emca/test1/emca_repos_create_<date>.log for more details. Apr 3, 2013 10:53:32 PM oracle.sysman.emcp.EMConfig perform SEVERE: Error creating the repository Refer to the log file at /u01/app/oracle/product/10g/db_1/cfgtoollogs/emca/test1/emca_2013-04-03_10-49-20-PM.log for more details. Could not complete the configuration. Refer to the log file at /u01/app/oracle/product/10g/db_1/cfgtoollogs/emca/test1/emca_2013-04-03_10-49-20-PM.log for more details.
Does this mean one only one OEM must be created under 10g OracleHome? How do I delete all installed OEM first to cleanup all?
ORA-06512: at line 17 oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-20001: SYSMAN already exists.. ORA-06512: at line 17
it's mention OEM Benefits for version 9.0.1 and you imagine 12c what features includedhaissst.... lots of new tools to study oem 9i , oem 10g, oem 11g , oem 12c :(