OEM 12c: Compatibilidad

Posted by Paola Pullas | Posted in Administración, Oracle | Posted on 31-10-2012

Tags: , ,

30

Al momento me encuentro dictando un taller de Oracle Enterprise Manager 12c para Oracle University y una de las preguntas clave con las que deberíamos empezar hace referencia a la compatibilidad del producto. En este post voy a colocar un listado de compatibilidad del producto a diferentes niveles. Para quienes están comenzando con la herramienta les será muy útil pues el listado que coloco a continuación es un overview para empezar a trabajar con el producto:

Enterprise Applications (4 Items)

  • Enterprise Manager Ops Center Plug-in
  • 1 Release(12.1.0.1.0)

  • JD Edwards EnterpriseOne Tools (Managed Target)
  • 1 Release(8.97+)

  • Oracle Fusion Applications (Managed Target)
  • 1 Release(11.1.1.5.1)

  • Siebel Enterprise (Managed Target)
  • 3 Releases(8.1.1,8.0.0,7.8.2)

Databases (8 Items)

  • Audit Vault 10.3.0.0.0 (Managed Target)
  • 1 Release(10.3.0.0.0)

  • IBM DB2 (Managed Target)
  • 1 Release(9.1)

  • Microsoft SQL Server (Managed Target)
  • 2 Releases(2008 R2,2005)

  • Oracle Audit Vault (Managed Target)
  • 1 Release(10.2.3.2)

  • Oracle Database (Managed Target)
  • 8 Releases(11.2.0.3.0,11.2.0.2.0,11.2.0.1.0,11.1.0.7.0,10.2.0.5.0,10.2.0.4.0,10.1.0.5.0,9.2.0.8.0)

  • Oracle Database (Repository)
  • 5 Releases(11.2.0.3.0,11.2.0.2.0,11.2.0.1.0,11.1.0.7.0,10.2.0.5.0)

  • Oracle Exadata Storage Server (Managed Target)
  • 3 Releases(11.2.3.1.0,11.2.2.4.0,11.2.2.3.0)

  • Sybase Adaptive Server Enterprise (Managed Target)
  • 1 Release(12.5.4)

Virtualization Software (1 Item)

  • Oracle VM Server for x86
  • 3 Releases(3.1.1.0.0,3.0.3.0.0,3.0.2.0.0)

Desktop Applications, Browsers and Clients (5 Items)

  • Adobe Flash Player
  • 2 Releases(10.3+,10)

  • Firefox
  • 3 Releases(5+,4,3.6)

  • Google Chrome
  • 1 Release(17)

  • Internet Explorer
  • 4 Releases(9.x,9,8,7)

  • Safari
  • 2 Releases(5,4)

Middleware / Application Servers (35 Items)

  • Apache Tomcat (Managed Target)
  • 5 Releases(7.*,6.0.*,5.5.*,5.0.30,5.0.3+)

  • Directory Integration Platform (Managed Target)
  • 1 Release(11.1.1.2.0)

  • IBM WebSphere Application Server (Managed Target)
  • 3 Releases(7.*,6.1,6.0)

  • IBM WebSphere MQ (Managed Target)
  • 2 Releases(7.0.*,6.0.*)

  • IBM WebSphere Portal Server (Managed Target)
  • 3 Releases(7.0.0.0,6.1.0.2+,6.0.1+)

  • JBoss Application Server (Managed Target)
  • 4 Releases(6.*,5.0.1,4.2.*,4.0.*)

  • Microsoft .NET Framework (Managed Target)
  • 3 Releases(3.0.*,2.0.*,1.1.*)

  • Microsoft Active Directory (Managed Target)
  • 2 Releases(2008,2003)

  • Microsoft BizTalk Server (Managed Target)
  • 1 Release(2004)

  • Microsoft Internet Information Server (Managed Target)
  • 3 Releases(7.0,6.0,5.0+)

  • Oracle Access Manager (Managed Target)
  • 4 Releases(11.1.1.5.0,11.1.1.3.0,10.1.4.3.0,10.1.4.2.0)

  • Oracle Adaptive Access Manager (Managed Target)
  • 2 Releases(11.1.1.5.0,11.1.1.3.0)

  • Oracle Application Server (Managed Target)
  • 3 Releases(10.1.3.5.0,10.1.3.4.0,10.1.2.3.0)

  • Oracle BPEL Process Manager (Managed Target)
  • 4 Releases(10.1.3.5.0,10.1.3.4.0,10.1.3.3.0,10.1.3.1.0)

  • Oracle Business Intelligence Enterprise Edition (Managed Target)
  • 4 Releases(11.1.1.6.0,11.1.1.5.0,10.1.3.4.1,10.1.3.4.0)

  • Oracle Business Intelligence Publisher (Infrastructure)
  • 1 Release(11.1.1.6.0)

  • Oracle Coherence (Managed Target)
  • 6 Releases(3.7.1.0.0,3.7.0.0.0,3.6.1.0.0,3.6.0.0.0,3.5.0.0.0,3.4.0.0.0)

  • Oracle Directory Integration Platform (Managed Target)
  • 2 Releases(10.1.4.3.0,10.1.4.2.0)

  • Oracle Directory Server Enterprise Edition (Managed Target)
  • 1 Release(11.1.1.5.0)

  • Oracle Enterprise Content Management (Managed Target)
  • 5 Releases(11.1.1.6.0,11.1.1.5.0,11.1.1.4.0,11.1.1.3.0,11.1.1.2.0)

  • Oracle Forms (Managed Target)
  • 5 Releases(11.1.1.6.0,11.1.1.4.0,11.1.1.3.0,11.1.1.2.0,11.1.1.1.0)

  • Oracle Fusion Middleware (Infrastructure)
  • 1 Release(11.1.1.6.0)

  • Oracle HTTP Server (Managed Target)
  • 7 Releases(11.1.1.6.0,11.1.1.5.0,11.1.1.4.0,11.1.1.3.0,11.1.1.2.0,11.1.1.1.0,10.1.2.0.0)

  • Oracle Identity Federation (Managed Target)
  • 3 Releases(11.1.1.2.0,10.1.4.3.0,10.1.4.2.0)

  • Oracle Identity Management (Managed Target)
  • 2 Releases(10.1.4.3.0,10.1.4.2.0)

  • Oracle Identity Manager (Managed Target)
  • 3 Releases(11.1.1.3.0,9.1.0.2.0,9.1.0.1.0)

  • Oracle Reports (Managed Target)
  • 5 Releases(11.1.1.6.0,11.1.1.4.0,11.1.1.3.0,11.1.1.2.0,11.1.1.1.0)

  • Oracle SOA Suite (Managed Target)
  • 6 Releases(11.1.1.6.0,11.1.1.5.0,11.1.1.4.0,11.1.1.3.0,11.1.1.2.0,11.1.1.1.0)

  • Oracle Service Bus (Managed Target)
  • 9 Releases(11.1.1.6.0,11.1.1.5.0,11.1.1.4.0,11.1.1.3.0,10.3.1.0.0,10.3.0.0.0,3.0.0.0.0,2.6.1.0.0,2.6.0.0.0)

  • Oracle Virtual Directory (Managed Target)
  • 4 Releases(11.1.1.6.0,11.1.1.5.0,11.1.1.3.0,11.1.1.2.0)

  • Oracle WebCenter (Managed Target)
  • 4 Releases(11.1.1.5.0,11.1.1.4.0,11.1.1.3.0,11.1.1.2.0)

  • Oracle WebLogic Portal (Managed Target)
  • 4 Releases(10.3.3.0.0,10.3.2.0.0,10.3.1.0.0,10.3.0.0.0)

  • Oracle WebLogic Server (Infrastructure)
  • 1 Release(10.3.5.0.0)

  • Oracle WebLogic Server (Managed Target)
  • 7 Releases(12.1.1.0.0,10.3.6.0.0,10.3.5.0.0,10.3.4.0.0,10.3.3.0.0,10.3.2.0.0,9.2)

  • WebLogic Server (Managed Target)
  • 4 Releases(9.2,9.1,9.0,8.1)

Operating Systems (7 Items)

  • IBM AIX on POWER Systems (64-bit)
  • 3 Versions(7.1,6.1,5.3)

  • Linux x86
  • 7 Versions(SLES 11,SLES 10,Red Hat Enterprise Linux 5,Red Hat Enterprise Linux 4,Oracle Linux 5,Oracle Linux 4,Asianux 3)

  • Linux x86-64
  • 8 Versions(SLES 11,Red Hat Enterprise Linux 6,Red Hat Enterprise Linux 5,Red Hat Enterprise Linux 4,Oracle Linux 6,Oracle Linux 5,Oracle Linux 4,Asianux 3)

  • Microsoft Windows x64 (64-bit)
  • 4 Versions(7,2008 R2,2008,2003)

  • Oracle Exalogic Infrastructure (Managed Target)
  • 3 Releases(2.0.0.0.0,1.0.0.2.1,1.0.0.1.0)

  • Oracle Solaris on SPARC (64-bit)
  • 3 Versions(9,11,10u9)

  • Oracle Solaris on x86-64 (64-bit)
  • 2 Versions(11,10u9)

OTN Tour 2012 llegó el momento de la inscripción a nuestro evento

Posted by Paola Pullas | Posted in Administración, Aplicaciones, Base de Datos, JDeveloper, Noticias, Oracle, Oracle XE | Posted on 19-06-2012

Tags: , , , , , , , , , , ,

9

Estimados Amigos,

Se acerca el evento de tecnología Oracle más importante del año a Ecuador. Este año contaremos con la participación de 8 expositores internacionales y hasta 5 tracks de capacitación en tecnología de los cuales podrán elegir.

A continuación los detalles y costos del evento:

Fecha: 6 de Julio de 2012
Lugar: Universidad de las Américas, Campus Av. de los Granados y Colimes esq, Quito – Ecuador, Auditorio 1 y 2.
Costo del Evento: 150USD o 100USD por día. Estudiantes cuentan con el 50% de descuento si presentan el carnet de su universidad.
Pago del Evento: El pago del evento podrá hacerse mediante depósito en la cuenta corriente #02054016475 del Banco Produbanco a nombre de Refundation o realizar el pago en efectivo en nuestras oficinas ubicadas en la Checoslovaquia y Av. Eloy Alfaro, Edf. Cuarzo, Piso 5, Of. 2. Una vez que haya realizado el pago deberá enviar un correo electrónico a inscripcion@ecuoug.org con la papeleta de depósito escaneada e indicando el track de capacitación en el cual desea reservar su cupo.
Retiro de credenciales: El retiro de credenciales de acceso al evento deberá hacerse entre el día Viernes 29 de Junio y Martes 3 de Julio en las oficinas de Refundation ubicadas en la Checoslovaquia y Av. Eloy Alfaro, Edf. Cuarzo, Piso 5, Of. 2.
Acceso a tracks de capacitación por el pago de 150USD: Por el pago de 150USD tendrá acceso a:

  • Evento del 6 de Julio de 2012
  • Accceso a un track de capacitación los cuales se dictarán el 4 y 5 de Julio. Usted podrá elegir entre: Oracle DBA en 2 días, High Availability con Oracle Real Application Clusters, Disaster Recovery con Oracle Data Guard u Oracle Security.
  • Acceso al Track de CIO’s en donde se tratará temas como ITIL, Cobit, Licenciamiento de Productos Oracle y demás..
  • Acceso a almuerzo, servicio de coffe break a media mañana y media tarde y cocktail.

Agenda del Evento: Descargar de Agenda del Evento OTN LAD Tour 2012 (2147) la agenda del evento para el día 6 de Julio.

Las personas que se inscriban y realicen el pago hasta el día Lunes 25 de Junio automáticamente participarán por el sorteo de una Notebook. En su credencial de acceso constará el número para participar en el sorteo.

OTN Tour 2012 – 4,5,6 de Julio de 2012 Quito Ecuador

Posted by Paola Pullas | Posted in Entrenamiento, Noticias, Oracle | Posted on 31-05-2012

Tags: , , , , , , , , , , ,

10

En 30 días Ecuador tendrá al evento de tecnología más grande e importante realizado durante el año. Tendremos 3 días de conocimiento distribuídos entre el 4 y 6 de Julio en la Universidad de las Américas en la sede ubicada en la Av. de los Granados y Colimes esq, Quito – Ecuador.

Lo invitamos a inscribirse en nuestra página web http://www.ecuoug.org/otn12.

Day 6: Tip Log_Archive_Dest_1 Set To Default in Oracle Database 11.1

Posted by Paola Pullas | Posted in Base de Datos, Oracle, Tips | Posted on 03-10-2010

Tags: , , , ,

7

In this post I want to share with you the information about the Bug 6373164 present in Oracle Database 11.1. This bug was fixed in release 11.1.0.7.0.

Symptoms

I configured Archivelog Mode in my database and set the flash recovery area like the default location to store achivelog files. I configured the next parameters in order to set the flash recovery area:

  • DB_RECOVERY_FILE_DEST
  • DB_RECOVERY_FILE_DEST_SIZE

Other parameters related to Archivelog Mode aren’t configured in my linux box, for example:

  • LOG_ARCHIVE_DEST is not set
  • LOG_ARCHIVE_DEST_n is not set

In the next screen I show you my actual configuration:

When the database starts to generate archivelog files, these was send to flash recovery area location but additionally to $ORACLE_HOME/dbs causing higher disk space utilization in my server, like I show you in the next screen:

How to solve the problem

In order to solve this problem you should change the configuration of LOG_ARCHIVE_DEST_1 parameter with the next command:

  • alter system set LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST' scope=both;

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. Also your donation can help me to buy more coffee or Red Bull.





Day 5: Configuring ARCHIVELOG Mode

Posted by Paola Pullas | Posted in Administración, Base de Datos, Oracle | Posted on 05-09-2010

Tags: , , , , , ,

103

Before to review this tutorial review this links:

Configuring the Flash Recovery Area

The flash recovery area is a storage location for all recovery related files. All files that are needed to completely recover a database from a media failure are part of the flash recovery area. Some files in the flash recovery area are: control files, redo logs, archived logs, backup pieces, image copies, flashback logs and foreign archived logs.

By allocating a storage location and unifying related recovery files within a specific area, the Oracle database server relieves the database administrator from having to manage the disk files created by these components.

When setting up a flash recovery area, you choose a directory, file system or Automatic Storage Management disk group to hold the files, and set a disk quota for the maximum space to be used for all files stored in the flash recovery area.

The flash recovery area should be on a separate disk from the working area. Keeping the flash recovery area on the same disk as the working area exposes you to loss of both your live database files and backups in the event of a disk failure.

You can execute the next command from SQL*Plus in order to verify the actual configuration of flash recovery area:

  • show parameter db_recovery_file_dest

If you want to change this configuration you can execute the alter system command from SQL*Plus to set the values that are more appropriate for your environment:

  • alter system set db_recovery_file_dest='/u01/app/oracle/flash_recovery_area' scope=both;
  • alter system set db_recovery_file_dest_size='2G' scope=both;

The first parameter shows you the physical directory of the flash recovery area and the second parameter shows you the quota or size assigned for this area. Keep in mind that quota should be bigger enough to keep the recovery files.

Another method to verify the flash recovery area configuration is using Enterprise Manager Dbconsole going to Availability –> Recovery Settings like I show you in the next screens.

Configuring the Archivelog Mode from SQL*Plus

The firs step is make a clean shutdown of your database using any of the next commands from SQL*Plus:

  • shutdown immediate;
  • shutdown normal;
  • shutdown transactional;

Then you should use the next commands from SQL*Plus in order to mount the database, configure the archivelog mode and finally open the database:

  • alter database mount;
  • alter database archivelog;
  • alter database open;

Next I will verify if my configuration is working properly with the next commands:

  • select log_mode from v$database;
  • alter system archive log current;

In the first screen the command verify the log mode of the database and in the second screen I am forcing the archiving process in the database:

Configuring the Archivelog Mode from Enterprise Manager Dbconsole

Login in Enterprise Manager Dbconsole page.

Go to Recovery Settings link under Availability tab.

Go to Media Recovery section and check the ARCHIVED Mode option then click in Apply button.

A Confirmation screen will appear after click in Apply button, then click in Yes button.

The next screen will appear and you should fill the text boxes with the os and database users information, in my case the os user is oracle and the database user with SYSDBA privilege is sys, then click in OK button.

The next screens will appear after this operation. You should wait a few minutes until the process finished. In order to know that this complete successfully you should refresh your browser until the login screen appears.

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. Also your donation can help me to buy more coffee or Red Bull.





Remember: Database Administrator Responsabilities

Posted by Paola Pullas | Posted in Administración, Base de Datos, Oracle, Recuerda | Posted on 05-09-2010

Tags: , , ,

0

A database administrator’s responsibilities can include the following tasks:

  • Installing and upgrading the Oracle Database server and application tools.

  • Allocating system storage and planning future storage requirements for the database system.

  • Creating primary database storage structures (tablespaces) after application developers have designed an application.

  • Creating primary objects (tables, views, indexes) once application developers have designed an application.

  • Modifying the database structure, as necessary, from information given by application developers.

  • Enrolling users and maintaining system security.

  • Ensuring compliance with Oracle license agreements.

  • Controlling and monitoring user access to the database.

  • Monitoring and optimizing the performance of the database.

  • Planning for backup and recovery of database information.

  • Maintaining archived data on tape.

  • Backing up and restoring the database.

  • Contacting Oracle for technical support.

Ref.: http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/dba001.htm#i1006120

Day 4: How to submit SQL commands to Oracle database

Posted by Paola Pullas | Posted in Administración, Base de Datos, Oracle | Posted on 05-09-2010

Tags: , , , , , , ,

4

There are different tools to access Oracle database in order to submit SQL commands. In this section I will show you 3 Oracle tools that you have with no extra cost. Before to review this tutorial review this links:

SQL*Plus

The firs tool is SQL*Plus, this is a command-line interface tool to access to Oracle database. You use SQL*Plus to execute many administrative tasks for example: start up and shut down the database, set database initialization parameters, create and manage users, create and alter database objects (such as tables and indexes), and more. In addition SQL*Plus can be used to insert and update data and run SQL queries.

The format to establish a connection using SQL*Plus is:

  • CONN[ECT] [logon] [AS {SYSOPER | SYSDBA}]
  • {username | /}[@connect_identifier]

In the next screen I will show you some examples in order to gain access to database from SQL*Plus.

  • sqlplus /nolog

  • connect sys/oracle as sysdba

  • conn sys/oracle@eva as sysdba

  • conn system/oracle

  • connect system/oracle@eva

  • connect system/oracle as sysdba

  • conn system/oracle as sysoper

  • conn hr/hr

  • conn hr/hr@eva

Enterprise Manager Dbconsole

Oracle Enterprise Manager Dbconsole is an intuitive graphical interface to administer the database.

In order to gain access to Enterprise Manager you should be a user defined like administrator in the application dbconsole. In the next screen I will show you the users that can login in the Oracle Enterprise Manager Dbconsole. In order to acess this screen you should login in Enterprise Manager Dbconsole like sys user and then go to Setup link in the right upper corner of the application:

In the next screens I will show you some examples in order to login in Enterprise Manager Dbconsole. The url to access have the format https://server_ip:em_port/em. If you don’t know the port to access the application you can find this in the file portlist.ini located in $ORACLE_HOME/install:

SQL Developer

Start the application with sqldeveloper command from a operating system terminal, and next create a connection in the graphical interface like I show you in the next 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. Also your donation can help me to buy more coffee or Red Bull.





Day 3: How to install SQL Developer in Linux

Posted by Paola Pullas | Posted in Aplicaciones, Base de Datos, Oracle | Posted on 04-09-2010

Tags: , , , , ,

5

In this post I will show you how to install Oracle SQL Developer in a Linux box. First, you should download the SQL Developer software from http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html.

Next, if you downloaded the software without JDK included, you need to download a JDK 1.6.11 version or above from http://www.oracle.com/technetwork/java/javase/downloads/index.html

Install JDK

First install the JDK version in your Linux box in any directory. I will install the JDK in /u01/app/oracle like I show you in the next screens:

  • chmod a+x jdk-6u-linux-i586.bin
  • ./jdk-6u-linux-i586.bin

Install SQL Developer

Then install SQL Developer rpm using the next command:

  • rpm -Uhv sqldeveloper-2.1.1.64.45-1.noarch.rpm

Next, verify if the file jdk contains the JDK’s path. This file is located in $HOME/.sqldeveloper. If the JDK’s path that you installed previously isn’t registered in the jdk file, the first time that you launch the application, you should be prompted to provide the path.

Finally execute sqldeveloper with the next command:

  • sqldeveloper

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. Also your donation can help me to buy more coffee or Red Bull.





Paola Pullas’s Oracle Magazine Interview

Posted by Paola Pullas | Posted in Noticias, Opinión, Oracle | Posted on 24-08-2010

Tags: , , , , , , ,

1

Oracle Magazine Interview published at: http://www.oracle.com/technetwork/oramag/2010/10-sep/o50upclose-165467.html

COMMUNITY: Up Close

As Published In
Oracle Magazine
September/October 2010

Stronger Together
By Jeff Erickson

A growing Ecuadorian user group builds ties with its Latin American neighbors.

Paola Pullas knows how to do a lot with a little. With the nearest Oracle corporate office in neighboring Colombia and user group members spread across a geographically diverse nation, Pullas, president of the Ecuador Oracle Users Group (ECUOUG), is helping to forge a single Oracle user group that can attract top speakers and make its voice heard.

ECUOUG represents more than 200 corporate members in the country’s major industries, including mining, construction, and telecommunications, as well as agricultural production of crops such as bananas, cocoa, and flowers. “We have three main telecommunications companies in Ecuador, and all of them are members of our group,” says Pullas. “But there are many smaller businesses, such as in our flower industry, that are coming to us.”

Across the Stack

The group holds as many as 12 meetings a year, mostly in Quito, Ecuador’s capital city, and mostly on subjects such as Oracle Database, Oracle WebLogic Server, and Oracle JDeveloper. But the group is expanding to support other parts of the technology stack. “We’ve found that lots of midsize companies in Ecuador use [Oracle’s] JD Edwards, and many of our members use [Oracle’s] PeopleSoft and Siebel,” says Pullas. “We are in the process of launching an applications user group within ECUOUG.”

With Oracle’s acquisition of Sun, ECUOUG is also reaching out to Sun users through a new Sun special interest group and is working with an existing Java user group to fold it into ECUOUG. “As a small country, we want to bring all Oracle users, Sun, applications, Java, and tech under one roof,” says Pullas.

With members dotted across Ecuador, the ECUOUG community has become adept at using social media to communicate. The group is easy to find and follow on Facebook, Twitter, and Oracle Mix. Its blog, at ecuoug.org, was the online foundation from which the current user group was formed, and it is still a great place to keep up with Oracle technologists in Ecuador. “We organize our live event each month to share experiences and network because we want to cover all the subjects and we want this community to stay together,” says Pullas. “In between events, we go online to share tutorials, tips, and news.”

Banding Together

On the heels of a successful Oracle OpenWorld conference in São Paulo, Brazil, in 2009, the Latin American user group community began working together to keep the momentum going. User group leaders organized a Latin American user group council, with each member country providing a board member. Pullas is the board member from Ecuador. Current member countries include Argentina, Brazil, Chile, Colombia, Costa Rica, Mexico, Peru, Uruguay, and Ecuador.

For 2010 the group has organized what Pullas calls a Latin American Oracle Technology Network tour. The plan, says Pullas, is for smaller countries to hold their annual meetings in quick succession so that top speakers can make a swing through Latin America and visit several user groups along the way. Top Oracle ACEs from the U.S. and Europe and speakers from Oracle Consulting are expected to make the trip—even Oracle architect and Oracle Magazine columnist Tom Kyte is on the bill in some countries. Ecuador’s event is scheduled for October. “We are now working like one big integrated community,” says Pullas. “We know that Latin American technologists are a big presence in the Oracle world, and this community will be a voice for sharing our experiences with members in neighboring countries and with Oracle.”

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: , , , , , ,

472

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.