Posted on 2009-02-24
Last Modified: 2013-12-13
Hi all,

I am begginer with Linux(UNIX) , i want to create a Oracle database on LINUX machine, which has Oracle already installed. I am using putty and logged-in as user oracle , and i am at the command promt below, what do i do from here? I know i need to invoke DBCA, how do i do that and where will i find it? To be honest , I dont even know how to find teh Oracle_HOME.
Please advice!

[oracle@myrhsan ~]$
Question by:crishna1
    1 Comment
    LVL 3

    Accepted Solution

    Sounds like you probably should spend some time with a Oracle for Beginners kind of book.  I can recommend a few if you'd like.  But here's a few tips to get you started:

    The ORACLE_HOME environment variable should be set in the .bash_profile file.  Typically it will be something like /u01/app/oracle/product/10.2.0/db_1.  The part that will be the most variable is the base mount point, "u01" in this case.

    The dbca program can be found in the $ORACLE_HOME/bin directory.  The tricky part may be getting the display to your desktop if that is necessary, but there's no point getting into that if it's not an issue.  

    If this is a sandbox server and there are no functioning databases present, I would recommend scrubbing the existing Oracle installation and doing it again yourself.  It's a great way for a beginning to become properly oriented with the environment.  If you choose to go that route, I'd recommend following this procedure:

    Even if you don't reinstall, you could probably learn a lot about your Oracle environment by reading that document.

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
    Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
    Via a live example, show how to take different types of Oracle backups using RMAN.

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now