Re: Problem accessing ORACLE from my account.

From: Yves Noel <noel_at_omega.univ-lille1.fr>
Date: 21 Apr 1994 15:19:01 GMT
Message-ID: <2p65h5$l4e_at_netserver.univ-lille1.fr>

In article <21APR94.15474797_at_tigris.cti.gr>, tzagara_at_tigris.cti.gr writes:
|>Hi there,
|>
|>I have the following problem:
|>
|>when I try to connect to ORACLE, after inserting my password the following
|>message appears :
|>
|>%sqlplus
|>
|>Username : tzag
|>password
|>
|>ERROR: ORA-01034: ORACLE not available
|>ORA-07318: smsget: open error when opening sgadef.dbf file.
|>SunOS error: 13: Permission denied
|>
|>But, when I try to connect ORACLE from the ORACLE account, there is no
|>problem. I can then access my ORACLE account. We are using
|>ORACLE7 Server and tools V 7.0.12
|>
|>Can anybody tell me what I am doing wrong ?
|>
|>Thanks in advance .
|>
|>Emmanuel Tzabgarakis e-mail :
|>Computer Technology Institute (CTI) tzag_at_cti.gr
|>Patras, tzagara_at_grpatvx1.bitnet
|>Greece
|>
Hi Emmanuel !
It's typically an access problem, probably on oracle executable. On my machine (DEC RISC ULTRIX v4.3) this executable is under /usr/oracle/bin and named oracle and it's access are :
-rwsr-x--x 1 oracle 4156908 Apr 1 1993 oracle

Yves NOEL ______________________________________________ C.I.T.I. (batiment M4)
Database Administrator ________________ Universite des Sciences et Technologies

Email: Yves.Noel_at_univ-lille1.fr ________ 59655 Villeneuve d'Ascq Cedex - FRANCE

Voice: (33) 20.43.42.70 _________________________________ Fax: (33) 20.43.66.25

Received on Thu Apr 21 1994 - 17:19:01 CEST