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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Connection Problem

RE: Connection Problem

From: Nagadevi Kavali <Nagadevik_at_coreobjects.com>
Date: Tue, 31 Oct 2000 12:46:55 +0530
Message-Id: <10665.120635@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_000E_01C04338.A62472D0 Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

I think you have to set write permission for that user on this directory(/export/home1/oracle8/product/8.0.6/network/ log) , where it's trying to create the log file.

You can do so by adding the id (with which you are trying to connect) to the same group that oracle id belongs to.

NRK Database Architect/Administrator
Core Objects
  -----Original Message-----
  From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Giri Gajjela   Sent: Tuesday, October 31, 2000 11:00 AM   To: Multiple recipients of list ORACLE-L   Subject: Connection Problem

  Hi All,

      While connecting to Oracle Database with an id other than Oracle i am getting the
  following problem

  ld.so.1: oracleEMPLOY: fatal: libobk.so: open failed: No such file or directory
  ERROR:
  ORA-12547: TNS:lost contact

  When I start Listener using the same id i am facing the foll. problem

  bash-2.03$ lsnrctl start

  LSNRCTL for Solaris: Version 8.0.6.0.0 - Production on 30-OCT-00 21:30:55

  (c) Copyright 1999 Oracle Corporation. All rights reserved.

  Starting /export/home1/oracle8/product/8.0.6/bin/tnslsnr: please wait...

  TNSLSNR for Solaris: Version 8.0.6.0.0 - Production   NL-00280: error creating log stream
/export/home1/oracle8/product/8.0.6/network/   log/listener.log
   NL-00278: cannot open log file
    SNL-00016: snlfohd: error opening file      Solaris Error: 13: Permission denied

  While connecting using Oracle Id i am able to connect without any problem.

  What could be the problem? I think there would be some permission problems.

  TIA
  Giri

------=_NextPart_000_000E_01C04338.A62472D0 Content-Type: text/html;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D184401207-31102000>I=20
think you have to set write permission for that user on this=20 directory(/export/home1/oracle8/product/8.0.6/network/<BR>log) , where = it's=20
trying to create the log file.&nbsp; </SPAN></FONT></DIV> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20 class=3D184401207-31102000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN = class=3D184401207-31102000>You=20
can do so by adding the id (with which you are trying to connect) to the = same=20
group that oracle id belongs to.</SPAN></FONT></DIV> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20 class=3D184401207-31102000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20 class=3D184401207-31102000>NRK</SPAN></FONT></DIV> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20 class=3D184401207-31102000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20 class=3D184401207-31102000>Database =
Architect/Administrator</SPAN></FONT></DIV> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN = class=3D184401207-31102000>Core=20
Objects</SPAN></FONT></DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com=20   [mailto:root_at_fatcity.com]<B>On Behalf Of </B>Giri = Gajjela<BR><B>Sent:</B>=20
  Tuesday, October 31, 2000 11:00 AM<BR><B>To:</B> Multiple recipients = of list=20
  ORACLE-L<BR><B>Subject:</B> Connection Problem<BR><BR></DIV></FONT>
<DIV><FONT face=3DVerdana size=3D2>Hi All,</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DVerdana size=3D2>&nbsp;&nbsp;&nbsp; While connecting =
to Oracle=20
  Database with an id other than Oracle i am getting the </FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2>following problem</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DVerdana size=3D2>ld.so.1: oracleEMPLOY: fatal: =
libobk.so: open=20
  failed: No such file or directory<BR>ERROR:<BR>ORA-12547: TNS:lost=20   contact</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DVerdana size=3D2>When I start Listener using the =
same id i am=20
  facing the foll. problem</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DVerdana size=3D2>bash-2.03$ lsnrctl =
start</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DVerdana size=3D2>LSNRCTL for Solaris: Version =
8.0.6.0.0 -=20
  Production on 30-OCT-00 21:30:55</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DVerdana size=3D2>(c) Copyright 1999 Oracle =
Corporation.&nbsp;=20
  All rights reserved.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DVerdana size=3D2>Starting=20
  /export/home1/oracle8/product/8.0.6/bin/tnslsnr: please = wait...</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DVerdana size=3D2>TNSLSNR for Solaris: Version =
8.0.6.0.0 -=20
  Production<BR>NL-00280: error creating log stream=20   =
/export/home1/oracle8/product/8.0.6/network/<BR>log/listener.log<BR>&nbsp= ;NL-00278:=20
  cannot open log file<BR>&nbsp; SNL-00016: snlfohd: error opening=20   file<BR>&nbsp;&nbsp; Solaris Error: 13: Permission=20   =
denied&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;=20
</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DVerdana size=3D2>While connecting using Oracle Id i =
am able to=20
  connect without any problem.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DVerdana size=3D2>What could be the problem? I think =
there would=20
  be some permission problems.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DVerdana size=3D2>TIA</FONT></DIV>
Received on Tue Oct 31 2000 - 01:16:55 CST

Original text of this message

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