Posted on 2009-02-24
Medium Priority
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

Accepted Solution

garysadler earned 1000 total points
ID: 23724253
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

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

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

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses

864 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