Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ORA-01034: ORACLE not available

ORA-01034: ORACLE not available

From: Thomas Fischer <himself_at_tfischer.de>
Date: Sat, 04 Mar 2000 18:28:03 GMT
Message-ID: <38c1547b.4260906@news.uni-kassel.de>


Hi,

I have installed Oracle805 on Linux as user 'oracle'. when I do
>dbstart

and then
>lsnrctl start

I get the following:

-----8<-------------------------------------------------------------------------------

LSNRCTL for Linux: Version 8.0.5.0.0 - Production on 04-MAR-00 13:53:35  

(c) Copyright 1997 Oracle Corporation. All rights reserved.  

Starting /home/oracle/product/8.0.5/bin/tnslsnr: please wait...  

TNSLSNR for Linux: Version 8.0.5.0.0 - Production System parameter file is
/home/oracle/product/8.0.5/network/admin/listener.ora Log messages written to
/home/oracle/product/8.0.5/network/log/listener.log

Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=6)(KEY=ARCH))
Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=10)(KEY=PNPKEY))
Listening on:

(ADDRESS=(PROTOCOL=tcp)(DEV=11)(HOST=127.0.0.1)(PORT=1521))  

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ARCH)) TNS-12546: TNS:permission denied
 TNS-12560: TNS:protocol adapter error
  TNS-00516: Permission denied
   Linux Error: 13: Permission denied
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PNPKEY)) TNS-12546: TNS:permission denied
 TNS-12560: TNS:protocol adapter error
  TNS-00516: Permission denied
   Linux Error: 13: Permission denied
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=libretto)(Port=1521)) STATUS of the LISTENER


Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 8.0.5.0.0 -
Production
Start Date                04-MAR-00 13:53:38
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  OFF
SNMP                      OFF

Listener Parameter File
/home/oracle/product/8.0.5/network/admin/listener.ora Listener Log File
/home/oracle/product/8.0.5/network/log/listener.log Services Summary...
  ARCH          has 1 service handler(s)
  extproc               has 1 service handler(s)
The command completed successfully
-----8<-------------------------------------------------------------------------------

shouldn't oracle be up now?
when I now try to talk to it via sqlplus it tells me oracle is down:

oracle_at_libretto:/home/oracle > sqlplus internal  

SQL*Plus: Release 8.0.5.0.0 - Production on Sat Mar 4 13:53:56 2000  

(c) Copyright 1998 Oracle Corporation. All rights reserved.  

Connected.
SQL> CREATE foo;
CREATE foo
*
ERROR at line 1:
ORA-01034: ORACLE not available

WHY????? What can I do/check/repair?

Thanks,
Tom

...........................>>>>>>>
candy m. herr = $candy_at_tfischer.de

.........and remove the $.........
.................................>

visit the pink inferno candypolis>
>www.tfischer.de/candy.........>>>
Received on Sat Mar 04 2000 - 12:28:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US