oracle on solaris

IInnssttiittuutt MMaannaajjeemmeenn TTeellkkoomm

http://www.imtelkom.ac.id

OOrraaccllee ddii SSoollaarriiss

[Instalasi Oracle 10 di Solaris 10]

Nyoman Bogi Aditya Karna Sisfo – IM Telkom [email protected] http://bogi.blog.imtelkom.ac.id

mailto:[email protected]

http://bogi.blog.imtelkom.ac.id/

Oracle di Solaris @ Institut Manajemen Telkom (http://www.imtelkom.ac.id)

Mengecek Spesifikasi yang diperlukan: ========================================================================= #/usr/sbin/prtconf | grep “Memory size” [Check RAM size] # /usr/sbin/swap -s [check swap] # df -k /tmp [check /tmp size (>400mb)] # uname –r [check solaris version]

# pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibm SUNWlibms SUNWsprot SUNWsprox SUNWtoo SUNWi1of SUNWi1cs SUNWi15cs SUNWxwfnt cat: SUNWsprox untuk OS selain Solaris 10

# cat /etc/nsswitch.conf | grep hosts # hostname # domainname

Cek Hosts File ========================================================================= # vi /etc/hosts <IP-address> <fully-qualified-machine-name> <machine-name>


Set Kernel Parameters ========================================================================= Buat group dengan nama “dba”, oracle inventory group “oinstall” dan “oracle” user # /usr/sbin/groupadd oinstall # /usr/sbin/groupadd dba {menentukan oracle user ada atau tidak # id -a oracle {Jika ada, maka akan terlihat seperti ini= uid=103(oracle) gid=104(dba) groups=103(ooinstall) {create oracle user= # useradd -d /data/oracle -g dba -G oinstall -m -s /bin/ksh oracle Tampilannya:

#mkdir /data/oracle #chown oracle:dba /data/oracle Buat directori untuk menginstall Oracle: # mkdir -p /u01/app/oracle/product/10.2.0/db_2


# chown -R oracle:oinstall /u01

EDIT FILE # vi /export/home/oracle/.profile ========================================================================= umask 022 TMP=/tmp TMPDIR=$TMP DISPLAY=localhost:0.0 export TMP TMPDIR DISPLAY ORACLE_BASE= /data/oracle; export ORACLE_BASE [ganti dengan directory oracle Anda] ORACLE_BASE=/u01/app/oracle/product/10.2.0/db_2; export ORACLE_HOME [ganti dengan Oracle home Directory Anda] ORACLE_HOME=$ORACLE_BASE /product/10.2.0/db_2; export ORACLE_HOME ORACLE_SID=TSHI; export ORACLE_SID [ganti dengan database Anda] PATH=$ORACLE_HOME/bin:$PATH; export PATH Tampilannya:

Mengkonfigurasi Parameter Kernel ========================================================================= #projadd oracle [Perintah ini akan membuat sebuah 'resource project' baru] # vi /etc/user_attr file adm::::profiles=Log Management lp::::profiles=Printer Management root::::auths=solaris.*,solaris.grant;profiles=Web Console


Management,All;lock_after_retries=no oracle::::project=oracle [add this line] Tampilannya:

Kemudian: #su – oracle $ id -p $ prctl -n project.max-shm-memory -i project oracle Tampilannya:

Biarkan user oracle tetap terhubung . Kemudian sebagai root terminal baru, ketik perintah: #prctl -n project.max-shm-memory -v 4gb -r -i project oracle [membuat max memory sebesar 4GB] Setelah mengetik perintah tersebut, kembali lagi ke oracle user’s session dan ketik ulang


perintah seperti perintah yang ada di terminal baru: $ prctl -n project.max-shm-memory -i project oracle Catatan: #prctl -n project.max-shm-memory -v 4gb -r -i project oracle [pengaturan ini akan hilang setelah reboot], oleh karena itu agar tidak hilang ketik perintah: #projmod -s -K “project.max-shm-memory=(priv,4gb,deny)” oracle Tampilannya:

Edit file "/etc/project" sehingga nilainya tidak berubah saat reboot. # cat /etc/project system:0:::: user.root:1:::: noproject:2:::: default:3:::: group.staff:10:::: oracle:100::::project.max-shm-memory=(priv,4294967296,deny) # Tampilannya:


Menambahkan package SUNWi1cs dan SUNWi15cs ========================================================================= Jika pada OS tidak ada package SUNWi1cs dan SUNWi15cs, maka tambahkan package SUNWi1cs dan SUNWi15cs menggunakan perintah “pkgadd”. # pkgadd -d /cdrom/sol_10_106_x86/Solaris_10/Product SUNWi1cs SUNWi15cs maka akan tampil tampilan: Processing package instance from X11 ISO8859-1 Codeset Support(i386) 2.0,REV=2004.10.17.15.04 Copyright 2004 Sun Microsystems, Inc. All rights reserved. Use is subject to license terms. This appears to be an attempt to install the same architecture and version of a package which is already installed. This installation will attempt to overwrite this package. Using as the package base directory. ## Processing package information. ## Processing system information. 16 package pathnames are already properly installed. ## Verifying package dependencies. ## Verifying disk space requirements. ## Checking for conflicts with packages already installed. ## Checking for setuid/setgid programs. This package contains scripts which will be executed with super-user permission during the process of installing this package. Do you want to continue with the installation of [y,n,?] y Installing X11 ISO8859-1 Codeset Support as ## Installing part 1 of 1. Installation of was successful. Processing package instance from X11 ISO8859-15 Codeset Support(i386) 2.0,REV=2004.10.17.15.04 Copyright 2004 Sun Microsystems, Inc. All rights reserved. Use is subject to license terms. This appears to be an attempt to install the same architecture and version of a package which is already installed. This installation will attempt to overwrite this package.


Using as the package base directory. ## Processing package information. ## Processing system information. 21 package pathnames are already properly installed. ## Verifying package dependencies. ## Verifying disk space requirements. ## Checking for conflicts with packages already installed. ## Checking for setuid/setgid programs. This package contains scripts which will be executed with super-user permission during the process of installing this package. Do you want to continue with the installation of [y,n,?] y Installing X11 ISO8859-15 Codeset Support as ## Installing part 1 of 1. Installation of was successful. # D. Performing the Oracle Installation ========================================================================= $vi /etc/system * Oracle Parameter set noexec_user_stack=1 * Setup for CE set ce:ce_put_cfg = 1 set cl_comm:ifk_disable_v6=1 * Sun 5.10 doesn't need this static parameter set shmsys:shminfo_shmmax=4294967295 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=100 set shmsys:shminfo_shmseg=10 set semsys:seminfo_semmns=2000 set semsys:seminfo_semmsl=1000 set semsys:seminfo_semmni=100 set semsys:seminfo_semopm=100 set semsys:seminfo_semvmx=32767 #su – oracle $xhost + $export DISPLAY=localhost;0.0 $ cd /data/oracle/database [the source unzipped here] $ ./runInstaller

oracle on solaris

Education