Link to home
Start Free TrialLog in
Avatar of jcob_l
jcob_l

asked on

database

I did not put the option create database option while installing oracle software..
only rdbms

how will create new database using dbca
I am seeing this error can you check this..

[oracle@server1 ~]$ cd /oracle/app/oracle/product/11.2.0/db/
[oracle@server1 db]$ ls
apex         deinstall         jdev     OPatch       scheduler
assistants   demo              jdk      opmn         slax
bin          diagnostics       jlib     oracore      sqldeveloper
ccr          dv                ldap     oraInst.loc  sqlj
cdata        emcli             lib      ord          sqlplus
cfgtoollogs  has               log      oui          srvm
clone        hs                md       owb          sysman
config       ide               mesg     owm          timingframework
crs          install           mgw      perl         ucp
csmig        install.platform  network  plsql        uix
css          instantclient     nls      precomp      utl
ctx          inventory         oc4j     racg         wwg
cv           j2ee              odbc     rdbms        xdk
dbs          javavm            olap     relnotes
dc_ocm       jdbc              ons      root.sh
[oracle@server1 db]$ which dbca
/usr/bin/which: no dbca in (/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/oracle/bin)
[oracle@server1 db]$ dbca
bash: dbca: command not found
[oracle@server1 db]$ cd dbs
[oracle@server1 dbs]$ ls
init.ora
[oracle@server1 dbs]$
Avatar of johnsone
johnsone
Flag of United States of America image

It would seem that the environment is not set correctly.  At a minimum, I believe you need to do this:

ORACLE_HOME=/oracle/app/oracle/product/11.2.0/db
ORACLE_SID=
PATH=${PATH}:${ORACLE_HOME}/bin
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:${ORACLE_HOME}/lib
export ORACLE_HOME
export ORACLE_SID
export PATH
export LD_LIBRARY_PATH

For ORACLE_SID, you need to set that to the name of the database you are creating.  Also, depending on your OS, LD_LIBRARY_PATH may not be the correct environment variable, you are going to have to check on that one, you can usually find it pretty easily in the man page for the ld command.  Common ones are LD_LIBRARY_PATH, LD_LIBRARY_PATH64, and LIBPATH.
ASKER CERTIFIED SOLUTION
Avatar of Praveen Kumar Chandrashekatr
Praveen Kumar Chandrashekatr
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jcob_l
jcob_l

ASKER

fine