Usually we create an entry in tnsnames.ora of our server when we want to connect remotely via sqlplus, do a tnsping, duplicate via rman, etc.
What it you want to connect w/o set up a tnsnames.ora file? You can using a connection method called EZCONNECT (EZ=Easy).
The syntax is pretty simple:
CONNECT username@[//]host[:port][/service_name][:server][/instance_name]
i.e:
CONNECT scott@sales-server:1521/sales.us.example.com CONNECT scott@//sales-server/sales.us.example.com CONNECT scott@//sales-server.us.example.com/sales.us.example.com
All of this I retrieved from the doc path below. So, if you don't know it during the exam, go to the doc in less than 5 seconds.
Path to Documentation:
Database Administration -> Net Services Administrator's Guide -> 8 Configuring Naming Methods
Click here to go back to the Main OCM 11g Preparation page.
Have you enjoyed? Please leave a comment or give a 👍!
