2 Day DBA Course: perception check

Giganews Newsgroups
Subject: 2 Day DBA Course: perception check
Posted by:  David E. Grove (david_gro…@correct.state.ak.us)
Date: Thu, 27 Jan 2005

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@host [:port] [/service_name]

Then it supplies a specific example:

CONNECT scott/tiger@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@my-server/mydb

Thank you.

--
David Grove

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
"I think not," said Descartes, and disappeared.

Replies