SID's, service_names. listener and jdbc again

From: Björn Nilsson <b.w.nilsson_at_telia.com>
Date: Thu, 26 Apr 2001 21:22:35 GMT
Message-ID: <3ae88e3e.1173186@news1.telia.com>

Sorry about that (Blushing all over.)
Here are the specifics:
The listener.ora file on the server looks like this:

---

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.50)(PORT =
1521))
      )

    )
    (DESCRIPTION =
(PROTOCOL_STACK =

        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )


      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.50)(PORT = 2481))

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u02)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = oralin)
(ORACLE_HOME = /u02)
(SID_NAME = oralin)

    )
  )

---

and my client tnsnames.ora file looks like this:

---

ORALIN.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.50)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = oralin)

    )
  )   

(plus some stuff about http...)

---

Now, when, from the client using jdbc, I can connect using the following connection string:
"jdbc:oracle:oci8:@oralin.world", "scott", "tiger"

but when trying
"jdbc:oracle:thin:@192.168.10.50:1521:oralin", "scott", "tiger"

I get an "I/O exception, The network adapter couldn't establish the connection."
(I get a similar error, ORA-12545, if I try defining and testing a SID entry called oralin.world in Net8.)

Now, I guess that I have to set sometning up on the serverside. Do I just have to fill something into the existing lisetener.ora file, or do I have to configue a new listener service? Or is it the fact that the service_name shouldn't have the same name as the SID?

I hope that I make a bit more sense now.

Regards

Björn

On Thu, 26 Apr 2001 17:06:03 +0200, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>Always try to be as specific as possible so please define 'fails' Any
>specific error, or should I look into a crystal ball as to what is happening
>at your side?
>
>Regards,
>
>Sybrand Bakker, Oracle DBA
>
>"B N" <bjorn.nilsson_at_pac.ericsson.se> wrote in message
>news:3ae7f909.3282656901_at_news.ericsson.se...
>> Hi!
>>
>> I'm a bit puzzled about setting up a SID to use with my 8.1.7
>> installation on a SuSE linux box on my local home network. I want to
>> be able to use the thin Oracle jdbc client, which seems to want a SID
>> to address.
>> Now, heres what I've managed to setup so far:
>> I do have a listener setup to listen for calls to a service_name,
>> where the server address is 192.168.... and it's called ORALIN
>>
>> On a client I have a tnsnames.ora where an entry called ORALIN.WORLD
>> connects to the ORALIN service_name on server 192.168...
>>
>> The $ORACLE_SID env. variable on the serveri is "oralin".
>>
>> But if I try to create a sid entry on the client to the SID "ORALIN"
>> the connection fails. The same goes for trying the thin jdbc driver.
>> (The thicker one, where I need the client libraries, talks through
>> tnsnames.ora and finds the server correctly.)
>>
>> I guess that I have to set up the listener service on the server
>> correctly. But how do I do this? By adding a SID entry to the same
>> listener? Or should I have a different listener, addressing a
>> different port? What should the entry look like?
>>
>> Regards
>>
>> Björn
>
>

Received on Thu Apr 26 2001 - 16:22:35 CDT