Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself While at Work and Welcome any body Needing Help!!!.*** CAUTION: Using any of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.***

Tuesday, 21 January 2014

Install Oracle 12c on Windows env.

The article describes the step by step installation of oracle 12c Release 1 on windows 2008 based on server installation with a minimum of 2GB swap. Click on the link to download oracle: Download Oracle 12c database then unzip software to a directory such as: unzip, unzip
Step1: Run the Setup.exe the installer will start. Uncheck checkbox “I wish to receive security updates via My Oracle Support” and then click “Next” button. Then in next subsequent screen ignore the security alert message.

Step2: Select “skip software updates” and click ‘Next” button afterward select “create and configure a database” and click “Next” button.
Step3: Now select the system class accordingly in my case I have selected “server class”
         Desktop class: Choose this option if you are installing on a laptop or desktop class system (stand alone). This includes a starter database and allows minimal configuration.
         Server class: Choose this option if you are installing on a server class system, which oracle database as a system used in a production data center. This option allows for more advance configuration system.
Step4: Select “single instance database installation” option and click “Next”.
Other option are available if you have grid software 12c installed. In case you want to install oracle 12c RAC on windows 2008 click on the following link: Install oracle RAC 12c on windows 2008 using Virtual Box
Step5: Either Select “Typical install” (full database installation with basic configuration) or “Advanced install” to have more options during installation of new database and click “Next”. Then select your language option (English) and click “Next
Step6: Accept Default “Enterprise Edition” and click “Next” button.
Step7: On this screen you can select account which will be used to install and use of new database software. I used “Use Windows Built-in Account”. Click “Next” button. In such case accept next subsequence alert message by clicking on “Yes”.
Note: Oracle recommended that specify a standard windows user account (not an Administrator account) to install and configure the oracle home for enhanced security. This account is used for running the windows services for the oracle home. Do not log in using this account to perform administrative task.
Step8: Select the new binaries location and click on “Next” button. Then select the type of database “General purpose/Transaction processing” and click “Next” button.
Step9: Enter “Global database name” and “Oracle system identifier (SID)” for your new database which will be created. If you check checkbox “Create as Container database” your database will be able to consolidate many databases. In such case you need to enter name of your first pluggable database “Pluggable database name (12c new feature )”. Click “Next” button.
Step10: Specify configuration option (more details) about database in respective tab: Memory, character sets, Sample Schema etc.
         Check on “enable automatic memory management” (allows the database distribute memory automatically between SGA based on overall target size). If automatic memory not enabled then SGA and PGA must be size manually.
         Either use default character set for this database is based on the language setting of the operating system or choose from the list available.
         You can choose to “create a starter database” with or without sample schema or you can plug the sample schema to your existing starter database after creation.   
Step 11: Select database storage type either “file system” or ASM (select this option only if you intended to use oracle ASM). Provide the file system location and click “Next”.
On the next subsequent screen “Management function” register your database with oracle Enterprise Cloud.
Step12: In the ‘Recovery options” screen check “Enable Recovery” to specify recovery area where backup will be stored.
Step13: Specify schema password for each user or enter the same for all then by clicking on “Next” button checks are started to verify the OS is ready to install database software. If every things OK then “install” button is appear verify every things before click on “install” button.
Now database install is in progress… wait until you are getting the summary window and finally “The installation of oracle database was successful” message.


Post a Comment