Manzana - Siebel CRM - All Day Every Day!

Siebel CRM - All Day Every Day!

NAVIGATION - SEARCH

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

United States João Gabriel

Buscapé apenas protege dentro de até mesmo R$ 5 milénio.

United States Amor Por Direito Youtube

Olá , seu  blog é  excelente , seus artigos   estão melhores do  que muitos que encontramos na  em outros sites!! Saiba que seu site  é uma grande  fonte de dados .

Se você obter  Insurance você recebe 2-1.

United States affiliat markting onlin

The easiest way to locate out the contents for insurance policies are if you take into mind all of that are stored in your cupboards.  If you concentrate on the individuals who will hear you in the future, your blog post will be ranking an excellent source of no time.  If you are the first person to announce that yours is ready, then you need already won the race provided your product's quality and price is within a competitive range using the competitors.

United States Casino Online

Eis qualquer gênero fantástico com jogos Indies.

United States free cccam server cline generator 2014

Notre Serveur CCcam en ligne 24/7 tout le temps sans déconnexion pas de gel sans arrêt.

United States https://buyinstagramfollowers.co/

You've made some really good points there. I checked on the internet to learn more about the issue and found most people will go along with your views on this site.

SILVA, Amós Caçapo da. Com Dido ao preço de Matrona de Éfeso.

United States telecharger musique gratuite

Bonjour les gens,   Est-ce que vous connaissez un site où c'est possible d'écouter de la musique gratuitement ?   Avant j'utilisais le site internet  telecharger musique gratuite - https://imusique.fr   mais malheureusement il ne marche plus.   Merci beaucoup !

United States http://mbyourls.azurewebsites.net/

(1Timóteo 2,11-13).    Acessão em: 11 mai.

United States sexonanet.net

14, § 3.º). 432p.  A aba Constitucional do Transexual.

United States Norsk erotik gratis prr

Escort finspång erotisk massage borås - dating.

United States sexiga tjejer som hånglar youtube

Svensk porrfilm Gamla klassiska erotiska filmer.

United States Djurkata.Tk

Den vackra rakade fitta svenska nya Svensk sexfilm.

United States Porrspel mogna svenska kvinnor

Escort -sex- stockholm -porrbilder-mogna-kvinnor-.

United States mjukporn.tk

Afrikansk massage göteborg free sex svenska.

United States plan culturel numérique pdf

Les femmes sont plus belles sans leurs vêtements.

Amoureux d'une nympho. "Après dîner", c'est un plan cul.

United States Video Culte Protestants En FêTe

Il y a une femme nue dans ton lit. C'est qu'un plan cul.

United States Cougarencollant.Tk

The new boat was a real HIGH- TECH creation.

Apregoado no: 17 com outubro a 2009.

(et ce n'est pas forcément une femme insatisfaite).

United States chiropracteur paris 11

This article will assist the internet people for building up new website or even a blog from start to end.

United States rdv femme enceinte travail

C'est pas un plan cul, j'espère. C'est un plan cul.

United States Video robot Culinaire kitchenaid

Une blonde prise en sandwich par deux gynécos.

United States high tech box mods

La rubrique High-tech est mise à jour en temps réel.

United States https://sexonanet.net

Terei colegas vivos, porém, cometer...?

United States http://sexnederlandse.tk/sitemap18.php

Je zou maar laten weten dat je iemand leuk vindt….

United States neuk het buurmeisje

Je zou maar laten weten dat je iemand leuk vindt….

Fantaseer jij ook zo over telefoonsex met Huisvrouwen?

United States fietsen Kopen 26 inch

Lees hier meer over onze accu's en actieradius.

United States fiets achterwiel 28 inch kopen

Gewoon omdat ze meer ervaring met dure fietsen hebben.

United States essay writer free trial

May I just say what a relief to find someone that truly understands what they're talking about on the web. You actually understand how to bring a problem to light and make it important. More people need to read this and understand this side of your story. I can't believe you aren't more popular since you most certainly possess the gift.  My page  essay writer free trial - essaytypers.net/essaytypers-provides-premium-writing-services

United States coursework writing services for students in usa

Hi there to all, since I am truly keen of reading this website's post to be updated on a regular basis. It carries nice stuff.  Review my web-site ::  coursework writing services for students in usa - essaytypers.net/coursework-writing-services-for-students-in-usa

United States elektrische fiets 45 km/u te koop

De Wegcode beschouwt dit niet meer als fietsen.

United States Buy cheap Lumigan

Your style is so unique in comparison to other folks I've read stuff from. Thanks for posting when you have the opportunity, Guess I will just book mark this page.  my webpage:  Buy cheap Lumigan - sites.google.com/.../

Pingbacks and trackbacks (2)+

Add comment