databasecreationwronghome

anishtv
anishtv used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Top Expert 2012
Commented:
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
Mark GeerlingsDatabase Administrator

Commented:
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.

Author

Commented:
good
Most Valuable Expert 2011
Top Expert 2012

Commented:
isn't a split in order?

Author

Commented:
This is ok found solution.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial