Red Hat Linux (6.6) Oracle 11G Installation Steps in Red hat Linux(6.6) Step 1:- Check for proper rpm installed or not by using rpm –q |grep <rpm name>. List of all RPM’s needed- binutils-2.20.51.0.2-5.11.el6 (x86_64) compat-libstdc++-33-3.2.3-69.el6 (x86_64) glibc-2.12-1.7.el6 (x86_64) ksh-*.el6 (x86_64) <== any version of ksh is acceptable libaio-0.3.107-10.el6 (x86_64) libgcc-4.4.4-13.el6 (x86_64) libstdc++-4.4.4-13.el6 (x86_64) make-3.81-19.el6 […]
1. Firstly, export Environment Variables. To export EV automatically for every session, do below changes to /home/oracle/.bashrc file: export ORACLE_SID=kamran export ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1 export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib 2. Create parameter file and modify it by setting minimum required parameters: *.db_name=kamran *.db_block_size=8192 *.sga_target=1677721600 *.undo_management=’AUTO’ *.control_files = (‘/home/oracle/oracle/product/10.2.0/control01.ctl’) *.user_dump_dest=’/home/oracle/oracle/product/10.2.0/udump’ *.background_dump_dest=’/home/oracle/oracle/product/10.2.0/bdump’ *.core_dump_dest=’/home/oracle/oracle/product/10.2.0/cdump’ After creation of this parameter file, create below folders
How to find Table Fragmentation in Oracle Database What is Oracle Table Fragmentation? If a table is only subject to inserts, there will not be any fragmentation. Fragmentation comes with when we update/delete data in table. The space which gets freed up during non-insert DML operations is not immediately re-used (or sometimes, may not get reuse ever
How to Find Table Fragmentation in Oracle Database | Reclaim The Fragmented Space Read More »
The list of files are – /vch27/VCHP/vchdata/wntitel01.dbf and /vch27/VCHP/vchdata/wntitel02.dbf of table space WNTITEL (File No-6 & 13). /vch27/VCHP/rpdata/riepatables03.dbf of table space RIEPATABLES (File No-21). Control File Location- /vch8/VCHP/oradata/control01.ctl, /vch8/VCHP/oradata/control02.ctl, /vch8/VCHP/oradata/control03.ctl The steps are as follows- Shut immediate; Copy the files to /vch32/VCHP/vchdata, /vch32/VCHP/rpdata and rename them if required. Startup mount ALTER DATABASE BACKUP CONTROLFILE TO ‘/vch32/VCHP/control.bkp’;
12C Up-Gradation Prerequisite Check:- Step One:- Operating System Requirements – Red Hat Enterprise Linux 6: 2.6.18-238.0.0.0.1.el5 or later Step Two:- For Red Hat Linux 6 binutils-2.17.50.0.6 compat-libstdc++-33-3.2.3 compat-libstdc++-33-3.2.3 (32 bit) coreutils-5.97-23.el5_4.1 gcc-4.1.2 gcc-c++-4.1.2 glibc-2.5-58 glibc-2.5-58 (32 bit) glibc-devel-2.5-58 glibc-devel-2.5-58 (32 bit) ksh libaio-0.3.106 libaio-0.3.106 (32 bit) libaio-devel-0.3.106 libaio-devel-0.3.106 (32 bit) libgcc-4.1.2 libgcc-4.1.2 (32 bit) libstdc++-4.1.2
ORA-00257: archiver error. Connect AS SYSDBA only, until resolved. Cause: The archiver process received an error while trying to archive a redo log. If the problem is not resolved soon, the database will stop executing transactions. The most likely cause of this message is the destination device is out of space to store the redo
Adjusting The Password Expiration Policy / PASSWORD_LIFE_TIME Doing a default database installation will install a feature that all passwords will expire after 180 days and being unaware of that can be a serious problems in applications as they are unable to connect to the database post that time period. It will cause unnecessary downtime for the
Adjusting The Password Expiration Policy | PASSWORD_LIFE_TIME Read More »
