Ameer Khan

Steps to power down  a cell without affecting ASM in Exadata:- Environment:-Oracle SuperCluster  T5-82 SPARC T5-8 Compute nodes, 4 EXADATA X5-2 Storage cells Scenario:- One of exadata Storage cell node had a faully motherboard, which required a replacement. Due to this we had to shutdown the storage cell and perform the replacement activity. Note:- When… Continue Reading

Oracle 11.2.0.4 download link for Windows x86_64:- https://mega.nz/#F!KcQXCIAY!ZT4lFv6YfNoX8f4WzO7cCw Please share your ideas and opinions about this topic. If you like this post, then please share with others.Please subscribe on email for every updates on mail. Continue Reading

Step 1. Lets create an user first. SQL> create user soumya IDENTIFIED BY soumya; User created. SQL> grant connect,resource to soumya; Grant succeeded. Step 2. Run the procedure to restrict the user to be dropped. SQL> Create OR Replace Trigger UserDropRestrict  2  3  Before Drop On Database  4  5  Declare  6  7  Begin  8  9 … Continue Reading

Oracle 10.2.0.4 download link for Windows 64Bit Link :- https://mega.nz/#F!nE4lACaa!M2CDMHSPdKZUFpvouPSRdQ Please share your ideas and opinions about this topic. If you like this post, then please share with others.Please subscribe on email for every updates on mail. Continue Reading

Overview:- In this scenario, we have free space available in celldisk . we would like to increase our DATAC2 disk group size . EnvironmentOracle SuperCluster  T5-82 SPARC T5-8 Compute nodes, 4 EXADATA X5-2 Storage cells step 1. Find out freespace available in celldisk Login to any storage cell :-cellcli -e “list celldisk where name like… Continue Reading

When installing Oracle 11g  you may get the following error :-  Error in invoking target ‘agent nmhs’  of makefile ‘/u01/app/oracle/product/11.1.0/db_1/sysman/lib/ins_emagent.mk Solution:- Open the file it reports in error message. vi $ORACLE_HOME/sysman/lib/ins_emagent.mk Search for the line $(MK_EMAGENT_NMECTL)Change it to:$(MK_EMAGENT_NMECTL) -lnnz11 Note : edit this file while you still have the installer open, once you have changed it just… Continue Reading

Objective :-We are cloning a database running on target server  and restoring it into clone server with a different sid. Note- Make sure oracle binary is already installed on target db server.In this case the directory structure of target server is different than source server. Database Version :- Oracle Enterprise Edition  11.2.0.1 on RHEL 6.4… Continue Reading

Migrating databases from NON-ASM to ASM in oracle 12c Step 1.Login to the database and write down the path of all the datafiles, tempfiles and redo log files. SQL> select status,version,instance_name from v$instance; STATUS       VERSION           INSTANCE_NAME———— —————– —————-OPEN         12.1.0.2.0        orclnew SQL> select file_name,tablespace_name… Continue Reading

How to clone a database using user managed hot backup in oracle database 11g Objective :-We are cloning a database running on target server  and restoring it into clone server. Database Version :- Oracle Enterprise Edition  11.2.0.1 on RHEL 6.4 Target Server: 192.168.0.101Database sid:- prim Clone Server: 192.168.0.104database sid: newprim ****At target Database Take online… Continue Reading

Software used:-1.VMWARE 102.Redhat enterprise linux 6.5(64 bit)3.Oracle database 12C (64 bit)4.Oracle Grid infrastructure 12c(64 bit) What to Setup:- 1. Setup oracle grid infrastructure for standalone server “ASM”2. Setup oracle Database Update /etc/sysctl.conf[root@server1]# vi /etc/sysctl.confScroll to the bottom and add the following: fs.file-max = 6815744kernel.sem = 250 32000 100 128kernel.shmmni = 4096kernel.shmall = 1073741824kernel.shmmax = 4398046511104net.core.rmem_default… Continue Reading