Davis Apps DBA

I'm using Oracle EBS R12.2.7 and below are the steps I followed to create custom top. Here I used the name xxerp for my custom top,custom schema and the tablespace for this schema.  1.Download Patch 3636980 "Support Diagnostics (IZU) patch for AD Splice" from My Oracle Support. 2.Manually copy the three .txt files from the 3636980\izu\admin directory to your own temporary directory. 3.Rename izuprod.txt to <CUSTOM MODULE>prod.txt. In this example, we will use "xxerpprod.txt". 4.Rename izterr.txt to <CUSTOM MODULE>terr.txt. In this example, we will use "xxerpterr.txt". 5.Open newprods.txt in a text editor. a.Change all references of "izu" to <custom module> and all references of "IZU" to <CUSTOM MODULE> (i.e. keep the case sensitivity). b.Modify other values as below. 6.Create a custom schema,tablespace for that schema and provide the required grants to that schema. ...

Recently I've created a new ASM instance. In that I've created a diskgroup named DATA and created with Normal redundancy, but I supposed to create it with External redundacy. Now I need to change the redundancy to Normal of that diskgroup. I tried many steps, but at last I did change the redundancy and below are the steps I followed. Trying to dismount the Diskgroup DATA in-order to change the redundancy, but in the attempt of dismounting the diskgroup I faced below issues. So, I decided to take a bounce on the ASM Instance and dismount the diskgroup, it works. Now I tried to drop that diskgroup and recreate the same with External redundancy but no luck! Facing the above issue, since the diskgroup is in mount state. Tried to dismount,disable the diskgroup but nothing worked. Finally I decided to do the dismount and drop the diskgroup using force option. Since this is a new instance and the diskgroup doesn'...

We can add an ASM disk to existing diskgroup in two ways.    1. GUI - Using asmca utility    2. Command Line - Using SQL Command GUI - Using asmca utility Check Diskgroup and ASM disk details as follows. Now switch to root user and create ASM disk(DATA07) as follows. Here DATA07 is the new LUN partition provisioned by storage team in the alias name as DATA07. Also I'm going to create the ASM disk in the same name(DATA07)  Once ASM disk is created, switch to grid user and invoke asmca utility as follows. Here enter your server IP and launch the putty session. Command Line - Using SQL Command Here in the below example I'm going to add a new ASM disk named DISK14 to diskgroup DATA. Let us see the steps involved. In the below SS, we've disks upto 13. Below are the SS shows the diskgroup details.   In below SS, you can see disk named DATA14. Our storage team had assigned a LUN p...