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

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01034 error

Re: ORA-01034 error

From: Miguel Demaerel <Miguel.Demaerel_at_SGMS.SEMA.BE>
Date: Wed, 18 Oct 2000 13:32:59 +0200
Message-ID: <39ED8A6A.A209A232@SGMS.SEMA.BE>

Hoi

I have found the problem.
Its located in the listener.ora file.

I have put oem and NOT OEM.

Now I connect the database.

Thanks for the responses.

Greetings Miguel

Miguel Demaerel wrote:

> 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 - 06:32:59 CDT

Original text of this message

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