检查最终的效果

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