| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01034 error
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
> >
-- 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 - 04:49:01 CDT
 |
 |