linux as4 is installed under the oracle9

Posted on 2009-06-23 filed under: Oracle (RSS) 23 views

linux as4 is installed under the oracle9

ORACLE patch installed RHAS4 Set
http://www.cublog.cn/opera/showart.php?blogid=8463&id=68996

Environment: Lenovo Wanquan R630 (I think there is no good products) customers are using this server, Lenovo servers that support the specified REDHAT9. 0 / AS 3/AS4 so start preparing to install REDHAT9. 0J, no corresponding results, RAID card driver telephone to the Lenovo technical support, technical support said they do not support, REDHAT9. 0. Mind the installation of AS3, then the next installation of AS3, or RAID driver, however, Lenovo's technical support call, it is necessary to drive, said they were not aware of this technology-driven models, but I almost collapsed, tossing the day, and the results of the case. Ah depressing! Later, asked how do we solve this? The answer AS4 experimental technology installed on! So once in a hard-hearted, plus a small equipment呗! It can be said that risk of going through a thousand difficulties, GOOLE, BAIDU a lot of information, finally completed the installation of systems and databases! Hungry heart much good about them! The installation process is now sharing some hope that other brothers and fewer detours, as soon as possible to go back to sleep after work! Originally, there would be no overtime for it! Not worth the overtime too!
A: AS4 operating system installed, choose the best total package to install, or install the ORACLE package to prompt much less.

These packages are a must, prior to the installation of ORACLE check:

1, see the development kit has been installed;
Installation packages and patch packages:
p4198954_21_linux.zip play before running runInstaller.
p3238244_9204_LINUX.zip patch to repair the wrong agent.
play p2617419_210_GENERIC.zip patch 3238244 patches needed.
compat-db - 4.1.25 -9
compat-gcc-32-3.2.3-47.3
compat-gcc-32-c + + -3.2.3-47.3
compat-oracle-rhel4-1.0-3
compat-libcwait-2.0-1
compat-libgcc-296-2.96-132.7.2
compat-libstdc + + -296-2.96-132.7.2
compat-libstdc + + -33-3.2.3-47.3
gcc-3.4.3-9.EL4
gcc-c + +-3.4.3-9.EL4
gnome-libs-1.4.1.2.90-44
gnome-libs-devel-1.4.1.2.90-44
libaio-devel-0.3.102-1
libaio-0.3.102-1
make-3.80-5
openmotif21-2.1.30-11
xorg-x11-deprecated-libs-devel-6.8.1-23.EL
xorg-x11-deprecated-libs-6.8.1-23.EL
Which compat-oracle-rhel4 and compat-libcwait in the following Web site:
http://oss.oracle.com/projects/compat-oracle/files/RedHat/
# Rpm-qa | grep 'compat'
Note: If the package was incomplete, most of Book 3 in the first system disk. Find yourself. A separate installation package. Dependence may be prompted, when prompted to install the failure is

Rpm - nodeps - force *. rpm

Second, extract the installation files Oracle9204
1. Oracle 9iR2 ( 9.2.0 .4)
(1) simplify the process (to oracle registry, the release of the installation file, use less disk space, faster)
LINUX best when installed at a district / bak

gunzip ship_9204_linux_disk1.cpio.gz

cpio-idmv <ship_9204_linux_disk1.cpio

gunzip ship_9204_linux_disk2.cpio.gz

cpio-idmv <ship_9204_linux_disk2.cpio
gunzip ship_9204_linux_disk3.cpio.gz

cpio-idmv <ship_9204_linux_disk1.cpio
(2) unpacking and decompression process, the automatic creation of three documents containing the installation directory:
Disk1
Disk2
Disk3
Can be installed after the Oracle9iR2.
Third, create a database of the preparations for the installation;
1, create a user / group;
# groupadd dba
# groupadd oinstall
# useradd oracle-g oinstall-G dba
# passwd oracle
2, the establishment of oracle installation folder;
# Mkdir-p / u01/app/oracle/product / 9.2.0 .4
# Mkdir / u01/cwdata
# Chmod 777 / u01/cwdata
# Chown oracle.dba / u01/cwdata
# Chown oracle.dba / orasetup
# Chmod 777 / orasetup
# Chown-R oracle.dba / u01/app/oracle/product/9.2.0.4
# Chmod-R 777 / u01/app/oracle/product/9.2.0.4
2, configure the environment variable;
Login to root user, root user's environment set up to open. Bash_profile file, add this:
export ORACLE_BASE = / u01/app/oracle
export ORACLE_HOME = / u01/app/oracle/product/9.2.0.4
export PATH = $ PATH: $ ORACLE_HOME / bin: $ ORACLE_HOME / Apache / Apache / bin
export ORACLE_OWNER = oracle
export ORACLE_SID = oradb
The use of Oracle User Login:
# su - oracle
$ vi. bash_profile
Following is a profile of content (based on the actual situation of their own)
#. Bash_profile

# Get the aliases and functions
if [-f ~ /. bashrc]; then
. ~ /. Bashrc
fi

# User specific environment and startup programs

PATH = $ PATH: $ HOME / bin
# ORACLE_BASE can navigate to the disk array on / data
export ORACLE_BASE = / u01/app/oracle
export ORACLE_HOME = / u01/app/oracle/product/9.2.0.4
export PATH = $ PATH: $ ORACLE_HOME / bin: $ ORACLE_HOME / Apache / Apache / bin
export ORACLE_OWNER = oracle
export ORACLE_SID = oradb
export ORACLE_TERM = xterm
export LD_ASSUME_KERNEL = 2.4.19
export THREADS_FLAG = native
export LD_LIBRARY_PATH = $ LD_LIBRARY_PATH: $ ORACLE_HOME / lib
export NLS_LANG = "American_america.zhs16gbk"
# Export NLS_LANG = "SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
export ORA_NLS33 = $ ORACLE_HOME / ocommon / nls / admin / data
export DISPLAY =: 0
export LANG = en_US
export GDM_LANG = en_US
export LC = en_US
export PATH
unset USERNAME
4, set the system parameters;
# su - root to switch to root user
a) modify # vi / etc / sysctl.conf, the following is the contents of configuration files (one red font for the added content):
# Kernel sysctl configuration file for Red Hat Linux
#
# For binary values, 0 is disabled, 1 is enabled. See sysctl (and
# Sysctl.conf (5) for more details.

# Controls IP packet forwarding
net.ipv4.ip_forward = 0

# Controls source route verification
net.ipv4.conf.default.rp_filter = 1

# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 0

# Controls whether core dumps will append the PID to the core filename.
# Useful for debugging multi-threaded applications.
kernel.core_uses_pid = 1
kernel.shmmax = 536870912 / 268435456
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
Modified to run # sysctl-p command allows the kernel to change with immediate effect;
Translator's Note: Under normal circumstances you can set the maximum shared memory for half of physical memory, if physical memory is 2G , You can set the maximum shared memory for the 1,073,741,824, as indicated; such as the physical memory is 1G , You can set the maximum shared memory of 512 * 1024 * 1024 = 536,870,912; and so on. )
Proposal to increase shmmax setting permanently.
sem 4 parameters were SEMMSL (each user has a maximum number of semaphore); SEMMNS (the largest number of signals); SEMOPM (for each system call semopm operand); SEMMNI (system hard maximum number of volume sets). Shmmax maximum shared memory, the official document is the memory recommended 1 / 2, Shmmni minimum shared memory size of all memory 4096KB.Shmall

B) set the oracle of the documentation requirements:
Edit the document: # vi / etc / security / limits.conf by adding the following statement:
oracle soft nofile 65536
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384

C ) Gcc downgrade
# su - root
# mv / usr / bin / gcc / usr/bin/gcc34
# ln-s / usr/bin/gcc32 / usr / bin / gcc
# mv / usr / bin / g + + / usr / bin / g + +34
# ln-s / usr / bin / g + +32 / usr / bin / g + +
After the installation is complete remember to resume later in order to prevent future use of GCC
5, to install oracle patch

I suggest the first choice of installation SOFT installation, and then use the DBCA and NETCA and configuration database. As4 installed because the installation ORACLE9204 database at the same time when using DBCA, called JRE problem, you will find that library may have been fixed to stop 46 percent. I waited for more than two hours are not fixed point, then re-install it this way, then call the JRE that he is wrong, it should be a BUG. Therefore, we suggest that you first install the software, after the establishment of databases.

When you implement Oracle 9iR2 CD runInstaller appears when the error message:
Error occurred during initialization of VM
Unable to load native library:
/ tmp / OraInstall 2003-10-25 _03-14-57PM/jre/lib/i386
/ libjava.so symbol _libc_wait, version GLIBC_2.0 not
defined in file libc.so.6 with link time reference
In order to solve the problem _libc_wait symbols,
Download patch from http://oss.oracle.com/projects/compat-oracle/files/RedHat/
compat-libcwait-2.0-2.i386.rpm compat-oracle-rhel4-1.0-5.i386.rpm. In order to apply this patch, you can run:
$ su - root
# Cd / bak
# ls compat *. rpm
compat-libcwait-2.0-2.i386.rpm compat-oracle-rhel4-1.0-5.i386.rpm
# Rpm-Uvh compat *. rpm
Preparing ... ########################################### [100% ]
1at-libcwait-2.0-2.i386.rpm ##################################### [50 %]
at-oracle-rhel4-1.0-5.i386.rpm #################################### [ 100%]
Fourth, start the installation oracle9iR2
(A) to start the installation:
1. To oracle user sign-on system for Oracle installation:
$ Cd Disk1
$. / RunInstaller After a while there will be the installation of Oracle interface
2. Step by step to install it on the list!
The installation process in order to root user will be prompted to perform some procedures for landing
3, after the patch is installed: (I have not encountered the situation Pink)
Switch to root: # su - root to install the first opatch.
# cd / bak

# unzip p2617419_210_GENERIC.zip
Archive: p2617419_210_GENERIC.zip
creating: OPatch /
creating: OPatch / docs /
inflating: Opatch / docs / FAQ
......
inflating: README.txt
# export PATH = $ PATH: / orasetup / OPatch: / sbin
(Modified to include the PATH to extract from the sbin directory and Opatch)
# Unzip p3238244_9204_LINUX.zip
# Cd 3238244
# mkdir / var / tmp / .oracle
# chown oracle: dba / var / tmp / .oracle
# Opatch apply

If the HOME variable error prompt executable statement:
# export ORACLE_BASE = / u01/app/oracle
# export ORACLE_HOME = / u01/app/oracle/product / 9.2.0 .4
Prompt appears on the success of all installed successfully.

After the patch finished, but also relinked one. Mk document window to switch to the oracle user
cd $ ORACLE_HOME / network / lib
make-f ins_oemagent.mk install
Agent will be able to start after the service.

Third: Because DBCA call ORACLE database is the JRE itself a mistake, therefore, I suggest that their up to install a JRE.

1: Download j2sdk-1_4_2_04-linux-i586-rpm.bin to the server

2: chmod + x j2sdk-1_4_2_04-linux-i586-rpm.bin

3: sh j2sdk-1_4_2_04-linux-i586-rpm.bin

4: rpm-ivh j2sdk-1_4_2_04-linux-i586.rpm

5: mv $ ORACLE_HOME / JRE $ ORACLE_HOME / JRE_ORIG

ln-s / usr / java / jdk 1.4.2 / jre $ ORACLE_HOME / JRE

su - root

ln-s / usr / java / jdk 1.4.2 / jre / bin / java / usr/java/jdk1.4.2/jre/bin/jre

ln-s / usr / java / jdk 1.4.2 / jre/bin/i386/native_threads/java / usr/java/jdk1.4.2/jre/bin/i386/native_threads/jre

6: su - oracle

Export JRE_LOCATION = / usr / java / jdk 1.4.2

7: dbca database to establish the beginning of the smooth. . . . . . . . . . . . . All the best of luck

8: netca monitor configuration database

Four: Configure it self-starting

1, after the completion of the database to create, modify / etc / oratab, the final boss of the N line into Y, and then restart the database dbstart implementation of the database may not be able to start, the report Can't find init file ... the error, the need for an initial copy of documents:
cp / u01/app/oracle/admin/oradb/pfile/init.ora .* / u01/app/oracle/product / 9.2.0 / dbs / initoradb.ora
Dbstart rerun it.
In order to facilitate the management, you can write a startup script ora9i:
Entered root in the preparation of the following script:

#! / bin / bash
# start and stop the oracle instance
# Chkconfig-level 5 - add ora9i
# chkconfig: 345 91 19
# Description: starts the oracle listener and instance

export ORACLE_HOME = "/ u01/app/oracle/product/9.2.0.4"
export PATH = $ ORACLE_HOME / bin: $ ORACLE_HOME / Apache / Apache / bin: $ PATH
export ORACLE_OWNER = "oracle"
export ORACLE_SID = oradb

if [!-f $ ORACLE_HOME / bin / dbstart-o!-d $ ORACLE_HOME]
then
echo "oracle startup: cannot start"
exit 1
fi

case "$ 1" in
start)
# startup the listener and instance
echo-n "oracle startup:"
su - $ ORACLE_OWNER-c "$ ORACLE_HOME / bin / lsnrctl start"
su - $ ORACLE_OWNER-c $ ORACLE_HOME / bin / dbstart
touch / var / lock / subsys / oracle
echo "finished"
;;
stop)
# Stop listener, apache and database
echo-n "oracle shutdown:"
su - $ ORACLE_OWNER-c "$ ORACLE_HOME / bin / lsnrctl stop"
su - $ ORACLE_OWNER-c $ ORACLE_HOME / bin / dbshut
rm-f / var / lock / subsys / oracle
echo "finished"
;;
reload | restart)
$ 0 stop
$ 0 start
;;
*)
echo "Usage: ora9i [start | stop | reload | restart]"
exit 1

esac
exit 0

Save as ora9i after, and then use chmod a + x ora9, may in the future to root Run / etc/rc.d/init.d/ora9i start | stop to manage the oracle of the start-up and stopped. If you want this script into the system so that it can be switched, then to run the following command: chkconfig - level 3 (or 5) - add ora9i
Or, to use the root user to perform the following command:
# cp / orasetup/ora9i / etc / rc.d / init.d /
# chmod a + x / etc / rc.d / init.d / ora9
# cd / etc/rc.d/rc5.d
# ln-s / etc/rc.d/init.d/ora9i S99ora9i
# cd / etc/rc.d/rc0.d
# ln-s / etc/rc.d/init.d/ora9i K99ora9i
Can also be self-starting oracle9i!
Or in the / etc / rc.d / rc.local add the following:
su - oracle-c "/ u01/app/oracle/product/9.2.0.4/bin/lsnrctl start"
su - oracle-c "/ u01/app/oracle/product/9.2.0.4/bin/dbstart start"

2
Re-installed on the database to delete the questions:
The ORACLE installation directory and delete the / etc / ora *.* to delete on the list
# rm-f / etc / ora *.*