Ameer Khan

Create a profile with unlimited access and other unlimited privileges in Oracle 11g SQL> CREATE PROFILE “NEW” LIMITCPU_PER_SESSION UNLIMITEDCPU_PER_CALL UNLIMITEDCONNECT_TIME UNLIMITEDIDLE_TIME UNLIMITEDSESSIONS_PER_USER UNLIMITEDLOGICAL_READS_PER_SESSION UNLIMITEDLOGICAL_READS_PER_CALL UNLIMITEDPRIVATE_SGA UNLIMITEDCOMPOSITE_LIMIT UNLIMITEDPASSWORD_LIFE_TIME UNLIMITEDPASSWORD_GRACE_TIME UNLIMITEDPASSWORD_REUSE_MAX UNLIMITEDPASSWORD_REUSE_TIME UNLIMITEDPASSWORD_LOCK_TIME UNLIMITEDFAILED_LOGIN_ATTEMPTS UNLIMITEDPASSWORD_VERIFY_FUNCTION NULL; Profile created. SQL> select * from dba_profiles WHERE PROFILE=’NEW’; PROFILE                      … Continue Reading

The usage of orainstRoot.sh and root.sh scripts  in Oracle 11g Standalone and RAC environment :- Oracle Version :- 11gOS:- Rhel 6.4ORACLE_HOME:- /u01/app/oracle/product/11.2.0/db_1ORACLE_BASE:- /u01/app/oracle Executing orainstRoot.sh and root.sh are the ultimate steps which we execute as root user to ensure that our installation process is done.Its a good practice to save those scripts in somewhere safe.… Continue Reading

Failover is a one way process where your primary database goes down due to some reasons and to get back the production live without any data loss, you convert your existing PhysicalStandby database to start behaving as Primary database..The following conditions must be met before you can use the broker: ■ Primary and standby DB’s… Continue Reading

How to install MongoDB on RHEL 6:- Os version _ Rhel 6.4MongoDB Version:-2.6.7 Step:1 System Login as root user. We are checking system OS type and system bits type. # uname –aLinux server1.soumya.com 2.6.32-358.el6.x86_64 #1 SMP Tue Jan 29 11:47:41 EST 2013 x86_64 x86_64 x86_64 GNU/Linux # cat /etc/issueRed Hat Enterprise Linux Server release 6.4… Continue Reading

Oracle Version :-11gTarget Database : primTarget Database Server : server1.soumya.comIP: 192.168.2.102 Oracle Version :-11gAuxiliary Database : standAuxiliary Database Server : server3.soumya.comIP:192.168.2.12 Step 1:Take the incremental level 0 backup of the Target database using RMAN.In my case, I had the backup of my target database (prim) taken at the location ‘/u01/bkp’[oracle@server1 bkp]$ pwd/u01/bkp [oracle@server1 bkp]$ ls… Continue Reading

Oracle version : 11.2.0.1.0 Enterprise EditionOS : Rhel 6.4Database Name : orclTablespace Name : TESTTBS A user reported a table named “TSPITR” was accidentally dropped . There was no flashback enabled on thisdatabase and the recyclebin too was purged out. As a result, the table could not be recovered usingflashback method. The other methods to… Continue Reading

Oracle version : 12.1.0.2.0  Enterprise EditionOS : Rhel 6.4Database Name : ORA12C sqlplus soumya/soumya SQL> create table xyz (id number);SQL> insert into xyz values (1);1 row created.SQL> /1 row created.SQL> /1 row created.SQL> /1 row created.SQL> /1 row created.SQL> /1 row createdSQL> commit; SQL> SELECT * FROM xyz;         ID———-     … Continue Reading

Switchover of Databases (Primary to standby and standby to primary) in  Dataguard  oracle 11g. Oracle Version:- Enterprise Edition Release 11.2.0.1OS:- Rhel 6.4Primary database:- PrimStandby database:- Stand Switchover is a planned event, it is ideal when we might want to upgrade the primary database or changethe storage/hardware configuration (add memory, cpu networking), we may even want… Continue Reading

Password less authentication between linux servers:-Source server:-192.168.2.11Target server:-192.168.2.12 Hostfile entry On both source and target server: cat /etc/hosts192.168.2.11 server1.soumya.com server1192.168.2.12 server2.soumya.com server2 On source server:- # ssh-keygen -t rsa# ssh-keygen -t dsa# cd /root/.ssh# cat id_rsa.pub >>authorized_keys# cat id_dsa.pub >>authorized_keys# scp authorized_keys root@server2:/root/.ssh/ On target server:-# ssh-keygen -t rsa# ssh-keygen -t dsa# cd /root/.ssh# cat… Continue Reading

Creating a physical standby database on Oracle 12.1.0.2 :- OS Version:-Red Hat Enterprise Linux Server release 6.4Oracle version:- Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 64bit System Configuration System Configuration primary server:- edit the following files vi /etc/hosts 192.168.2.100   server3.soumya.com      server3192.168.2.101   server4.soumya.com      server4 :wq vi /etc/sysconfig/networkHOSTNAME=server3.soumya.com :wq vi /etc/sysconfig/network-scripts/ifcfg-eth0… Continue Reading