Re: Oracle & linux

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_at_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_at_spv22.ing.uniroma1.it>,
  Marco Ronchini <22002795_at_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. Received on Fri Mar 03 2000 - 00:00:00 CST