Skip to main content

How to recreate Oracle EM in linux

You may want to recreate Oracle Enterprise Manager due to several reasons..
Below are the details to recreate the EM.

Drop Database Console
To drop (remove) the configuration files and repository for Database Console, run:
$ emca -deconfig dbcontrol db -repos drop
 
------------------------------------------------------------------------------------------------------------------ 
Eg: 
[oracle@local ~]$ emca -deconfig dbcontrol db -repos drop

STARTED EMCA at Apr 6, 2011 11:46:55 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: my830
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:

Do you wish to continue? [yes(Y)/no(N)]: y
Apr 6, 2011 11:47:09 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/OraHome_1/cfgtoollogs/emca/my830/emca_2011-04-06_11-46-55-AM.log.
Apr 6, 2011 11:47:09 AM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Apr 6, 2011 11:47:16 AM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Apr 6, 2011 11:48:18 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Apr 6, 2011 11:48:18 AM
 
------------------------------------------------------------------------------------------------------------------------ 
 
In the case the above command is giving an error and you cannot drop the EM,
try to do it manually by executing below commands in SQLPLUS prompt.
 
sql> drop user sysman cascade;
sql> drop role mgmt_user;
sql> drop user mgmt_view cascade;
sql> drop public synonym MGMT_TARGET_BLACKOUTS;
sql> drop public synonym SETEMVIEWUSERCONTEXT;
Create Database Console
To create the configuration files and repository for Database Console, run:
$ emca -config dbcontrol db -repos create
 
--------------------------------------------------------------------------------------------------
Eg:
[oracle@local ~]$ emca -config dbcontrol db -repos create

STARTED EMCA at Apr 6, 2011 11:50:37 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: my830
Database SID: 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 ................ /u01/app/oracle/OraHome_1

Database hostname ................ local.test.com
Listener port number ................ 1521
Database SID ................ lin11830
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Apr 6, 2011 11:50:56 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/OraHome_1/cfgtoollogs/emca/my830/emca_2011-04-06_11-50-37-AM.log.
Apr 6, 2011 11:50:57 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Apr 6, 2011 11:53:00 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Apr 6, 2011 11:53:03 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Apr 6, 2011 11:54:38 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Apr 6, 2011 11:54:38 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://local.test:1158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Apr 6, 2011 11:54:38 AM
---------------------------------------------------------------------------------------------------

 
Recreate Database Console(This command is a collection of above two commands)
To recreate the configuration files and repository for Database Console, run:
$ emca -config dbcontrol db -repos recreate
 


Configure Database Console


$ emca -config dbcontrol db
 

Comments

Post a Comment

Popular posts from this blog

Building Continuous Data Trust with Oracle GoldenGate Veridata 26c

Today I'll discus on how we can build continuous data trust with Oracle GoldenGate Veridata 26c! As we accelerate towards hybrid and multi cloud architectures , one challenge keep coming up. That is "H ow do you trust your data across all these platforms?" With increasing data movement, replication, and transformation, even small changes can lead to major business risks. This is where Oracle GoldenGate Veridata 26c comes in handy! Rather than just validating data occasionally, the focus now is on continuous data trust . What is Veridata? It is a tool to compare data across different systems. It ensures source and target databases are in sync. It works during , Data migration, Replication setups, Ongoing operations. What’s new in Veridata 26c? 1. Support for Modern Architectures Built for hybrid, multi-cloud, and lakehouse environments with support for heterogeneous databases. 2. Continuous Data Validation Enables ongoing validation to detect data drift and inconsisten...
Post a Comment
Read more

Bring AI to Data , A Smarter Way with Oracle!

  “Bring AI to Data” is a term I recently heard during the Oracle AI World in Singapore last week and it really caught my attention. It sounded simple but the idea behind it is quite powerful. So I thought it’s worth exploring a bit more! Normally, working with data and AI meant one thing, which is, moving data around. We would extract data from databases, send it to external tools or platforms, build machine learning models and then push the results back into the database. But this approach adds complexity, increases costs and introduces security risks. But now, Oracle is changing that model by bringing AI to where the data already is ! The concept of “Bring AI to Data” is straightforward but powerful. Instead of moving large volumes of data across systems, Oracle allows you to run AI and machine learning directly inside the database. This means that data do not have to leave its secure environment. This results faster processing, reduced data duplication, improved security ...
Post a Comment
Read more

Why Oracle Cloud Infrastructure is powering the Next Generation of Enterprise Innovation

Oracle Cloud Infrastructure (OCI) is a modern cloud platform designed to help businesses run their applications faster, safer, and at lower cost. It supports companies of all sizes in moving their workloads to the cloud with confidence. OCI is built for high performance. Its advanced architecture allows applications, databases, and workloads to run smoothly with low latency. This makes it suitable for business critical systems, data analytics, and enterprise applications. Security is a core feature of Oracle Cloud. Data is encrypted by default, and strong identity and access controls help protect systems from threats. OCI also meets global compliance standards, making it a trusted choice for regulated industries. Oracle Cloud works especially well with Oracle databases and applications, offering better performance and efficiency. At the same time, it supports open source tools and technologies, allowing organizations to use the platforms and frameworks they already know. Oracle Cloud...
Post a Comment
Read more