Ugh please help , been at this for hours! I messed up my oracle dbconsole and now the dbconsole service itself is gone!
So I dropped and recreate em repos but got the ff error msg:
but when trying to creating it --- it's stoped at this error massage from log file
ORA-06512: at line 38
oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-24344: success with compilation error
ORA-06512: at line 38
-first i trying to drop it
C:\Users\Administrator>emca -deconfig dbcontrol db -repos drop
STARTED EMCA at Aug 22, 2018 5:23:24 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: live
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: y
Aug 22, 2018 5:23:38 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at E:\oracle\product\10.2.0\db_1\cfgtoollog
s\emca\live\emca_2018-08-22_05-23-24-PM.log.
Aug 22, 2018 5:23:43 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be p
erformed.
Aug 22, 2018 5:23:43 PM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Aug 22, 2018 5:24:42 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Aug 22, 2018 5:24:42 PM
-----------------------------------
Second
trying to recreate it
with --- >> emca -config dbcontrol db -repos create
C:\Users\Administrator>emca -config dbcontrol db -repos create
STARTED EMCA at Aug 22, 2018 5:29:41 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: live
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Password for SYSMAN user: Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ................ E:\oracle\product\10.2.0\db_1
Database hostname ................ server11
Listener port number ................ 1521
Database SID ................ live
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Aug 22, 2018 5:30:31 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at E:\oracle\product\10.2.0\db_1\cfgtoollog
s\emca\live\emca_2018-08-22_05-29-41-PM.log.
Aug 22, 2018 5:30:48 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Aug 22, 2018 5:31:41 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error creating the repository
Aug 22, 2018 5:31:41 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at E:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\li
ve\emca_repos_create_<date>.log for more details.
Aug 22, 2018 5:31:41 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error creating the repository
Refer to the log file at E:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\live\emc
a_2018-08-22_05-29-41-PM.log for more details.
Could not complete the configuration. Refer to the log file at E:\oracle\product
\10.2.0\db_1\cfgtoollogs\emca\live\emca_2018-08-22_05-29-41-PM.log for more deta
ils.
===================================================
log file
Aug 22, 2018 5:29:41 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag '-config' set to true
Aug 22, 2018 5:29:41 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'UPDATE_EMAIL' set to true
Aug 22, 2018 5:29:41 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'dbcontrol' set to true
Aug 22, 2018 5:29:41 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'db' set to true
Aug 22, 2018 5:29:41 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'create' set to true
Aug 22, 2018 5:29:41 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: ORACLE_HOME value: E:\oracle\product\10.2.0\db_1
Aug 22, 2018 5:29:41 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Aug 22, 2018 5:29:41 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: EM_HOME value: E:\oracle\product\10.2.0\db_1
Aug 22, 2018 5:29:45 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: SID value: live
Aug 22, 2018 5:29:45 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Aug 22, 2018 5:29:45 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: Cluster.isCluster: false. Skip call to getLocalNode
Aug 22, 2018 5:29:45 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
Aug 22, 2018 5:29:45 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Aug 22, 2018 5:29:45 PM oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
CONFIG: Sid: live Host: server11 Node: null OH: E:\oracle\product\10.2.0\db_1 isDBC: false
Aug 22, 2018 5:29:45 PM oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured
CONFIG: Sid: live Host: server11 Node: null OH: E:\oracle\product\10.2.0\db_1 agentHome: null isCentral: false
Aug 22, 2018 5:29:45 PM oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured
CONFIG: Sid: live Host: server11 Node: null OH: E:\oracle\product\10.2.0\db_1 agentHome: null isCentral: false
Aug 22, 2018 5:29:45 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter SYS_PWD.
Aug 22, 2018 5:29:45 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: live, oracleHome: E:\oracle\product\10.2.0\db_1, and user:
Aug 22, 2018 5:29:46 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Aug 22, 2018 5:29:46 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'asm_db' set to false
Aug 22, 2018 5:29:46 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'asm_db' set to false
Aug 22, 2018 5:30:12 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: PORT value: 1521
Aug 22, 2018 5:30:15 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter SYS_PWD.
Aug 22, 2018 5:30:15 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: live, oracleHome: E:\oracle\product\10.2.0\db_1, and user: SYS
Aug 22, 2018 5:30:16 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Aug 22, 2018 5:30:19 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: live, oracleHome: E:\oracle\product\10.2.0\db_1, and user: DBSNMP
Aug 22, 2018 5:30:21 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Aug 22, 2018 5:30:27 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: EMAIL_ADDRESS value:
Aug 22, 2018 5:30:28 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: MAIL_SERVER_NAME value:
Aug 22, 2018 5:30:28 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Aug 22, 2018 5:30:28 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: CONFIRMATION ANSWER value:
Aug 22, 2018 5:30:29 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: CONFIRMATION ANSWER value: yes
Aug 22, 2018 5:30:29 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter LOG_FILE.
Aug 22, 2018 5:30:29 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
Aug 22, 2018 5:30:29 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
Aug 22, 2018 5:30:29 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: live, oracleHome: E:\oracle\product\10.2.0\db_1, and user: SYS
Aug 22, 2018 5:30:31 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Aug 22, 2018 5:30:31 PM oracle.sysman.emcp.DatabaseChecks getDbUniqueName
CONFIG: No Database unique name available. Will try to retrieve it from DB itself
Aug 22, 2018 5:30:31 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value: live
Aug 22, 2018 5:30:31 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at E:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\live\emca_2018-08-22_05-29-41-PM.log.
Aug 22, 2018 5:30:31 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'CHECK_CONFIG' set to true
Aug 22, 2018 5:30:31 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: live, oracleHome: E:\oracle\product\10.2.0\db_1, and user: SYS
Aug 22, 2018 5:30:33 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Aug 22, 2018 5:30:33 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: live, oracleHome: E:\oracle\product\10.2.0\db_1, and user: DBSNMP
Aug 22, 2018 5:30:34 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Aug 22, 2018 5:30:34 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
Aug 22, 2018 5:30:34 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: live, oracleHome: E:\oracle\product\10.2.0\db_1, and user: SYS
Aug 22, 2018 5:30:36 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Aug 22, 2018 5:30:36 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'asm_db' set to false
Aug 22, 2018 5:30:36 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
Aug 22, 2018 5:30:36 PM oracle.sysman.emcp.DatabaseChecks getDbServiceName
CONFIG: No service name available. Will try to set db_unique_name.db_domain
Aug 22, 2018 5:30:36 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: live, oracleHome: E:\oracle\product\10.2.0\db_1, and user: SYS
Aug 22, 2018 5:30:37 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Aug 22, 2018 5:30:37 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value:
Aug 22, 2018 5:30:37 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
Aug 22, 2018 5:30:37 PM oracle.sysman.emcp.DatabaseChecks getDbUniqueName
CONFIG: No Database unique name available. Will try to retrieve it from DB itself
Aug 22, 2018 5:30:37 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value: live
Aug 22, 2018 5:30:37 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_DOMAIN.
Aug 22, 2018 5:30:37 PM oracle.sysman.emcp.DatabaseChecks getDbDomain
CONFIG: No db domain available. Will query db for db_domain parameter
Aug 22, 2018 5:30:37 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value: live
Aug 22, 2018 5:30:37 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: SERVICE_NAME value: live
Aug 22, 2018 5:30:37 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
Aug 22, 2018 5:30:37 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DBID.
Aug 22, 2018 5:30:37 PM oracle.sysman.emcp.DatabaseChecks getDbid
CONFIG: No dbid available. Will query db to extract it.
Aug 22, 2018 5:30:37 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: live, oracleHome: E:\oracle\product\10.2.0\db_1, and user: SYS
Aug 22, 2018 5:30:39 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Aug 22, 2018 5:30:39 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DBID value: 699022860
Aug 22, 2018 5:30:39 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Aug 22, 2018 5:30:39 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Aug 22, 2018 5:30:39 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'db' set to true
Aug 22, 2018 5:30:39 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
Aug 22, 2018 5:30:39 PM oracle.sysman.emcp.DatabaseChecks getDbServiceName
CONFIG: No service name available. Will try to set db_unique_name.db_domain
Aug 22, 2018 5:30:39 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: live, oracleHome: E:\oracle\product\10.2.0\db_1, and user: SYS
Aug 22, 2018 5:30:41 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Aug 22, 2018 5:30:41 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value:
Aug 22, 2018 5:30:41 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
Aug 22, 2018 5:30:41 PM oracle.sysman.emcp.DatabaseChecks getDbUniqueName
CONFIG: No Database unique name available. Will try to retrieve it from DB itself
Aug 22, 2018 5:30:41 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value: live
Aug 22, 2018 5:30:41 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_DOMAIN.
Aug 22, 2018 5:30:41 PM oracle.sysman.emcp.DatabaseChecks getDbDomain
CONFIG: No db domain available. Will query db for db_domain parameter
Aug 22, 2018 5:30:41 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value: live
Aug 22, 2018 5:30:41 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: SERVICE_NAME value: live
Aug 22, 2018 5:30:41 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter EMAIL_ADDRESS.
Aug 22, 2018 5:30:41 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MAIL_SERVER_NAME.
Aug 22, 2018 5:30:41 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: live, oracleHome: E:\oracle\product\10.2.0\db_1, and user: SYS
Aug 22, 2018 5:30:42 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Aug 22, 2018 5:30:42 PM oracle.sysman.emcp.EMDBPreConfig invoke
CONFIG: Passed repository configuration check
Aug 22, 2018 5:30:42 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
Aug 22, 2018 5:30:42 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
Aug 22, 2018 5:30:42 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter GLOBAL_DB_UNIQUE_NAME.
Aug 22, 2018 5:30:42 PM oracle.sysman.emcp.DatabaseChecks getGlobalDbUniqueName
CONFIG: No Global database unique name available. Will try to retrieve it from DB itself
Aug 22, 2018 5:30:42 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: live, oracleHome: E:\oracle\product\10.2.0\db_1, and user: SYS
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_DOMAIN.
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.DatabaseChecks getDbDomain
CONFIG: No db domain available. Will query db for db_domain parameter
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: GLOBAL_DB_UNIQUE_NAME value: live
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file E:\oracle\product\10.2.0\db_1\sysman\config\emd.properties to E:\oracle\product\10.2.0\db_1\sysman\config\emd.properties.emca.tmp
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.FileUtil backupFile
CONFIG: The original file E:\oracle\product\10.2.0\db_1\sysman\config\emd.properties has been copied to E:\oracle\product\10.2.0\db_1\sysman\config\emd.properties.emca.tmp
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file E:\oracle\product\10.2.0\db_1\sysman\config\emoms.properties to E:\oracle\product\10.2.0\db_1\sysman\config\emoms.properties.emca.tmp
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.FileUtil backupFile
CONFIG: The original file E:\oracle\product\10.2.0\db_1\sysman\config\emoms.properties has been copied to E:\oracle\product\10.2.0\db_1\sysman\config\emoms.properties.emca.tmp
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file E:\oracle\product\10.2.0\db_1\sysman\emd\targets.xml to E:\oracle\product\10.2.0\db_1\sysman\emd\targets.xml.emca.tmp
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.FileUtil backupFile
CONFIG: The original file E:\oracle\product\10.2.0\db_1\sysman\emd\targets.xml has been copied to E:\oracle\product\10.2.0\db_1\sysman\emd\targets.xml.emca.tmp
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'IS_CENTRAL_AGENT_RECONFIG' set to false
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured
CONFIG: Sid: live Host: server11 Node: null OH: E:\oracle\product\10.2.0\db_1 agentHome: null isCentral: false
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
CONFIG: Sid: live Host: server11 Node: null OH: E:\oracle\product\10.2.0\db_1 isDBC: false
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'IS_CENTRAL_AGENT_CONFIGURED' set to false
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'IS_DBCONTROL_CONFIGURED' set to false
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT.
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter AGENT_PORT.
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter RMI_PORT.
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter JMS_PORT.
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
CONFIG: Sid: live Host: server11 Node: null OH: E:\oracle\product\10.2.0\db_1 isDBC: false
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter PORTS_FILE.
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter JMS_PORT_live.
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter JMS_PORT.
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter RMI_PORT_live.
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter RMI_PORT.
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT_live.
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT.
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter AGENT_PORT_live.
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter AGENT_PORT.
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc
CONFIG: Setting oracle.installer.oui_loc to E:\oracle\product\10.2.0\db_1\oui
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc
CONFIG: Setting oracle.installer.oui_loc to E:\oracle\product\10.2.0\db_1\oui
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Homes to scan for used ports: [E:\oracle\product\10.2.0\db_1]
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Searching all DBConsole instances for used ports under ORACLE_HOME E:\oracle\product\10.2.0\db_1
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking JMS port: null from E:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking RMI port: null from E:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking HTTP port: null from E:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking JMS port: 5544 from E:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_server11_live
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking JMS port: 5540 from E:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_server11_live
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking RMI port: 5520 from E:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_server11_live
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking HTTP port: 1158 from E:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_server11_live
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking Agent port: 1832 from E:\oracle\product\10.2.0\db_1\server11_live\sysman\config\emd.properties
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking Agent port: 3938 from E:\oracle\product\10.2.0\db_1\server11_live\sysman\config\emd.properties
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.PortManager getAgentPort
CONFIG: Cannot parse EMD_URL correctly. No port identified
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking Agent port: null from E:\oracle\product\10.2.0\db_1\sysman\config\emd.properties
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Cannnot parse EMD_URL correctly. No port identified
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.FileUtil getProperties
CONFIG: Error reading file E:\oracle\product\10.2.0\db_1\install\staticports.ini
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.PortManager getFreePorts
CONFIG: E:\oracle\product\10.2.0\db_1:server11:null:live:{}:null:{DBCONTROL_HTTP_PORT=5500, RMI_PORT=5521, JMS_PORT=5541, AGENT_PORT=1831}
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter AGENT_PORT_live.
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: AGENT_PORT_live value: 1831
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT_live.
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DBCONTROL_HTTP_PORT_live value: 5500
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter JMS_PORT_live.
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: JMS_PORT_live value: 5541
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter RMI_PORT_live.
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: RMI_PORT_live value: 5521
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.EMDBPreConfig getFreePorts
CONFIG: Ports assigned for SID: live : {DBCONTROL_HTTP_PORT=5500, RMI_PORT=5521, JMS_PORT=5541, AGENT_PORT=1831}
Aug 22, 2018 5:30:44 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: live, oracleHome: E:\oracle\product\10.2.0\db_1, and user: SYS
Aug 22, 2018 5:30:48 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Aug 22, 2018 5:30:48 PM oracle.sysman.emcp.EMReposConfig createRepository
CONFIG: Spooling to E:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\live\emca_repos_create_2018-08-22_05-30-48-PM.log
Aug 22, 2018 5:30:48 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Aug 22, 2018 5:31:41 PM oracle.sysman.emcp.EMReposConfig createRepository
CONFIG: ORA-24344: success with compilation error
ORA-06512: at line 38 oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException:
ORA-24344: success with compilation error
ORA-06512: at line 38
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1474)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:848)
at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:267)
at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:308)
at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:422)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:192)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:134)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:171)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:486)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1142)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:470)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:419)
Aug 22, 2018 5:31:41 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error creating the repository
Aug 22, 2018 5:31:41 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at E:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\live\emca_repos_create_<date>.log for more details.
Aug 22, 2018 5:31:41 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error creating the repository
Refer to the log file at E:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\live\emca_2018-08-22_05-29-41-PM.log for more details.
Aug 22, 2018 5:31:41 PM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Error creating the repository
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:204)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:134)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:171)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:486)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1142)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:470)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:419)