Home » Infrastructure » Linux » DBCA command not found, Ubuntu w/ Oracle 10g (Oracle 10g on Ubuntu 9.04)
DBCA command not found, Ubuntu w/ Oracle 10g [message #449707] Wed, 31 March 2010 09:16 Go to next message
bluexiii
Messages: 3
Registered: March 2010
Junior Member
Hi all,

I recently installed Oracle 10g on my Ubuntu 9.04 comp. After finally setting up all the environment variables to run sqlplus, I cannot run the command dbca. It just gives me the error

bash: dbca: command not found

I have found some other forum topics where people have similar issues, but none of their solutions worked for me. I tried setting the path variables to what they said would work, but it does not work for me. I will show what I have for my variables:

ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

ORACLE_BASE=/u01/app/oracle (this is the path everyone said it should be, however the folder /u01 does not even exist on my machine)

For path, I tried appending a bunch of stuff to it (I know some of it probably isn't needed, but it hasn't affected my machine at all having all the extras)
PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin:/home/neal/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin/: /bin:/usr/games:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin:/prduct/oracle/10.2.0/bin:/usr/lib/oracle/xe/app/oracle/admin /cfgtoologs/dbca


So that is what I am working with. Any information anyone could provide would be greatly appreciated! I found a couble dbca folders on the system but nothing is in them. Does that mean the install did not work properly?

Thanks in advance!!
Re: DBCA command not found, Ubuntu w/ Oracle 10g [message #449711 is a reply to message #449707] Wed, 31 March 2010 09:34 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It works for me.

bcm@bcm-laptop:~/bcm_old/sql$ which dbca
/u01/app/oracle/product/10.2.0/db_1/bin/dbca
bcm@bcm-laptop:~/bcm_old/sql$ echo $PATH
/home/bcm/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/u01/app/oracle/product/10.2.0/db_1/bin
bcm@bcm-laptop:~/bcm_old/sql$ echo $ORACLE_HOME
/u01/app/oracle/product/10.2.0/db_1
bcm@bcm-laptop:~/bcm_old/sql$ uname -a
Linux bcm-laptop 2.6.31-20-generic #58-Ubuntu SMP Fri Mar 12 05:23:09 UTC 2010 i686 GNU/Linux
Re: DBCA command not found, Ubuntu w/ Oracle 10g [message #449712 is a reply to message #449707] Wed, 31 March 2010 09:39 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I just remembered, dbca does not exist for XE, since it is licensed as single DB per server.
Re: DBCA command not found, Ubuntu w/ Oracle 10g [message #449713 is a reply to message #449711] Wed, 31 March 2010 09:40 Go to previous messageGo to next message
bluexiii
Messages: 3
Registered: March 2010
Junior Member
Which version of 10g do you have? Do you have the express edition? Is it possible to get a free version of Oracle that is better than the express version? I installed express and I read DBCA is not included in that.
Re: DBCA command not found, Ubuntu w/ Oracle 10g [message #449715 is a reply to message #449707] Wed, 31 March 2010 09:44 Go to previous message
bluexiii
Messages: 3
Registered: March 2010
Junior Member
Would the first file on this page be what I am looking for then?

oracle.com/technology/software/products/database/oracle10g/htdocs/10201linuxsoft.html
Previous Topic: NFS mountpoint going dead
Next Topic: Patch Installation Trouble - Can't connect to X11..
Goto Forum:
  


Current Time: Thu Mar 28 11:24:13 CDT 2024