Re: Net8 questions

From: Fuzzy <granta_at_nospam.student.canberra.edu.au>
Date: Wed, 21 Mar 2001 22:29:49 GMT
Message-ID: <3ab92967.779100@newshost.interact.net.au>

On Tue, 20 Mar 2001 20:05:03 -0600, "Jay" <jjstrauss_at_yahoo.com> wrote:

>Hi,
>
>I'm not having any networking problems, just curious
>
>Listener.ora - questions
>
>- Is there any advantage using the host name in the:
> (ADDRESS = (PROTOCOL = TCP)(HOST = roscoe)(PORT = 1521))
> as opposed to using HOST=localhost, or HOST=127.0.0.1, will one give me
>better performance?

Slightly better as DNS resolution won't be required.

>- If I use "Dedicate this end point to IIOP connections (for back...)". I
>get the:
> (PROTOCOL_STACK =
> (PRESENTATION = GIOP)
> (SESSION = RAW)
> )
> lines in my listener.ora, from what I read this has something to do with
>Java. If I don't have
> and java apps connecting to my database do I need this?

Don't know about this one.

>tnsnames.ora
>
>- Is there any way to setup a service name so that if I do a connection
>(while on the server) like:
>sqlplus system/manager_at_local, that I get a local connection (like I'd get if
>I set my ORACLE_SID
>and left off the '@local'). If so, could you post an example.

Something like

LOCAL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = <your port here>))

    )
    (CONNECT_DATA =
      (SERVICE_NAME = <your sid here>)
    )
  )

(This example uses TCP/IP ... you could do the same with named pipes, and other protocols).

Note: I didn't test this ... give it a try and see what happens.

Ciao
Fuzzy
:-) Received on Wed Mar 21 2001 - 16:29:49 CST