CentOS 5.5 的oracle 10g安装(32位)

CentOS 5.5 的oracle 10g安装(32位)


测试环境:


主机:windows server 2008 R2 64位


虚拟机:VMware Workstation 11.0.0(32位)


linux版本:CentOS release 5.5 (Final) (32位)


主机性能有限,所以只采用32位的测试环境。


[root@localhost ~]# ls
anaconda-ks.cfg  Desktop  install.log  install.log.syslog




#内存检查
[root@localhost ~]# grep MemTotal /proc/meminfo
MemTotal:      2075368 kB


#查看共享内存大小
[root@localhost ~]# df -k /dev/shm
Filesystem           1K-blocks      Used Available Use% Mounted on
tmpfs                  1037684         0   1037684   0% /dev/shm


#交换空间检查
[root@localhost ~]# grep SwapTotal /proc/meminfo
SwapTotal:     4128696 kB


#查看有效的内存和交换空间
[root@localhost ~]# free
             total       used       free     shared    buffers     cached
Mem:       2075368     889704    1185664          0      83688     641828
-/+ buffers/cache:     164188    1911180
Swap:      4128696          0    4128696


#检查临时目录/tmp
[root@localhost ~]# df -k /tmp
Filesystem           1K-blocks      Used Available Use% Mounted on
/dev/sda2             56643640   2401496  51318316   5% /


#检查磁盘空间
[root@localhost ~]# df -k
Filesystem           1K-blocks      Used Available Use% Mounted on
/dev/sda2             56643640   2401496  51318316   5% /
/dev/sda1               295561     16202    264099   6% /boot
tmpfs                  1037684         0   1037684   0% /dev/shm
.host:/              1428056060 1113043392 315012668  78% /mnt/hgfs


#检查OS版本
[root@localhost ~]# lsb_release -a
LSB Version:    :core-3.1-ia32:core-3.1-noarch:graphics-3.1-ia32:graphics-3.1-noarch
Distributor ID: CentOS
Description:    CentOS release 5.5 (Final)
Release:        5.5
Codename:       Final


#检查内核
[root@localhost ~]# uname -r
2.6.18-194.el5


#标识用户的存在性
[root@localhost ~]# id oracle
uid=500(oracle) gid=500(oracle) groups=500(oracle) 


context=root:system_r:unconfined_t:SystemLow-SystemHigh




#创建组
[root@localhost ~]# /usr/sbin/groupadd oinstall
[root@localhost ~]# /usr/sbin/groupadd dba
[root@localhost ~]# /usr/sbin/groupadd oper


#安装OS时就建好了oracle用户


#用户分组,这里是用图形界面完成的
[root@localhost ~]# /usr/sbin/useradd -g oinstall -G dba, oper oracle


#标识用户的存在性,检查一下
[root@localhost ~]# id oracle
uid=500(oracle) gid=500(oracle) groups=500(oracle),501(oinstall),502(dba),503(oper) 


context=root:system_r:unconfined_t:SystemLow-SystemHigh






#检查Oracle 10g安装所需要的内核版本:
[root@localhost ~]# rpm -q gcc make binutils openmotif
gcc-4.1.2-48.el5
make-3.81-3.el5
binutils-2.17.50.0.6-14.el5
package openmotif is not installed


#查询其他包安装情况:
[root@localhost ~]# rpm -q gcc make binutils openmotif setarch compat-db compat-gcc > 


compat-gcc-c++ compat-libstdc++ compat-libstdc++-devel




#安装所需要的包
[root@localhost CentOS]# rpm -Uvh gcc-4*
warning: gcc-4.1.2-48.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID e8562897
Preparing...                ########################################### [100%]
        package gcc-4.1.2-48.el5.i386 is already installed
[root@localhost CentOS]# rpm -Uvh make-3*
warning: make-3.81-3.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID e8562897
Preparing...                ########################################### [100%]
        package make-3.81-3.el5.i386 is already installed
[root@localhost CentOS]# rpm -Uvh binutils-2*
warning: binutils-2.17.50.0.6-14.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 


e8562897
Preparing...                ########################################### [100%]
        package binutils-2.17.50.0.6-14.el5.i386 is already installed
[root@localhost CentOS]# rpm -q gcc make binutils openmotif
gcc-4.1.2-48.el5
make-3.81-3.el5
binutils-2.17.50.0.6-14.el5
package openmotif is not installed


#创建安装目录
[root@localhost CentOS]# mkdir -p /u01/app/oracle
[root@localhost CentOS]# chown -R oracle:oinstall /u01/app/oracle
[root@localhost CentOS]# chmod -R 775 /u01/app/oracle




#切换用户
[root@localhost CentOS]# cd /
[root@localhost /]# su - oracle


#设置环境变量
[oracle@localhost ~]$ vi .bash_profile




在现有文件的下面增加
umask 022
export ORACLE_BASE=/u01/app/oracle;export ORACLE_BASE
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1;
export ORACLE_HOME
export ORACLE_SID=orcl

export PATH=$ORACLE_HOME/bin:$PATH; export PATH

NLS_LANG='Simplified Chinese_china'
DB_HOME=/u01/app/oracle/oradata



#查看环境变量
[oracle@localhost ~]$ env
HOSTNAME=localhost.localdomain
SHELL=/bin/bash
TERM=vt100
HISTSIZE=1000
USER=oracle
LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;3


7;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.s


h=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:


*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.


jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:
ORACLE_BASE=/u01/app/oracle
MAIL=/var/spool/mail/oracle
PATH=/u01/app/oracle/product/10.2.0/db_1/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:


/home/oracle/bin
INPUTRC=/etc/inputrc
PWD=/home/oracle
LANG=en_US.UTF-8
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SHLVL=1
HOME=/home/oracle
LOGNAME=oracle
CVS_RSH=ssh
LESSOPEN=|/usr/bin/lesspipe.sh %s
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
G_BROKEN_FILENAMES=1
_=/bin/env






#让环境变量立即生效
[oracle@localhost ~]$ . ./.bash_profile




#回到root用户
[oracle@localhost ~]$ su - root
Password: 




#修改hosts文件
[root@localhost ~]# vi /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1               localhost.localdomain localhost
::1             localhost6.localdomain6 localhost6


192.168.1.30  orcl-a


#检查
[root@localhost ~]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1               localhost.localdomain localhost
::1             localhost6.localdomain6 localhost6


192.168.1.30  orcl-a


#查看版本信息
[root@localhost /]# cat /etc/redhat-release 
CentOS release 5.5 (Final)






#启用图形支持
[root@localhost ~]# xhost +
access control disabled, clients can connect from any host


#切换用户
[root@localhost ~]# su - oracle


#切换到安装文件下
[oracle@localhost ~]$ cd /mnt/hgfs/sharefiles/oracle10g/10201_database_linux32/database


[oracle@localhost database]$ ls
doc  install  response  runInstaller  stage  welcome.html


#开始安装
[oracle@localhost database]$ ./runInstaller 
Starting Oracle Universal Installer...


Checking installer requirements...


Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, 


asianux-1 or asianux-2
                                      Failed <<<<


Exiting Oracle Universal Installer, log for this session can be found at 


/tmp/OraInstall2015-09-14_02-27-55AM/installActions2015-09-14_02-27-55AM.log




#说是不支持当前linux版本,修改版本信息
#回到root用户修改版本信息
[root@localhost /]# vi /etc/redhat-release 
#CentOS release 5.5 (Final)
CentOS release 4


#回到oracle用户继续安装
[oracle@localhost database]$ ./runInstaller 


Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-09-14_02-30-04AM. 


Please wait ...
[oracle@localhost database]$ Exception in thread "main" 
java.lang.UnsatisfiedLinkError: 
/tmp/OraInstall2015-09-14_02-30-04AM/jre/1.4.2/lib/i386/libawt.so: 
libXp.so.6: cannot open shared object file: No such file or directory


#原因是缺少了包,装上如下的包就可以了。


# rpm -ivh libXp-1.0.0-8.1.el5.i386.rpm


记录一下以免忘记了。


libXau-devel-1.0.1-3.1.i386.rpm


libXp-1.0.0-8.1.el5.i386.rpm


libXp-devel-1.0.0-8.1.el5.i386.rpm




#安装包
[root@localhost CentOS]# rpm -ivh lib*
[root@localhost CentOS]# yum -y install libXau
[root@localhost CentOS]# yum -y install libXp*


#重新开始安装
[oracle@localhost database]$ ./runInstaller 


安装界面出来了。



实例名:orcl
密码:

继续下一步




安装中途报错:
Error in invoking target 'all_no_orcl ihsodbc' of makefile
'/u01/app/oracle/product/10.2.0
/db_1/rdbms/lib/ins_rdbms.mk'




#经查:是由于缺少compat-libstdc++-33*兼容包所报的错误
#回到root用户补充安装
[root@localhost CentOS]# rpm -ivh compat-libstdc++-33-3.2.3-61.i386.rpm 
Preparing...                ########################################### [100%]
   1:compat-libstdc++-33    ########################################### [100%]


安装后,retry。正常通过,继续安装。


#临近安装结束,oracle安装程序提示需要在root用户下运行两个脚本
#脚本1
[root@localhost /]# /u01/app/oracle/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oracle/oraInventory to 770.
Changing groupname of /u01/app/oracle/oraInventory to oracle.
The execution of the script is complete


#脚本2
[root@localhost /]# /u01/app/oracle/product/10.2.0/db_1/root.sh
Running Oracle10 root.sh script...


The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/10.2.0/db_1


Enter the full pathname of the local bin directory: [/usr/local/bin]: 
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...




Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
[root@localhost /]# 


#查看环境变量之实例名
[oracle@localhost ~]$ echo $ORACLE_SID
orcl


#查看监听
[oracle@localhost ~]$ lsnrctl


LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 14-SEP-2015 04:11:21


Copyright (c) 1991, 2005, Oracle.  All rights reserved.


Welcome to LSNRCTL, type "help" for information.


LSNRCTL> help
The following operations are available
An asterisk (*) denotes a modifier or extended command:


start               stop                status              
services            version             reload              
save_config         trace               spawn               
change_password     quit                exit                
set*                show*               


LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                14-SEP-2015 03:41:44
Uptime                    0 days 0 hr. 29 min. 42 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl_XPT" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> quit




#登录数据库
[oracle@localhost ~]$ sqlplus /nolog


SQL*Plus: Release 10.2.0.1.0 - Production on Mon Sep 14 04:12:06 2015


Copyright (c) 1982, 2005, Oracle.  All rights reserved.


SQL> connect / as sysdba
Connected.


SQL> select * from dual;


D
-
X


SQL> 




SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options




#Oracle企业管理器
[oracle@localhost ~]$ emctl
TZ set to US/Pacific
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0  
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
Invalid arguments


Unknown command option 
Usage:: 
   Oracle Enterprise Manager 10g Database Control commands:
       emctl start| stop| status| setpasswd dbconsole
       emctl secure <options>


       emctl set ssl test|off|on em
       emctl set ldap <host> <port> <user dn> <user pwd> <context dn>
emctl blackout options can be listed by typing "emctl blackout"
emctl config options can be listed by typing "emctl config"
emctl secure options can be listed by typing "emctl secure"
emctl ilint  options can be listed by typing "emctl ilint"
emctl deploy  options can be listed by typing "emctl deploy"


[oracle@localhost ~]$ emctl status dbconsole
TZ set to US/Pacific
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0  
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
http://localhost.localdomain:1158/em/console/aboutApplication
Oracle Enterprise Manager 10g is running. 
------------------------------------------------------------------
Logs are generated in directory 


/u01/app/oracle/product/10.2.0/db_1/localhost.localdomain_orcl/sysman/log 






——安装完成

#关机
[root@localhost ~]# init 0




总结:


在实践工作中,安装前的配置和环境检查还是很重要的。简单的说,前期准备工作要做好。

后面还准备测试数据库的创建,创建表空间,建表,删除,闪回,恢复。

转ASM存储,RMAN备份和恢复。

一堆试验。。。。。








评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值