In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this statement:
CONNECT HR/HRMGR@orcl - No name server is used. Which statement is true about ORCL?
A.
It must be the value of the SERVICE_NAMES parameter on the client side
B.
It must resolve to a valid connect descriptor in the server's tnsnames.ora file
C.
It must resolve to a valid connect descriptor in the client's tnsnames.ora file
D.
It must be the name of the database to whose instance HR wishes to connect
E.
It must be the name of the server running the database to whose instance HR wishes to connect
A is wrong. SERVICE_NAMES is an instance parameter on server side.
B is wrong. The connect descriptor must be accessible to the client and therefore cannot be on the server side.
C is correct. Service name resolution must happen at client side so we need a local TNSNAMES.ORA file with the appropriate connect descriptor.
D is wrong. You never connect to a database, but rather to a database instance via a service.
E is wrong. The server name has nothing to do with the service.
"port (optional) is the TCP port number on which the Oracle Net listener is listening. If not specified, the default port number 1521 is assumed."
So you cannot use that syntax in this case, since it would try to connect on port 1521 while the listener, as per question, is configured to listen on port 1531.
C is correct because "Name server" is referred to the record in a DNS but it doesn't change the fact that the tns must point to the correct server, either using an IP or direct resolution of the address via hosts file.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Rivaldo11
Highly Voted 2 years, 5 months agoEkos
2 years agoadoptc94
2 years, 3 months agoraferen10
Most Recent 3 days, 15 hours agoOCP19c
2 months, 3 weeks agoFranky_T
7 months, 3 weeks agoryuah
11 months, 1 week agoNowOrNever
2 years, 2 months agoSimoneF
1 year, 11 months agoNowOrNever
2 years, 2 months ago