Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Loading...

Thursday, November 6, 2014

ORA-15001: diskgroup " " does not exist or is not mounted


Issue:
====
SQL> drop diskgroup TESTDAT;
drop diskgroup TESTDAT
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15001: diskgroup "TESTDAT" does not exist or is not mounted


SQL> select name from v$asm_diskgroup;

NAME
------------------------------
TESTDAT


Fix:-
====
SQL> drop diskgroup TESTDAT force including contents;

Diskgroup dropped.



rsync - scp to Copy files between servers



rsync
Use this command to transfer files remotely and locally in Linux based machines.

-v : verbose
-r : copies data recursively (but don’t preserve timestamps and permission while transferring data
-a : archive mode, archive mode allows copying files recursively and it also preserves symbolic links, file permissions, user & group ownerships and timestamps
-z : compress file data
-h : human-readable, output numbers in a human-readable format

example:

rsync -avzh source destination
rsync -avzh username@shaiksameer.com:/u0/db/oracle/oradata/ /u0/db/oracle/oradata 
 

Tuesday, July 22, 2014

Create Oracle RAC 11gR2 database using dbca silent file


How to create a 11g RAC database using dbca silent response file.

dbca -progress_only -responseFile “/home/shaiksameer/dbca_testdb.rsp”

vi dbca_testdb.rsp
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"
GDBNAME = "TESTDB"
SID = "TESTDB"
NODELIST=machine1,machine2,machine3,machine4
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "syspass12"
SYSTEMPASSWORD = "systempass12"
STORAGETYPE=ASM
DISKGROUPNAME=DATA
CHARACTERSET = "AL32UTF8"
NATIONALCHARACTERSET= "AL16UTF16
SAMPLESCHEMA=FALSE
MEMORYPERCENTAGE = "10"
DATABASETYPE = "MULTIPURPOSE"
AUTOMATICMEMORYMANAGEMENT = "TRUE"

or you can pass the variable values directly.

dbca -silent -nodelist machine1,machine2,machine3,machine4 
 -createDatabase -templateName General_Purpose.dbc 
 -gdbName TESTDB 
 -sid TESTDB 
 -SysPassword syspass12
 -SystemPassword systempass12 
-emConfiguration NONE 
-characterSet WE8ISO8859P15
 -totalMemory 500