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]$
Oracle Database

Avatar of undefined
Last Comment
jcob_l

8/22/2022 - Mon
johnsone

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
Praveen Kumar Chandrashekatr

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
jcob_l

fine
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23