Link to home
Create AccountLog in
Avatar of anishtv
anishtv

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
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.
Avatar of anishtv
anishtv

ASKER

good
isn't a split in order?
Avatar of anishtv

ASKER

This is ok found solution.