//
archives

Oracle Installation & Configuration

This category contains 13 posts

Oracle 11g R2 RAC on Oracle Enterprise Linux 5.11 with Virtual Box – Section 2 Install OEL 5.11

Install Oracle Enterprise Linux 5 upgrade 11 Insert the Oracle Enterprise Linux 5u11 iso into the virtual machine and powerup the virtual machine. Select the language English(English) and click Next Ignore the warning message by select Yes, click Next Select Create custom layout. and click Next Select the partition /dev/sda, Add Partition. Create a swap … Continue reading

java.sql.SQLRecoverableException: No more data to read from socket cause by connection pool running out

java.sql.SQLRecoverableException: No more data to read from socket caused by connection pool running out Issues Currently, in Oracle database server is built on more than one tablespace for different systems, both systems at the same time in the course of a project being developed in a test run, appeared from time to time the connection … Continue reading

Oracle 11g R2 RAC on Oracle Enterprise Linux 5.11 with Virtual Box – Section 1 The Database Environment

Oracle RAC Nodes Node Name Instance Name Database Name Processor RAM Operation System orcl11gnode1 TESTDB1 TESTDB.newzonetech.com 2 Virtual CPU 3GB Oracel Enterprise Linux 5 upgrade 11 orcl11gnode2 TESTDB2 2 Virtual CPU 3GB Oracel Enterprise Linux 5 upgrade 11   Network Configuration Node Name Public IP Private IP Virtual IP SCAN Name SCAN IP orcl11gnode1 192.168.56.40 … Continue reading

Set Oracle User password never expired

Sometime the Oracle User account password need to set to never expire 1、First, to check the user belong to which profile,normal the user belong to ‘default’ group: 2、Check the password policy for the profile( for example ‘default’): 3、Change the password expire period from 180 days to unlimited: 4、After the password expire period change, reset the … Continue reading

Standard Practice to build an Oracle 11g R2 Database Server (Keep Add on)

Standard Practice to build an Oracle Database Server 1) Re-locate the sys.aud$ to a dedicated tablespace 2) Using spfile instead of pfile 3) If the database use as production database, set the database to archivelog mode

How to relocate the sys.aud$ table to another tablespace in Oracle 11g R2

When the Oracle database fail to allocate the next extent to the sys.aud$ table, all users will not able login to the database remotely. The solution of the issue is to relocate the sys.aud$ table to a dedicated tablespace and shrink the sys.aud$ table regularly. There are some reasons for DBAs to relocated the sys.aud$ … Continue reading

Install Oracle Database 11g R2 on Linux RHEL/CentOS 6.5 – Section 6

Create Oracle Database Manually without using DBCA Before start create the database I need to change the ‘oracle‘ bin permission for oracle software. Create the init parameter file for oracle database Insert the following contents Login to an idle instance as sysdba Start the database at nomount status Run the create database statement Run following … Continue reading

Install Oracle Database 11g R2 on Linux RHEL/CentOS 6.5 – Section 5 (Single Instance)

Prepare the Oracle Database software for Installation Login to the Oracle Database Server as user root Using any FTP or winscp to transfer the Oracle Database Software package to the Oracle Database Server Unzip the Oracle Database Software Once the unzip complete, Grant the correct permission for grid folder Start install the Oracle Database software … Continue reading

Install Oracle Database 11g R2 on Linux RHEL/CentOS 6.5 – Section 4 (Single Instance)

Now we created our ASM instance, next we can create the ASM Disk and Diskgroup. There are two options we can create and bind the ASM Disks Use the Oracle ASM API(Oracle ASMLib) provide by Oracle Or, use the linux udev In this case, I will use the Linux udev to bonding the ASM Disks … Continue reading

Install Oracle Database 11g R2 on Linux RHELCentOS 6.5 – Before Start

The purpose of the Installation Oracle Database 11g R2 on Linux CentOS 6.5 is to build a study environment for learning Oracle 11g R2 database. This installation process should not be used at production environment. The latest patchset for Oracle 11g r2 is 11.2.0.4. The installation is based on CentOS 6.5 Linux, the database server … Continue reading