检查最终的效果
# prctl -i process $$
process: 1025: -sh
NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT
process.max-port-events
privileged 65.5K - deny -
system 2.15G max deny -
process.max-msg-messages
privileged 8.19K - deny -
system 4.29G max deny -
process.max-msg-qbytes
privileged 64.0KB - deny -
system 16.0EB max deny -
process.max-sem-ops
privileged 512 - deny -
system 2.15G max deny -
process.max-sem-nsems
privileged 512 - deny -
system 32.8K max deny -
process.max-address-space
privileged 16.0EB max deny -
system 16.0EB max deny -
process.max-file-descriptor
basic 256 - deny 1025
privileged 65.5K - deny -
system 2.15G max deny -
process.max-core-size
privileged 8.00EB max deny -
system 8.00EB max deny -
process.max-stack-size
basic 10.0MB - deny 1025
privileged 125TB max deny -
system 125TB max deny -
process.max-data-size
privileged 16.0EB max deny -
system 16.0EB max deny -
process.max-file-size
privileged 8.00EB max deny,signal=XFSZ -
system 8.00EB max deny -
process.max-cpu-time
privileged 18.4Es inf signal=XCPU -
system 18.4Es inf none -
task.max-cpu-time
system 18.4Es inf none -
task.max-lwps
system 2.15G max deny -
project.max-contracts
privileged 10.0K - deny -
system 2.15G max deny -
project.max-device-locked-memory
privileged 1002MB - deny -
system 16.0EB max deny -
project.max-locked-memory
system 16.0EB max deny -
project.max-port-ids
privileged 8.19K - deny -
system 65.5K max deny -
project.max-shm-memory
privileged 3.91GB - deny -
system 16.0EB max deny -
project.max-shm-ids
privileged 128 - deny -
system 16.8M max deny -
project.max-msg-ids
privileged 128 - deny -
system 16.8M max deny -
project.max-sem-ids
privileged 128 - deny -
system 16.8M max deny -
project.max-crypto-memory
privileged 3.91GB - deny -
system 16.0EB max deny -
project.max-tasks
system 2.15G max deny -
project.max-lwps
system 2.15G max deny -
project.cpu-cap
system 4.29G inf deny -
project.cpu-shares
privileged 1 - none -
system 65.5K max none -
zone.max-swap
system 16.0EB max deny -
zone.max-locked-memory
system 16.0EB max deny -
zone.max-shm-memory
system 16.0EB max deny -
zone.max-shm-ids
system 16.8M max deny -
zone.max-sem-ids
system 16.8M max deny -
zone.max-msg-ids
system 16.8M max deny -
zone.max-lwps
system 2.15G max deny -
zone.cpu-cap
system 4.29G inf deny -
zone.cpu-shares
privileged 1 - none -
system 65.5K max none -
3.8.创建数据库安装目录
创建数据库软件目录;
# mkdir -p /usr/sjes/database/product/12.2.0/dbhome_1
# ls -alt /usr/sjes/database
total 4
drwxr-xr-x 3 root root 512 Mar 11 02:37 ..
drwxr-xr-x 2 root root 512 Mar 11 02:37 .
# chown -R oracle:oinstall /usr/sjes/database
3.9.配置用户环境变量
为oracle用户设置环境变量;
-bash-3.2$ vi local.profile
"local.profile" 10 lines, 176 characters
#
# Copyright (c) 2001 by Sun Microsystems, Inc.
# All rights reserved.
#
# ident "@(#)local.profile 1.10 01/06/23 SMI"
stty istrip
PATH=/usr/bin:/usr/ucb:/etc:.
export PATH
export ORACLE_BASE=/export/home/oracle/database
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=orcl
3.10.解压安装程序
解压oracle安装程序
$ unzip Oracle\ Database\ 12.2.0.1.0\ for\ Oracle\ Solaris\ on\ x86-64\ \(64-bit\).zip -d /export/home/oracle/database/product/12.2.0/dbhome_1
3.11.安装数据库软件
3.11.1.启动安装程序
-bash-3.2$ cd /export/home/oracle/software/database
-bash-3.2$ ls
install response rpm runInstaller sshsetup stage welcome.html
-bash-3.2$ ./runInstaller
3.11.2.配置安全更新
取消“I wish to receive security updates via My Oracle Support.”,点击“Next”;
此时会出现提醒,告知无法收到安全更新,点击“Yes”;
3.11.3.选择安装选项
选择“Install database software only”,仅仅安装数据库软件,点击“Next”;
3.11.4.选择数据库安装选项
选择“Single instance database installation”,安装单实例数据库,点击“Next”;
3.11.5.选择数据库版本
选择“Enterprise Edition”,安装企业版本数据库,点击“Next”;
3.11.6.指定数据库安装路径
Oracle base 填写“/usr/sjes/database”,Software location填写“/usr/sjes/database/product/12.2.0/dbhome_1”,点击“Next”;
3.11.7.创建清单目录
Inventory Directory填写“/usr/sjes/oraInventory”,点击“Next”;
3.11.8.操作系统权限组
数据库需要的用户组都已经创建完毕,此处会自动识别,保持默认即可,点击“Next”;
3.11.9.执行预安装检查
安装程序自动进行预安装检查,并将发现的问题列出在窗口中,点击“Fix & Check Again”按钮,以便修复可自动修复的检查项;
自动修复脚本位置已经给出,使用root用户执行runfixup.sh自动修复脚本;
# /tmp/CVU_12.2.0.1.0_oracle/runfixup.sh
All Fix-up operations were completed successfully.
自动修复脚本执行成功后,可以看到修复的结果是否完成;
如果还有无法修复的内容,点击“Ignore All”,忽略这些问题,点击“Next”;
我们已知这些问题,因此忽略此处的错误提醒,点击“Yes”;
3.11.10.汇总界面
所有配置确认无误,点击“Install”;
3.11.11.安装过程
此时开始安装数据库软件
3.11.12.执行配置脚本
安装进行到末尾时,需要使用root用户来执行脚本;
# /export/home/oracle/oraInventory/orainstRoot.sh
Changing permissions of /export/home/oracle/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /export/home/oracle/oraInventory to oinstall.
The execution of the script is complete.
# /export/home/oracle/database/product/12.2.0/dbhome_1/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /export/home/oracle/database/product/12.2.0/dbhome_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Creating /usr/local/bin directory...
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /var/opt/oracle/oratab file...
Entries will be added to the /var/opt/oracle/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.
Do you want to setup Oracle Trace File Analyzer (TFA) now ? yes|[no] :
yes
Installing Oracle Trace File Analyzer (TFA).
Log File: /export/home/oracle/database/product/12.2.0/dbhome_1/install/root_chengdr_2021-03-11_04-16-36.log
Finished installing Oracle Trace File Analyzer (TFA)
执行脚本完成后,点击“OK”;
3.11.13.安装完成
点击“Close”,即可完成安装;
3.12.创建数据库
3.12.1.启动数据库创建助手
-bash-3.2$ dbca
3.12.2选择数据库操作
选择“Create a database”,点击“Next”;
3.12.3.选择数据库创建模式
选择“Advanced configuration”,点击“Next”;
3.12.4.选择数据库部署类型
选择“General Purpose or Transaction Processing”,点击“Next”;
3.12.5.指定数据库标识
Global database name 填写“orcl”,SID填写“orcl”,取消“Create as Container database”,点击“Next”;
3.12.6.选择数据库存储位置
选择“Use following for the database storage attributes”,location填写“/usr/data”,点击“Next”;
3.12.7.配置快速恢复区
选择“Specify Fast Recovery Area”,点击“Next”;
3.12.8.指定网络配置
勾选“Create a new listener”,创建新的监听器Listener name填写“LISTENER”,port填写“1521”,点击“Next”;
3.12.9.选择数据库Vault选项
保持默认,不勾选,点击“Next”;
3.12.10.指定配置选项
选择“Use Automatic Shared Memory Management”,SGA使用13G,PGA使用3G,点击“Next”;
Sizing页面,Processes填写“600”;
字符集选择“Choose from the list of character sets”,使用“AL32UTF8”;
connection mode 选择“Dedicated server mode”;
Sample schemas 页面保持默认,不勾选,点击“Next”;
3.12.11.指定管理选项
取消“Configure Enterprise Manger(EM)database express”,点击“Next”;
3.12.12指定数据库用户许可
选择“Use the same administrative password for all accouts”,输入统一的密码,点击“Next”;
出现提醒,点击“Yes”
3.12.13.选择数据库创建选项
勾选“Create database”和“Generate database creation scripts”,点击“Next”;
3.12.14.概要信息
确保配置无误,点击“Finish”;
3.12.15.安装进行
安装正在进行中,稍等片刻;
3.12.16.安装完成
安装已经完成,点击“Close”;
4.登录数据库
-bash-3.2$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Thu Mar 11 06:39:58 2021
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
orcl OPEN
SQL>
- 还没有人评论,欢迎说说您的想法!