OraFAQ Forum: Enterprise Manager » Restoration EM after database is restored

Home » RDBMS Server » Enterprise Manager » Restoration EM after database is restored (oracle 10g 10.2.0.1.0 on linux 32 bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Restoration EM after database is restored [message #311487]

Fri, 04 April 2008 11:15

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

Report message to a moderator

Re: Restoration EM after database is restored [message #311501 is a reply to message #311487]

Fri, 04 April 2008 11:43

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.

Report message to a moderator

Re: Restoration EM after database is restored [message #311925 is a reply to message #311501]

Mon, 07 April 2008 06:57

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

Report message to a moderator

Re: Restoration EM after database is restored [message #312217 is a reply to message #311925]

Tue, 08 April 2008 04:11

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

Report message to a moderator

Re: Restoration EM after database is restored [message #313001 is a reply to message #312217]

Thu, 10 April 2008 05:46

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

Report message to a moderator

Previous Topic:	default quota on tablespace for user
Next Topic:	Performance charts do not show data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 11:53:39 CDT 2024