网络编程 | 站长之家 | 网页制作 | 图形图象 | 操作系统 | 冲浪宝典 | 软件教学 | 网络办公 | 邮件系统 | 网络安全 | 认证考试 | 系统进程
Firefox | IE | Maxthon | 迅雷 | 电驴 | BitComet | FlashGet | QQ | QQ空间 | Vista | 输入法 | Ghost | Word | Excel | wps | Powerpoint
asp | .net | php | jsp | Sql | c# | Ajax | xml | Dreamweaver | FrontPages | Javascript | css | photoshop | fireworks | Flash | Cad | Discuz!
当前位置 > 网站建设学院 > 网络编程 > 数据库 > Oracle教程
Tag:注入,存储过程,分页,安全,优化,xmlhttp,fso,jmail,application,session,防盗链,stream,无组件,组件,md5,乱码,缓存,加密,验证码,算法,cookies,ubb,正则表达式,水印,索引,日志,压缩,base64,url重写,上传,控件,Web.config,JDBC,函数,内存,PDF,迁移,结构,破解,编译,配置,进程,分词,IIS,Apache,Tomcat,phpmyadmin,Gzip,触发器,socket
数据库:数据库教程,数据库技巧,Oracle教程,MySQL教程,Sybase教程,Access教程,DB2教程,数据库安全,数据库文摘
本月文章推荐
.Oracle分层管理器的技术原理及应.
.[Oracle]Oracle10g闪回恢复区详细.
.Oracle中通过触发器来追踪用户的.
.Oracle中的汉字显示.
.Qmail如何把该本地传送的邮件投递.
.全球获得Oracle认证者逾越20万人.
.Oracle常見問題集(四).
.Oracle通过期中考试.
.Oracle中用Rowid查找和删除重复记.
.簡析REDO LOGFILE.
.Oracle E-Business多个未明SQL注.
.研究生管理信息系统的开发流程三.
.Oracle与SQL Server在企业应用中.
.在Linux下打开32位I/O和DMA.
.如何创建DBA ROLE.
.教你怎样进行Oracle数据库性能完.
.查看Oracle回滚段的详细情况,以.
.Oracle的TNS-12502 错误原因及解.
.Oracle 10i的安装过程.
.DataGuard.

Oracle904InstalOnRedHatAS3

发表日期:2008-2-9



  
---------------------------MAKE RAID DISK STORAGE----------------------
STEP 1 :
FOLLOW AS THE HINT,PRESS CTRL-M,START TO CONFIG RAID
STEP 2 :
MAKE 3 RAIDS :1 DISK,1 DISK ,4 DISKS.

---------------------install AS3 operation system in IDE------------------------

step 1:
in installing we choose chinese simplified language package,
step 2:
set operation system default language is us english
step 3:
in install package,wo choose develope package and FTP package

FINISH THE OPERATION SYSTEM INSTALL
--------------------

--------------------fdisk and partition----------------------------------------
step 1
fdisk /dev/sda
n-->p--->1--->return---->+20000M
n-->p--->2--->return---->+20000M
n-->p--->3--->return---->return--->w
fdisk /dev/sdb
n-->p--->1--->return---->return---->w
fdisk /dev/sdc
n-->p--->1--->return---->+40000M
n-->p--->2--->return---->return---->w
mkfs.ext3 /dev/sdc1
mkfs.ext3 /dev/sdc2
step 2
raw /dev/raw/raw1 /dev/sda1
raw /dev/raw/raw2 /dev/sda2
raw /dev/raw/raw3 /dev/sda3
raw /dev/raw/raw4 /dev/sdb1
step 3
 add  command into /etc/rc.d/rc.local
raw /dev/raw/raw1 /dev/sda1
raw /dev/raw/raw2 /dev/sda2
raw /dev/raw/raw3 /dev/sda3
raw /dev/raw/raw4 /dev/sdb1
chown Oracle /dev/raw/raw1
chown oracle /dev/raw/raw2
chown oracle /dev/raw/raw3
chown oracle /dev/raw/raw4

mount -t tmpfs /dev/tmpfs /oradata/bcp_for_ora/m0 -o size=500m

step 4
mkdir /oracle /oradata
step 5
mount /dev/sdc1 /oracle
mount /dev/sdc2 /oradata
it may like this
/********************************************************************/

LABEL=/             /                    ext3    defaults        1 1
LABEL=/boot      /boot             ext3    defaults        1 2
none                /dev/pts             devpts  gid=5,mode=620  0 0
none                /proc                  proc    defaults        0 0
none                /dev/shm             tmpfs   defaults        0 0
LABEL=/swap /swap                 ext3    defaults        1 2
/dev/sdc1          /oracle               ext3    defaults        0 0
/dev/sdc2          /oradata              ext3    defaults        0 0
/********************************************************************/


step 6
add the above two commands into /etc/fstab


------------------------------------------------------------------------------
   INSTALL ORACLE

*-----------------------
*notation!
!!! as3 Linux install must include developer rpms
*-----------------------
===========================================
Step 1.
 Add user and group
===========================================
groupadd dba
groupadd oinstall
useradd -g oinstall -G dba oracle
passwd oracle

mkdir /oracle
mkdir -p /oracle/ora9/prodUCt/
chown oracle.oinstall /oracle
chown -R oracle.oinstall /oracle/ora9
chmod 755 /oracle
chown -R oracle.oinstall /oradata /dev/raw/raw1 /dev/raw/raw2 /dev/raw/raw3 /dev/raw/raw4

===========================================
Step 2.
 Append these lines to
  /etc/sysctl.conf to set kernel parameters:
===========================================

kernel.shmmax = 1073741824
kernel.shmmni = 4096
# *******************************
kernel.shmall = 2097152 
#********************************
kernel.sem    = 250 32000 100 128
fs.file-max   = 65536

net.ipv4.ip_local_port_range = 1024 65000

 

===========================================
Step 3.
 Append these lines to
 /etc/security/limits.conf to
 modify your resource limits:
===========================================

oracle soft nofile 65536
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384

===========================================
Step 4.

===========================================
echo 250 32000 100 128 > /proc/sys/kernel/sem
echo 1073741824 > /proc/sys/kernel/shmmax
echo 4096 > /proc/sys/kernel/shmmni
echo 2097152 > /proc/sys/kernel/shmall
echo 65536 > /proc/sys/fs/file-max
echo 1024 65000 > /proc/sys/net/ipv4/ip_local_port_range

 

===========================================
Step 5.
 Go into the ./rpms Directory and
Add the neccessory runtime file
===========================================

rpm -ivh compat-libstdc++-7.3-2.96.122.i386.rpm
rpm -ivh compat-libstdc++-devel-7.3-2.96.122.i386.rpm

rpm -ivh compat-db-4.0.14-5.i386.rpm
rpm -ivh compat-gcc-7.3-2.96.122.i386.rpm
rpm -ivh compat-gcc-c++-7.3-2.96.122.i386.rpm

rpm -ivh tcl-8.3.5-92.i386.rpm
rpm -ivh setarch-1.3-1.i386.rpm
rpm -ivh openmotif-2.2.2-16.i386.rpm

 


===========================================
Step 6.
 Change compiler's settings
===========================================
mv /usr/bin/gcc /usr/bin/gcc323
ln -s /usr/bin/gcc296 /usr/bin/gcc
mv /usr/bin/g++ /usr/bin/g++323
ln -s /usr/bin/g++296 /usr/bin/g++

 



===========================================
Step 7.
 Unzip the compressed install file
Notice:
1. Copy the three install file into oracle's home
2. change the owner and group to oracle and oinstall

===========================================
chgrp oinstall lnx*
chown oracle lnx*

cpio -idmv <lnx_920_disk1.cpio
cpio -idmv <lnx_920_disk2.cpio
cpio -idmv <lnx_920_disk3.cpio


===========================================
Step 8.
 Unzip the compressed install file
===========================================
unzip p3006854_9204_LINUX.zip
cd 3006854
sh rhel3_pre_install.sh

NOTE: If you get the following error when you run rhel3_pre_install.sh:
  rhel3_pre_install.sh: line 36: gcc: command not found
Then you forgot to install or link gcc, see above. This means you can't start any binaries any more:
# ls
ls: error while loading shared libraries: /etc/libcwait.so: cannot open shared object file: No such file or directory
# rm /etc/ld.so.preload
rm: error while loading shared libraries: /etc/libcwait.so: cannot open shared object file: No such file or directory
#
To fix that, run the echo command which is a built-in shell command:
# echo "" > /etc/ld.so.preload
rm /etc/ld.so.preload

 


===========================================
Step 9.
Copy and replace the Oracle's .bash_profile
with below contents
Notice :
1. check your oracle's path
===========================================
.bash_profile  list


# .bash_profile


# take your display with you at remote login:
# Put it into your ~/.bash_profile

 

# oracle 9i
eXPort ORACLE_BASE=/oracle/ora9
export ORACLE_HOME=/oracle/ora9/product/
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
export ORACLE_OWNER=oracle
export ORACLE_SID=ora9i32
export ORACLE_TERM=xterm
export Java_HOME=$ORACLE_HOME/jdk
export CLASSPATH=./:$ORACLE_HOME/jdbc/lib/classes12.jar:$ORACLE_HOME/lib/XMLparserv2.jar:$ORACLE_HOME/rdbms/jlib/jmscommon.jar:$ORACLE_HOME/rdbms/jlib/aqapi.jar:$ORACLE_HOME/rdbms/jlib/xsu12.jar:$ORACLE_HOME/dm/lib/odmapi.jar:ORACLE_HOME/jdbc/lib/nls_charset12.zip

# Use old Linuxthreads with floating stacks instead of
# the new Native POSIX Thread Library (NPTL)
# *************************
export LD_ASSUME_KERNEL=2.4.19   
#  *************************
export THREADS_FLAG=native

# Edit paths
export PATH
unset USERNAME
umask 022

export LD_LIBRARY_PATH=/oracle/ora9/product/9.2/lib
export PATH=/sbin:$JAVA_HOME/bin:/oracle/ora9/product/9.2/bin:$PATH

#
# change this NLS settings to suit your country:
# example:
# german_germany.we8iso8859p15, american_america.we8iso8859p2 etc.
#
export NLS_LANG='
american_america.ZHS16GBK'

 

# User specific environment and startup programs

PATH=$PATH:$HOME/bin:/usr/sbin


export PATH

 

 

===========================================
Step 10.
 Begin install
===========================================
su - oracle
echo $LD_ASSUME_KERNEL

// Try to find your file's location
export DISPLAY=yourIP:0.0  (use the X-Win32)
runInstaller
inventory:/oracle/ora9/oraInventory
unix group name :oinstall
available product :oracle9i Database 9204
choose Enterprise version

only install software
can not create database;

during the install there will be two notce then run the:
sh  /tmp/orainstRoot.sh
sh  /oracle/ora9/prouuct/root.sh

NOTE :you can remote install
you install x-win32 in your local machine and start it
then you type
export DISPLAY=YOURLOCALIP:0.0
THEN
./runInstaller


===========================================
Step 11.
 update gcc
===========================================


rm  -f /usr/bin/gcc
rm -f /usr/bin/g++
mv /usr/bin/gcc323 /usr/bin/gcc
mv /usr/bin/g++323 /usr/bin/g++
上一篇:Oracle内存结构(三)----Process Memory的详细信息 人气:926
下一篇:Oracle内存结构(四)----如何获得Oracle各内存段的内部信息 人气:995
浏览全部Oracle教程的内容 Dreamweaver插件下载 网页广告代码 祝你圣诞节快乐 2009年新年快乐