[Last Call] Learn how to a build a cloud-first strategyRegister Now


Oracle starter

Posted on 2011-10-27
Medium Priority
Last Modified: 2012-05-12
I am SQL DBA and have to start maintaining Oracle databases.  I need to install development oracle 10g(I am not sure if that is free like in SQl) ..create an Oracle database in  my development environment and start playing around with it to get familiar with Oracle.   Can an Oracle guru  get me started with some how to instructions?......did research online..too much info..need to get straight to the point.  Any inputs appreciated.
Question by:Nana Hemaa
LVL 74

Accepted Solution

sdstuber earned 1000 total points
ID: 37038644
you can download multiple versions for free from OTN for development and study

you can download them here


11g will be at the top, scroll down to get to 10g
LVL 74

Expert Comment

ID: 37038661
also note  Oracle XE (express edition) is totally free (even for production use)

it has limitations, but is still pretty good to learn with


again 11g is at the top,  10g is lower.

Unless you "must" use 10g,  I recommend starting with the most recent 11g  11gR2
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37038834

Can I assume SQL Server?

I would suggest a crossover guide that can bridge the gaps between the two systems.

There are a few out there:

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.


Author Comment

by:Nana Hemaa
ID: 37039079
After the installation ..where do I go to create test databases etc  and manage them.. can someone share more light?
LVL 74

Expert Comment

ID: 37039091
you'll create them on some server,  your own pc if you want.

if you don't have much space/memory/cpu  then use XE, it's lighter weight
LVL 78

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 400 total points
ID: 37039124
A 'database' in Oracle doesn't mean the same thing as a database in SQL Server.

This is why a good crossover book will help.  It will cover the terminology differences.

The install will ask you if you want to create a database.

You can create them after with the Configuration Assistants.

A database in Oracle has schemas which are basically users that own objects like tables.

There are 'sample' schemas that can be installed when you build the database.  Most documentation examples are based on these sample schemas.

LVL 23

Assisted Solution

OP_Zaharin earned 600 total points
ID: 37042821
- the earlier experts have provide sufficient detail on downloading and install the Oracle database. going forward, you can either use command prompt - 'sqlplus' tool that comes with the database to do DML operations such as insert update delete tables, index, query, create tables and etc or use the following free SQL Developer GUI-based to do the same:


Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question