目录1 报告内容概要2 Oracle Database 11g R2安装过程详解2.1 安装前的准备工作2.1.1 拷贝安装文件2.1.2 解压安装包的压缩文件2.
目录
1 报告内容概要
2 Oracle Database 11g R2安装过程详解
2.1 安装前的准备工作
2.1.1 拷贝安装文件
2.1.2 解压安装包的压缩文件
2.1.3 创建oracle相关用户和组
2.1.4 创建相关目录并赋予权限
2.1.5 设置Oracle用户的环境变量
2.2 开始安装软件
2.2.1 启动安装程序的图形界面
2.2.2 安装过程
3 数据库的创建
3.1 创建数据库
3.2 创建监听
3.3 继续数据库创建过程
(全文点击小图看大图)
1 报告内容概要
本文介绍了在Oracle Linux 6环境中安装Oracle Database 11.2.0以及创建一个数据库的详细过程。
2 Oracle Database 11安装过程详解
2.1 安装前的准备工作
2.1.1 拷贝安装文件
由于安装的Oracle Database 11是在VMware Workstation 10环境下的Oracle Linux 6中安装的,,所以事先通过SecureFXPortable这个软件将Oracle Database 11安装包拷贝到Oracle Linux 6中/u01分区下software文件夹中;
2.1.2 解压安装包的压缩文件
压缩文件解压为“database”文件夹;
[root@ENMOEDU ~]# cd /u01/software
[root@ENMOEDU software]# ls
database p10404530_112030_LINUX_1of7.zip p10404530_112030_LINUX_2of7.zip
2.1.3 创建oracle相关用户和组
[root@ENMOEDU ~]# groupadd dba
[root@ENMOEDU ~]# groupadd oinstall
[root@ENMOEDU ~]# useradd -g oinstall -G dba -s /bin/bash oracle
[root@ENMOEDU ~]# 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.
2.1.4 创建相关目录并赋予权限
[root@ENMOEDU ~]# mkdir /soft
[root@ENMOEDU ~]# chown -R oracle:oinstall /soft
[root@ENMOEDU ~]# chmod -R 755 /soft
[root@ENMOEDU ~]# mkdir -p /u01/app/oracle
[root@ENMOEDU ~]# chown -R oracle:oinstall /u01
[root@ENMOEDU ~]# chmod -R 755 /u01
2.1.5 设置Oracle用户的环境变量
[root@ENMOEDU ~]# su - oracle
[oracle@ENMOEDU ~]$ vi .bash_profile
将.bash_profile文件修改如下:
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORACLE_SID=ENMOEDU
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
然后执行:[oracle@ENMOEDU ~]$ source .bash_profile
至此,安装前的准备工作已经完成。
2.2 开始安装软件
2.2.1 启动安装程序的图形界面
在oracle用户下,打开安装程序的图形界面:
[oracle@ENMOEDU ~]$ cd /u01/software/database
[oracle@ENMOEDU database]$ ls
doc readme.html rpm sshsetup welcome.html
install response runInstaller stage
[oracle@ENMOEDU database]$ ./runInstaller
此时会显示这个提示:
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 4324 MB Passed
Checking swap space: must be greater than 150 MB. Actual 5119 MB Passed
Checking monitor: must be configured to display at least 256 colors
>>> Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed
Some requirement checks failed. You must fulfill these requirements before
continuing with the installation,
Continue? (y/n) [n]
然后执行以下操作:
[oracle@ENMOEDU database]$ su - root
Password:
[root@ENMOEDU ~]# xhost +
access control disabled, clients can connect from any host
继续之前安装:
[root@ENMOEDU ~]# su - oracle
[oracle@ENMOEDU ~]$ cd /u01/software/database
[oracle@ENMOEDU database]$ ./runInstaller
将“I wish to receive security updates via My Oracle Support”取消。
至此,安装文件的图形界面已经启动。
2.2.2 安装过程
(1)点击“Yes”;
(2)取消软件更新;
(3)选择只安装软件;
(4)选择单实例数据库安装

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

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

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

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.

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.

MySQLBLOBshavelimits:TINYBLOB(255bytes),BLOB(65,535bytes),MEDIUMBLOB(16,777,215bytes),andLONGBLOB(4,294,967,295bytes).TouseBLOBseffectively:1)ConsiderperformanceimpactsandstorelargeBLOBsexternally;2)Managebackupsandreplicationcarefully;3)Usepathsinst

The best tools and technologies for automating the creation of users in MySQL include: 1. MySQLWorkbench, suitable for small to medium-sized environments, easy to use but high resource consumption; 2. Ansible, suitable for multi-server environments, simple but steep learning curve; 3. Custom Python scripts, flexible but need to ensure script security; 4. Puppet and Chef, suitable for large-scale environments, complex but scalable. Scale, learning curve and integration needs should be considered when choosing.

Yes,youcansearchinsideaBLOBinMySQLusingspecifictechniques.1)ConverttheBLOBtoaUTF-8stringwithCONVERTfunctionandsearchusingLIKE.2)ForcompressedBLOBs,useUNCOMPRESSbeforeconversion.3)Considerperformanceimpactsanddataencoding.4)Forcomplexdata,externalproc


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

SublimeText3 Linux new version
SublimeText3 Linux latest version

Dreamweaver Mac version
Visual web development tools

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.
