Tom,

Does 10g grid control need seprate license or it is part of Enterprise Edition?

Thanks.

separately licensed

Tom,

One basic question :

I read many pages in asktom, where the name "dbconsole" used.

1. Are "dbconsole" and "dbcontrol" synonymous with respect to 10g EM atleast ?

2. I also read that "dbcontrol" method of EM method does not need "respository". But it does use "sysman" tables stored in "SYSAUX" Tablespace for that particular database.

Doesn't this mean that it needs/uses respository ?
Can you clarify this, please ?

3. The only difference between i understand is, "DBcontrol" users self-managed database respository as part of the database whereas "Grid control" needs dedicated repository database to manage/monitor multiple database systems. Is my understanding correct or not ?

3. Why do we need "Oracle Application Server" in the context of "EM setup for Oracle Grid Control" .
And OracleAS purpose in this.


Thanks for clarifying this up.


each will be available on a different port -- 5500, 5501, 5502 and so on.

dbconsole is designed for "an" instance only.

10g Grid control -- that can do many simultaneously.

Hi Tom,

I’m using OEM 9.2.0.1.0 and I have a problem to discover a node from a different domain.
I have to domains say domain1.com and domain2.com
So far all my databases were on domain1.com. Now we have a database running on a server at domain2.com.
I want to add this database to the database tree in OMS.
OMS is configured on domain1.com

The problem is that the new database has the same global name as one old database that is already discovered in the OMS. (say dbtest) Another important fact is that both servers have same name. (say serv1)

When I am trying to discover the new node, I am using IP address.
Discovery Wizard found the database running at that particular IP, but for the node name instead of serv1.domain2.com suggests serv1.domain1.com.

I have the same situation if I use server name instead of IP address. It is strange, it found the Entered Name, but for the node name OEM suggest serv1.domain1.com again.

My listener.ora, tnsnames.ora, and sqlnet.ora (on the target node) are properly configured (for host name I am using serv1.domain2.com and also I have included GLOBAL_DBNAME parameter in listener.ora.

Do you have any idea, why is this happening?

Thanks,
Michael

Hi Tom,

We have a combination of 8i,9i and 10g databases. Can we use 10g grid for monitoring these? Any pointers for the configuration/comaptibility of 10g grid control will be highly helpful.

thanks in advance,

Tom,

Reading OEM Documentation I saw the following:

>>
This metric checks for the total free space in the tablespace specified by the Tablespace name....
...
If the version of the monitored database target is Oracle Database 10g Release 1 or later, then the Oracle Database Server evaluates this metric internally every 10 minutes. Alternatively, if the version of the monitored Database target is Oracle 9i or earlier, then the Oracle Management Agent tests the value of this metric every 30 minutes...
<<

How should I understand that Oracle Database 10g Release 1 or later evaluates this metric internally every 10 minutes.
Is there a default database job for this? Where and how I can see the results of such internal evaluation?

Tom,

thanks for exact answer.

As far as I know we need a separate license to use AWR. Is is allowed to write our own code to get a status (per sql) from AWR repository tables?

Tom,

Do you need a license to access the OEM gui presentation of the information in the AWR tables, or can you run the script manually ($ORACLE_HOME/rdbms/admin/awrrpt.sql) without a license?

I ask because as far as I know, we have no extra license but that script/report works just fine.

My understanding of using OEM, Grid Control, & DBConsole is that you can use the basic features for free but need a separate license for certain packages. However, I was just told by the DBA group that they have stopped using OEM completely (not even to schedule a backup job) due to license issue raised by Oracle audit.

My question is: what feature in OEM/Grid Control/DBConsole that I can use without requiring a license. Thanks for the help.

Tom:

Is oracle 11g Grid control different Grid infrastructure component comes with 11g software ?

Another question,
I searched all over but i could not find any software/documentation for 11g Grid control. Is 11g Grid control released yet ?


Thank you

Hi Tom

From the above comments and the manuals, I have deduced the following - sounds too good to be true - so can you tell me where I have gone wrong.

1. Both db control and grid control are included with enterprise editions.

2. If implementing grid control for Enterprise edition databases no additional licensing is required for the grid control repository database, and no extra license required for Oracle Application Server Containers.

So both points mean either method comes with enterprise editions hence I can implement either without having to pay any additional costs?

Thanks in advance.

Luca

Tom:

Does oracle grid control system tell you whether existing issues in performance are in server or network.

We normally have very slow connections and db eprformance around nnon time. The dba metric alert for user logon time show it takes 300 seconds to connect to the database.

Is it possible to tell if it is the DB itself (unlikely), other DBs running all on same machine, the machine, or network.


Thanks

hit tom,
very useful info to know as a DBA but i've one question still uncleared. say we do not have performance pack license, can we still run $ORACLE_HOME/rdbms/admin/awtrpt.sql to genereat awr report?
thank you so much in advance ,please answer this to me as i'm hearing different answeres from other DBA from my team and no one really knows for sure.

If you could have a look at the screenshot of SQL Monitor here:

https://blogs.oracle.com/sql/entry/how_to_create_an_execution

I'm trying to understand why mine doesn't look like that. I recently was in Real World Performance team training where this was covered, and their OEM also looked like Chris's blog.

My OEM SQL Monitoring tabs look as follows:

Statistics | Activity | Plan | Plan Control |Tuning History | SQL Monitoring

None of which have all the cool information comparing expected vs actual results all in one matrix. Is it a version difference? I can't find a specific version in OEM anywhere other than the Cloud Control 12c when you log in.

Thanks,

select DBMS_SQLTUNE.REPORT_SQL_MONITOR(
  sql_id=>...,
  type=>'ACTIVE',
  report_level=>'ALL')
from dual

Thanks for the reply. I cannot reproduce the issue anymore. We upgraded to 12c over the weekend (database) and now I see the same view as Chris's blog.

I have one follow up question though, in the SQL Monitor I often see queries of ours where the duration is much higher than database time. Is database time the time spent processing the query, and so the additional time in the duration could be network or on fetches?

Getting following error for installing EM using dbca command on windows server with oracle database 11g Enterprise Edition.

following error extract from emca.log

CONFIG: Restoring oracle.installer.oui_loc to d:\app\oradba\product\11.2.0\dbhome_1\oui
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.EMConfig addEMCALogFile
CONFIG: ORACLE_BASE :d:\app\oradba
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.EMConfig restoreOuiLoc
CONFIG: Restoring oracle.installer.oui_loc to d:\app\oradba\product\11.2.0\dbhome_1\oui
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.EMConfig restoreOuiLoc
CONFIG: Restoring oracle.installer.oui_loc to d:\app\oradba\product\11.2.0\dbhome_1\oui
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at d:\app\oradba\cfgtoollogs\dbca\orcl\emConfig.log.
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.util.ClusterUtil isCRSInstalled
CONFIG: isCRSInstalled: false
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.EMConfig restoreOuiLoc
CONFIG: Restoring oracle.installer.oui_loc to d:\app\oradba\product\11.2.0\dbhome_1\oui
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.EMConfig restoreOuiLoc
CONFIG: Restoring oracle.installer.oui_loc to d:\app\oradba\product\11.2.0\dbhome_1\oui
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'CHECK_CONFIG' set to true
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ASM_OH.
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter REP_DB_RUNNING_HOST.
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager getHost
CONFIG: Host having instnces running for database orcl : DBSERVER
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: REP_DB_RUNNING_HOST value: DBSERVER
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager getRepDbPort
CONFIG: Listener Port: 1530
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
CONFIG: isLocalConnectionRequired: true
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: d:\app\oradba\product\11.2.0\dbhome_1, and user: SYS
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine created successfully and connected
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ASM_OH.
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager getHost
CONFIG: Host having instnces running for database orcl : DBSERVER
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: REP_DB_RUNNING_HOST value: DBSERVER
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager getRepDbPort
CONFIG: Listener Port: 1530
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
CONFIG: isLocalConnectionRequired: true
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: d:\app\oradba\product\11.2.0\dbhome_1, and user: DBSNMP
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine created successfully and connected
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager getHost
CONFIG: Host having instnces running for database orcl : DBSERVER
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: REP_DB_RUNNING_HOST value: DBSERVER
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager getRepDbPort
CONFIG: Listener Port: 1530
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
CONFIG: isLocalConnectionRequired: true
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: d:\app\oradba\product\11.2.0\dbhome_1, and user: SYS
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine created successfully and connected
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'asm_db' set to false
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.DatabaseChecks getDbServiceName
CONFIG: No service name available. Will try to set db_unique_name.db_domain
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager getHost
CONFIG: Host having instnces running for database orcl : DBSERVER
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: REP_DB_RUNNING_HOST value: DBSERVER
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager getRepDbPort
CONFIG: Listener Port: 1530
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
CONFIG: isLocalConnectionRequired: true
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: d:\app\oradba\product\11.2.0\dbhome_1, and user: SYS
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine created successfully and connected
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value:
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.DatabaseChecks getDbUniqueName
CONFIG: No Database unique name available. Will try to retrieve it from DB itself
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value: orcl
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_DOMAIN.
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.DatabaseChecks getDbDomain
CONFIG: No db domain available. Will query db for db_domain parameter
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value: orcl
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: SERVICE_NAME value: orcl
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DBID.
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.DatabaseChecks getDbid
CONFIG: No dbid available. Will query db to extract it.
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager getHost
CONFIG: Host having instnces running for database orcl : DBSERVER
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: REP_DB_RUNNING_HOST value: DBSERVER
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager getRepDbPort
CONFIG: Listener Port: 1530
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
CONFIG: isLocalConnectionRequired: true
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: d:\app\oradba\product\11.2.0\dbhome_1, and user: SYS
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine created successfully and connected
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DBID value: 156827926
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ASM_OH.
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager getHost
CONFIG: Host having instnces running for database orcl : DBSERVER
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: REP_DB_RUNNING_HOST value: DBSERVER
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager getRepDbPort
CONFIG: Listener Port: 1530
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
CONFIG: isLocalConnectionRequired: true
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: d:\app\oradba\product\11.2.0\dbhome_1, and user: SYSMAN
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine created successfully and connected
Oct 14, 2016 10:41:22 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getHost
CONFIG: Host having instnces running for database orcl : DBSERVER
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: REP_DB_RUNNING_HOST value: DBSERVER
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getRepDbPort
CONFIG: Listener Port: 1530
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
CONFIG: isLocalConnectionRequired: true
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: d:\app\oradba\product\11.2.0\dbhome_1, and user: SYS
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine created successfully and connected
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.EMDBPreConfig invoke
CONFIG: Passed repository configuration check
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter GLOBAL_DB_UNIQUE_NAME.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.DatabaseChecks getGlobalDbUniqueName
CONFIG: No Global database unique name available. Will try to retrieve it from DB itself
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getHost
CONFIG: Host having instnces running for database orcl : DBSERVER
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: REP_DB_RUNNING_HOST value: DBSERVER
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getRepDbPort
CONFIG: Listener Port: 1530
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
CONFIG: isLocalConnectionRequired: true
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: d:\app\oradba\product\11.2.0\dbhome_1, and user: SYS
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine created successfully and connected
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_DOMAIN.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.DatabaseChecks getDbDomain
CONFIG: No db domain available. Will query db for db_domain parameter
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: GLOBAL_DB_UNIQUE_NAME value: orcl
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Copying file d:\app\oradba\product\11.2.0\dbhome_1\sysman\config\emd.properties to d:\app\oradba\product\11.2.0\dbhome_1\sysman\config\emd.properties.emca.tmp
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.FileUtil backupFile
CONFIG: The original file d:\app\oradba\product\11.2.0\dbhome_1\sysman\config\emd.properties has been copied to d:\app\oradba\product\11.2.0\dbhome_1\sysman\config\emd.properties.emca.tmp
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Copying file d:\app\oradba\product\11.2.0\dbhome_1\sysman\config\emoms.properties to d:\app\oradba\product\11.2.0\dbhome_1\sysman\config\emoms.properties.emca.tmp
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.FileUtil backupFile
CONFIG: The original file d:\app\oradba\product\11.2.0\dbhome_1\sysman\config\emoms.properties has been copied to d:\app\oradba\product\11.2.0\dbhome_1\sysman\config\emoms.properties.emca.tmp
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Copying file d:\app\oradba\product\11.2.0\dbhome_1\sysman\emd\targets.xml to d:\app\oradba\product\11.2.0\dbhome_1\sysman\emd\targets.xml.emca.tmp
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.FileUtil backupFile
CONFIG: The original file d:\app\oradba\product\11.2.0\dbhome_1\sysman\emd\targets.xml has been copied to d:\app\oradba\product\11.2.0\dbhome_1\sysman\emd\targets.xml.emca.tmp
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.ClusterUtil isHASInstalled
CONFIG: isHAInstalled: false
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'IS_CENTRAL_AGENT_RECONFIG' set to false
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured
CONFIG: Sid: orcl Host: DBSERVER Node: null OH: d:\app\oradba\product\11.2.0\dbhome_1 agentHome: null isCentral: false
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
CONFIG: Sid: orcl Host: DBSERVER Node: null OH: d:\app\oradba\product\11.2.0\dbhome_1 isDBC: false
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'IS_CENTRAL_AGENT_CONFIGURED' set to false
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'IS_DBCONTROL_CONFIGURED' set to false
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter AGENT_PORT.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter RMI_PORT.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter JMS_PORT.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
CONFIG: Sid: orcl Host: DBSERVER Node: null OH: d:\app\oradba\product\11.2.0\dbhome_1 isDBC: false
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter PORTS_FILE.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter JMS_PORT_DBSERVER.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter JMS_PORT.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter RMI_PORT_DBSERVER.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter RMI_PORT.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT_DBSERVER.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter AGENT_PORT_DBSERVER.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter AGENT_PORT.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc
CONFIG: Setting oracle.installer.oui_loc to d:\app\oradba\product\11.2.0\dbhome_1\oui
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Homes to scan for used ports: [d:\app\oradba\product\11.2.0\dbhome_1]
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Searching all DBConsole instances for used ports under ORACLE_HOME d:\app\oradba\product\11.2.0\dbhome_1
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking JMS port: null from d:\app\oradba\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking RMI port: null from d:\app\oradba\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking HTTP port: null from d:\app\oradba\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.PortManager getAgentPort
CONFIG: Cannot parse EMD_URL correctly. No port identified
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking Agent port: null from d:\app\oradba\product\11.2.0\dbhome_1\sysman\config\emd.properties
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Cannnot parse EMD_URL correctly. No port identified
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.FileUtil getProperties
CONFIG: Error reading file d:\app\oradba\product\11.2.0\dbhome_1\install\staticports.ini
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.PortManager getFreePorts
CONFIG: d:\app\oradba\product\11.2.0\dbhome_1:DBSERVER:null:orcl:{}:null:{DBCONTROL_HTTP_PORT=1158, RMI_PORT=5520, JMS_PORT=5540, AGENT_PORT=3938}
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter AGENT_PORT_DBSERVER.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: AGENT_PORT_DBSERVER value: 3938
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT_DBSERVER.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DBCONTROL_HTTP_PORT_DBSERVER value: 1158
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter JMS_PORT_DBSERVER.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: JMS_PORT_DBSERVER value: 5540
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter RMI_PORT_DBSERVER.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: RMI_PORT_DBSERVER value: 5520
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.EMDBPreConfig getFreePorts
CONFIG: Ports assigned for Node: DBSERVER : {DBCONTROL_HTTP_PORT=1158, RMI_PORT=5520, JMS_PORT=5540, AGENT_PORT=3938}
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.EMDBPreConfig copyAgentTimeStampFile
CONFIG: File: d:\app\oradba\product\11.2.0\dbhome_1\DBSERVER_orcl\sysman\emd\agntstmp.txt:DBSERVER does not exists.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getHost
CONFIG: Host having instnces running for database orcl : DBSERVER
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: REP_DB_RUNNING_HOST value: DBSERVER
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getRepDbPort
CONFIG: Listener Port: 1530
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
CONFIG: isLocalConnectionRequired: true
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: d:\app\oradba\product\11.2.0\dbhome_1, and user: SYS
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine created successfully and connected
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.EMReposConfig unlockAccounts
CONFIG: Unlocking dbsnmp and sysman
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.EMReposConfig invoke
CONFIG: Successfully unlocked relevant accounts
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getHost
CONFIG: Host having instnces running for database orcl : DBSERVER
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: REP_DB_RUNNING_HOST value: DBSERVER
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.ParamsManager getRepDbPort
CONFIG: Listener Port: 1530
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
CONFIG: isLocalConnectionRequired: true
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: d:\app\oradba\product\11.2.0\dbhome_1, and user: SYS
Oct 14, 2016 10:41:23 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine created successfully and connected
Oct 14, 2016 10:41:25 AM oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs
CONFIG: Finished executing emreposoutofbox.sql
Oct 14, 2016 10:41:25 AM oracle.sysman.emcp.ParamsManager getHost
CONFIG: Host having instnces running for database orcl : DBSERVER
Oct 14, 2016 10:41:25 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: REP_DB_RUNNING_HOST value: DBSERVER
Oct 14, 2016 10:41:25 AM oracle.sysman.emcp.ParamsManager getRepDbPort
CONFIG: Listener Port: 1530
Oct 14, 2016 10:41:25 AM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
CONFIG: isLocalConnectionRequired: true
Oct 14, 2016 10:41:25 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
Oct 14, 2016 10:41:25 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: d:\app\oradba\product\11.2.0\dbhome_1, and user: SYSMAN
Oct 14, 2016 10:41:26 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine created successfully and connected
Oct 14, 2016 10:41:26 AM oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs
CONFIG: Submitting dbms job: d:\app\oradba\product\11.2.0\dbhome_1\sysman\admin\emdrep\sql\core\latest\admin\admin_submit_dbms_jobs.sql
Oct 14, 2016 10:41:26 AM oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs
CONFIG: Successfully submitted dbms job
Oct 14, 2016 10:41:26 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Oct 14, 2016 10:41:26 AM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
CONFIG: connectDesc : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=DBSERVER)(PORT=

Oct 14, 2016 10:41:35 AM oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
CONFIG: Unlocked mgmt_view account
Oct 14, 2016 10:41:35 AM oracle.sysman.emcp.EMReposConfig invoke
CONFIG: Successfully unlocked mgmt_view account
Oct 14, 2016 10:41:35 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Oct 14, 2016 10:41:35 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Oct 14, 2016 10:44:52 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
CONFIG: Error uploading configuration data to the repository
oracle.sysman.emdrep.config.ConfigurationException: FATAL Configuration Exceptions

at oracle.sysman.emdrep.config.EMSchemaConfiguration.perform(EMSchemaConfiguration.java:232)
at oracle.sysman.emcp.EMReposConfig.uploadConfigDataToRepository(EMReposConfig.java:699)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:385)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
at oracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:583)
at oracle.sysman.assistants.util.em.EMConfigStep.executeImpl(EMConfigStep.java:139)
at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
at oracle.sysman.assistants.util.step.BasicStep.callStep(BasicStep.java:251)
at oracle.sysman.assistants.dbca.backend.PostDBConfigureStep.executeImpl(PostDBConfigureStep.java:269)
at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2667)
at java.lang.Thread.run(Thread.java:595)
Oct 14, 2016 10:44:52 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at d:\app\oradba\cfgtoollogs\emca\orcl\emca_repos_config_<date>.log for more details.
Oct 14, 2016 10:44:52 AM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error uploading configuration data to the repository
Oct 14, 2016 10:44:52 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Error uploading configuration data to the repository
Refer to the log file at d:\app\oradba\cfgtoollogs\dbca\orcl\emConfig.log for more details.
Oct 14, 2016 10:44:52 AM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Error uploading configuration data to the repository
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:397)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
at oracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:583)
at oracle.sysman.assistants.util.em.EMConfigStep.executeImpl(EMConfigStep.java:139)
at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
at oracle.sysman.assistants.util.step.BasicStep.callStep(BasicStep.java:251)
at oracle.sysman.assistants.dbca.backend.PostDBConfigureStep.executeImpl(PostDBConfigureStep.java:269)
at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2667)
at java.lang.Thread.run(Thread.java:595)
Oct 14, 2016 10:44:52 AM oracle.sysman.emcp.EMConfig restoreOuiLoc
CONFIG: Restoring oracle.installer.oui_loc to d:\app\oradba\product\11.2.0\dbhome_1\oui