I have my binaries in /u01/app/oracle/product/
export ORACLE_HOME=/u01/app/oracle/product/
cd bin

successfully created database but it is created in dbhome_1
database should be created in dbhome_2
please help

below line is from /etc/oratab
NEWDB:/u01/app/oracle/product/               # line added by Agent
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

your path must have had the home1 before the home2  when you invoked dbca

easily fixed though, assuming the two homes are identical,  just edit the /etc/oratab and change the path

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mark GeerlingsDatabase AdministratorCommented:
Oracle database files don't need to be created in the ORACLE_HOME directory tree.  In fact, I always prefer to have the data, log and control files for Oracle databases *OUTSIDE* of the ORACLE_HOME.  That way, I can manage the space for and backups of the database separate from the ORACLE_HOME.  I also re-direct log and trace files outside of the ORACLE_HOME so the size of that stays static unless I'm installing a patch.

I agree with sdstuber's suggestion: just edit your /etc/oratab file so it points to your binaries.  That files doesn't have to point to your data files.   It only needs to know where your Oracle binaries are.
anishtvAuthor Commented:
isn't a split in order?
anishtvAuthor Commented:
This is ok found solution.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.