免费观看又色又爽又黄的小说免费_美女福利视频国产片_亚洲欧美精品_美国一级大黄大色毛片

oraclelinux5.8安裝oracle10g數(shù)據(jù)庫

1.下載oracle luinux 5.8和oracle 10g數(shù)據(jù)庫軟件

創(chuàng)新互聯(lián)是一家集網(wǎng)站建設(shè),奇臺企業(yè)網(wǎng)站建設(shè),奇臺品牌網(wǎng)站建設(shè),網(wǎng)站定制,奇臺網(wǎng)站建設(shè)報價,網(wǎng)絡(luò)營銷,網(wǎng)絡(luò)優(yōu)化,奇臺網(wǎng)站推廣為一體的創(chuàng)新建站企業(yè),幫助傳統(tǒng)企業(yè)提升企業(yè)形象加強(qiáng)企業(yè)競爭力。可充分滿足這一群體相比中小企業(yè)更為豐富、高端、多元的互聯(lián)網(wǎng)需求。同時我們時刻保持專業(yè)、時尚、前沿,時刻以成就客戶成長自我,堅(jiān)持不斷學(xué)習(xí)、思考、沉淀、凈化自己,讓我們?yōu)楦嗟钠髽I(yè)打造出實(shí)用型網(wǎng)站。

2.操作系統(tǒng)安裝

  (1).圖形化界面安裝

  (2).系統(tǒng)分區(qū)

     /       根分區(qū)(17G)

     /boot    安裝oracle分區(qū)(512M)

     swap     交換分區(qū)(4G)

  (3).禁用防火墻

  (4).禁用Selinux

3.搭建yum網(wǎng)絡(luò)源

[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.安裝系統(tǒng)依賴包

[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.修改內(nèi)核參數(shù)

[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      --添加的參數(shù)生效

6.用戶對系統(tǒng)的限制

[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.用戶登陸驗(yàn)證模塊

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

session   required     /lib/security/pam_limits.so

session   required     pam_limits.so

[root@oracle10g ~]#

9.主機(jī)各與IP地址解析,修改系統(tǒng)版本

[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.創(chuàng)建用戶和用戶組

[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    --設(shè)置密碼

11.創(chuàng)建目錄和設(shè)置環(huán)境變量

[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數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

[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數(shù)據(jù)庫

13.創(chuàng)建數(shù)據(jù)庫

[oracle@oracle10g database]$ dbca

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

14.創(chuàng)建監(jiān)聽

[oracle@oracle10g database]$ netca

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

oracle linux 5.8安裝oracle 10g數(shù)據(jù)庫

[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數(shù)據(jù)庫

[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> 

分享標(biāo)題:oraclelinux5.8安裝oracle10g數(shù)據(jù)庫
網(wǎng)頁URL:http://m.newbst.com/article18/gpjegp.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供微信小程序定制網(wǎng)站用戶體驗(yàn)網(wǎng)站制作關(guān)鍵詞優(yōu)化

廣告

聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請盡快告知,我們將會在第一時間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場,如需處理請聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時需注明來源: 創(chuàng)新互聯(lián)

成都網(wǎng)頁設(shè)計公司