Home What is Oracle? Oracle Training Tutorials for Beginners Difference Between Oracle 11g and 12c and 10g Import 12c Oracle Dump to 11g Ora 28001 The Password Has Expired Error Cache and Nocache in Oracle Sequence BR*Tools Documentation ORA-01455: Converting Column Overflows Integer Datatype Oracle Wait Events Interview Questions Difference Between Primary, Secondary and Clustered Indexes in DBMS Difference Between Hot and Cold Backup Oracle Partitioning Interview Questions Update Statement Works in Oracle Architecture Differences Between SAP HANA and Oracle Group Functions Ignore Null Values in Processed Column ORA-10458: Standby Database Requires Recovery Oracle Interview Questions

dbca command not found

Updated Jun 11, 2018

Hello Experts,

I met with an error after installing oracle database software I want create dbca. Please resolve this error if anyone from you guys can. I am attaching the error as in form of image so that you may also consider that while provide a solution for my error.

Thanks in Advance!

Comments

27 Aug 2015 3:59 pm Nitesh Singh

You need to run root.sh to get solution of your error.

27 Aug 2015 3:59 pm Jyoti Pandey

What I need to run root user?

27 Aug 2015 4:00 pm Sugandh

Go to $oracle_home/bin and run it from there as a root user
Type the command:
Xhost +
And than run the bash file.

27 Aug 2015 4:00 pm Jyoti Pandey

When I am going to cd $ORACLE_HOME ERROR is bash:cd:/u01/Oracle/11.2.o:no such file or dorectory.

27 Aug 2015 4:00 pm Abhijeet Mudgal

You have to set env variables then you can invoke the DBCA at bin directory.

27 Aug 2015 4:01 pm Jyoti Pandey

Xhost + also run root user same error.

27 Aug 2015 4:01 pm Sugandh

Edit the bash file and enter the name of your database. save it and run it.
After that export the SID name.

27 Aug 2015 4:01 pm Romil Tripathi

Export SID and set evironment variables correct like ORACLE_HOME details and all.

27 Aug 2015 4:02 pm Chandan Singh Parihar

Please share the result of this command
echo $PATH

27 Aug 2015 4:02 pm Jyoti Pandey

That is everything done but I am still unable to understand.

27 Aug 2015 4:03 pm Sushma

Run display command and clock check.
Or
I feel your oracle installation completed ignoring all prerequisites.
Check your installation log which is normally in oraInventory/logs.
If any of the Overallstatus is unsuccessful for those checks whose severity is Critical then you will get the root cause

27 Aug 2015 4:04 pm Rohit Mahajan

First as root type xhost +, thenn conn as oracle user and type dbca. Or you may set oracle bin path first of all.

27 Aug 2015 4:04 pm Chandan Singh Parihar

You didn't set the environment variables in bash file.

27 Aug 2015 4:05 pm rekha

First check and set oracle bin path & env(.bash_profile) is it correct or not and run xhost + cmd using logging root.

27 Aug 2015 4:05 pm Chandan Singh Parihar

Your oracle home path is not correct, In which path you installed oracle software?