Monday, January 20, 2014

killing expdp/impdp job.

some time it is really necessary  to terminate  a expdb/impdp jobs because of any valid reason which impact database.
here are the steps for quick references, how can we terminate the expdp/impdp job,
step 1:  take the job_name from below views
select * from USER_DATAPUMP_JOBS;
select * from DBA_DATAPUMP_SESSIONS;
step 2: Attach to that job_name which you find out in step1.
oracle@aa: /u02/backups # impdp system/***** attach=test_DUMP11(job_name)
step 3:  stop job immediate
impdp> STOP_JOB=IMMEDIATE
impdp>kill_job
- Manish Nashikkar


Disable ntpd and make ctssd active – 11gR2 RAC

We have two options to synchronize time on our clusters,
1. Using NTP or
2. Using Oracle Cluster Synchronization Services Deamon (ctssd)
By default, if a time sync software is running like NTP, ctssd will run in observer mode. In this tutorial we will see how to start ctssd in active mode
1. Check if ctssd is active or not
[grid@rac1 ~]$ crsctl check ctss
CRS-4700: The Cluster Time Synchronization Service is in Observer mode.
[grid@rac2 ~]$ crsctl check ctss
CRS-4700: The Cluster Time Synchronization Service is in Observer mode.
We can see that CTSSD is in observer mode
2. De-configure NTP.
#crsctl stop crs
#/sbin/service ntpd stop
#chkconfig ntpd off
#chkconfig --list ntpd
#mv /etc/ntp.conf /etc/ntp.conf.original
#rm /var/run/ntpd.pid
3. Start the cluster on all nodes
#crsctl start cluster
4. Check that ctssd automatically starts in active mode as
CRS-4701: The Cluster Time Synchronization Service is in Active mode.
CRS-4702: Offset (in msec): 0
[root@rac2 etc]# crsctl check ctss
CRS-4701: The Cluster Time Synchronization Service is in Active mode.
CRS-4702: Offset (in msec): 0