Instalasi Oracle Database 10g Release 2 (10.2.0.2) pada Solaris 10 (x86)

Instalasi Oracle Database 10g Release 2 (10.2.0.2) di Solaris 10 (x86).
Langkah-langkah :

Download Software

Download Oracle untuk Solaris disini:

Unpack Files

Unzip filenya dengan perintah ini :

unzip 10202_database_solx86.zip

Sekarang sudah terbentuk single directory dng name “database” yang mengandung
installation files.

Hosts File

/etc/hosts file dirubah / disesuaikan dengan nama komputer / servernya

<IP-address>  <fully-qualified-machine-name>  <machine-name>

Set Kernel Parameters

Pada Solaris versi sebelumnya, kernel parameters disesuaikan dengan cara merubah
file ini “/etc/system”, kemudian systemnya di reboot.

set semsys:seminfo_semmni=100 
set semsys:seminfo_semmsl=256 
set shmsys:shminfo_shmmax=4294967295 
set shmsys:shminfo_shmmni=100

The Oracle installer mengenali kernel parameters dengan metode ini, tapi sekarang
bisa dengan cara dibawah ini :

Sebagai root user, jalankan command ini :

projadd oracle

Tambahkan baris ini pada file “/etc/user_attr”

oracle::::project=oracle

Cek beberapa settingan di kernel parameter dengan perintah ini :.

# prctl -n project.max-shm-memory -i project oracle 
project: 100: oracle 
NAME    PRIVILEGE       VALUE    FLAG   ACTION      RECIPIENT 
project.max-shm-memory 
        privileged       254MB      -   deny                     - 
        system          16.0EB    max   deny                   - 
#

Untuk merubah valuenya, pastikan setidaknya ada satu setu yang login sebagai oracle
user, kemudian dari root user jalankan perintah ini :

# prctl -n project.max-shm-memory -v 4gb -r -i project oracle 
# projmod -s -K "project.max-shm-memory=(priv,4gb,deny)" oracle

Pada perintah pertama diatas merubah valuenya secara dinamis, sedangkan perintah
yg kedua merubah file “/etc/project” sehingga value nya persistent setelah di
reboots.

# cat /etc/project 
system:0:::: 
user.root:1:::: 
noproject:2:::: 
default:3:::: 
group.staff:10:::: 
oracle:100::::project.max-shm-memory=(priv,4294967296,deny) 
#

Oracle installer akan memunculkan warning ketika mengecek kernel parameter set
, tapi diignore aja nanti juga “installation completes successfully.”

Setup

Tambahkan “SUNWi1cs” dan “SUNWi15cs” packages dengan perintah “pkgadd”

# pkgadd -d /cdrom/sol_10_106_x86/Solaris_10/Product SUNWi1cs SUNWi15cs   

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

Bikin groups and users baru seperti ini :

groupadd oinstall 
groupadd dba 
groupadd oper   

useradd -g oinstall -G dba -d /export/home/oracle oracle 
mkdir /export/home/oracle 
chown oracle:oinstall /export/home/oracle 
passwd -r files oracle

Bikin direktory dimana Oracle software akan diinstall :

mkdir -p /u01/app/oracle/product/10.2.0/db_1 
chown -R oracle:oinstall /u01

Misalkan pada direktory ini “/export/home/oracle”

mkdir -p /export/home/oracle/product/10.2.0/db_1 
chown -R oracle:oinstall /export/home/oracle

Login sebagai oracle user tambahkan baris dibawah ini pada akhir file .profile
, pastikan ORACLE_BASE value nya seperti ini:

# Oracle Settings 
TMP=/tmp; export TMP 
TMPDIR=$TMP; export TMPDIR   

# Select the appropriate ORACLE_BASE 
#ORACLE_BASE=/export/home/oracle; export ORACLE_BASE 
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE 
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME 
ORACLE_SID=TSH1; export ORACLE_SID 
PATH=$ORACLE_HOME/bin:$PATH; export PATH

Installation

Login sebagai oracle user.jika menggunakan X emulation set DISPLAY environmental
variable nya dengan perintah ini :

DISPLAY=<machine-name>:0.0; export DISPLAY

Start Oracle Universal Installer (OUI) dengan menjalankan perintah dibawah ini
dari direktory “database” :

./runInstaller

Detail Prosesnya bisa dilihat melalui gamba-gambar ini

  1. Select Installation
    Method
  2. Specify
    Inventory Directory and Credentials
  3. Select Installation
    Type
  4. Specify Home Details
  5. Product-Specific
    Prerequisite Checks
  6. Select Configuration
    Option
  7. Select Database
    Configuration
  8. Specify
    Database Configuration Options
  9. Select Database
    Management Option
  10. Specify Database
    Storage Option
  11. Specify
    Backup and Recovery Options
  12. Specify Database
    Schema Passwords
  13. Summary
  14. Install
  15. Configuration Assistants
  16. Database
    Configuration Assistant
  17. Database
    Configuration Assistant Password Management
  18. Execute Configuration
    Scripts
  19. End Of Installation

Post Installation

Edit setting file”/var/opt/oracle/oratab” pada restart flag nya untuk setiap instance
menjadi ‘Y’:

TSH1:/u01/app/oracle/product/10.2.0/db_1:Y

Untuk instruksi detailnya liat link dibawah ini :

Disadur dari http://www.oracle-base.com

Back to the Top.

2 thoughts on “Instalasi Oracle Database 10g Release 2 (10.2.0.2) pada Solaris 10 (x86)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s