Re: 2 Day DBA Course: perception check

David E. Grove wrote:
> I'm working through the 2 Day DBA Course for 10g.
>
> I notice that on p. 4-3 ("Configuring the Network Environment") the "Easy
> Connect Naming" is discussed. It states the the connect string is formed as
> follows:
>
> CONNECT username/password_at_host [:port] [/service_name]
>
> Then it supplies a specific example:
>
> CONNECT scott/tiger_at_my-server:1521/mydb
>
>
>
> My question: Since the service name already includes the port information,
> isn't the explicit inclusion of the port number in the example redundant?
> Wouldn't the following also be acceptable as a connect string:
>
> CONNECT scott/tiger_at_my-server/mydb
>
>

my-server is *not* the service name, it's the server's name. The one you get tying `hostname` on a command line.

Your service name could be defined in the tnsnames.ora file. If so, the connect string would be even shorter:

CONNECT scott/tiger_at_my-servicename

-- 
Regards,
Frank van Bortel