Database Analyser

Step By Step Guide To Install Oracle 19C RAC With ASM & Version Upgrade

This document will guide you for a step by step Oracle 19C RAC installation with ASM on a Linux platform. Each and every step is discussed here. We will RAC installation with ASM and version upgrade. Steps to Follow – Server Configuration Configure Oracle ASM Precheck for RAC setup Install GRID Infrastructure for RAC Install Oracle […]

Step By Step Guide To Install Oracle 19C RAC With ASM & Version Upgrade Read More »

ORACLE 12C RAC INSTALLATION

Perform the below Manual Setup to complete the basic prerequisites Disabling Firewall: service iptables stop chkconfig iptables off Add or amend the following lines to the “/etc/sysctl.conf” file: fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.panic_on_oops = 1 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576

ORACLE 12C RAC INSTALLATION Read More »

Oracle 11G Installation on Linux

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

Oracle 11G Installation on Linux Read More »

Manual Database Creation

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

Manual Database Creation Read More »

How to Find Table Fragmentation in Oracle Database | Reclaim The Fragmented Space

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 »

Data File Relocation Steps

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’;

Data File Relocation Steps Read More »

ORACLE DATABASE UPGRADATION FROM 11GR2 TO 12C

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

ORACLE DATABASE UPGRADATION FROM 11GR2 TO 12C Read More »

Adjusting The Password Expiration Policy | PASSWORD_LIFE_TIME

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 »