Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Connecting to a database
May be you've forgot the command "start BBDALISTENER" in your
listener session?
--
Have a nice day
Michel
Ralf Boroschewski <rboro_at_gap-berlin.de> a écrit dans le message :
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 - 06:40:23 CST