Re: ORA-01034 error

From: Miguel Demaerel <Miguel.Demaerel_at_SGMS.SEMA.BE>
Date: Wed, 18 Oct 2000 12:06:09 +0200
Message-ID: <39ED7611.A00FF458@SGMS.SEMA.BE>

Hoi

This is one of my NT machine:
oem =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= 172.27.150.50)(Port= 1521))
(CONNECT_DATA = (SID = OEM))

  )

oem.world =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= 172.27.150.50)(Port= 1521))
(CONNECT_DATA = (SID = OEM))

  )

This is one of the Unix machine (where also the database is running)

#
# Installation Generated Net8 Configuration
# Version Date: Oct-27-97
# Filename: Tnsnames.ora
#

oem =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= 172.27.150.50)(Port= 1521))
(CONNECT_DATA = (SID = oem))

  )

oem.world =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= 172.27.150.50)(Port= 1521))
(CONNECT_DATA = (SID = oem))

  )

oem_BEQ =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = BEQ)(PROGRAM =
/opt/oracle/app/oracle/product/8.0.5)

               (args = '(DESCRIPTION =
(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')
               (envs =
'ORACLE_HOME=/opt/oracle/app/oracle/product/8.0.5,ORACLE_SID=oem')

    )
  )

I get the error on both machines.
Thanks

Greetings Miguel

sybrandb_at_my-deja.com wrote:

> In article <39ED3F5F.EF25453A_at_SGMS.SEMA.BE>,
>   Miguel Demaerel <Miguel.Demaerel_at_SGMS.SEMA.BE> wrote:
> > Hoi
> >
> > I have checked the permission and these are correct.
> >
> > I have tested it localy (there is a tnsnames.ora)
> > sqlplus system/manager_at_OEM
> Hoi
> To keep this discussion internationally readable, I will not refrain
> to Dutch :)
> Post your tnsnames.ora please.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
> > ORA-01034 Oracle unavailble...
> >
> > I don't know how to solve this one.
> >
> > Thanks in advance.
> >
> > Greetings Miguel
> >
> > sybrandb_at_my-deja.com wrote:
> >
> > > In article <39EC2B3F.74EDFA00_at_SGMS.SEMA.BE>,
> > >   Miguel Demaerel <Miguel.Demaerel_at_SGMS.SEMA.BE> wrote:
> > > > 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
> > > >
> > > >
> > > Usually this is caused by incorrect protection of datafiles and/or
> > > executables. Also note the setuid bit should be on for the oracle
> > > executable.
> > > Refer to the getting started manual for the exact protection masks,

 they

> > > are outlined in chapter 4.
> > >
> > > --
> > > Sybrand Bakker, Oracle DBA
> > >
> > > All standard disclaimers apply
> > >
 ------------------------------------------------------------------------
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
> >
>
> --
> Sybrand Bakker, Oracle DBA
>
> All standard disclaimers apply
> ------------------------------------------------------------------------
>

> Sent via Deja.com http://www.deja.com/ > Before you buy. Received on Wed Oct 18 2000 - 05:06:09 CDT