Create a General Purpose Oracle 10g Database on Solaris 10

export ORACLE_HOME=/opt/oracle/product/10.2
export ORACLE_SID=soa11g

* You’ll need X Windows. I used Cygwin X. See this post for details.

cd $ORACLE_HOME/bin
./dbca

* Select Create a Database
* Select General Purpose
* Enter
– Global Database Name: soa11g.my.com
– SID: soa11g
* Select use the Same Password for All Accounts
– Password: welcome1
* Select Register this database with all the listeners
* Select File System on Select the storage mechanism
* Select use Common Location for All Database Files and enter
– Database Files Location: /data1/oradata
* Uncheck both Specify Flash Recovery Area and Enable Archiving
* Uncheck Sample Schemas
* Initialization Parameters
– On Memory tab,
Select Typical
Percentage: 20
– On Sizing tab, Enter
Processes: 150
– On Character Sets tab,
select Use Unicode (“)
– On Connection Mode tab,
Select Dedicated Server Mode
* Edit Database Storage
– Controlfile
control01.ctl /data1/oradata/{DB_NAME}/
control02.ctl /data2/oradata/{DB_NAME}/
control03.ctl /data3/oradata/{DB_NAME}/
– Datafile
Accept defaults
– Redo Log Groups
– redo01.log /data1/oradata/{DB_NAME}/
– redo02.log /data2/oradata/{DB_NAME}/
– redo03.log /data3/oradata/{DB_NAME}/
* On Creation Options
– Check Create Database
– Check Generate Database Creation Scripts and enter
Destination Directory: /opt/oracle/admin/soa11g/scripts
– Click Finish
* Click OK
* Click Exit when done

soa11g =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = tcp)(HOST = mydbsvr)(PORT = 1521))
    (CONNECT_DATA =
      (sid = soa11g)
    )
  )
 
soa11g.my.com =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = tcp)(HOST = mydbsvr)(PORT = 1521))
    (CONNECT_DATA =
      (service_name = soa11g.my.com)
    )
  )

* Installing and Configuring Oracle Database 10g on the Solaris Platform