linux 7.5 安装oracle 12c,Oracle linux上安装oracle 12c文档

最新推荐文章于 2023-07-28 14:39:13 发布

weixin_39897070

最新推荐文章于 2023-07-28 14:39:13 发布

阅读量147

点赞数

文章标签： linux 7.5 安装oracle 12c

下载地址：http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

或者直接到edelivery下载：https://edelivery.oracle.com

V38500-01_1of2.zip

V38500-01_2of2.zip

官方安装文档地址：http://docs.oracle.com/cd/E16655_01/install.121/e17718/toc.htm

1、安装依赖包

对于linux5，官方给出的如下：

[code]binutils-2.17.50.0.6

compat-libstdc++-33-3.2.3

compat-libstdc++-33-3.2.3 (32 bit)

gcc-4.1.2

gcc-c++-4.1.2

glibc-2.5-58

glibc-2.5-58 (32 bit)

glibc-devel-2.5-58

glibc-devel-2.5-58 (32 bit)

ksh

libaio-0.3.106

libaio-0.3.106 (32 bit)

libaio-devel-0.3.106

libaio-devel-0.3.106 (32 bit)

libgcc-4.1.2

libgcc-4.1.2 (32 bit)

libstdc++-4.1.2

libstdc++-4.1.2 (32 bit)

libstdc++-devel 4.1.2

libXext-1.0.1

libXext-1.0.1 (32 bit)

libXtst-1.0.1

libXtst-1.0.1 (32 bit)

libX11-1.0.3

libX11-1.0.3 (32 bit)

libXau-1.0.1

libXau-1.0.1 (32 bit)

libXi-1.0.1

libXi-1.0.1 (32 bit)

make-3.81

sysstat-7.0.2[/code]

将安装光盘挂载到虚拟机，进入Server目录。使用rpm -qa查询包是否安装，使用rpm -ivh安装未安装的包

[code][root@ora12c Server]# pwd

/media/OL5.7 x86_64 dvd 20110728/Server

[root@ora12c Server]# rpm -qa compat-libstdc

[root@ora12c Server]# rpm -ivh compat-libstdc++-33-3.2.3-61.

compat-libstdc++-33-3.2.3-61.i386.rpm

compat-libstdc++-33-3.2.3-61.x86_64.rpm

[root@ora12c Server]# rpm -ivh compat-libstdc++-33-3.2.3-61.i386.rpm

warning: compat-libstdc++-33-3.2.3-61.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing... ########################################### [100%]

package compat-libstdc++-33-3.2.3-61.i386 is already installed

[root@ora12c Server]# rpm -ivh compat-libstdc++-33-3.2.3-61.x86_64.rpm

warning: compat-libstdc++-33-3.2.3-61.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing... ########################################### [100%]

package compat-libstdc++-33-3.2.3-61.x86_64 is already installed[/code]

按照次方法将所有包安装

2、创建oracle用户和组

[code][root@ora12c Server]# groupadd oinstall

[root@ora12c Server]# groupadd dba

[root@ora12c Server]# useradd -g oinstall -G dba oracle

[root@ora12c Server]# passwd oracle

Changing password for user oracle.

New UNIX password:

BAD PASSWORD: it is based on a dictionary word

Retype new UNIX password:

passwd: all authentication tokens updated successfully.[/code]

3、创建目录

[code][root@ora12c Server]# mkdir -p /oracle/

[root@ora12c Server]# chown -R oracle:oinstall /oracle/

[root@ora12c Server]# chmod -R 775 /oracle/[/code]

4、修改内核参数

在/etc/sysctl.conf文件下加入如下参数

[code][root@ora12c Server]# vim /etc/sysctl.conf

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 536870912

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048586[/code]

/sbin/sysctl -p 是参数生效

[code][root@ora12c Server]# /sbin/sysctl -p

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 536870912

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048586

net.ipv4.ip_forward = 0

net.ipv4.conf.default.rp_filter = 2

net.ipv4.conf.default.accept_source_route = 0

kernel.sysrq = 0

kernel.core_uses_pid = 1

net.ipv4.tcp_syncookies = 1

kernel.msgmnb = 65536

kernel.msgmax = 65536

kernel.shmmax = 68719476736

kernel.shmall = 4294967296[/code]

5、修改用户限制

在/etc/security/limits.conf加入相关配置

[code][root@ora12c Server]# vim /etc/security/limits.conf

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft stack 10240

oracle hard stack 10240[/code]

6、配置环境变量

在 .bash_profile配置如下变量

[code][oracle@ora12c ~]$ vim .bash_profile

export ORACLE_BASE=/oracle/12c

export ORACLE_HOME=$ORACLE_BASE/db1

export ORACLE_SID=orcl12c

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

export EDITOR=/bin/vi[/code]

使配置文件生效

[oracle@ora12c ~]$ source .bash_profile

7、ftp上传数据库安装文件

[code]stevenMacBook-Pro:~ steven$ ftp 130.30.0.210

Connected to 130.30.0.210.

220 (vsFTPd 2.0.5)

Name (130.30.0.210:steven): oracle

331 Please specify the password.

Password:

ftp> bin

200 Switching to Binary mode.

ftp> cd /oracle

ftp> put V38500-01_1of2.zip

local: V38500-01_1of2.zip remote: V38500-01_1of2.zip

229 Entering Extended Passive Mode (|||15729|)

150 Ok to send data.

100% |***********************************| 1297 MiB 11.49 MiB/s 00:00 ETA

226 File receive OK.

1361028723 bytes sent in 01:52 (11.49 MiB/s)

ftp> put V38500-01_2of2.zip

local: V38500-01_2of2.zip remote: V38500-01_2of2.zip

229 Entering Extended Passive Mode (|||29997|)

150 Ok to send data.

100% |***********************************| 1064 MiB 9.43 MiB/s 00:00 ETA

226 File receive OK.

1116527103 bytes sent in 01:53 (9.38 MiB/s)[/code]

8、解压文件

unzip V38500-01_1of2.zip

unzip V38500-01_2of2.zip

9、运行OUI安装

cd database

./runInstaller

基本上和之前的区别不大，下一步下一步搞定

[img]http://www.orasql.com/bbs/download/file.php?id=81[/img]

配置

[img]http://www.orasql.com/bbs/download/file.php?id=78[/img]

正在安装

[img]http://www.orasql.com/bbs/download/file.php?id=79[/img]

root运行2个脚本

[code][root@ora12c Server]# cd /oracle/oraInventory/

[root@ora12c oraInventory]# ./orainstRoot.sh

Changing permissions of /oracle/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /oracle/oraInventory to oinstall.

The execution of the script is complete.

[root@ora12c oraInventory]# cd /oracle/12c/db1/

[root@ora12c db1]# ./root.sh

Performing root user operation for Oracle 12c

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /oracle/12c/db1

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 script.

Now product-specific root actions will be performed.[/code]

初始化数据库

[img]http://www.orasql.com/bbs/download/file.php?id=80[/img]

在创建数据库时，12c会自动创建监听

[code][oracle@ora12c ~]$ lsnrctl status

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 27-JUN-2013 12:41:16

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production

Start Date 27-JUN-2013 12:01:32

Uptime 0 days 0 hr. 39 min. 45 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /oracle/12c/db1/network/admin/listener.ora

Listener Log File /oracle/12c/diag/tnslsnr/ora12c/listener/alert/log.xml

Listening Endpoints Summary...

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

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

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=ora12c)(PORT=5500))(Security=(my_wallet_directory=/oracle/12c/admin/orcl12c/xdb_wallet))(Presentation=HTTP)(Session=RAW))

Services Summary...

Service "orcl12c" has 1 instance(s).

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

Service "orcl12cXDB" has 1 instance(s).

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

Service "pdborcl12c" has 1 instance(s).

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

The command completed successfully[/code]

使用sqlplus连接数据库

[code][oracle@ora12c ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Thu Jun 27 12:41:41 2013

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> set linesize 150

SQL> select * from v$version;

BANNER CON_ID

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

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production 0

PL/SQL Release 12.1.0.1.0 - Production 0

CORE 12.1.0.1.0 Production 0

TNS for Linux: Version 12.1.0.1.0 - Production 0

NLSRTL Version 12.1.0.1.0 - Production 0[/code]

「喜欢文章，快来给作者赞赏墨值吧」赞赏

请登录后发表评论

weixin_39897070

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
linux 7.5 安装oracle 12c,Oracle linux上安装oracle 12c文档

下载地址：http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html或者直接到edelivery下载：https://edelivery.oracle.comV38500-01_1of2.zipV38500-01_2of2.zip官方安装文档地址：http://docs.oracle.com/...
复制链接

扫一扫