oracle@ORATEST software$ cpio -idmv 10201databaselinuxx8664.cpio oracle@ORATEST software$ ls -ltr total 1945716 drwxr-xr-x 6 oracle dba 4096 Oct 23 2005 database-rwxr-xr-x 1 oracle dba 801603584 Nov 16 2008 10201databaselinuxx8664.cpio Installing Oracle.
This post will describe all steps to install Oracle 10g on linux with RHEL 5 x86_64.
Steps in few words.
1. download oracle 10g 2.0.5 installation media’s 2. configure Linux Machine 3. install oracle software 10.2.0.1 4. upgrade oracle database software to 10.2.0.5
Steps in details :
1. download oracle 10g 2.0.5 installation media’s
10201_database_linux_x86_64.cpio.gz
p8202632_10205_Linux-x86-64.zip
2. configure Linux Machine
2.1 . system kernel should be : 2.6.18-8 (os command #uname -r)
SELinux should be disabled .
2.2 Set kernel parameters by editing file /etc/sysctl.conf with following config then play (sysctl -p)
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1 net.ipv4.conf.default.accept_source_route = 0 kernel.sysrq = 0 kernel.core_uses_pid = 1 net.ipv4.tcp_syncookies = 1 kernel.msgmnb = 65536 kernel.msgmax = 65536 kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 fs.file-max = 101365 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 1048576 net.core.rmem_max = 1048576 net.core.wmem_default = 262144 net.core.wmem_max = 262144
2.3 edit /home/oracle/.bash_profile with :
export PATH
export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1 export ORACLE_SID=orcl export ORACLE_TERM=xterm export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
#export LD_LIBRARY_PATH CLASSPATH
if [ $USER = “oracle” ]; then
if [ $SHELL = “/bin/ksh” ];then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi
2.4 Create Oracle user and groups
# groupadd oinstall # groupadd dba # useradd -g oinstall -G dba oracle # passwd oracle
2.5. Create the required directories for Oracle database and change the ownership
For example # mkdir -p /u01/app/oracle # chown -R oracle:oinstall /u01/app/oracle
2.6 Set the session limits for Oracle user
Add the following lines to the /etc/security/limits.conf file
oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536
Add the following line in the /etc/pam.d/login file
session required pam_limits.so
2.7. installing required packages:
(e.g : yum install <package> )
binutils-2.17.50.0.6-2 (x86_64)
compat-db-4.2.52-5.1 (x86_64) compat-libstdc++-296-2.96-138 (i386) compat-libstdc++-33-3.2.3-61(x86_64) compat-libstdc++-33-3.2.3-61 (i386) control-center-2.16.0-14 (x86_64) gcc-4.1.1-52 (x86_64) gcc-c++-4.1.1-52 (x86_64) glibc-2.5-12 (x86_64) glibc-2.5-12 (i686) glibc-common-2.5-12 (x86_64) glibc-devel-2.5-12 (x86_64) glibc-devel-2.5-12 (i386) glibc-headers-2.5-12 (x86_64) ksh-20060214-1.4 (x86_64) libaio-0.3.106-3.2 (x86_64) libgcc-4.1.1-52 (i386) libgcc-4.1.1-52 (x86_64) libgnome-2.16.0-6 (x86_64) libgnomeui-2.16.0-5 (x86_64) libgomp-4.1.1-52 (x86_64) libstdc++-4.1.1-52 (x86_64) libstdc++-devel-4.1.1-52 (x86_64) libXp-1.0.0-8 (i386) libXtst-1.0.1-3.1(i386) make-3.81-1.1 (x86_64) sysstat-7.0.0-3 (x86_64)
3. install oracle database software 10.2.0.1
Log in as Oracle user and start installation
3.1 extract installer media :
gunzip 10201_database_linux_x86_64.cpio.gz
cpio -idmv < 10201_database_linux_x86_64.cpio
3.2 start installation :
./runInstaller -ignoreSysPrereqs
Screens filled and validated and installer applied correctly .
4. upgrade oracle database software to 10.2.0.5
4.1 extract patchset : unzip p8202632_10205_Linux-x86-64.zip
4.2 Stop listener and shutdown database .
/* Stop the listener */
$ lsnrctl stop
$ sqlplus / as sysdba SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL>
4.3 take backup of entire $ORACLE_BASE
$ tar czf ora10g.tar.gz /u01/app/oracle
4.4 locate on patchset extract folder.
cd Disk1/
$ ./runInstaller
validate screens and patchset is now appied
4.5
$ sqlplus / as sysdba
SQL> startup upgrade
SQL> spool pre_upgrade.log
SQL> @utlu102i.sql SQL> spool off
The output from utlu102i.sql shows that every thing is fine, no changes are required and the database is ready for upgrade.
Lets start the upgrade process.
SQL> spool upgrade.log
SQL> @catupgrd.sql SQL> spool off SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL>
When the upgrade script catupgrd.sql finishes shutdown the database and open the spool of the upgrade process and try to find out if any thing failed. If you see something failed try to fix it and re-run the upgrade process.
The upgrade process may leave many objects invalid in the database. Perform a normal startup and run the utlrp.sql script to recompile any invalid objects.
$ sqlplus / as sysdba
SQL> startup
SQL> spool recompile.log
SQL> @utlrp.sql SQL> spool off
/*
When the script utlrp.sql completes go ahead and verify if all the components are upgraded to 10.2.0.5 */
SQL> select * from v$version
cpio command is used to process archive files (for example, *.cpio or *.tar files).
cpio stands for “copy in, copy out”.
cpio performs the following three operations.
cpio takes the list of files from the standard input while creating an archive, and sends the output to the standard output.
1. Create *.cpio Archive File
You can create a *.cpio archive that contains files and directories using cpio -ov
As seen above, the ls command passes the three object filenames to cpio command and cpio generates the object.cpio archive.
2. Extract *.cpio Archive File
cpio extract: To extract a given *.cpio file, use cpio -iv as shown below.
3. Create *.cpio Archive with Selected Files
The following example creates a *.cpio archive only with *.c files.
4. Create *.tar Archive File using cpio -F
We already know how to use the tar command effectively.
Did you know that you can also use cpio command to create tar files as shown below?
As seen above, instead of redirecting the standard output you can mention the output archive filename with the option -F.
5. Extract *.tar Archive File using cpio command
You can also extract a tar file using cpio command as shown below.
6. View the content of *.tar Archive File
To view the content of *.tar file, do the following.
7. Create a *.cpio Archive with the Original files that a Symbolic Link Points
cpio archive can be created with the original files that a symbolic link is referring to as shown below.
8. Preserve the File Modification Time while restoring *.cpio
The modification time of the files can be preserved when we are restoring the cpio archive files as shown below.
9. Manipulate Linux and Kernel image files using cpio
How to View, Modify and Recreate initrd.img – As we discussed a while back, we can also use cpio command to manipulate initrd.img file.
10. Copy Directory Tree from One to Another
cpio allows you to copy one directory contents into another directory without creating an intermediate archive. It reads the file list from the standard input and pass it to the target directory.
The example below copies the files and sub-directories of objects directory into /mnt/out directory.
In the above example:
> Add your comment
If you enjoyed this article, you might also like..
Next post: Top 10 Open Source Bug Tracking System
Previous post: Packet Analyzer: 15 TCPDUMP Command Examples
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |