Re: 2 Day DBA Course: perception check

From: David E. Grove <david_grove_at_correct.state.ak.us>
Date: Thu, 27 Jan 2005 13:40:26 -0900
Message-ID: <10virek7i2kuu00@corp.supernews.com>

Thank you.

> my-server is *not* the service name, it's the server's name.

That was my understanding. I was thinking that "mydb" was the service name.

> Your service name could be defined in the tnsnames.ora file.

That's what I was thinking. And since service name implies the port (per the definition in tnsnames.ora), I didn't see why it was necessary to specify both the port and the service name (as the example did).

>If so, the connect string would be even shorter:
>
> CONNECT scott/tiger_at_my-servicename

I thought of that, too. But, the text seems to indicate that the required syntax is "CONNECT username/password_at_host" (not allowing "CONNECT service_name"), while both ":port" and "/service_name" are optional. The example then illustrates by supplying both of the optional expressions (i.e., the example supplies both the port and the service name). Received on Thu Jan 27 2005 - 16:40:26 CST