Re: Connecting to a database

After starting the lsnrctl utility type STATUS to see whether your listener is started. If not, you can start it. If the listener is started then begin by pinging the server, tnspinging the server, and trying to connect with SQL*Plus to see where the problem lies. The Oracle NET80 documenttation has a good section on troubleshooting.

Van

Ralf Boroschewski <rboro_at_gap-berlin.de> wrote in message news:38216C77.D13D8538_at_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 - 16:55:18 CST