URGENT: SQL*Net and Personal Oracle...

From: Willem Gestel <willem.gestel_at_tip.nl>
Date: 1997/12/10
Message-ID: <01bd05a3$ad278b60$5a4e12c3@csollt50>#1/1

This is a multi-part message in MIME format.

------=_NextPart_000_01BD05AC.0EEBF360
Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit

Hello,

I have Personal Oracle 7.2 installed and want to make a connection to the ORCL database with a connect_string. Without it works fine. But when I enter a connect_string, I get:

TNS-12541: TNS:no listener

This seems right, becouse I don't believe I have a listener running. How do I start the listener?

Do I need a TCP/IP anyway when I want to connect to a local database, but want to use a connect_string. I don't get it.

Please help,

Willem Gestel

// TNSNAMES.ORA willem.world =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = 


          (COMMUNITY = tcp.world)

          (PROTOCOL = TCP)

          (Host = 127.0.0.1)

          (Port = 1521)

        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
Beq-Local.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 


          (COMMUNITY = beq.world)

          (PROTOCOL = BEQ)

          (PROGRAM = oracle73)

          (ARGV0 = oracle73ORCL)

          (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')

        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )

------=_NextPart_000_01BD05AC.0EEBF360
Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable

<html><head></head><BODY bgcolor=3D"#FFFFFF">Hello, I have Personal Oracle = 7.2 installed and want to make a connection to the ORCL database with a = connect_string. Without it works fine. But when I enter a = connect_string, I get: TNS-12541: TNS:no listener This = seems right, becouse I don't believe I have a listener running. How do I = start the listener? Do I need a TCP/IP anyway when I want to = connect to a  local database, but want to use a connect_string. I = don't get it. Please help, Willem Gestel // = TNSNAMES.ORA willem.world =3D  (DESCRIPTION =3D =

&nbsp;&nbsp;&nbsp;(ADDRESS_LIST =3D <br> =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(ADDRESS =3D <br> =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(COMMUNITY =3D =

tcp.world) =
         (PROTOCOL =3D = TCP)          (Host =3D = 127.0.0.1) =
         (Port =3D = 1521)        ) =    )    (CONNECT_DATA =3D (SID =3D = ORCL)    )  ) Beq-Local.world =3D =

&nbsp;(DESCRIPTION =3D <br> &nbsp;&nbsp;&nbsp;(ADDRESS_LIST =3D <br> =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(ADDRESS =3D <br> =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(COMMUNITY =3D =

beq.world) =
         (PROTOCOL =3D = BEQ)          (PROGRAM = =3D oracle73) =
         (ARGV0 =3D = oracle73ORCL) =
         (ARGS =3D = '(DESCRIPTION=3D(LOCAL=3DYES)(ADDRESS=3D(PROTOCOL=3Dbeq)))') =

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)<br> &nbsp;&nbsp;&nbsp;)<br> =
&nbsp;&nbsp;&nbsp;(CONNECT_DATA =3D (SID =3D ORCL)<br> =
&nbsp;&nbsp;&nbsp;)<br> &nbsp;)<br><br></p>

</body></html>
------=_NextPart_000_01BD05AC.0EEBF360-- Received on Wed Dec 10 1997 - 00:00:00 CST