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.





Be Sociable, Share!

Comments (472)

salam kenal, kami pengrajin cincin kawin, mungkin anda butuh banuan kami makasih
lokasi kami dikelapa dua, depok, jawa barat, dan dapat melayani dari luar daerah, 😀
cincin kawin

This site really has all the information I wanted
concerning this subject and didn’t know who to ask.

Unquestionably consider that which you said. Your favourite reason seemed to be on the internet the simplest
thing to consider of. I say to you, I certainly get irked even as folks think about
worries that they just do not know about. You controlled
to hit the nail upon the top and also defined out the
whole thing with no need side effect , other people can take a signal.
Will likely be back to get more. Thanks

What’s up it’s me, I am also visiting this web site on a regular basis, this web page is
truly pleasant and the visitors are in fact sharing nice thoughts.

And despite the fact that I occasionally really feel hunger pangs for the duration of
the day, they only last a couple of seconds.

Definitely believe that that you said. Your favorite reason seemed to be on the
internet the simplest factor to understand of. I say to you, I definitely get irked while people consider issues that they plainly do not recognise about.
You managed to hit the nail upon the highest as neatly as outlined out the
whole thing with no need side effect , people could take
a signal. Will likely be again to get more. Thanks

Hi, everything is going fine here and ofcourse every one is sharing facts, that’s in fact
fine, keep up writing.

Hi there to all, the contents existing at this website are truly amazing for people experience,
well, keep up the nice work fellows.

I got this web page from my pal who informed me regarding this web
site and now this time I am browsing this web page and reading very informative articles at this time.

I have to thank you for the efforts you have put in writing this blog.
I’m hoping to check out the same high-grade blog posts from you in the future as well.
In fact, your creative writing abilities has inspired me to
get my own, personal website now 😉

I read this article fully concerning the comparison of most
up-to-date and previous technologies, it’s awesome article.

Hello, all is going perfectly here and ofcourse every one is sharing information, that’s genuinely fine,
keep up writing.

For the very best quality peptides and study chemicals,
Top Peptides has what you require.

This post gives clear idea in favor of the new users of blogging,
that truly how to do blogging and site-building.

I don’t even know how I finished up here, but I believed this put up was once good.
I do not know who you are but certainly you are going to a famous blogger for those who
are not already. Cheers!

My brother recommended I would possibly like this
web site. He used to be totally right. This post actually made my day.
You cann’t believe simply how much time I had spent for this info!
Thanks!

Hi colleagues, pleasant paragraph and nice arguments commented aat this place, I aam actually enjoying by these.

Thank you a buunch for sharing this with all
of us you actually underwtand what you’re talking about!
Bookmarked. Kindly additionally discuss with my web site
=). We could have a hyperlink trade contract between us

Superb, what a weblog it is! This web site provides helpful data to us, keep it up.

Intriguing articles unmercifully medication and differing stories

Non-specific The facts Far this descendant

These tainted products have resulted in tragic medical consequences including liver and kidney damage, stroke, pulmonary failure and death. Tainted items are problematic, but people and organizations that intentionally taint their supplements and items are far worse compared to the neighborhood drug dealer. The area drug dealer thriving in every town in the united states illegally sells and distributes his/her drugs into a consumer base aware of what they’re purchasing and also the potential dangers from ingesting those chemicals. Supplement manufacturers and distributors conscious of selling tainted supplements are far worse since their consumers are ignorant for the dangerous chemicals being added. http://www.getraws.com

Write a comment