CRS-2640: Required resource ‘ora.ARC2_DG.dg’ is missing.

PRCR-1079 : Failed to start resource ora.mydb.db
CRS-2640: Required resource ‘ora.ARC2_DG.dg’ is missing.
How to remove the ASM resource from CRS start/stop dependency?

Applies to:

Oracle 11gR2 RAC

Scenario:

(2 node RAC with 11gR2 in RHEL 5.3 x86_64)

I was having 2 ASM diskgroup (ARC1_DG & ARC2_DG) assigned for archive logs and standby Dataguard when first RAC .

Due to some reason that management want to merge these 2 diskgroups into one (ARC1_DG).

I confimed that ARC2_DG was not contain any file and diskgroup ARC2_DG dropped successfully.

Continue reading CRS-2640: Required resource ‘ora.ARC2_DG.dg’ is missing. »

Posted by helloworld in Database General, Oracle Database
No Comments

Tagged Under : , , ,

How to check content of Informix TEMPSPACE when getting fill up?

Scenario:
TEMPSPACE “npts_tmpdbs3” is getting fill up.
We would like to check what is kept in this TEMPSPACE.
$ onstat -d | grep tmpdbs
8426c198 4        2001     4        1        N T      informix npts_tmpdbs1
8426c258 5        2001     5        1        N T      informix npts_tmpdbs2
8426c318 6 2001     6        1        N T      informix npts_tmpdbs3
8426c3d8 7        2001     7        1        N T      informix npts_tmpdbs4
83764f30 4   4   0        512000   509333            PO-   /dev/infdev/npts_tmpdbs1.1
83765038 5   5   0        512000   312458            PO-   /dev/infdev/npts_tmpdbs2.1
83765140 6   6   0        512000   9675              PO-   /dev/infdev/npts_tmpdbs3.1
83765248 7   7   0        512000   509421            PO-   /dev/infdev/npts_tmpdbs4.1

Steps:

(1) Get TBLspace partnum using DBspace number.

Continue reading How to check content of Informix TEMPSPACE when getting fill up? »

Posted by helloworld in Database General, Informix Database
No Comments

Tagged Under : , , ,

How to change SYSMAN password in Oracle 10g

I would like to share how to change SYSMAN password in Oracle 10g (10.1 & 10.2) and 11gR1.

Applies to:
Oracle RDBMS 10.1, 10.2 & 11.1

Solution:
Continue reading How to change SYSMAN password in Oracle 10g »

Posted by helloworld in Database General, Oracle Database
(1) Comment

Tagged Under : , , , , , , ,

« Older Entries
Newer Entries »