Re: Oracle Question!

The installation procedure normally includes the creation of an instance and a database.
The instance needs to be started, the database created, a dictionary created, all this is done through the installation procedure. You could have chosen NOT to create the starter database, but other than that it looks like your install was unsuccessfull. On other Unix ports you verify the state of Oracle by ps -ef | grep ora or ps -fu | oracle.
Typically you would see processes like ora*dbwr, ora*lgwr etc. The list of available instances is kept in either /etc/oratab or /var/opt/oracle/oratab. Using the korn shell you should give the following commands to have correct env vars set export ORACLE_SID=<your sid,usually ORCL> export ORAENV_ASK=NO
. (dot) oraenv
Oracle not found seems to be a non-exact error message, Oracle not available would give better clues.
Please try to be as exact as possible and avoid forwarding all your posts to both .server and .misc. This post is a clear .server one.

Hth,

--
Sybrand Bakker, Oracle DBA
Rishi Karan <karan_at_cs.tu-berlin.de> wrote in message news:385273B1.37960727_at_cs.tu-berlin.de...
> Hello,
>
> I´m having a small problem with oracle. Though I´m nre to oracle i´ve
> managed to successfully install it onto my linux system. I wanted to get
> to know the basics now, how does one make a DB, create tables, I mean
> regarding oracle. I´m pretty thorough in SQL. What does one start first?
> I tried starting "sqlplus", but I guess I need to have a DB first...and
> then anything I do I keep getting the error: ORACLE not found. Could
> anyone please help me?
>
> Thanks in advance
> Rishi Karan
>
Received on Sat Dec 11 1999 - 10:08:19 CST