From: Terry Steyaert <steyaert@my-deja.com>
Subject: Re: Oracle & linux
Date: 2000/03/03
Message-ID: <89oclo$bsr$1@nnrp1.deja.com>#1/1
References: <Pine.A41.3.95.1000303124504.16638B-100000@spv22.ing.uniroma1.it>
X-Http-Proxy: 1.1 x34.deja.com:80 (Squid/1.1.22) for client 209.255.87.19
Organization: Deja.com - Before you buy.
X-Article-Creation-Date: Fri Mar 03 12:54:18 2000 GMT
X-MyDeja-Info: XMYDJUIDsteyaert
Newsgroups: comp.databases.oracle.misc
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)


The first question needs to be, Is the database up or down?  (ps jwax |
grep $ORACLE_SID will show if the database is up.  If so, there should
be 6 processes running.)  Generally, what we do is edit the /etc/oratab
file.  You will find a single line that mentions the ORACLE_HOME,
ORACLE_SID and ends with a :N or :Y.  We change the default N to a Y to
specify that when you type dbstart, the database will actually start
fully.

Otherwise, you need to go into svrmgrl:

connect internal;
startup
alter database SID mount;
exit

to get your database up.  (Maybe others have better ways of doing it,
but that's how we have done it.)

Terry Steyaert
steyaert@my-deja.com

P.S.  If the database is up, I would check on the account that you are
having problems with that you have a valid ORACLE_HOME and ORACLE_SID
defined, along with LD_LIBRARY_PATH.

In article <Pine.A41.3.95.1000303124504.16638B-
100000@spv22.ing.uniroma1.it>,
  Marco Ronchini <22002795@spv22.ing.uniroma1.it> wrote:
> I have a problem with oracle and linux. When starts the Sql plus,
 after
> the login Sql+ shows me the following error:
> 'The database is initializing or shutdown'.
> Can you help me???
>
> I use a Debian 2.1.
>
> _______________________________________
>
> Marco Ronchini
> Student of computer science engeenering
> University of Rome - La Sapienza
>
> http://web.interpuntonet.it/lonestar
> ---------------------------------------
>
>


Sent via Deja.com http://www.deja.com/
Before you buy.