Home » RDBMS Server » Enterprise Manager » Restoration EM after database is restored (oracle 10g 10.2.0.1.0 on linux 32 bit)
Restoration EM after database is restored [message #311487] Fri, 04 April 2008 11:15 Go to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
I have restored Oracle database 10g after creating Disaster recovery scenario in Test db.
But all running fine now except enterprise manager, when i write command

emctl status dbconsole
result is
TZ set to GB-Eire
OC4J Configuration issue. /u01/app/oracle/product/10.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_localhost_test not found.

then i look at it and shift all the contents of folder (OC4J_DBConsole)in the same place to OC4J_DBConsole_localhost_test after creating it

After it again when i write command
emctl status dbconsole
TZ set to GB-Eire
EM Configuration issue. /u01/app/oracle/product/10.2.0/db_1/localhost_test not found.

When i am trying to recreate EM by using following command
emca -config dbcontrol db -repos recreate
it is hanging after i insert SID name

Re: Restoration EM after database is restored [message #311501 is a reply to message #311487] Fri, 04 April 2008 11:43 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Make Sure you oracle_home,oracle_base,oracle_sid and time zone are properly set.
Re: Restoration EM after database is restored [message #311925 is a reply to message #311501] Mon, 07 April 2008 06:57 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
i am settiing ORACLE_HOME and ORACLE_SID before running emca, but it is still hanging after i am providing SID
Re: Restoration EM after database is restored [message #312217 is a reply to message #311925] Tue, 08 April 2008 04:11 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Do anybody have any suggestion for EM restoration, what about Database configuration assistant,does it work
Re: Restoration EM after database is restored [message #313001 is a reply to message #312217] Thu, 10 April 2008 05:46 Go to previous message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
i have deinstall and reinstall the EM again from Universal installer but when i tried to start emctl sart dbconsole, start failed then i start to remove depository by following

emca -deconfig dbcontrol db -repos drop

but it was hanging.

then i remove the repository manually by following

SQL> execute sysman.emd_maintenance.remove_em_dbms_jobs;

PL/SQL procedure successfully completed.

SQL> DROP USER mgmt_view CASCADE;

User dropped.

SQL> DROP ROLE mgmt_user;

Role dropped.

SQL> DROP USER sysman CASCADE;

now when i am trying to create new depositiory it is again hanging after getting SID

STARTED EMCA at 10-Apr-2008 12:02:20
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: test

Is there anybody who can help me
Previous Topic: default quota on tablespace for user
Next Topic: Performance charts do not show data
Goto Forum:
  


Current Time: Wed Dec 07 20:27:17 CST 2016

Total time taken to generate the page: 0.12844 seconds