Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
How to re-install Enterprise Manager for Oracle database 11gR2
Bhavin Dave-Oracle
Member Posts: 11 Employee
Hi,
I installed Oracle database 11gR2 on Windows 7 with 4 GB of physical memory and over 200 GB of free disk space. Just before the finish screen a warning indicated that Enterprise Manager could not be setup and asked me to execute a few commands through command-line to configure it.
Just as I executed the first command the antivirus installed on my laptop deleted a lot of files relating to Enterprise Manager as it detected threats from them. Currently the database works fine but I'm unable to figure out how to get the Enterprise Manager up.
Is there a way to re-install Enterprise Manager for the database already installed?
I installed Oracle database 11gR2 on Windows 7 with 4 GB of physical memory and over 200 GB of free disk space. Just before the finish screen a warning indicated that Enterprise Manager could not be setup and asked me to execute a few commands through command-line to configure it.
Just as I executed the first command the antivirus installed on my laptop deleted a lot of files relating to Enterprise Manager as it detected threats from them. Currently the database works fine but I'm unable to figure out how to get the Enterprise Manager up.
Is there a way to re-install Enterprise Manager for the database already installed?
Tagged:
Answers
-
are you refering to Database control when you say Enterprise manager in your above post?
-
Affirmative.
-
Hi Friend,
To drop and recreate DBConsole configuration files and repository using a single command, run below EMCA command.
This command will recreate the DBConsole configuration files and DBConsole repository for the Database.
<ORACLE_HOME>/bin/emca -config dbcontrol db -repos recreate
Enter the following information:
Database SID: <sid>
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Listener port number: <Port>
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]:Y
Log Files will store in the below location :
--------------------------------------------
/home/oracle/app/oracle/cfgtoollogs/emca/orcl/emca_with_date.log
Thanks
LaserSoft -
Hi LaserSoft,
The antivirus has deleted many important files like the emca, emagent.exe etc.
Hence the command-line is unable to recognize the emca command and proceed.
Thanks.
Bhavin Dave -
It means ORACLE_HOME files are missing , please restore the files if you have a backup .
Or reinstall oracle in new home and move your existing database to new home and then retry.
Regards
Rajesh -
Hi Rajesh,
I did a fresh installation after deinstalling the previously created database. The Database Configuration Assistant was unable to setup Enterprise Manager once again.
On following the steps mentioned above by LaserSoft I got the following output :
e:\app\Bhavin\product\11.2.0\dbhome_1\BIN>emca -config dbcontrol db -repos recreate
STARTED EMCA at Dec 9, 2012 2:17:51 AM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: ocp11g
Listener port number: 1521
Listener ORACLE_HOME [ E:\app\Bhavin\product\11.2.0\dbhome_1 ]: y
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:\app\Bhavin\product\11.2.0\dbhome_1
Local hostname ................ Bhavin-PC
Listener ORACLE_HOME ................ y
Listener port number ................ 1521
Database SID ................ ocp11g
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Dec 9, 2012 2:18:16 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at E:\app\Bhavin\cfgtoollogs\emca\ocp11g\em
ca_2012_12_09_02_17_51.log.
Dec 9, 2012 2:18:28 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Listener is not up or database service is not registered with it. Start
the Listener and register database service and run EM Configuration Assistant ag
ain .
Refer to the log file at E:\app\Bhavin\cfgtoollogs\emca\ocp11g\emca_2012_12_09_0
2_17_51.log for more details.
Could not complete the configuration. Refer to the log file at E:\app\Bhavin\cfg
toollogs\emca\ocp11g\emca_2012_12_09_02_17_51.log for more details.
--------------------------------------------------
LISTENER.ORA
--------------------------------------------------
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = E:\app\Bhavin\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:E:\app\Bhavin\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
ADR_BASE_LISTENER = E:\app\Bhavin
------------------------------------------------------
TNSNAMES.ORA
------------------------------------------------------
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
OCP11G =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ocp11g)
)
)
LISTENER_OCP11G =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Also I'm able to tnsping and lsnrctl.exe states the listener LISTENER as started.
e:\app\Bhavin\product\11.2.0\dbhome_1\BIN>tnsping ocp11g
TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 09-DEC-2
012 02:34:46
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
E:\app\Bhavin\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhos
t)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ocp11g)))
OK (0 msec)
e:\app\Bhavin\product\11.2.0\dbhome_1\BIN>lsnrctl start listener
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 09-DEC-2012 02:35
:46
Copyright (c) 1991, 2010, Oracle. All rights reserved.
TNS-01106: Listener using listener name LISTENER has already been started
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Thanks.
Bhavin Dave
This discussion has been closed.