Re: URGENT: SQL*Net and Personal Oracle...

From: GL <rasmussen_at_gl.org>
Date: 1997/12/16
Message-ID: <01bd0a3a$20865f60$5c858483@john>#1/1

The connect string to the database is 2:

Willem Gestel <willem.gestel_at_tip.nl> skrev i artiklen <01bd05a3$ad278b60$5a4e12c3_at_csollt50>... 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)
    )
  )

---

Received on Tue Dec 16 1997 - 00:00:00 CST