Day 2: Creating an Oracle Database 11g
Posted by Paola Pullas | Posted in Base de Datos, Oracle, Refundation, Unix/Linux | Posted on 23-08-2010
Tags: capacitación, Ecuador, Oracle, Oracle Open World 2010, soporte, tecnología, tutoriales
2
First ensure that you installed the Oracle Software according the tutorial in http://www.ecuoug.org/?p=264. In this post I show you how to create an Oracle Database.
Listener Creation
When an instance starts, a listener process establishes a communication pathway to Oracle Database. When a user process makes a connection request, the listener determines whether it should use a shared server dispatcher process or a dedicated server process and establishes an appropriate connection.
In order to create a listener open a terminal in your linux box, logged in like oracle user, and call the Net Configuration Assistant with command netca.
I the next screens I will show you step by step the process to create a listener with the next information:
-
Listener Name: LISTENER
-
Protocol: TCP
-
Port: 1521
Continue with the wizard until the Finish button appears, then Click Finish.
Database Creation
After the listener creation I will continue with database creation. Open a terminal in your linux box, logged in like oracle user, and call the Database Configuration Assistant with command dbca.
In the next screen named Welcome click Next.
In the screen 1 of 14 named Operations select Create Database and click Next.
In the screen 2 of 14 named Database Templates select General Purpose and Transaction Processing template and click Next. This template contains a pre-created database, so the database could be created in minutes, as opposed to an hour or more. In case that you require to change some database characteristics like block size you should create a Custom Database because this attribute can’t be changed with templates.
In the screen 3 of 14 named Database Identification fill the text boxes with the Global Database Name and SID and click Next. In this example I will use the next information:
-
Global Database Name: eva.refundation.ec
-
SID eva
In the screen 4 of 14 named Management Options check the options:
- Configure Enterprise Manager
- Configure Database Control for local management
Then click Next. I won’t select the other options because these can be configured later.
In the screen 5 of 14 named Database Credentials select the option Use the Same Administrative Password for All Accounts and click Next. In this example I will use this option for easily remember the password but in productions environments we recommend choose a different password for each account:
In the screen 6 of 14 named Storage Options select the option File System and click Next. In this example I will use this option because I don’t the other options configured in my linux box, we recommend evaluate the use of Automatic Storage Management in production environments:
In the screen 7 of 14 named Database File Locations select the option Use Common Location for All Database Files, fill the text box with the desired location, in this case I will use the location $ORACLE_BASE/oradata for this example, and click Next. Don’t remember to evaluate if the other options are valid for your production environment.
In the screen 8 of 14 named Recovery Configuration check the option Specify Flash Recovery Area and click Next. I will use the next information:
-
Flash Recovery Area: {ORACLE_BASE}/flash_recovery_area
-
Flash Recovery Area Size: 2048 (MB)
I won’t check Enable Archiving option because I will configure this option later.
In the screen 9 of 14 named Database Content check the option Sample Schemas and click Next. I recommend not install the sample schemas in production environments:
In the screen 10 of 14 named Initialization Parameters you can configure: Memory, Sizing, Character Sets and Connection Model. In the next screens I will show you the options that I chose for this screen, in all cases I am using the default configuration that can be changed after the database is created. When you finished click Next.
In the screen 11 of 14 named Security Settings I will keep the settings by default and click Next.
In the screen 12 of 14 named Automatic Maintenance Tasks I will keep the settings by default and click Next.
In the screen 13 of 14 named Database Storage you can review the configuration of controlfiles, datafiles, and redo log files. When you finished click Next.
In the screen 14 of 14 named Creation Options check the option Create Database and click Finish.
A confirmation screen will be displayed and you can save this information like an HTML file. When you finished click OK.
If the database is created successfully a new screen will appear showing you the configuration information. When you finished click Exit.
How to Monitor Database from Enterprise Manager Dbconsole
In the next screen I will show you how to review the Enterprise Manager Console service.
While I was developing this post I noticed that the wizard has a bug in the graphical interfaces. There are only 14 screens in the wizard but the firsts screens show you like there are 15 screens 
.
Author: Paola Pullas
Do you need to buy support?: Contact me at pp@refundation.com
If you think that this tutorial helped you. Make a donation to this initiative. We appreciate your support.
