RENAMING INSTANCE In this article we will learn how to rename a oracle instance. Step 1 : Check instance information SYS>>select instance_name from v$instance; Inst-Name ———- primary My instance name is primary. No i want to convert Primary to PROD. Step 2 : Shutdown the… Read More
Renaming the Oracle Database. In this article we will learn how to rename a oracle database using trace controlfile . RENAMING DATABASE : Step 1 : Check the database name SYS>>select name from v$database; NAME —————————————- PRIMARY My Old Database name is PRIMARY Step 2… Read More
Controlfile Multiplexing and De-Multiplexing In Oracle12c In this article we will learn what controlfile contains,How to perform controlfile Multiplexing and De-Multiplexing . Control file : Controlfile is a Physical file. Controlfile is a small binary file which contains the current physical structure of database. Control… Read More
Different Block Size of ORACLE Oracle 9i supports tablespaces with different block sizes. This allows large tables and indexes to have a larger block size than smaller objects. It also means that tablespaces can be transported between databases with differing block sizes. The database is… Read More
Storage Management in Oracle -3 In article we will learn creating tablespaces with storage parameters(DEMO). Before reading this article please check previous articles. Storage Management in Oracle -2 Demo On Storage Management : To view information about storage management use DBA_TABLESPACES or V$TABLESPACE SYS>> desc… Read More
Storage Management in Oracle -2 In this article we will learn about Storage Parameters . Before reading this article please go through with previous article. Storage Management in Oracle -1 Storage Hierarchy Summary In summary, the hierarchy of storage in Oracle is as follows: 1.… Read More
Storage Management in Oracle -1 In this article we will learn about Storage Management . A Database is a collection of Logical and Physical Phases.In Logical phase we have DB objects. A Tablespace is a logical storage container in Oracle that comes at the top… Read More
E-Business Suite(EBS) ARCHITECTURE-1 Hello Everyone previously we learnt about Introduction to apps dba and EBS. Please check below link. ROLES & RESPONSIBILITIES OF ORACLE APPS DBA Now let us see about EBS architecture. When we come to oracle EBS basically it is a triple tier… Read More
Moving Online Data files in Oracle Database 12c Release 1 In order to rename, move and relocate a datafile up to 11g, we had to put a tablespace or database completely offline. As we can see here drawback is Database is not available this whole… Read More
INTRODUCTION TO ORACLE APPS DBA Oracle APPS DBA: What is Application Database? The Database which is storing the data’s from application (say front end ) that is EBS (Enterprise Business suite) is said to be Application Database . What is EBS? Oracle E-Business Suite is… Read More
