Re: ORA-01034 error

From: Frank <frankbo_at_interaccess.nl>
Date: Tue, 17 Oct 2000 14:49:54 +0200
Message-ID: <8shhu6$6cq$1@porthos.nl.uu.net>

configuration on the client side (aka the 'other' machine) is incorrect; in that tnsnames.ora, you should have an entry for the Sun Solaris machine: OEM=
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL= TCP)(Host= SOBUNIX))     (CONNECT_DATA = (SID = OEM))
  )

You should now be able to connect using sqlplus uid/passwd_at_oem

--
Frank
Miguel Demaerel <Miguel.Demaerel_at_SGMS.SEMA.BE> schreef in berichtnieuws
39EC2B3F.74EDFA00_at_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 - 07:49:54 CDT