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