Oracle database 11g R2 Pre-installation

-

1) Install the oracle-validated RPM

http://www.oracle.com/technetwork/articles/servers-storage-admin/ginnydbinstallonlinux-488779.html

2) Set user limits

vi /etc/security/limits.conf

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

3)  Edit /etc/pam.d/login and add the line below in order for the login program to load the pam_limits.so so that the /etc/security/limits.conf is read and limits activated and enforced.
session required pam_limits.so

4) Add Groups and Users

groupadd –g 1000 oinstall
groupadd –g 1021 asmdba
groupadd –g 1031 dba
groupadd –g 1023 oper
useradd –u 1101 –g oinstall –G dba,asmdba,oper oracle

5) Create directory

mkdir -p /home/oracle/app/oracle
chown oracle:oinstall /home/oracle/app/oracle
chmod -R 775 /home/oracle/

6) Create the user profiles for oracle user.

su - oracle

vi .bash_profile

# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
umask 022
ORACLE_BASE=/home/oracle/app/oracle
ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/db_1
ORACLE_HOSTNAME=soadev.skynet
ORACLE_SID=SOADB1
ORACLE_UNQNAME=SOADB
LD_LIBRARY_PATH=$ORACLE_HOME/lib
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH PATH ORACLE_HOSTNAME ORACLE_UNQNAME
TEMP=/tmp
TMPDIR=/tmp
export TEMP TMPDIR
ulimit –t unlimited
ulimit –f unlimited
ulimit –d unlimited
ulimit –s unlimited
ulimit –v unlimited
if [ -t 0 ]; then
stty intr ^C
fi
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH

# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH

Comments

Post a Comment

Popular posts from this blog

How to mount a WD Book Live as NFS in OEL6U3

-
Scenario : I have a Windows 8 (Host) laptop on which I am running two OEL6U3 (Guest) machines in a Virtual Box. I want to have a shared mount between the two Linux machine which will allow me to read/write from both the machines concurrently. Its a very common scenario for a High Availability Environment. Virtual Box provides a facility of creating sharable VDI disks which can be mounted on multiple machines, but it doesn’t allow concurrent read/write access from multiple machines. If you are installing RAC database then its still achievable, because ASM will provide the feature of concurrent read/writes, but if you want to install a WebLogic cluster with High Availability the recommended approach would be to have a Shared Mount. Step to create a shared nfs mount is fairly simple. I am using a WD My Book Live, and will mount the Public folder as shared mount 1. Get the hostname/ip of the WD device. 2. On the Linux Machine 1 create the folder where you want to mount the nfs
Read more

ORA-44412: XE edition memory parameter invalid or not specified

-
SQL> connect sys as sysdba Enter password: Connected to an idle instance. SQL> startup ORA-44412: XE edition memory parameter invalid or not specified SQL> startup pfile=C:\oraclexe\app\oracle\product\10.2.0\server\config\scripts\init.ora ORACLE instance started. Total System Global Area 805306368 bytes Fixed Size 1289996 bytes Variable Size 209715444 bytes Database Buffers 591396864 bytes Redo Buffers 2904064 bytes Database mounted. Database opened. SQL> create spfile from pfile='C:\oraclexe\app\oracle\product\10.2.0\server\config\scripts\init.ora'; File created. SQL> shutdown Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 805306368 bytes Fixed Size 1289996 bytes Variable Size 209715444 bytes Database Buffers 591396864 byt
Read more

Oracle SQL Developer 19.4 font too small

-
Image
I downloaded the latest version of Oracle SQL developer on my windows laptop and when I started it, the font on GUI was too small. To fix the font size scroll to the bottom of the  'Welcome Page' and uncheck 'show on startup'. Restart the SQL Developer and issue will be fixed.
Read more