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
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

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of jcob_l
jcob_l

ASKER

fine
Oracle Database
Oracle Database

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

81K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo