the paper was a lesson to me from Mr. Sameer dehadrai, renowned person in IT industry.
Simple Oracle 10g queries and programs. Visual Basic 6.0 Applications with Oracle as Back End. Published as Practical Record, in University College of Applied Sciences (MG University), Pathanam...
Full description
Full description
Install Xrdp on CentOS 7
Full description
PLSQLDescripción completa
Description complète
Oracle Database 10g Migration to ASM, August 2004Full description
Configuring Oracle 10g ASM on LinuxFull description
The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual ...Full description
The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual ...
Descripción completa
Full description
Install Oracle 10g R2 in OEL/Hedhat/CentOS OEL/Hedhat/CentOS 6.2 Configuring Linux for the Installation of Oracle Database 10g R2. This module describes how to configure Linux and prepare for the installation of Oracle Database 10g.
1. Hosts File
The /etc/hosts file must contain a fully qualified name for the server: # vi /etc/hosts 127.0.0.1
ukhore.uzzal.com
ukhore
2. Set Kernel Parameters
Open the /etc/sysctl.conf file in any text editor and add lines similar to the following: # vi /etc/sysctl.conf #kernel.shmall = 2097152 kernel.shmmni = 4096 # semaphores: semmsl, semmns, semopm, semmni kernel.sem = 250 32000 100 128 #fs.file-max = 65536 net.ipv4.ip_local_port_range net.ipv4.ip_local_port_range = 1024 65000 net.core.rmem_default=262144 net.core.rmem_max=262144 net.core.wmem_default=262144 net.core.wmem_max=262144 kernel.shmmax = 838860800
By specifying values for these parameters in the /etc/sysctl.conf /e tc/sysctl.conf file, these values persist when you reboot the system. Run the following command to change the current kernel parameters: #/sbin/sysctl -p
1|Page
3. Security
# vi /etc/security/limits.conf * * * *
soft hard soft hard
nproc 2047 nproc 16384 nofile 1024 nofile 65536
4. Session
# vi /etc/pam.d/login session
required
/lib/security/pam_limits.so
5. SELinux
# vi /etc/selinux/config SELINUX=disabled
6. Create the new groups and user
Create the groups oinstall, dba, oper, asmdba. # /usr/sbin/groupadd -g 5001 oinstall # /usr/sbin/groupadd -g 5002 dba # /usr/sbin/groupadd -g 5003 oper # /usr/sbin/groupadd -g 5004 asmdba Create the operating system user ‘oracle’
Copy the content and save it in a text file and replace the content with redhat-4 [CentOS release 6.2 (Final)] # vi /etc/redhat-release redhat-4
9. Modify bash_profile
With an editor of your choosing open /home/oracle/.bash_profile file. Add the following lines at the end of the .bash_profile file # Oracle Settings TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_BASE=/u01/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db; export ORACLE_HOME ORACLE_SID=orcl; export ORACLE_SID ORACLE_TERM=xterm; export ORACLE_TERM PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH if [ $USER = "oracle" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi # End Oracle Setting
3|Page
10. Setup required packages: Install the following packages
Login as 'oracle' user Open terminal and enter in your oracle installation CD/DVD directory $ cd /u01/software/database $ ./runInstaller During the installation enter the appropriate ORACLE_HOME and name then continue installation.
12. Post Installation
--Execute two scripts as root --Edit the /etc/redhat-release file restoring the original release information: # vi /etc/redhat-release --Edit the /etc/oratab file setting the restart flag for each instance to 'Y': # vi /etc/oratab TSH1:/u01/app/oracle/product/10.2.0/db:Y
ByUzzal Kumar Hore Member, R&D Commlink Info Tech Ltd. 4|Page