ORA-01034 error

From: Miguel Demaerel <Miguel.Demaerel_at_SGMS.SEMA.BE>
Date: Tue, 17 Oct 2000 12:34:41 +0200
Message-ID: <39EC2B3F.74EDFA00@SGMS.SEMA.BE>

Hoi

Can someone help me with this one?
Running Oracle 8.05 on Solaris 2.6.
When I connect to the database with sqlplus from an other machine, I get the following error ORA-01034 Oracle not available (I'm using system as user).
I get a reply with tnsping.
I can connect with svrmgrl and sqlplus localy (I'm using system as user)

Listener parameter file:
#
# Installation Generated Net8 Configuration
# Version Date: Jun-17-97
# Filename: Listener.ora
#

LISTENER =

  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= IPC)(KEY= oem))
        (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
        (ADDRESS= (PROTOCOL= TCP)(Host= SOBUNIX)(Port= 1521))

  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME= oem.sgms.sema.be)
      (ORACLE_HOME= /opt/oracle/app/oracle/product/8.0.5)
      (SID_NAME = oem)

    )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF Info instance:
INSTANCE_NAME VERSION STATUS HOST_NAME

---------------- ----------------- -------
----------------------------------------------------
OEM              8.0.5.0.0         OPEN    SOBUNIX

Process overview:
$ ps -ef | grep oracle

  oracle  1249  1247  0 08:48:57 pts/5    0:00 -ksh
  oracle  1285     1  0 08:49:53 ?        0:00 ora_pmon_OEM
  oracle  1287     1  0 08:49:53 ?        0:00 ora_dbw0_OEM
  oracle  1289     1  0 08:49:53 ?        0:00 ora_lgwr_OEM
  oracle  1291     1  0 08:49:53 ?        0:00 ora_ckpt_OEM
  oracle  1293     1  0 08:49:53 ?        0:00 ora_smon_OEM
  oracle  1295     1  0 08:49:53 ?        0:00 ora_reco_OEM
  oracle  1301  1299  0 08:50:17 pts/6    0:00 -ksh
  oracle  1848  1249  0 10:00:18 pts/5    0:00 svrmgrl
  oracle  1788     1  0 09:47:46 ?        0:00

/opt/oracle/app/oracle/product/8.0.5/bin/tnslsnt $

What do I wrong?

Thanks in advance.

Greetings Miguel Received on Tue Oct 17 2000 - 05:34:41 CDT