nobleit
asked on
emctl and database console
11g is installed in the system
I tried to start database console using emctl and services.msc
both of them did not work.
Result is shown below.
Also log file for the error is copied below.
Could you please help me to figure out the issue..
C:\Documents and Settings\Mathew>set oracle_sid=orcl
C:\Documents and Settings\Mathew>emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://98.238.175.93:1158/em/console/aboutApplication
EM Daemon is not running.
-------------------------- ---------- ---------- ---------- ----------
Logs are generated in directory C:\app\Mathew\product\11.1 .0\db_1/98 .238.175.9 3_
orcl/sysman/log
C:\Documents and Settings\Mathew>emctl stop dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://98.238.175.93:1158/em/console/aboutApplication
The OracleDBConsoleorcl service is not started.
More help is available by typing NET HELPMSG 3521.
C:\Documents and Settings\Mathew>emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://98.238.175.93:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ...The OracleDBConsoleor
cl service is starting...............
The OracleDBConsoleorcl service could not be started.
A service specific error occurred: 2.
More help is available by typing NET HELPMSG 3547.
Also log file for the error is copied below.
2011-03-25 00:05:52 Thread-3252 WARN http: snmehl_connect: connect failed to (98.238.175.93:3938): No connection could be made because the target machine actively refused it.
(error = 10061)
2011-03-25 00:05:52 Thread-3252 ERROR main: nmectla_agentctl: Error connecting to http://98.238.175.93:3938/emd/main. Returning status code 1
2011-03-25 00:06:14 Thread-412 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 00:06:15 Thread-412 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 00:09:35 Thread-3992 WARN http: snmehl_connect: connect failed to (98.238.175.93:3938): No connection could be made because the target machine actively refused it.
(error = 10061)
2011-03-25 00:09:35 Thread-3992 ERROR main: nmectla_agentctl: Error connecting to https://98.238.175.93:3938/emd/main. Returning status code 1
2011-03-25 00:29:59 Thread-3716 WARN http: snmehl_connect: connect failed to (98.238.175.93:1158): No connection could be made because the target machine actively refused it.
(error = 10061)
2011-03-25 00:30:01 Thread-2712 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 00:30:02 Thread-2712 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 00:30:44 Thread-988 WARN http: snmehl_connect: connect failed to (98.238.175.93:3938): No connection could be made because the target machine actively refused it.
(error = 10061)
2011-03-25 00:30:44 Thread-988 ERROR main: nmectla_agentctl: Error connecting to https://98.238.175.93:3938/emd/main. Returning status code 1
2011-03-25 00:30:56 Thread-1168 WARN http: snmehl_connect: connect failed to (98.238.175.93:3938): No connection could be made because the target machine actively refused it.
(error = 10061)
2011-03-25 00:30:56 Thread-1168 ERROR main: nmectla_agentctl: Error connecting to https://98.238.175.93:3938/emd/main. Returning status code 1
2011-03-25 00:31:31 Thread-3860 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 00:31:32 Thread-3860 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 00:32:04 Thread-3276 WARN http: snmehl_connect: connect failed to (98.238.175.93:3938): No connection could be made because the target machine actively refused it.
(error = 10061)
2011-03-25 00:32:04 Thread-3276 ERROR main: nmectla_agentctl: Error connecting to https://98.238.175.93:3938/emd/main. Returning status code 1
2011-03-25 00:33:02 Thread-4028 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 00:33:04 Thread-4028 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 00:33:32 Thread-3576 WARN http: snmehl_connect: connect failed to (98.238.175.93:3938): No connection could be made because the target machine actively refused it.
(error = 10061)
2011-03-25 00:33:32 Thread-3576 ERROR main: nmectla_agentctl: Error connecting to https://98.238.175.93:3938/emd/main. Returning status code 1
2011-03-25 00:34:57 Thread-208 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 00:34:58 Thread-208 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 00:35:28 Thread-3336 WARN http: snmehl_connect: connect failed to (98.238.175.93:3938): No connection could be made because the target machine actively refused it.
(error = 10061)
2011-03-25 00:35:28 Thread-3336 ERROR main: nmectla_agentctl: Error connecting to https://98.238.175.93:3938/emd/main. Returning status code 1
2011-03-25 00:35:49 Thread-3040 WARN http: snmehl_connect: connect failed to (98.238.175.93:3938): No connection could be made because the target machine actively refused it.
(error = 10061)
2011-03-25 00:35:49 Thread-3040 ERROR main: nmectla_agentctl: Error connecting to https://98.238.175.93:3938/emd/main. Returning status code 1
2011-03-25 00:36:20 Thread-280 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 00:36:21 Thread-280 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 00:36:51 Thread-1616 WARN http: snmehl_connect: connect failed to (98.238.175.93:3938): No connection could be made because the target machine actively refused it.
(error = 10061)
2011-03-25 00:36:51 Thread-1616 ERROR main: nmectla_agentctl: Error connecting to https://98.238.175.93:3938/emd/main. Returning status code 1
2011-03-25 01:33:37 Thread-3388 WARN http: snmehl_connect: connect failed to (98.238.175.93:1158): No connection could be made because the target machine actively refused it.
(error = 10061)
2011-03-25 01:34:07 Thread-3680 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 01:34:08 Thread-3680 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 01:34:47 Thread-2468 WARN http: snmehl_connect: connect failed to (98.238.175.93:3938): No connection could be made because the target machine actively refused it.
(error = 10061)
2011-03-25 01:34:47 Thread-2468 ERROR main: nmectla_agentctl: Error connecting to https://98.238.175.93:3938/emd/main. Returning status code 1
I tried to start database console using emctl and services.msc
both of them did not work.
Result is shown below.
Also log file for the error is copied below.
Could you please help me to figure out the issue..
C:\Documents and Settings\Mathew>set oracle_sid=orcl
C:\Documents and Settings\Mathew>emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://98.238.175.93:1158/em/console/aboutApplication
EM Daemon is not running.
--------------------------
Logs are generated in directory C:\app\Mathew\product\11.1
orcl/sysman/log
C:\Documents and Settings\Mathew>emctl stop dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://98.238.175.93:1158/em/console/aboutApplication
The OracleDBConsoleorcl service is not started.
More help is available by typing NET HELPMSG 3521.
C:\Documents and Settings\Mathew>emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://98.238.175.93:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ...The OracleDBConsoleor
cl service is starting...............
The OracleDBConsoleorcl service could not be started.
A service specific error occurred: 2.
More help is available by typing NET HELPMSG 3547.
Also log file for the error is copied below.
2011-03-25 00:05:52 Thread-3252 WARN http: snmehl_connect: connect failed to (98.238.175.93:3938): No connection could be made because the target machine actively refused it.
(error = 10061)
2011-03-25 00:05:52 Thread-3252 ERROR main: nmectla_agentctl: Error connecting to http://98.238.175.93:3938/emd/main. Returning status code 1
2011-03-25 00:06:14 Thread-412 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 00:06:15 Thread-412 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 00:09:35 Thread-3992 WARN http: snmehl_connect: connect failed to (98.238.175.93:3938): No connection could be made because the target machine actively refused it.
(error = 10061)
2011-03-25 00:09:35 Thread-3992 ERROR main: nmectla_agentctl: Error connecting to https://98.238.175.93:3938/emd/main. Returning status code 1
2011-03-25 00:29:59 Thread-3716 WARN http: snmehl_connect: connect failed to (98.238.175.93:1158): No connection could be made because the target machine actively refused it.
(error = 10061)
2011-03-25 00:30:01 Thread-2712 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 00:30:02 Thread-2712 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 00:30:44 Thread-988 WARN http: snmehl_connect: connect failed to (98.238.175.93:3938): No connection could be made because the target machine actively refused it.
(error = 10061)
2011-03-25 00:30:44 Thread-988 ERROR main: nmectla_agentctl: Error connecting to https://98.238.175.93:3938/emd/main. Returning status code 1
2011-03-25 00:30:56 Thread-1168 WARN http: snmehl_connect: connect failed to (98.238.175.93:3938): No connection could be made because the target machine actively refused it.
(error = 10061)
2011-03-25 00:30:56 Thread-1168 ERROR main: nmectla_agentctl: Error connecting to https://98.238.175.93:3938/emd/main. Returning status code 1
2011-03-25 00:31:31 Thread-3860 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 00:31:32 Thread-3860 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 00:32:04 Thread-3276 WARN http: snmehl_connect: connect failed to (98.238.175.93:3938): No connection could be made because the target machine actively refused it.
(error = 10061)
2011-03-25 00:32:04 Thread-3276 ERROR main: nmectla_agentctl: Error connecting to https://98.238.175.93:3938/emd/main. Returning status code 1
2011-03-25 00:33:02 Thread-4028 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 00:33:04 Thread-4028 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 00:33:32 Thread-3576 WARN http: snmehl_connect: connect failed to (98.238.175.93:3938): No connection could be made because the target machine actively refused it.
(error = 10061)
2011-03-25 00:33:32 Thread-3576 ERROR main: nmectla_agentctl: Error connecting to https://98.238.175.93:3938/emd/main. Returning status code 1
2011-03-25 00:34:57 Thread-208 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 00:34:58 Thread-208 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 00:35:28 Thread-3336 WARN http: snmehl_connect: connect failed to (98.238.175.93:3938): No connection could be made because the target machine actively refused it.
(error = 10061)
2011-03-25 00:35:28 Thread-3336 ERROR main: nmectla_agentctl: Error connecting to https://98.238.175.93:3938/emd/main. Returning status code 1
2011-03-25 00:35:49 Thread-3040 WARN http: snmehl_connect: connect failed to (98.238.175.93:3938): No connection could be made because the target machine actively refused it.
(error = 10061)
2011-03-25 00:35:49 Thread-3040 ERROR main: nmectla_agentctl: Error connecting to https://98.238.175.93:3938/emd/main. Returning status code 1
2011-03-25 00:36:20 Thread-280 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 00:36:21 Thread-280 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 00:36:51 Thread-1616 WARN http: snmehl_connect: connect failed to (98.238.175.93:3938): No connection could be made because the target machine actively refused it.
(error = 10061)
2011-03-25 00:36:51 Thread-1616 ERROR main: nmectla_agentctl: Error connecting to https://98.238.175.93:3938/emd/main. Returning status code 1
2011-03-25 01:33:37 Thread-3388 WARN http: snmehl_connect: connect failed to (98.238.175.93:1158): No connection could be made because the target machine actively refused it.
(error = 10061)
2011-03-25 01:34:07 Thread-3680 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 01:34:08 Thread-3680 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-480,and testTZoffset for America/Los_Angeles:-420 do not match
2011-03-25 01:34:47 Thread-2468 WARN http: snmehl_connect: connect failed to (98.238.175.93:3938): No connection could be made because the target machine actively refused it.
(error = 10061)
2011-03-25 01:34:47 Thread-2468 ERROR main: nmectla_agentctl: Error connecting to https://98.238.175.93:3938/emd/main. Returning status code 1
Hi,
check your listener is started are not, go to run ->services.msc->TNSListene r and start it.
OR
run->cmd->lsnrctl status it should give u the status if not start it
lsnrctl start.
after that start the emctl start dbconsole
but if you have not configured it you can manually confirgue it, check this below doc for more info.
http://mehmoodm.blogspot.com/2010/05/enterprise-manager-db-console-set-up.html
check your listener is started are not, go to run ->services.msc->TNSListene
OR
run->cmd->lsnrctl status it should give u the status if not start it
lsnrctl start.
after that start the emctl start dbconsole
but if you have not configured it you can manually confirgue it, check this below doc for more info.
http://mehmoodm.blogspot.com/2010/05/enterprise-manager-db-console-set-up.html
'target machine actively refused it.' >> check you firewall settings. If enabled, disable it and try again.
P
P
Oh, and it might effectively be the listener who refuses the connection. Make sure the parameter SQLNET.AUTHENTICATION_SERV ICES is set to (NONE) in your sqlnet.ora file.
P
P
ASKER
I did this shows error...log file at the bottom
C:\Documents and Settings\Mathew>emca -repos create
STARTED EMCA at Mar 26, 2011 12:45:33 AM
EM Configuration Assistant, Version 11.1.0.5.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: orcl
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: Y
Mar 26, 2011 12:46:03 AM oracle.sysman.emcp.EMConfi g perform
INFO: This operation is being logged at C:\app\Mathew\cfgtoollogs\ emca\orcl\ emca
_2011_03_26_00_45_33.log.
Mar 26, 2011 12:46:03 AM oracle.sysman.emcp.EMRepos Config createRepository
INFO: Creating the EM repository (this may take a while) ...
Mar 26, 2011 12:46:03 AM oracle.sysman.emcp.EMRepos Config invoke
SEVERE: Error creating the repository
Mar 26, 2011 12:46:03 AM oracle.sysman.emcp.EMRepos Config invoke
INFO: Refer to the log file at C:\app\Mathew\cfgtoollogs\ emca\orcl\ emca_repos _cr
eate_<date>.log for more details.
Mar 26, 2011 12:46:03 AM oracle.sysman.emcp.EMConfi g perform
SEVERE: Error creating the repository
Refer to the log file at C:\app\Mathew\cfgtoollogs\ emca\orcl\ emca_2011_ 03_26_00_
45_33.log for more details.
Could not complete the configuration. Refer to the log file at C:\app\Mathew\cfg
toollogs\emca\orcl\emca_20 11_03_26_0 0_45_33.lo g for more details.
-------------------------- -
log
Mar 25, 2011 1:34:43 AM oracle.sysman.emcp.ParamsM anager setFlag
CONFIG: Flag '-migrate' set to false
Mar 25, 2011 1:34:43 AM oracle.sysman.emcp.ParamsM anager setFlag
CONFIG: Flag 'migrateFromDBControl' set to false
Mar 25, 2011 1:34:43 AM oracle.sysman.emcp.ParamsM anager setFlag
CONFIG: Flag 'migrateToCentralAgent' set to false
Mar 25, 2011 1:34:43 AM oracle.sysman.emcp.ParamsM anager setFlag
CONFIG: Flag 'migrateFromCentralAgent' set to false
Mar 25, 2011 1:34:43 AM oracle.sysman.emcp.ParamsM anager setFlag
CONFIG: Flag 'migrateToDBControl' set to false
Mar 25, 2011 1:34:43 AM oracle.sysman.emcp.ParamsM anager setParam
CONFIG: Setting param: ORACLE_HOME value: C:\app\Mathew\product\11.1 .0\db_1
C:\Documents and Settings\Mathew>emca -repos create
STARTED EMCA at Mar 26, 2011 12:45:33 AM
EM Configuration Assistant, Version 11.1.0.5.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: orcl
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: Y
Mar 26, 2011 12:46:03 AM oracle.sysman.emcp.EMConfi
INFO: This operation is being logged at C:\app\Mathew\cfgtoollogs\
_2011_03_26_00_45_33.log.
Mar 26, 2011 12:46:03 AM oracle.sysman.emcp.EMRepos
INFO: Creating the EM repository (this may take a while) ...
Mar 26, 2011 12:46:03 AM oracle.sysman.emcp.EMRepos
SEVERE: Error creating the repository
Mar 26, 2011 12:46:03 AM oracle.sysman.emcp.EMRepos
INFO: Refer to the log file at C:\app\Mathew\cfgtoollogs\
eate_<date>.log for more details.
Mar 26, 2011 12:46:03 AM oracle.sysman.emcp.EMConfi
SEVERE: Error creating the repository
Refer to the log file at C:\app\Mathew\cfgtoollogs\
45_33.log for more details.
Could not complete the configuration. Refer to the log file at C:\app\Mathew\cfg
toollogs\emca\orcl\emca_20
--------------------------
log
Mar 25, 2011 1:34:43 AM oracle.sysman.emcp.ParamsM
CONFIG: Flag '-migrate' set to false
Mar 25, 2011 1:34:43 AM oracle.sysman.emcp.ParamsM
CONFIG: Flag 'migrateFromDBControl' set to false
Mar 25, 2011 1:34:43 AM oracle.sysman.emcp.ParamsM
CONFIG: Flag 'migrateToCentralAgent' set to false
Mar 25, 2011 1:34:43 AM oracle.sysman.emcp.ParamsM
CONFIG: Flag 'migrateFromCentralAgent' set to false
Mar 25, 2011 1:34:43 AM oracle.sysman.emcp.ParamsM
CONFIG: Flag 'migrateToDBControl' set to false
Mar 25, 2011 1:34:43 AM oracle.sysman.emcp.ParamsM
CONFIG: Setting param: ORACLE_HOME value: C:\app\Mathew\product\11.1
ASKER
Here is the sqlnet.
How can I make modification..
# sqlnet.ora Network Configuration File: C:\app\Mathew\product\11.1 .0\db_1\ne twork\admi n\sqlnet.o ra
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERV ICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
How can I make modification..
# sqlnet.ora Network Configuration File: C:\app\Mathew\product\11.1
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERV
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
hi,
please let us know your listener is up and running and you are able to login to database in sql*plus
i.e command promt
C:\Documents and Settings\Mathew>set oracle_sid=orcl
C:\Documents and Settings\Mathew>sqlplus " / as sysdba"
please let us know your listener is up and running and you are able to login to database in sql*plus
i.e command promt
C:\Documents and Settings\Mathew>set oracle_sid=orcl
C:\Documents and Settings\Mathew>sqlplus " / as sysdba"
ASKER
C:\Documents and Settings\Mathew>set oracle_sid=orcl
C:\Documents and Settings\Mathew>sqlplus /nolog
SQL*Plus: Release 11.1.0.6.0 - Production on Sat Mar 26 08:43:48 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> select name from v$database;
NAME
---------
ORCL
SQL>
hi,
Also you have checked the listener is up and running?
C:\Documents and Settings\Mathew>lsntctl
lsnrctl> status
if this is up and running, try below command to reconfigure the OEM
C:\Documents and Settings\Mathew>emca -config dbcontrol db -repos recreate
Also you have checked the listener is up and running?
C:\Documents and Settings\Mathew>lsntctl
lsnrctl> status
if this is up and running, try below command to reconfigure the OEM
C:\Documents and Settings\Mathew>emca -config dbcontrol db -repos recreate
ASKER
This is what I did
not configured..
C:\Documents and Settings\Mathew>lsnrctl
LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 26-MAR-2011 17:21
:40
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PRO TOCOL=IPC) (KEY=EXTPR OC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.1.0.6.0 - Produ
ction
Start Date 26-MAR-2011 17:19:53
Uptime 0 days 0 hr. 2 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\app\Mathew\product\11.1 .0\db_1\ne twork\admi n\listen
er.ora
Listener Log File c:\app\mathew\diag\tnslsnr \home\list ener\alert \log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PRO TOCOL=ipc) (PIPENAME= \\.\pipe\E XTPROC1521 ipc)))
(DESCRIPTION=(ADDRESS=(PRO TOCOL=tcp) (HOST=98.2 38.175.93) (PORT=1521 )))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl_XPT" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> exit
C:\Documents and Settings\Mathew>emca -config dbcontrol db -repos recreate
STARTED EMCA at Mar 26, 2011 6:22:44 PM
EM Configuration Assistant, Version 11.1.0.5.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: orcl
Database Control is already configured for the database orcl
You have chosen to configure Database Control for managing the database orcl
This will remove the existing configuration and the default settings and perform
a fresh configuration
Do you wish to continue? [yes(Y)/no(N)]: Y
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 ................ C:\app\Mathew\product\11.1 .0\db_1
Local hostname ................ 98.238.175.93
Listener port number ................ 1521
Database SID ................ orcl
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-------------------------- ---------- ---------- ---------- ---------
Do you wish to continue? [yes(Y)/no(N)]: Y
Mar 26, 2011 6:25:14 PM oracle.sysman.emcp.EMConfi g perform
INFO: This operation is being logged at C:\app\Mathew\cfgtoollogs\ emca\orcl\ emca
_2011_03_26_18_22_44.log.
Mar 26, 2011 6:25:17 PM oracle.sysman.emcp.util.DB ControlUti l stopOMS
INFO: Stopping Database Control (this may take a while) ...
Mar 26, 2011 6:25:19 PM oracle.sysman.emcp.EMRepos Config invoke
INFO: Dropping the EM repository (this may take a while) ...
Mar 26, 2011 6:29:33 PM oracle.sysman.emcp.EMRepos Config invoke
INFO: Repository successfully dropped
Mar 26, 2011 6:29:33 PM oracle.sysman.emcp.EMRepos Config createRepository
INFO: Creating the EM repository (this may take a while) ...
Mar 26, 2011 6:41:31 PM oracle.sysman.emcp.EMRepos Config invoke
INFO: Repository successfully created
Mar 26, 2011 6:41:39 PM oracle.sysman.emcp.EMRepos Config uploadConfigDataToRepos
itory
INFO: Uploading configuration data to EM repository (this may take a while) ...
Mar 26, 2011 6:43:25 PM oracle.sysman.emcp.EMRepos Config invoke
INFO: Uploaded configuration data successfully
Mar 26, 2011 6:43:56 PM oracle.sysman.emcp.util.DB ControlUti l configureSoftwareL
ib
INFO: Software library configured successfully.
Mar 26, 2011 6:43:56 PM oracle.sysman.emcp.EMDBPos tConfig configureSoftwareLibra
ry
INFO: Deploying Provisioning archives ...
Mar 26, 2011 6:45:49 PM oracle.sysman.emcp.EMDBPos tConfig configureSoftwareLibra
ry
INFO: Provisioning archives deployed successfully.
Mar 26, 2011 6:45:53 PM oracle.sysman.emcp.util.DB ControlUti l secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Mar 26, 2011 6:47:25 PM oracle.sysman.emcp.util.DB ControlUti l secureDBConsole
INFO: Database Control secured successfully.
Mar 26, 2011 6:47:26 PM oracle.sysman.emcp.util.DB ControlUti l startOMS
INFO: Starting Database Control (this may take a while) ...
Mar 26, 2011 6:52:36 PM oracle.sysman.emcp.EMConfi g perform
SEVERE: Error starting Database Control
Refer to the log file at C:\app\Mathew\cfgtoollogs\ emca\orcl\ emca_2011_ 03_26_18_
22_44.log for more details.
Could not complete the configuration. Refer to the log file at C:\app\Mathew\cfg
toollogs\emca\orcl\emca_20 11_03_26_1 8_22_44.lo g for more details.
C:\Documents and Settings\Mathew>
not configured..
C:\Documents and Settings\Mathew>lsnrctl
LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 26-MAR-2011 17:21
:40
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PRO
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.1.0.6.0 - Produ
ction
Start Date 26-MAR-2011 17:19:53
Uptime 0 days 0 hr. 2 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\app\Mathew\product\11.1
er.ora
Listener Log File c:\app\mathew\diag\tnslsnr
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PRO
(DESCRIPTION=(ADDRESS=(PRO
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl_XPT" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> exit
C:\Documents and Settings\Mathew>emca -config dbcontrol db -repos recreate
STARTED EMCA at Mar 26, 2011 6:22:44 PM
EM Configuration Assistant, Version 11.1.0.5.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: orcl
Database Control is already configured for the database orcl
You have chosen to configure Database Control for managing the database orcl
This will remove the existing configuration and the default settings and perform
a fresh configuration
Do you wish to continue? [yes(Y)/no(N)]: Y
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 ................ C:\app\Mathew\product\11.1
Local hostname ................ 98.238.175.93
Listener port number ................ 1521
Database SID ................ orcl
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
--------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Mar 26, 2011 6:25:14 PM oracle.sysman.emcp.EMConfi
INFO: This operation is being logged at C:\app\Mathew\cfgtoollogs\
_2011_03_26_18_22_44.log.
Mar 26, 2011 6:25:17 PM oracle.sysman.emcp.util.DB
INFO: Stopping Database Control (this may take a while) ...
Mar 26, 2011 6:25:19 PM oracle.sysman.emcp.EMRepos
INFO: Dropping the EM repository (this may take a while) ...
Mar 26, 2011 6:29:33 PM oracle.sysman.emcp.EMRepos
INFO: Repository successfully dropped
Mar 26, 2011 6:29:33 PM oracle.sysman.emcp.EMRepos
INFO: Creating the EM repository (this may take a while) ...
Mar 26, 2011 6:41:31 PM oracle.sysman.emcp.EMRepos
INFO: Repository successfully created
Mar 26, 2011 6:41:39 PM oracle.sysman.emcp.EMRepos
itory
INFO: Uploading configuration data to EM repository (this may take a while) ...
Mar 26, 2011 6:43:25 PM oracle.sysman.emcp.EMRepos
INFO: Uploaded configuration data successfully
Mar 26, 2011 6:43:56 PM oracle.sysman.emcp.util.DB
ib
INFO: Software library configured successfully.
Mar 26, 2011 6:43:56 PM oracle.sysman.emcp.EMDBPos
ry
INFO: Deploying Provisioning archives ...
Mar 26, 2011 6:45:49 PM oracle.sysman.emcp.EMDBPos
ry
INFO: Provisioning archives deployed successfully.
Mar 26, 2011 6:45:53 PM oracle.sysman.emcp.util.DB
INFO: Securing Database Control (this may take a while) ...
Mar 26, 2011 6:47:25 PM oracle.sysman.emcp.util.DB
INFO: Database Control secured successfully.
Mar 26, 2011 6:47:26 PM oracle.sysman.emcp.util.DB
INFO: Starting Database Control (this may take a while) ...
Mar 26, 2011 6:52:36 PM oracle.sysman.emcp.EMConfi
SEVERE: Error starting Database Control
Refer to the log file at C:\app\Mathew\cfgtoollogs\
22_44.log for more details.
Could not complete the configuration. Refer to the log file at C:\app\Mathew\cfg
toollogs\emca\orcl\emca_20
C:\Documents and Settings\Mathew>
ASKER
AND this is the C:\app\Mathew\cfg
toollogs\emca\orcl\emca_20 11_03_26_1 8_22_44.lo g
Please help I tried my best..thank you
Mar 26, 2011 4:30:44 PM oracle.sysman.emcp.ParamsM anager setFlag
CONFIG: Flag '-migrate' set to false
Mar 26, 2011 4:30:44 PM oracle.sysman.emcp.ParamsM anager setFlag
CONFIG: Flag 'migrateFromDBControl' set to false
Mar 26, 2011 4:30:44 PM oracle.sysman.emcp.ParamsM anager setFlag
CONFIG: Flag 'migrateToCentralAgent' set to false
Mar 26, 2011 4:30:44 PM oracle.sysman.emcp.ParamsM anager setFlag
CONFIG: Flag 'migrateFromCentralAgent' set to false
Mar 26, 2011 4:30:44 PM oracle.sysman.emcp.ParamsM anager setFlag
CONFIG: Flag 'migrateToDBControl' set to false
Mar 26, 2011 4:30:44 PM oracle.sysman.emcp.ParamsM anager setParam
CONFIG: Setting param: ORACLE_HOME value: C:\app\Mathew\product\11.1 .0\db_1
toollogs\emca\orcl\emca_20
Please help I tried my best..thank you
Mar 26, 2011 4:30:44 PM oracle.sysman.emcp.ParamsM
CONFIG: Flag '-migrate' set to false
Mar 26, 2011 4:30:44 PM oracle.sysman.emcp.ParamsM
CONFIG: Flag 'migrateFromDBControl' set to false
Mar 26, 2011 4:30:44 PM oracle.sysman.emcp.ParamsM
CONFIG: Flag 'migrateToCentralAgent' set to false
Mar 26, 2011 4:30:44 PM oracle.sysman.emcp.ParamsM
CONFIG: Flag 'migrateFromCentralAgent' set to false
Mar 26, 2011 4:30:44 PM oracle.sysman.emcp.ParamsM
CONFIG: Flag 'migrateToDBControl' set to false
Mar 26, 2011 4:30:44 PM oracle.sysman.emcp.ParamsM
CONFIG: Setting param: ORACLE_HOME value: C:\app\Mathew\product\11.1
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
no other version is running...
ip address is communicatable.
I am sending e-mails and receiving e-mails also..
Thanks
ip address is communicatable.
I am sending e-mails and receiving e-mails also..
Thanks
Hi,
If you have an metalink account check this, It may be this issue
MetaLink note 757897.1: EMCA fails with "SEVERE: Error starting Database Control"
http://metalink.oracle.com
Since you are on a Windows PC, try a bounce.
You may have a RAM leak, or failed service process . .
If you have an metalink account check this, It may be this issue
MetaLink note 757897.1: EMCA fails with "SEVERE: Error starting Database Control"
http://metalink.oracle.com
Since you are on a Windows PC, try a bounce.
You may have a RAM leak, or failed service process . .
Hi,
Sorry I had no net connection to follow since today.... I see you still have your pb. And the last log you posted is not a big help....
----
Since you have reconfigured your dbconsole, could you just issue again : 'emctl start dbconsole' and confirm you still have those erros as at the beginning ? The 'TZ%' related ones ?
I'm thinking abut a timezones issue (your host seems to have one TZ set, and your database is configured on some other TZ).
If this is the case, you will have to drop the dbconsole configuration (emca) -> then set the env variable called TZ -> then reconfigure the dbconsole -> then try to start it again.
----
If you don't have anymore those TZ, please post the new log with other errors...
P
Sorry I had no net connection to follow since today.... I see you still have your pb. And the last log you posted is not a big help....
----
Since you have reconfigured your dbconsole, could you just issue again : 'emctl start dbconsole' and confirm you still have those erros as at the beginning ? The 'TZ%' related ones ?
I'm thinking abut a timezones issue (your host seems to have one TZ set, and your database is configured on some other TZ).
If this is the case, you will have to drop the dbconsole configuration (emca) -> then set the env variable called TZ -> then reconfigure the dbconsole -> then try to start it again.
----
If you don't have anymore those TZ, please post the new log with other errors...
P
Have you configured the dbconsole when you have installed the database ? In other words, have you checked the Entreprise Manager checkbox when you used dbca to create the database ?
If not, you won't be able to strat it as long as you have not configured it. To configure, just use emca :
emca -repos create
emca -config dbcontrol db
You will have to answer some questions and wait a few minutes to complete. Then you will be able to start the dbconsole.
Cheers,
P