Installing Oracle 11r2 on Windows 2008R2 Server Part 2

Hi,

Welcome to Installing Oracle 11r2 on Windows 2008R2 Server Part 2 of the series

Doing a Complete install of Siebel 8.2.2.4 on Oracle 11 r2, Win 2008R2. All from Scratch

In this part we will configure an oracle database server. This server will house a development database, and a test database. This walkthrough will focus only on the development database installation.

To Install an Oracle database we will go through the following steps

  1. Install the Oracle Database Software This was completed in Part 1 Here
  2. Configure the Oracle Database
  3. Configure the Listener
  4. Verify & Configure Windows Services
  5. Configure Windows Firewall
  6. Do Connectivity Tests

To Configure an oracle database you need to run the dbca from a command prompt. Follow the screenshots, and step guide below to configure the database for use as a Siebel development server.

We need to install a Custom Database, as we need to configure advanced properties. Hit Next

Provide the Global Database Name (in the format sid.domain.tld), provide the SID for the Database, Use a saying name if you like, I do. Remember to document these settings along the way, you will need them later. Hit Next

Set Check in Enterprise Manager (yes we want that – if you have a different enterprise manager in your environment already, you may not want that), and enable daily backup of the database. Provide the name of a domain user that will run the backup. Choose the Automatic Maintenance Tasks Tab

Enable the Automatic Maintenance Tasks. Hit Next

Provide the passwords for the oracle system accounts, Notice that these and all other passwords in this installation will be CaSe SENsiTIve! Choose the password strategy you like, make sure you document the passwords chosen, and notice that oracle is strengethening the complexity requirements of these passwords. Hit Next

For Database Storage we will use a common location for all database files, notice that the SID name automagically will be appended to the path chosen. You will need a minimum of 60-80gb of free space on the oracle datafiles drive for the installation we will do. Hit Next

Set Check in defining a specific Fast Recovery Area, i will use the same root as the oracle datafiles, this is NOT reccomended by Oracle, but this is not a mission critical development instance. In Production it would be an absolute disaster-waiting-to-happen to have the disaster recovery area on the same physical disks as the database files.

The Fast Recovery Area needs to be approximately 2x the size of the database installed, I estimate the Siebel development database with everything to be approximately 20gb, so 40gb is needed here. Set Check in Enable Archiving. Hit Next

There are no changes needed on this screen, so Hit Next

Use Automatic Memory Management.
As I’m installing more databases on the same box (the test db server as a separate instance) i provide a limited amount of memory to the development database instance. If you only install one db, then the oracle recommendation is to allocate all memory of the box minus 1 gb!
Hit All Initialization Parameters

Show Advanced Parameters

Make these changes for a Siebel Development DB.

  • NLS_SORT: BINARY
  • OPEN_CURSORS: 2000
  • OPTIMIZER_INDEX_COST_AJD: 1
  • DB_FILE_MULTIBLOCK_READ_COUNT: 32

NOTE: if you do not set the NLS_SORT: BINARY here you will get into trouble compiling an .srf later.

Close the Advanced Parameters and choose the Sizing Tab

Make sure the database Block size is 8k, and you have set a minimum of 300 processes. Choose the Character Sets Tab

Use Unicode (AL32UTF8) and Set the default National Character Set to AL16UTF16, and the Default Language and Territory to American, America (my options here show up in danish – probably due to the windows server locale settings.). Hit Connection Mode

There should be no changes here – this is a server in dedicated mode. Hit Next

We need to change some tablespace paramenter – do not create the Siebel tablespaces now. We will create the Siebel tabelspaces through oracle script once the database is online

  • TEMP: Size should be 2 Gb
  • SYSTEM: Size should be 2 Gb
  • SYSAUX: should be 1 Gb
  • UNDO: should be 2Gb

Also change the Redo Sizes to 3x 100mb – like this:

 And this

 Hit Finish to Create the Database!

Hit Finish Again – then the database creation process starts.

Verify your selections made here. I save the summary as html documentation purposes. Hit Ok

Wait for completion.

Once this is complete you are ready for the next step in the process – Configuring the Listener.

Read the Next part in the series “Configure the Listener

Enjoy!

/Henrik

Leave a Reply

Your email address will not be published.