OraFAQ Forum: RAC & Failsafe » EM stop working during impdp on RAC

Home » Server Options » RAC & Failsafe » EM stop working during impdp on RAC

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

EM stop working during impdp on RAC [message #658340]

Fri, 09 December 2016 11:52

DevilzAdvocate
Messages: 9
Registered: January 2015
Location: Pakistan

Junior Member

. I am running 2 nodes Oracle 11gr2. I am importing database from a non-Rac database to 2 node Rac database using impdb command. Backup was taken expdp with Full=Y parameter.
I created all the tablespaces in new RAC as per new requirements in ASM
Now when I start impdp with or without Full=Y or N parameter , data starts importing but EM stops working and gives the message database is down whereas instance is running

# Srvctl status database d RACDB
Instance RACDB1 is running on node rac1
Instance RACDB2 is running on node rac2
------------------------------------------------------------
SQL> select status from v$instance;

STATUS
------------
OPEN
----------------------------------------------------------

[oracle@rac1 ~]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
https://rac1.kpvt.com:5500/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------

SQL> select username, account_status from dba_users where username in ('SYSTEM','SYSMAN','DBSNMP');

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SYSTEM OPEN
DBSNMP OPEN
SYSMAN OPEN

-----------------------------------------------------------

I tried to drop repos and recreate it , repos dropped successfully but recreation failed
Please advise what should I do or how I can avoid it in durng impdp

Report message to a moderator

Re: EM stop working during impdp on RAC [message #658341 is a reply to message #658340]

Fri, 09 December 2016 12:00

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

You'll need to re-create the DB Console after the import. Run emca with the necessary switches,

Additional Parameters for cluster databases
        CLUSTER_NAME: Cluster name
        DB_UNIQUE_NAME: Database unique name
        SERVICE_NAME: Service name
        EM_NODE: Database Control node name
        EM_NODE_LIST: Agent Node list [comma separated]

Report message to a moderator

Re: EM stop working during impdp on RAC [message #658366 is a reply to message #658341]

Sat, 10 December 2016 04:27

DevilzAdvocate
Messages: 9
Registered: January 2015
Location: Pakistan

Junior Member

Thanks John Watson for your help. Now matter is sorted out
For others information, I did the following steps

1- I drop database control and agent using the below

emca -deconfig all db -repos drop -cluster

2- then recreate both, using the below, it'll prompt you different inputs

emca -config all db -repos create -cluster

and it works fine

Report message to a moderator

Previous Topic:	Oracle 11gr2 RAC checklist required
Next Topic:	How to add RAC second instance in OCR?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 04 17:24:15 CST 2025