{"id":2579,"date":"2019-03-12T11:32:43","date_gmt":"2019-03-12T08:32:43","guid":{"rendered":"https:\/\/sysdba.org\/?p=2579"},"modified":"2025-07-02T06:01:07","modified_gmt":"2025-07-02T06:01:07","slug":"installing-oracle-10g-on-a-unix-solaris-system","status":"publish","type":"post","link":"https:\/\/sysdba.org\/en\/installing-oracle-10g-on-a-unix-solaris-system\/","title":{"rendered":"Installing Oracle 10G on a Unix (Solaris) system"},"content":{"rendered":"

We can install the Oracle database by following the steps below.<\/p>\n

 <\/p>\n

Hardware requirements<\/strong><\/h3>\n\n\n\n\n\n\n\n
RAM<\/span><\/strong><\/span><\/td>\nRecommended SWAP Space<\/span><\/span><\/strong><\/span><\/td>\n<\/tr>\n
Up to 512 MB<\/span><\/td>\nDouble the amount of RAM<\/span><\/td>\n<\/tr>\n
1024 MB – 2048 MB<\/span><\/td>\n1.5x the amount of RAM<\/span><\/td>\n<\/tr>\n
2049 MB – 8192 MB<\/span><\/td>\nAs much as the RAM<\/span><\/td>\n<\/tr>\n
Over 8192 MB<\/span><\/td>\n3\/4 the amount of RAM<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

400 MB \/tmp space<\/p>\n

1.5 GB – 3.5 GB for the Oracle application<\/p>\n

 <\/p>\n\n\n\n\n\n\n
Version<\/span><\/strong><\/span> <\/span><\/td>\nMinimum Space (GB)<\/span> <\/span><\/strong><\/td>\n<\/tr>\n
Enterprise Edition<\/span><\/td>\n2.0<\/span><\/td>\n<\/tr>\n
Standard Edition<\/span><\/td>\n1.5<\/span><\/td>\n<\/tr>\n
Custom (maximum)<\/span><\/td>\n2.5<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

Controller<\/strong>
\n[crayon]\/usr\/sbin\/prtconf | grep “Memory size”<\/p>\n

\/usr\/sbin\/swap -s<\/p>\n

df -k \/tmp<\/p>\n

df -h[\/crayon]
\nChecking application suitability
\n[crayon]isainfo -kv<\/p>\n

[\/crayon]
\nCheck to see the missing packages
\n[crayon]pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibm SUNWlibms SUNWsprot<\/p>\n

SUNWtoo SUNWi1of SUNWi1cs SUNWi15cs SUNWxwfnt<\/p>\n

[\/crayon]
\nIf there are missing packages
\n[crayon]cd \/cdrom\/sol_10_910_x86\/Solaris_10\/Product<\/p>\n

pkgadd -d .\/ SUNWi1cs<\/p>\n

pkgadd -d .\/ SUNWi15cs[\/crayon]
\nNote: SUNWsprox is no longer necessary<\/p>\n

 <\/p>\n

Creating users and groups
\n[crayon]groupadd oinstall<\/p>\n

groupadd dba<\/p>\n

groupadd oper<\/p>\n

useradd -m -d \/export\/home\/oracle -s \/usr\/bin\/bash -g oinstall -G dba oracle<\/p>\n

[\/crayon]
\nEntering kernel parameters in \/etc\/system<\/strong>
\n[crayon]set semsys:seminfo_semmni=100<\/p>\n

set semsys:seminfo_semmsl=256<\/p>\n

set shmsys:shminfo_shmmax=4294967295<\/p>\n

set shmsys:shminfo_shmmni=100[\/crayon]
\nKernel parameters<\/p>\n

Using SHMMAX = 6GB as an example
\n[crayon]set shmsys:shminfo_shmmax=6442450944<\/p>\n

set semsys:seminfo_semmni=1024<\/p>\n

set semsys:seminfo_semmsl=1024<\/p>\n

set shmsys:shminfo_shmmni=100<\/p>\n

[\/crayon]
\nProject
\n[crayon]projadd -c “Oracle” ‘user.oracle’<\/p>\n

projmod -s -K “project.max-shm-memory=(privileged,52GB,deny)” ‘user.oracle’<\/p>\n

projmod -s -K ‘process.max-open-file-descriptor=(basic,1024,deny)’ ‘user.oracle’<\/p>\n

[\/crayon]
\nControl<\/strong>
\n[crayon]prctl -i project oracle<\/p>\n

prctl -n project.max-shm-memory -i project user.oracle<\/p>\n

prctl $$<\/p>\n

[\/crayon]
\nEnter the following lines into \/etc\/inittab<\/strong>
\n[crayon]####Oracle<\/p>\n

tm::sysinit:\/usr\/sbin\/ndd -set \/dev\/tcp tcp_smallest_anon_port 9000 > \/dev\/console<\/p>\n

tm::sysinit:\/usr\/sbin\/ndd -set \/dev\/tcp tcp_largest_anon_port 65500 > \/dev\/console<\/p>\n

tm::sysinit:\/usr\/sbin\/ndd -set \/dev\/udp udp_smallest_anon_port 9000 > \/dev\/console<\/p>\n

tm::sysinit:\/usr\/sbin\/ndd -set \/dev\/udp udp_largest_anon_port 65500 > \/dev\/console<\/p>\n

[\/crayon]
\nNecesary line for .profile<\/strong>
\n[crayon]ulimit -n 1024<\/p>\n

[\/crayon]
\nRequired packages
\n[crayon]=============================================================<\/p>\n

pkginfo -i SUNWarc +<\/p>\n

pkginfo -i SUNWbtool +<\/p>\n

pkginfo -i SUNWhea +<\/p>\n

pkginfo -i SUNWlibC +<\/p>\n

pkginfo -i SUNWlibm +<\/p>\n

pkginfo -i SUNWlibms +<\/p>\n

pkginfo -i SUNWsprot +<\/p>\n

pkginfo -i SUNWtoo +<\/p>\n

pkginfo -i SUNWi1of – (either this package isn’t in the repository or didn’t give an error message)<\/p>\n

pkginfo -i SUNWi1cs (ISO8859-1) –<\/p>\n

pkginfo -i SUNWi15cs (ISO8859-15) +<\/p>\n

pkginfo -i SUNWxwfnt –<\/p>\n

pkginfo -i SUNWcsl +<\/p>\n

=============================================================[\/crayon]
\n.profile<\/strong>
\n[crayon]ORACLE_HOSTNAME=sun11.gantek.local; export ORACLE_HOSTNAME<\/p>\n

ORACLE_UNQNAME=yts; export ORACLE_UNQNAME<\/p>\n

ORACLE_BASE=\/u01\/app\/oracle; export ORACLE_BASE<\/p>\n

ORACLE_HOME=$ORACLE_BASE\/product\/11.2.0\/dbhome_1; export ORACLE_HOME<\/p>\n

ORACLE_SID=yts; export ORACLE_SID<\/p>\n

BASE_PATH=\/usr\/sbin:$PATH; export BASE_PATH<\/p>\n

PATH=$ORACLE_HOME\/bin:$BASE_PATH; export PATH<\/p>\n

#alias \u2039 The list of aliases<\/p>\n

alias ll=’ls -ltr’<\/p>\n

alias adb=’tail -200f \/u01\/app\/oracle\/diag\/rdbms\/yts\/yts\/trace\/alert_yts.log’<\/p>\n

alias sql=’sqlplus \/ as sysdba’<\/p>\n

alias ohdb=’cd \/u01\/app\/oracle\/product\/11.2.0\/dbhome_1′<\/p>\n

alias diag=’cd \/u01\/app\/oracle\/diag’<\/p>\n

alias netdb=’cd \/u01\/app\/oracle\/product\/11.2.0\/dbhome_1\/network\/admin’<\/p>\n

alias dbs=’cd \/u01\/app\/oracle\/product\/11.2.0\/dbhome_1\/dbs’<\/p>\n

alias scripts=’cd \/u01\/app\/oracle\/admin\/yts\/scripts\/'[\/crayon]
\nMaking folders and granting rights
\n[crayon]mkdir -p \/u01\/app\/oracle<\/p>\n

chown -R oracle:oinstall \/u01\/app\/oracle<\/p>\n

chmod -R 775 \/u01\/app\/oracle[\/crayon]
\nAdd the lines below to the Oracle .profile user file \/export\/home\/oracle<\/strong>
\n[crayon]# Oracle Settings<\/p>\n

TMP=\/tmp; export TMP<\/p>\n

TMPDIR=$TMP; export TMPDIR<\/p>\n

# Select the appropriate ORACLE_BASE<\/p>\n

ORACLE_BASE=\/oracle; export ORACLE_BASE<\/p>\n

ORACLE_HOME=$ORACLE_BASE\/10g; export ORACLE_HOME<\/p>\n

ORACLE_SID=oratr; export ORACLE_SID<\/p>\n

PATH=$ORACLE_HOME\/bin:$PATH; export PATH[\/crayon]
\nEnter the database directory and run the runInstaller script, after which during the installation procedure is the same as other Linux\/Unix distros (such as installing 10G on Red Hat Enterprise Linux)<\/p>\n

\"10G<\/a><\/p>\n

Common errors or issues<\/strong><\/p>\n

“snmpdx unable to get my ip address” errors are due to nsswitch.conf hosts–>dns.<\/p>\n

Changing this option to files will most likely resolve this issue. The reason the dns setting causes this error is because the dns is unable to properly resolve its own name or maybe missing from the \/etc\/hosts file.<\/p>\n

There needs to be an entry similar to “192.168.0.10 dbserver.istanbul.localdbserver” in the hosts file.<\/p>\n

 <\/p>\n

A “UX: useradd: ERROR: Inconsistent password files” error could be because of a “oracle::::project=oracle” entry in the user_attr<\/strong> file before creating an Oracle user.<\/p>\n

 <\/p>\n

Issues during the application installation procedure (at the linking stage), while invoking target irman ins_rdbms.mk, can be solved by increasing the size of \/tmp.
\n[crayon]zfs create -V 2gb rpool\/extraswap<\/p>\n

swap -a \/dev\/zvol\/dsk\/rpool\/extraswap<\/p>\n

[\/crayon]
\nTo fix a sh runInstaller “ld.so libXM.so open failed no such file or directory” error.
\n[crayon]pkg install pkg:\/\/solaris\/library\/motif<\/p>\n

[\/crayon]
\nORA-27300: OS system dependent operation:fork failed with status: 11<\/p>\n

ORA-27301: OS failure message: Resource temporarily unavailable<\/p>\n

ORA-27302: failure occurred at: skgpspawn3<\/p>\n

 <\/p>\n

Troubleshooting ORA-27300 ORA-27301 ORA-27302 errors [ID 579365.1]<\/p>\n

Ora-27300 OS system dependent operation:fork failed with status: 11 [ID 392006.1]<\/p>\n

https:\/\/blogs.oracle.com\/hasham\/entry\/solaris_10_increasing_number_of<\/a>
\n[crayon]# mdb -kw<\/p>\n

Loading modules: [ unix krtld genunix specfs dtrace uppc apix cpu.generic zfs sockfs ip hook neti sctp arp usba uhci fcp fctl qlc nca lofs md cpc random crypto fcip logindmux ptm ufs sppp nfs ipc ]<\/p>\n

maxuprc\/D<\/p>\n

maxuprc:<\/p>\n

maxuprc: 27061<\/p>\n

maxuprc\/W 88B8<\/p>\n

maxuprc: 0x69b5 = 0x88b8<\/p>\n

maxuprc\/D<\/p>\n

maxuprc:<\/p>\n

maxuprc: 35000[\/crayon]
\nTo make the changes in \/etc\/system<\/strong> permanent after reboot:
\n[crayon]set maxuprc = 35000<\/p>\n

set max_nprocs = 35000<\/p>\n

[\/crayon]<\/p>\n","protected":false},"excerpt":{"rendered":"

We can install the Oracle database by following the steps below.<\/p>\n","protected":false},"author":1,"featured_media":3411,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[383,338],"tags":[345],"class_list":["post-2579","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dba_i","category-oracle-tr","tag-oracle"],"_links":{"self":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts\/2579","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/comments?post=2579"}],"version-history":[{"count":1,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts\/2579\/revisions"}],"predecessor-version":[{"id":4828,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts\/2579\/revisions\/4828"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/media?parent=2579"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/categories?post=2579"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/tags?post=2579"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}