Connecting to a database

From: Ralf Boroschewski <rboro_at_gap-berlin.de>
Date: Thu, 04 Nov 1999 12:22:32 +0100
Message-ID: <38216C77.D13D8538@gap-berlin.de>

Hallo,
I created a database a try now to establish a Net8 connection. I place in the tnsnames.ora the following entry:

BBDADB.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA = (SID = bbda))

  )

I added the following lines into listener.ora:

PASSWORDS_BBDALISTENER= (xyz)

BBDALISTENER =
  (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = BBDADB.WORLD))
(ADDRESS = (PROTOCOL = IPC)(KEY = BBDA))
(ADDRESS = (PROTOCOL = NMP)(SERVER = SERVICE-PC)(PIPE = ORAPIPE))
(ADDRESS = (PROTOCOL = IPC)(KEY = bbdadb.world))
(ADDRESS = (PROTOCOL = TCP)(HOST = service-pc)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = service-pc)(PORT = 1526))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
  )

SID_LIST_BBDALISTENER =
  (SID_LIST =
(SID_DESC =

      (SID_NAME = extproc)
      (PROGRAM = extproc)

    )
(SID_DESC =

      (GLOBAL_DBNAME = bbdadb)
      (SID_NAME = BBDA)

    )
  )

this is very close to the entry of the standart database, only a view words are replaced.
after entering from the shell these lines: lsnrctl80
set password xyz
services bbdalistener

I got these error lines (I translated the german expression into english, may be that the origin english text differs)

Connection with (ADDRESS=(PROTOCOL=IPC)(KEY=BBDADB.WORLD)) is beeing connected
TNS-12224: TNS: no listener
 TNS-12541: TNS: no listener
  TNS-12560: TNS: protokoll adapter error    TNS-00511: no listener
    32-bit Windows Error: 2: No such file or directory

What is my mistake?

   Thankss for your help

           Ralf Received on Thu Nov 04 1999 - 05:22:32 CST