RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Backup Recovery
Admin Tasks
Managing Users
«Prev
Next»
User Connectivity
Configuring Oracle
NetClient PC Database
Oracle Net Basic Concepts
Finding Listener Service
Listener Control Program
Configuring Listener
SID List Listener
Stop Restart Listener
Configuring OracleNet Client
Testing Client Connectivity
Testing OracleNet Connectivity
Check Default Domain
Connecting from Client
Oracle Net Conclusion
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
Configuring Oracle Net client - Exercise
Editing the tnsnames.ora file
Objective:
Edit your tnsnames.ora file, using Oracle Net Configuration Assistant, and add an entry for the
COIN
instance.
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
In order for you to connect to a database on another computer, you need to tell the Oracle Net software where that database is. You do this by adding an entry for the database in a file named tnsnames.ora. The Oracle Net Configuration Assistant utility facilitates this process.
Instructions
If you have Oracle installed on a computer, and are following along with the steps in this course, run the Oracle Net Configuration Assistant utility to edit your tnsnames.ora file, and add an entry pointing to the COIN database.
Submitting your exercise
When you are done, click on the
Submit
button to receive full credit for this exercise.
x
