Home » Server Options » RAC & Failsafe » EM stop working during impdp on RAC
EM stop working during impdp on RAC [message #658340] Fri, 09 December 2016 11:52 Go to next message
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
Re: EM stop working during impdp on RAC [message #658341 is a reply to message #658340] Fri, 09 December 2016 12:00 Go to previous messageGo to next message
John Watson
Messages: 7150
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]
Re: EM stop working during impdp on RAC [message #658366 is a reply to message #658341] Sat, 10 December 2016 04:27 Go to previous message
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

Previous Topic: Alert log error
Next Topic: How to add RAC second instance in OCR?
Goto Forum:
  


Current Time: Tue Nov 21 06:09:38 CST 2017

Total time taken to generate the page: 0.02619 seconds