solaris10 图形化安装Oracle 11gR2

Solaris一个时代的结束，目前作为Oracle的UNIX操作系统，主流版本为solaris 10和solaris 11，从solaris 10就开始支持x86架构，21c开始将会结束solaris x86的支持。

操作系统配置

系统架构检查

/bin/isainfo -kv

系统版本检查

cat /etc/release

内存检查

/usr/sbin/prtconf | grep "Memory size"

交换空间检查

/usr/sbin/swap -l

Note：生产环境一般16G即可

依赖包检查

pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibC SUNWlibms SUNWsprot \
 SUNWtoo SUNWi1of SUNWi1cs SUNWi15cs SUNWxwfnt

Note：若缺包可以挂盘用pkgadd进行安装，pkgadd -d /cdrom/sol_10_113_x86/Solaris_10/Product SUNWarc

网络参数配置

/usr/sbin/ndd /dev/tcp tcp_smallest_anon_port tcp_largest_anon_port

/usr/sbin/ndd -set /dev/tcp tcp_smallest_anon_port 9000
/usr/sbin/ndd -set /dev/tcp tcp_largest_anon_port 65500
/usr/sbin/ndd -set /dev/udp udp_smallest_anon_port 9000
/usr/sbin/ndd -set /dev/udp udp_largest_anon_port 65500

创建用户和组

groupadd oinstall
groupadd oper
groupadd dba


useradd -g oinstall -G oper,dba -m -d /export/home/oracle -s /usr/bin/bash oracle

修改密码
passwd -r files oracle
oracle_4U

创建project

projadd group.dba

vi /etc/user_attr 

oracle::::project=group.dba

Note：从10版本开始solaris利用project管理每个用户的资源

配置资源限制

id -p oracle

projmod -a -K "process.max-file-descriptor=(basic,65536,deny)" group.dba
projmod -a -K "process.max-file-descriptor=(priv,65536,deny)" group.dba

配置内核参数

projmod -sK "project.max-sem-ids=(privileged,128,deny)" group.dba
projmod -sK "project.max-sem-nsems=(privileged,512,deny)" group.dba
projmod -sK "project.max-shm-memory=(privileged,4294967295,deny)" group.dba
projmod -sK "project.max-shm-ids=(privileged,128,deny)" group.dba

–查看

cat /etc/project
su - oracle
id -p
prctl -n project.max-sem-ids -i process $$
prctl -n project.max-shm-memory -i process $$

配置环境变量

vi .profile

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4/dbhome_1
export ORACLE_SID=pretty
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin:$PATH

创建目录

mkdir -p /u01/app/oracle
chown -R oracle:oinstall /u01
chmod -R 775 /u01

安装DB软件

[@solaris10 /export/home/oracle/database]$export DISPLAY=192.168.1.11:0.0
Note：输出图形到你需要显示的地址

[@solaris10 /export/home/oracle/database]$runInstaller 
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 180 MB.   Actual 2848 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 3547 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2021-08-02_11-59-55AM. Please wait ...[@solaris10 /export/home/oracle/database]$You can find the log of this install session at:
 /u01/app/oraInventory/logs/installActions2021-08-02_11-59-55AM.log

[@solaris10 /export/home/oracle/database]$

运行ROOT脚本

脚本一：

bash-3.2# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
bash-3.2#

脚本二：

bash-3.2# /u01/app/oracle/product/11.2.0.4/dbhome_1/root.sh
Performing root user operation for Oracle 11g 

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/11.2.0.4/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.
Finished product-specific root actions.
bash-3.2#

配置监听

[@solaris10 /export/home/oracle]$netca

Oracle Net Services Configuration:
Configuring Listener:LISTENER
Listener configuration complete.
Oracle Net Listener Startup:
    Running Listener Control: 
      /u01/app/oracle/product/11.2.0.4/dbhome_1/bin/lsnrctl start LISTENER
    Listener Control complete.
    Listener started successfully.
Oracle Net Services configuration successful. The exit code is 0
[@solaris10 /export/home/oracle]$

创建数据库

[@solaris10 /export/home/oracle]$dbca
[@solaris10 /export/home/oracle]$

查看

[@solaris10 /export/home/oracle]$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Aug 2 12:43:21 2021

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select NAME,PLATFORM_NAME from v$database;

NAME
---------
PLATFORM_NAME
--------------------------------------------------------------------------------
PRETTY
Solaris Operating System (x86-64)


SQL>