Friday , August 18 2017
Home / Contact


DBA CENTRE – Remote DB Support
Registered Office,
I Floor,K T Road,
Tirupati,Andhra Pradesh,

DBA CENTRE – Remote DB Support
#301,3rd Floor
Rock View Apartments,
Opp Dr Agarwal Eye Hospital, Ameerpet
PH NO: +91 96404 72496

How to create ASM base groups

Creating  a ASM  base groups: >> Before  creating a ASM  base groups should be check   “labels” and ” raw partition or disk partition.”:  >> creating a base groups using asmca utility. >> asmca Means (Automatic Storage Management Configuration Assistant.) >>  click on ENTER. >> click on  create. >> Creating …

Read More »

ASM Installation process step by step in Oracle 11g

>> After created  VM ware version ,then continue ASM Installation process ,first create a saperate storage disk. >> How to create a storage  disk ,then following this steps: >>click  on   VM ,then you get  settings  option .   >> after get setting option  you can choose hardware . >> …

Read More »

How to Configure Oracle Dataguard in Oracle 11g


Dataguard is known as replicating the data from one server to another server,here i am showing step by step implementation method.In real time we will called as disaster recover model. PRIMARY : IP Address: The DB_NAME IS : CKPT The primary DB_UNIQUE_NAME IS : CKPT PHYSICAL STANDBY: IP Address: …

Read More »

RMAN-04006: error from auxiliary database:ORA-12528: TNS:listener: all appropriate instances are blocking new connections:

If you try to connecting duplicate database using rman and you get following error: [oracle@dbcentre1 ~]$ rman target sys/rac auxiliary sys/rac@to_ckpt_stdby Recovery Manager: Release – Production on Fri Jul 28 15:10:25 2017 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: CKPT (DBID=1925149927) …

Read More »

ORA-01102: cannot mount database in EXCLUSIVE mode

ORA-01102 ORA-09968 Error While Starting Oracle Database: * Database alert log might show following error. thu 24 Jul 20 12:47 2017 ALTER DATABASE MOUNT sculkget: failed to lock /u01/app/oracle/product/11.2.0/dbhome_1/dbs/lkCRD exclusive sculkget: lock held by PID: 64 ORA-09968: unable to lock file Linux-x86_64 Error: 11: Resource temporarily unavailable *You might have already …

Read More »

Cron tab scheduling command in linux

CRON  TAB SCHEDULING COMMAND IN LINUX: What is cron tab: It’s a unix utility that allows task to be automatically run at desired intervals regularly or as given command in the background in word,scheduling task are calls in unix as cron job or cron task. it’s great feature of unix, …

Read More »

How to change the SGA_TARGET & SGA_MAX_TARGET in Oracle

 ****  ENABLE SGA_TARGET ***** MEMORY_TARGET : Dynamic MEMORY_MAX_TARGET : NotDynamic *Prior to 11g, Oracle manages PGA seperately by the pga_aggregate_target parameter. *Oracle introduces AMM feature from 11g which will manage SGA as well as PGA. *When we set MEMORY_TARGET, Oracle will dynamically assign memory to SGA and PGA Note : …

Read More »

Oracle Database Links

DATABASE LINKS: What are the db links? create a link from one database to another database is called a database links.database link facilities accessing of the data existing in remote server from A server. PREREQUISITES: you must need  have the CREATE DATABASE LINK system privileges. you must need  have the …

Read More »