Welcome to Installing Oracle 11r2 on Windows 2008R2 Server Part 2 of the series
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
- Install the Oracle Database Software This was completed in Part 1 Here
- Configure the Oracle Database
- Configure the Listener
- Verify & Configure Windows Services
- Configure Windows Firewall
- 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:
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“