RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Managing Users
«Prev
Next»
User Connectivity
Configuring Oracle
SID List Listener
Configuring Listener
Oracle Net Basic Concepts
Password Files
Necessary Password Files
Password Creation Process
Placing | Naming PW File
Creating Password File
Remote Login Password
Connecting Internal Password
DBA Privileges
Different DBA Roles
Connect Database
PW Files Data Dictionary
Rebuilding Password File
Manage PW Conclusion
Enterprise Manager
SQL Plus Worksheet
OEM Architecture
SQL* Plus CLI
Accept Prompt Commands
Spooling Printing Report
SQL Plus Line Editing Commands
Creating Users
Steps To Change Security Manager
Default Tablespaces
Drop User
What Objects does User Own
Managing User Roles
Types System Privileges
Granting System Privileges
With Admin Option Clause
session_privs View
Revoke Privileges Oracle
Managing System Privileges
Connect Oracle Net Service - Exercise
Connecting from a client to a Oracle Net Service
Objective:
Connect to the Oracle Net service named COIN.
Exercise scoring
You will receive 10 points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the
Submit
button to receive full credit.
Background/overview
So far in this module you have edited your listener.ora file on the server, and added an entry for the
COIN
database. You have edited your tnsnames.ora file on the client, and also added an entry for the COIN database. Now it is time to try connecting the two.
Instructions
Using SQL*Plus or Server Manager, try connecting to the
COIN
service that you created in this module.
Hints
Remember to connect via the Oracle Net service named
COIN
by appending "
@COIN
" to the
CONNECT
command.
Submitting your exercise
When you are finished, click the
Submit
button to receive full credit for this exercise.