| 上一篇 |
Installation of Oracle 9i (R2) on Fedora Core Linux 2, 3, 4, 5 and 6 （fc6 2007年圣诞修改版） |
下一篇 |
Installation of Oracle 9i (R2) on Fedora Core Linux 2, 3, 4, 5 and 6 This paper (HOWTO) describes step-by-step installation of Oracle 9i database software on Fedora Core 2, 3, 4, 5 and 6.
This paper covers following steps:
Pre-Instalation Tasks Download & Install Post-Instalation Tasks Common Installation Errors Pre-Instalation Tasks1. Create oracle User Account
Login as root and create te user oracle which belongs to dba group.
su -
# groupadd dba# groupadd oinstall# useradd –g oinstall –G dba oracle# passwd oracle2. Setting System parameters
Edit the /etc/sysctl.conf and add following lines:
# for Oracle 9i onlykernel.sem = 250 32000 100 128
kernel.shmmax = 2147483648
kernel.shmmni = 128
kernel.shmall = 2097152
kernel.msgmnb = 65536
kernel.msgmni = 2878
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000 Note: You need execute "sysctl -p" or reboot system to apply above settings.
Edit the /etc/security/limits.conf file and add following lines:
# for Oracle 9i Onlyoracle soft nofile 65536oracle hard nofile 65536oracle soft nproc 16384oracle hard nproc 163843. Setting Oracle Enviroment
Edit the /home/oracle/.bash_profile file and add following lines:
Settings for Fedora Core 2,3,4 only. For Fedora Core 5 and 6 use the next settings.
ORACLE_BASE=/opt/oracle
ORACLE_HOME=$ORACLE_BASE/920
ORACLE_SID=MY_ORACLE
LD_LIBRARY_PATH=$ORACLE_HOME/lib
LD_ASSUME_KERNEL=2.4.1
THREADS_FLAG=native
ORACLE_OEM_JAVARUNTIME=/opt/jre1.3.1_18
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH LD_ASSUME_KERNEL THREADS_FLAG ORACLE_OEM_JAVARUNTIME PATH Settings for Fedora Core 5 and 6 only. For Fedora Core 2,3,4 use the above settings. Note setting of LD_ASSUME_KERNEL will cause incorrect functionality of FC5 and FC6.
# for Oracle 9i OnlyORACLE_BASE=/opt/oracleORACLE_HOME=$ORACLE_BASE/920ORACLE_SID=orasid1LD_LIBRARY_PATH=$ORACLE_HOME/libTHREADS_FLAG=nativeORACLE_OEM_JAVARUNTIME=/opt/jre1.3.1_18PATH=$PATH:$ORACLE_HOME/bin export PATH ORACLE_BASE ORACLE_HOME ORACLE_SID THREADS_FLAG ORACLE_OEM_JAVARUNTIME LD_LIBRARY_PATH #export PATHunset USERNAME Save the .bash_profile and execute following commands for load new enviroment:
cd /home/oracle
. .bash_profile 4. Create base directory for Oracle
Login as root and create base directory for Oracle ($ORACLE_BASE).
su -
# cd /opt
# mkdir oracle
# chown oracle:dba oracle Download & Install1. Download and install required .rpm packages
Some additional packages are required for succesful instalation of Oracle software. To check whether required packages are installed on your operating system use following command:
rpm -q gcc glibc-headers glibc-kernheaders glibc-devel compat-libstdc++ cpp compat-gcc Note: You don’t need glibc-kernheaders installed on FC6 as this package is not shipped with FC6.
# # yum update gcc ------------------or----# yum install gcc(1/4): gcc-4.1.2-13.fc6.i 100% |=========================| 5.2 MB 01:03
(2/4): cpp-4.1.2-13.fc6.i 100% |=========================| 2.6 MB 00:25
(3/4): libgomp-4.1.2-13.f 100% |=========================| 75 kB 00:02
(4/4): libgcc-4.1.2-13.fc 100% |=========================| 87 kB 00:02
# rpm -ivh compat-gcc-7.3-2.96.126.i386.rpm# rpm -ivh compat-libstdc++-7.3-2.96.118.i386.rpm If some package is not installed download it from
Fedora project website or direct from
Core 2,
Core 3,
Core 4,
Core 5,
Core 6 locations.
This step is required for Fedora Core 3 and 4 only. Fedora Core 3 is shipped with compat-gcc-8.3.3.4. Fedora Core 4 is shipped with compat-gcc-32-3.2.3. These package are GCC 3.x compiler which are not useful for succesful inatallation. Check whether compat-gcc-8.3.3.4 or compat-gcc-32-3.2.3 is installed. If so then uninstall it using folowing command:
rpm -e compat-gcc Download the compat-gcc-7.3-2.96.126.i386.rpm package from
Core 2 location or from
here.
Install the required packages using the rpm command (Note version of packages may change in newer release, so versions for all packages (except compat-gcc package) used in next command are just for example.):
# rpm -ivh gcc-3.4.2-6.fc3.i386.rpm \
glibc-headers-2.3.3-74.i386.rpm \
glibc-kernheaders-2.4-9.1.87.i386.rpm \
glibc-devel-2.3.3-74.i386.rpm \
compat-libstdc++-3.4.2-6.fc3.i386.rpm \
cpp-3.4.2-6.fc3.i386.rpm \
compat-gcc-7.3-2.96.126.i386.rpm For Fedora Core 4, 5 and 6 only:Install the required additional packages using the rpm command:
# rpm -ivh compat-libgcc-296-2.96-___.rpm \
compat-libstdc++-33-3.2.3-___.rpm \
compat-libstdc++-296-2.96-___.rpmIf all required packages were installed succesfuly then login as root and switch the GCC3 compiler binary with GCC2 compiler binary as following:
su -
# cd /usr/bin
# mv ./gcc ./gcc3
# mv ./gcc296 ./gcc2. Download the Java Runtime Enviroment (j2re-1_3_1_18-linux-i586.bin) from the
Sun website. Keep in mind you need to download j2re1.3.1_11 or higher (Note: Install JRE 1.3.1_1x version only).
Login as root and make the the file executable and then execute it. When the JRE is exracted move the "jre1.3.1_18" di rectory to "/opt" directory.
# chmod +x j2re-1_3_1_18-linux-i586.bin
# ./j2re-1_3_1_18-linux-i586.bin
# mv jre1.3.1_18 /opt/ 3. Download the Oracle 9i (9.2.0.4) software from
Oracle website.
Extract the files using following command:
gunzip ship_9204_linux_disk1.cpio.gz
gunzip ship_9204_linux_disk2.cpio.gz
gunzip ship_9204_linux_disk3.cpio.gz
cpio -idmv When all archives were extracted you’ve got three directories Disk1, Disk2 and Disk3.
Edit the Disk1/install/linux/oraparam.ini and modify JRE_LOCATION variable and set path to our JRE installation from Step 2.
JRE_LOCATION=/opt/jre1.3.1_18
4. Start the Oracle software installation process.
Now the system is prepared for Oracle software installation. To start the installation process execute the following commands:
cd Disk1
./runInstaller if show :
DISPLAY not set!
Please set DISPLAY and try again.
Then set DISPLAY
export DISPLAY=192.168.1.177:0.0 su – oracle
cd Disk1
./runInstaller cd Disk1
./runInstaller unix group name:oinstall When network configuration assistant and database configuration assistant has failed during st artup then do following steps:
cd /opt/oracle/920
rm JRE
ln -s /opt/jre1.3.1_18 JRE
su -
# cd /opt/oracle/920/JRE/bin
# ln -s java jre
# cd i386/native_threads
# ln -s java jre lsnrctl start/stop
停 db
oracle$ sqlplus /nolog
SQL> connect / as sysdba
SQL> startup
SQL>shutdown immediate
Post-Instalation Tasks1. Switch back the GCC binaries
su -
# cd /usr/bin
# mv ./gcc ./gcc296
# mv ./gcc3 ./gcc2. Change of JRE path in Oracle Universal Installer
Edit the $ORACLE_BASE/oui/oraparam.ini file and modify the value of JRE_LOCATION to /opt/jre1.3.1_18
3. (Optional) You may consider to use rlwrap for comfortable work with sqlplus. RPM package for Fedora Core (x86) distribution you can download
here.
su -
# rpm -ivh rlwrap-0.24.fedora.i386.rpm
# exit
echo "alias sqlplus=’rlwrap sqlplus’" >> /home/oracle/.bash_profile
. /home/oracle/.bash_profile Common Installation ErrorsUnable to load native library: /tmp/OraInstall2005-01-08_11-11-34AM/jre/lib/i386/libjava.so: symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference
Solution: Install new JRE 1.3.1 version. Edit the Disk1/install/linux/oraparam.ini and set path to new JRE for JRE_LOCATION variable. For more information see Download & Install section.
/tmp/OraInstall2005-04-26_11-38-19AM/jre/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory
Solution: Install the xorg-x11-deprecated-libs package (for >=FC4 versions). For FC5 and later install libXp package.
/tmp/OraInstall2005-06-14_03-46-25PM/jre/bin/i386/native_threads/java: error while loading shared libraries: /tmp/OraInstall2005-06-14_03-46-25PM/jre/lib/i386/native_threads/libhpi.so: cannot restore segment prot after reloc: Permission denied
Solution: Modify /etc/selinux/config and change value of SELINUX to "disabled" and reboot computer.
Starting Oracle Intelligent Agent.../opt/oracle/920/bin/dbsnmpwd: line 156: 1393 Segmentation fault nohup $ORACLE_HOME/bin/dbsnmp $* >>$DBSNMP_WDLOGFILE 2>&1
/opt/oracle/920/bin/dbsnmpwd: line 156: 1405 Segmentation fault nohup $ORACLE_HOME/bin/dbsnmp $* >>$DBSNMP_WDLOGFILE 2>&1
/opt/oracle/920/bin/dbsnmpwd: line 156: 1416 Segmentation fault nohup $ORACLE_HOME/bin/dbsnmp $* >>$DBSNMP_WDLOGFILE 2>&1
/opt/oracle/920/bin/dbsnmpwd: line 156: 1427 Segmentation fault nohup $ORACLE_HOME/bin/dbsnmp $* >>$DBSNMP_WDLOGFILE 2>&1
Solution: Download and apply patch nr.: 3238244 from http://metalink.oracle.com.
Exception in thread "main" java.lang.InternalError: Can’t connect to X11 window server using ’localhost:0.0’ as the value of the DISPLAY variable.
Solution: Execute "export DISPLAY=:0.0" (as oracle user) and "xhost +" as user who has opened X session (for example logged in KDE, GNOME, etc.). If the value is other than 127.0.0.1 or localhost you should "xhost +" on client machine.
Error in invoking target install of makefile /opt/oracle/920/ctx/lib/ins_ctx.mk
Error in invoking target install of makefile /opt/oracle/920/precomp/lib/ins_precomp.mk
Error in invoking target install of makefile /opt/oracle/920/plsql/lib/ins_plsql.mk
Error in invoking ntcontab.o of makfile /opt/oracle/920/network/lib/ins_net_client.mk
Solution: Install the compat-gcc-7.3-2.96.126.i386.rpm (gcc 2.96) package and change the GCC binaries. For more information see Download & Install section. In case of Fedora Core 5 take look at next error message.
sed: -e expression #1, char 7: unterminated `s’ command error in $ORACLE_HOME/install/make.log
Solution: There is probably bug in bash (FC5 only). Download and install bash package from FC4. I have prepared this package (builded from FC4 src.rpm) for FC5 -
Download.
Install it using "rpm -ivh bash-3.0-31.i386.rpm --force".
Initializing Java Virtual Machine from /tmp/OraInstall2006-10-25_01-43-30PM/jre/bin/java. Please wait... /tmp/OraInstall2006-10-25_01-43-30PM/jre/bin/i386/native_threads/java: error while loading shared libraries: libstdc++-libc6.1-1.so.2: cannot open shared object file: No such file or directory - after ./runInstaller execution.
Solution:
su -
# cd /usr/lib
# ln -s libstdc++-3-libc6.2-2-2.10.0.so libstdc++-libc6.1-1.so.2
Start ./runInstaller again.
Last update: 25-10-2006. Comments, suggestions, questions, errors (also grammatical :) )? Feel free to
contact me.
Thrown when the IP address of a host cannot be determined
Solution:
vi /etc/host
[root@o4linux3 ~]# vi /etc/host
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost.localdomain localhost
192.168.1.59 o4linux3