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

491

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.





Share and Enjoy:
  • Twitter
  • Google Bookmarks
  • Facebook
  • del.icio.us

Comments (491)

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

The San Francisco Chinese New Year Festival and Parade is
the oldest and biggest event of its sort outdoors of Asia, and the largest Asian cultural occasion in North America.

whoah this blog is wonderful i love reading your
articles. Keep up the great work! You already know,
many persons are hunting round for this information, you
can help them greatly.

Hi there! I could have sworn I’ve visited this blog before but after looking at many of the posts I realized it’s
new to me. Regardless, I’m certainly delighted I found it and I’ll
be book-marking it and checking back regularly!

Jewelry Shopping have New Destination Jewel24.in an Online Store Were you can buy
Anytime.

Simply wis to say your article is as astonishing.
The clearness in your post is simply nice and i could assume you’re an expert on this subject.
Well with your permissin allow mme to grab your feed to keep updatged with forthcoming post.

Thanks a million and please continue the rewadding work.

My weblog Koby

Saya tidak bisa menahan . Baiklah ditulis!

It’s going to be end of mine day, however before
finish I am reading this wonderful piece of writing to increase my know-how.

Does your site have a contazct paցe?

Ӏ’m һaving a tough time locating іt Ƅut, I’ԁ like tο shoot Why would you use a cheap windows vps, an email.
І’vе ǥot ѕome
recommendations fоr уоur blog ʏⲟu
might Ьe interested in hearing.
Ꭼither ᴡay, ցreat website and Ι lߋоk forward to ѕeeing іt grow օνᥱr time.

It’s not my first time to visit this site,
i am browsing this web site dailly and obtain nice information from here
everyday.

These shirts also go fortunate at parties where you can either.

V is available now at all retailers including Foot Locker for
$117. The Author is a professional writer, presently writing for Cheap Tee Shirts
and Short Sleeve Shirt.

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

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

Good information. Lucky me I ran across your blog by chance (stumbleupon).
I have book marked it for later!

College students take pride in their alma mater, which is why so numerous will purchase a hoodie that has some type of logo, writing, or
other symbols of the college or university embroidered on it.
The bookstores have a wide choice of hoodies for students to purchase.
The hoodies are not all plain, in reference to their style as an alternative, there are
stylish hoodies for ladies to choose from.

Excellent blog you’ve got here.. It’s difficult to find excellent writing like yours nowadays.
I really appreciate individuals like you! Take care!!

Hi my family member! I wish to say that this article is awesome, nice written and come
with almost all vital infos. I’d like to see more
posts like this .

It’s really very complicated in this busy life to listen news on TV, therefore I only use world
wide web for that reason, and obtain the latest information.

It’s an awesome piece of writing in favor of all the online viewers;
they will get benefit from it I am sure.

It’s awesome in favor of me to have a web site, which is helpful for my know-how.
thanks admin

Call 417-379-5441 to hire a DECORATIVE CONCRETE PROFESSIONAL.

Request a price for our project here.

Popppenga Concrete Construction, LLC is a company dedicated to providing Architects, designers, developers and homeowners wih the
highest level of quality work possible.
Since 1989 Dave hhas dedicated his team of experts to provide the vvery best
products and only premium top quality workmanship and
service resulting in a reputation of unsurpassed customer service and superior product and
application knowledge.

With over 30 year of experience, our company can provide youu with thee best quality forr the best
price. We are a licensed and insured local family owned business.

We are a full service contractor, experts iin decoratove stamped concrete fijnishes that can make yopur dream backyaard become reality, or fulfill all your commercial needs as well.
Contact Dave today for a custom estimate to fit your specific
needs. We serve Springfield Missouri and surrounding areas.

Check out mmy weblog and outdoor living areas (patios) finished in unique Stamped and Decorative patterns and colors are “IN” today. Contact Dave today for a custom estimate to fit your specific needs FREE ESTIMATES: Call Dave at 417-379-5441 to request a FREE estimate on your concrete project anywhere in the Springfield

What’s up to every body, it’s my first pay a quick visit of this
webpage; this blog includes remarkable and actually good information in favor of
visitors.

This info is worth everyone’s attention. How can I find out more?

Why visitors still use to read news papers when in this technological globe all is existing
on web?

Write a comment