databasecreationwronghome

I have my binaries in /u01/app/oracle/product/12.1.0.2/dbhome_2
and
I
export ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/dbhome_2
AND
cd bin
and
did

./dbca
successfully created database but it is created in dbhome_1
database should be created in dbhome_2
why
please help

below line is from /etc/oratab
NEWDB:/u01/app/oracle/product/12.1.0.2/dbhome_1:N # line added by Agent

Oracle Database

Last Comment

anishtv

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

Sean Stuber

2/15/2016

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Mark Geerlings

2/18/2016

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.

anishtv

2/20/2016

ASKER

good

Sean Stuber

2/20/2016

isn't a split in order?

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst

William Peck

anishtv

2/20/2016

ASKER

This is ok found solution.