网创优客建站品牌官网
为成都网站建设公司企业提供高品质网站建设
热线:028-86922220
成都专业网站建设公司

定制建站费用3500元

符合中小企业对网站设计、功能常规化式的企业展示型网站建设

成都品牌网站建设

品牌网站建设费用6000元

本套餐主要针对企业品牌型网站、中高端设计、前端互动体验...

成都商城网站建设

商城网站建设费用8000元

商城网站建设因基本功能的需求不同费用上面也有很大的差别...

成都微信网站建设

手机微信网站建站3000元

手机微信网站开发、微信官网、微信商城网站...

建站知识

当前位置:首页 > 建站知识

oraclelinux5.8安装oracle10g数据库

1.下载oracle luinux 5.8和oracle 10g数据库软件

创新互联是一家集网站建设,奇台企业网站建设,奇台品牌网站建设,网站定制,奇台网站建设报价,网络营销,网络优化,奇台网站推广为一体的创新建站企业,帮助传统企业提升企业形象加强企业竞争力。可充分满足这一群体相比中小企业更为丰富、高端、多元的互联网需求。同时我们时刻保持专业、时尚、前沿,时刻以成就客户成长自我,坚持不断学习、思考、沉淀、净化自己,让我们为更多的企业打造出实用型网站。

2.操作系统安装

  (1).图形化界面安装

  (2).系统分区

     /       根分区(17G)

     /boot    安装oracle分区(512M)

     swap     交换分区(4G)

  (3).禁用防火墙

  (4).禁用Selinux

3.搭建yum网络源

[root@oracle10g ~]# cd /etc/yum.repos.d/

[root@oracle10g yum.repos.d]# wget http://public-yum.oracle.com/public-yum-el5.repo

[root@oracle10g yum.repos.d]# vim public-yum-el5.repo

[ol5_u8_base]

name=Oracle Linux $releasever Update 8 installation media copy ($basearch)

baseurl=http://yum.oracle.com/repo/OracleLinux/OL5/8/base/$basearch/

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle

gpgcheck=1

enabled=1     --开启

[root@oracle10g yum.repos.d]# yum repolist

4.安装系统依赖包

[root@oracle10g ~]# yum install binutils compat-*  gcc-*  glibc-*  libXp  libXt  libXtst  libaio* libgcc  libstdc++-*  libgomp  make  numactl-devel  sysstat  elfutils-libelf-devel unixODBC-*  -y

5.修改内核参数

[root@oracle10g ~]# vim /etc/sysctl.conf 

kernel.shmall = 2097152

kernel.shmmax = 2147483648

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

fs.file-max = 65536

net.ipv4.ip_local_port_range = 1024 65000

net.core.rmem_default = 262144

net.core.rmem_max = 262144

net.core.wmem_default = 262144

net.core.wmem_max = 262144

[root@oracle10g ~]# sysctl -p      --添加的参数生效

6.用户对系统的限制

[root@oracle10g ~]# vim /etc/security/limits.conf 

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

[root@oracle10g ~]#

7.用户对shell的限制

[root@oracle10g ~]# vim /etc/profile

if [ $USER = "oracle" ]; then

   if [ $SHELL = "/bin/ksh" ]; then

      ulimit -p 16384

      ulimit -n 65536

   else

   ulimit -u 16384 -n 65536

   fi

fi

[root@oracle10g ~]# . /etc/profile

8.用户登陆验证模块

[root@oracle10g ~]# vim /etc/pam.d/login 

session   required     /lib/security/pam_limits.so

session   required     pam_limits.so

[root@oracle10g ~]#

9.主机各与IP地址解析,修改系统版本

[root@oracle10g ~]# vim /etc/hosts

192.168.2.143  oracle1

[root@oracle10g ~]# vim /etc/redhat-release 

Red Hat Enterprise Linux Server release 4 (Tikanga)

[root@oracle10g ~]# vim /etc/oracle-release 

Oracle Linux Server release 4

[root@oracle10g ~]#

10.创建用户和用户组

[root@oracle10g ~]# groupadd  -g 500 oinstall

[root@oracle10g ~]# groupadd  -g 501 dba

[root@oracle10g ~]# useradd -u 500 -g oinstall -G dba -d /home/oracle oracle

[root@oracle10g ~]# echo 500 > /proc/sys/vm/hugetlb_shm_group --将oracle用户的UID写入文件

[root@oracle10g ~]# chown -R oracle:oinstall /home/oracle

[root@oracle10g ~]# password oracle    --设置密码

11.创建目录和设置环境变量

[root@oracle10g ~]# mkdir /u01/oracle/product/10.2.0.1/db_1 -p

[root@oracle10g ~]# chown -R oracle:oinstall /u01/

[root@oracle10g ~]# vim /home/oracle/.bash_profile 

export ORACLE_BASE=/u01/oracle

export ORACLE_HOME=$ORACLE_BASE/product/10.2.0.1/db_1

export ORACLE_SID=orcl10g

export PATH=$ORACLE_HOME/bin:$PATH

[root@oracle10g ~]# . /home/oracle/.bash_profile 

12.解压oracle 10g软件并安装

[root@oracle10g ~]# xhost +

access control disabled, clients can connect from any host

[root@oracle10g ~]# su - oracle

[oracle@oracle10g ~]$ zcat 10201_database_linux_x86_64.cpio.gz  | cpio  -idvm

[oracle@oracle10g ~]$ cd database/

[oracle@oracle10g database]$ ./runInstaller 

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

[root@oracle10g ~]# sh /u01/oracle/oraInventory/orainstRoot.sh 

Changing permissions of /u01/oracle/oraInventory to 770.

Changing groupname of /u01/oracle/oraInventory to oinstall.

The execution of the script is complete

[root@oracle10g ~]# sh /u01/oracle/product/10.2.0.1/db_1/root.sh

Running Oracle10 root.sh script...

The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /u01/oracle/product/10.2.0.1/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@oracle10g ~]# 

oracle linux 5.8安装oracle 10g数据库

13.创建数据库

[oracle@oracle10g database]$ dbca

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

14.创建监听

[oracle@oracle10g database]$ netca

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

oracle linux 5.8安装oracle 10g数据库

[oracle@oracle10g database]$ lsnrctl

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 12-NOV-2016 16:56:10

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

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle10g)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date                12-NOV-2016 16:52:01

Uptime                    0 days 0 hr. 4 min. 11 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/oracle/product/10.2.0.1/db_1/network/admin/listener.ora

Listener Log File         /u01/oracle/product/10.2.0.1/db_1/network/log/listener.log

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle10g)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "orac10g" has 1 instance(s).

  Instance "orac10g", status READY, has 1 handler(s) for this service...

Service "orac10gXDB" has 1 instance(s).

  Instance "orac10g", status READY, has 1 handler(s) for this service...

Service "orac10g_XPT" has 1 instance(s).

  Instance "orac10g", status READY, has 1 handler(s) for this service...

The command completed successfully

LSNRCTL> 

14.登陆oracle数据库

[oracle@oracle10g database]$ sqlplus system/system@orac10g

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Nov 12 16:56:48 2016

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

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

SQL> select * from dual;

D

-

X

SQL> create table t (a number);

Table created.

SQL> insert into t values(1);

1 row created.

SQL> select * from t;

    A

----------

    1

SQL> 


本文标题:oraclelinux5.8安装oracle10g数据库
链接分享:http://bjjierui.cn/article/gpjegp.html

其他资讯