Re: java.sql.SQLException: ORA-01034: ORACLE not available

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sat, 19 Jul 2003 22:06:30 +0200
Message-ID: <8a8jhv8rhvi7tpe5tv7ajbecmld042duvb@4ax.com>

On Sat, 19 Jul 2003 17:59:37 +0200, Timo Nentwig <tcn_at_spamgourmet.com> wrote:

>Sybrand Bakker wrote:
>
>> Oracle is definitely not running. Please look into the alert log as to
>
>Yes. I noticed that I have to set autostart in /etc/oratab (?!). Afte doing
>so dbstart complains about missing the DBs init.ora file. Well, why is this
>file not created by the GUI assistant? So, I temporarily took the default
>init.ora...
>
>Ok, next thing to find out is how to create db users... ;)
>
>Thanks!
>Timo

IIRC, depending on version, you'll still need to copy the default init.ora to init${ORACLE_SID}.ora manually. If I remember correctly this has been adressed in 9i

It is easy to find out how to create database users. Just look up create user in the sql reference manual.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Jul 19 2003 - 15:06:30 CDT