Ameer Khan

vi /home/oracle/.bash_profile umask 022export ORACLE_BASE=/u01/app/oracleexport TNS_ADMIN=$ORACLE_BASE/product/11.2.0/db_1/network/admin 10g(){       export ORACLE_SID=prim10g        export ORACLE_HOME=$ORACLE_BASE/product/10.1.0/db_1        export LD_LIBRARY_PATH=$ORACLE_HOME/lib        export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin        export PS1='[\u@\h\W]\$ ‘} 11g(){       export ORACLE_SID=prim11g        export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1        export LD_LIBRARY_PATH=$ORACLE_HOME/lib        export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin   … Continue Reading

Oracle Version :11gOS: Rhel 6 Step 1:-Determine current location for redolog files. SQL> column member format a40SQL> select * from v$logfile;     GROUP# STATUS  TYPE    MEMBER                                   IS_RECOVERY_DEST_FILE———- ——- ——- —————————————- ———————         3  … Continue Reading

Oracle Version: 11gOS Version: Rhel 6 Step 1. Check the datafiles location & tablespace name .SQL> column file_name format a50SQL> select file_name , tablespace_name from dba_data_files;FILE_NAME                                          TABLESPACE_NAME————————————————– ——————————/u01/app/oracle/oradata/prim/users01.dbf           USERS/u01/app/oracle/oradata/prim/undotbs01.dbf  … Continue Reading

Oracle 11.2.0.4 download link for Linux x86_64:- p13390677_112040_Linux-x86-64_1of7.zip- https://mega.nz/file/rB5FCC7A#YfSa5BIC25CgP8ANeQQAZ2buu1NknYXvplGTG3bo6is p13390677_112040_Linux-x86-64_2of7.zip – p13390677_112040_Linux-x86-64_3of7.zip – https://1drv.ms/u/s!AojZQaghYsq5gQRQSKLSqpRG47uN p13390677_112040_Linux-x86-64_4of7.zip – p13390677_112040_Linux-x86-64_5of7.zip – https://1drv.ms/u/s!AojZQaghYsq5gQYfyLHITzpZK4R5 p13390677_112040_Linux-x86-64_6of7.zip – p13390677_112040_Linux-x86-64_7of7.zip –  Please share your ideas and opinions about this topic. improve alexa rank If you like this post, then please share with others.Please subscribe on email for every updates on mail. Continue Reading

It all started in January 2005 with Critical Patch Updates (CPU).Then Patch Set Updates (PSU) were addedas cumulative patches that included priority fixes as well as security fixes.  As of the October 2012Critical Patch Update, Oracle has changed the terminology to better differentiate between patch types.This terminology will be used for the Oracle Database, Enterprise… Continue Reading

Today while i was browsing on OTN i found a thread related to oracle 11gR2 Installation , the OP faced an error like the below :- The above error related to Space On Temp File system all you have to do make sure that there is enough space on temp ( tmp ) or use… Continue Reading

vi /backups/scripts/rmanoutput.sh #!/bin/bashexport ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1export ORACLE_SID=primexport PATH=$PATH:$ORACLE_HOME/binexport NLS_DATE_FORMAT=’DD-MON-YY HH24:MI:SS’export DATE=$(date +%Y-%m-%d) rman target sys/sys@prim msglog /u01/rman_full_backup_db_online_TEST1_${DATE}.log <<EOF backup database plus archivelog; exit; EOF :wq P.S Output for currently executing RMAN jobs is also stored in the V$RMAN_OUTPUT view,which reads only from memory (that is, the information is not stored in the control file).The V$RMAN_STATUS view contains… Continue Reading

Source Database:primTarget Database:-stand Step 1.create the USERS table and add some sample records inside. At source database:-[oracle@server1 ~]$ sqlplus sys/system as sysdba@primSQL> create user appuser identified by appuser;SQL> GRANT CONNECT,RESOURCE TO appuser;SQL> conn appuser/appuserConnected. SQL> insert into users values (1 ,’RAM’,’DAS’,’REDHAT’);SQL> insert into users values (2, ‘SHYAM’,’SINGH’,’SUSE’);SQL> insert into users values (3, ‘ROHAN’,’SHARMA’,’UBUNTU’);SQL> COMMIT;Commit complete.… Continue Reading

Step 1. Edit /etc/oratab file.# vi /etc/oratabprim:/u01/app/oracle/product/11.2.0/db_1:Y :wq Step 2. Create a file called “/etc/init.d/dbora” as the root user vi /etc/init.d/dbora #!/bin/bash# chkconfig: 345 99 10# description: Oracle auto start-stop script.ORA_HOME=/u01/app/oracle/product/11.2.0/db_1ORA_OWNER=oracleif [ ! -f $ORA_HOME/bin/dbstart ]then    echo “Oracle startup: cannot start”    exitficase “$1” in    ‘start’)        su $ORA_OWNER -c $ORA_HOME/bin/dbstart &        su – $ORA_OWNER -c… Continue Reading

Description:-SQL> set autotrace onSP2-0618: Cannot find the Session Identifier.  Check PLUSTRACE role is enabledSP2-0611: Error enabling STATISTICS report solution:-For execution AUTOTRACE the users needs to have the PLUSTRACE role, which does notexist by default. PLUSTRACE role can be created using SYS user by executing/u01/app/oracle/product/11.2.0/db_1/sqlplus/admin/plustrce.sql[oracle@server1]$ sqlplus /  as sysdbaSQL> @/u01/app/oracle/product/11.2.0/db_1/sqlplus/admin/plustrce.sqlSQL>SQL> drop role plustrace;drop role plustrace   … Continue Reading