| Ask Me Anything | Build | GitHub | Mastodon | SourceHut


  • the '#' at first line mean is the command must be run by root.

  • the '$' at first line mean is the command must be run by user, in this case user 'oracle’.

Create group for oracle

# groupadd oinstall
# groupadd dba
# groupadd oper

Create user oracle

# mkdir /export/home/oracle
# chown oracle:dba /export/home/oracle
# useradd -g oinstall -G dba,oper -d /export/home/oracle oracle
# passwd oracle

Make sure user nobody is exist

# id nodoby

Configure solaris 10 projects attributes

# projadd group.dba
# projmod -sK "project.max-shm-memory=(privileged,4294967295,deny)"
# group.dba
# projmod -sK "project.max-sem-ids=(privileged,100,deny)" group.dba
# projmod -sK "project.max-shm-ids=(privileged,100,deny)" group.dba
# projmod -sK "project.max-sem-nsems=(privileged,256,deny)" group.dba
# echo "oracle::::type=normal;project=group.dba" >> /etc/user_attr

and add this to "/etc/system",

set noexec_user_stack=1
set semsys:seminfo_semmni=100
set semsys:seminfo_semmns=1024
set semsys:seminfo_semmsl=256
set semsys:seminfo_semvmx=32767
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10

Prepare asm disk/partition

note: cylinder must start at 1
# format
# chown oracle:dba /dev/rdsk/cxtxdxsx
# chmod 660 /dev/rdsk/cxtxdxsx

Now login as oracle, then go to oracle installation directory and execute OUI,

# mkdir -p /usr/local/bin
# su - oracle
$ sh /path/to/database/runInstaller

Oracle installer will check all depedencies, make sure all of depedencies is passed. While installing, oracle installer will prompt you to execute two script as root. The scripts are

+ $ORACLE_BASE/oraInventory/

Oracle will create this additional directories:

+ /var/opt/oracle

Upgrade ASM in OUI

$ ${ORACLE_HOME}/bin/dbua

FTP and HTTP access for ASM

Run sql script catxdbdbca.sql

# sqlplus / as sysdba
SQL> @rdbms/admin/catxdbdbca.sql 2221 8880

where 2221 is port for FTP and 8880 is port for HTTP accces.