Oracle Linux 6.3 安装Oracle 11g R2 笔记-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

Oracle Linux 6.3 安装Oracle 11g R2 笔记

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 04:49 PM

考虑到方便，本次安装选了Vbox虚拟机，操作系统为Oracle Linux 6.3,Oracle为11g R2。Oracle的安装，官网上的文档非常详细，所以，

最近公司新换了电脑，10G的内存还是挺给力的，首先在本机安装了Oralce运行环境，本以为会很顺利，但还是出了一些小问题，记录下来帮自己梳理下吧，也算是博客的开篇之作。记得第一次在Linux上安装Oracle时，不知折腾了多少天，安装包不对，环境变量配置不好，，种种问题都想不到，也想不明白。现在看来，这都是一个必须要走的一个过程，好多东西只有自己不断实践、总结，才能随心所欲，看清问题的根本，比如简单一个Oracle安装，出问题基本都是由于操作系统相关知识不过关，所以Linux基础还是要打好。

考虑到方便，本次安装选了Vbox虚拟机，操作系统为Oracle Linux 6.3,Oracle为11g R2。Oracle的安装，官网上的文档非常详细，所以，抛弃之前从网上搜现成的安装文档的陋习，直接比照官网文档安装Oracle，放心又方便。

在CentOS 6.4下安装Oracle 11gR2(x64)

Oracle 11gR2 在VMWare虚拟机中安装步骤

Debian 下安装 Oracle 11g XE R2

下面是Oracle文档基本的步骤，根据自己的理解进行了说明：

１.以root用户登录

由于要安装软件，需要root权限，另外由于一般不会在本机安装，还需要Linux支持X windows，安装好xterm即可。

2.确认硬件要求，内存

需要了解基本的要求，比如Oracle１１gR2，至少１G内存，可通过下面命令查看

# grep MemTotal /proc/meminfo

# grep SwapTotal /proc/meminfo

# free

3.软件要求，操作系统、内核、各种包

操作系统只要Oracle支持就好，，一般不会有问题；主要是各种安装包部分，可能还是有一些讲究的，安装文档只是列出了必要的包，并没有详说如何安装，如果服务器可以上网并且网速还可以，那么直接yum install很快就搞定了，但通常安装时都是在内网的，不会让你这么顺利，所以一般需要配置下本地yum

#mkdir /mnt/mydvd

#mount -t iso9660 /dev/dvd /mnt/mydvd

# vi /etc/yum.repos.d/my-yum.repo

[myyum]

name=yumtest

baseurl=file:///mnt/mydvd/Server

gpcheck=0

enable=1

4.创建用户和组

包括三个组一个用户，Oracle安装组－oinstall，OSDBA组－dba，用户－oracle，OSOPER组－oper

查看oinstall组：

#more /etc/oraInst.loc

inventory_loc=/u01/app/oraInventory

inst_group=oinstall

查看dba组：

#grep dba /etc/group

如果没有，创建命令：

# /usr/sbin/groupadd oinstall

#/usr/sbin/groupadd dba

查看oracle用户是否存在，是否属于对应组

#id oracle

如果Oracle用户存在，组不对：

#/usr/sbin/usermod -g oinstall -G dba oracle

如果用户不存在

#/usr/sbin/useradd -g oinstall -G dba oracle

设置密码

#passwd oracle

5.配置内核参数和资源限制

这个直接根据官档上给出的参数贴就可以了

更多详情见请继续阅读下一页的精彩内容：

linux

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

MySQL String Types: Storage, Performance, and Best PracticesMay 10, 2025 am 12:02 AM

MySQLstringtypesimpactstorageandperformanceasfollows:1)CHARisfixed-length,alwaysusingthesamestoragespace,whichcanbefasterbutlessspace-efficient.2)VARCHARisvariable-length,morespace-efficientbutpotentiallyslower.3)TEXTisforlargetext,storedoutsiderows,

Understanding MySQL String Types: VARCHAR, TEXT, CHAR, and MoreMay 10, 2025 am 12:02 AM

MySQLstringtypesincludeVARCHAR,TEXT,CHAR,ENUM,andSET.1)VARCHARisversatileforvariable-lengthstringsuptoaspecifiedlimit.2)TEXTisidealforlargetextstoragewithoutadefinedlength.3)CHARisfixed-length,suitableforconsistentdatalikecodes.4)ENUMenforcesdatainte

What are the String Data Types in MySQL?May 10, 2025 am 12:01 AM

MySQLoffersvariousstringdatatypes:1)CHARforfixed-lengthstrings,2)VARCHARforvariable-lengthtext,3)BINARYandVARBINARYforbinarydata,4)BLOBandTEXTforlargedata,and5)ENUMandSETforcontrolledinput.Eachtypehasspecificusesandperformancecharacteristics,sochoose

How to Grant Permissions to New MySQL UsersMay 09, 2025 am 12:16 AM

TograntpermissionstonewMySQLusers,followthesesteps:1)AccessMySQLasauserwithsufficientprivileges,2)CreateanewuserwiththeCREATEUSERcommand,3)UsetheGRANTcommandtospecifypermissionslikeSELECT,INSERT,UPDATE,orALLPRIVILEGESonspecificdatabasesortables,and4)

How to Add Users in MySQL: A Step-by-Step GuideMay 09, 2025 am 12:14 AM

ToaddusersinMySQLeffectivelyandsecurely,followthesesteps:1)UsetheCREATEUSERstatementtoaddanewuser,specifyingthehostandastrongpassword.2)GrantnecessaryprivilegesusingtheGRANTstatement,adheringtotheprincipleofleastprivilege.3)Implementsecuritymeasuresl

MySQL: Adding a new user with complex permissionsMay 09, 2025 am 12:09 AM

ToaddanewuserwithcomplexpermissionsinMySQL,followthesesteps:1)CreatetheuserwithCREATEUSER'newuser'@'localhost'IDENTIFIEDBY'password';.2)Grantreadaccesstoalltablesin'mydatabase'withGRANTSELECTONmydatabase.TO'newuser'@'localhost';.3)Grantwriteaccessto'

MySQL: String Data Types and CollationsMay 09, 2025 am 12:08 AM

The string data types in MySQL include CHAR, VARCHAR, BINARY, VARBINARY, BLOB, and TEXT. The collations determine the comparison and sorting of strings. 1.CHAR is suitable for fixed-length strings, VARCHAR is suitable for variable-length strings. 2.BINARY and VARBINARY are used for binary data, and BLOB and TEXT are used for large object data. 3. Sorting rules such as utf8mb4_unicode_ci ignores upper and lower case and is suitable for user names; utf8mb4_bin is case sensitive and is suitable for fields that require precise comparison.

MySQL: What length should I use for VARCHARs?May 09, 2025 am 12:06 AM

The best MySQLVARCHAR column length selection should be based on data analysis, consider future growth, evaluate performance impacts, and character set requirements. 1) Analyze the data to determine typical lengths; 2) Reserve future expansion space; 3) Pay attention to the impact of large lengths on performance; 4) Consider the impact of character sets on storage. Through these steps, the efficiency and scalability of the database can be optimized.

See all articles