History Oracle Networking
Evolution Network Protocols
Oracle Networked Computers
Distributed Database Features
Transparent Network Substrate
SQL Handles Connections
SQL Net Enhancements
Distributed Database Connectivity
Net Services Architecture
Network Component Tools
Components Functions tnsnames.ora
sqlnet.ora File Location
Sqlnet ora File Characteristics
Net Communications Process Level
Create Oracle DBlink
Database Link Connection
SQLnet Architecture Conclusion
sqlnet Client/Server Components
Listener Manages Oracle Connection
Configuring Oracle Listener
Oracle Net Assistant
Net Assistant Naming Methods
Route Client connection Requests
Set TNS Timeout Value
Setting Listener Password
lsnrctl Listener control Utility
Start listener using lsnrctl
Stop Listener via lsnrctl
Setting Up Protocol Listeners
Client side Configuration
Windows Client Architecture
NET Configuration Assistant
Running Oracle Installer
Overview of Oracle Toplogy - Exercise
Overview of Oracle's Topology solution, part 3
Define Oracle database links
Define links and try SQL.
This exercise is worth a total of 10 points.Respond to the situation described below.
You are the DBA for a company in Spokane that just acquired an Oracle database in Tokyo. You have learned that the remote database in Tokyo is called FUJI and the main user is NIPPON with the password JAPAN. You have created an entry in your Spokane tnsnames.ora file identifying the FUJI database with the service name FUJI, so you are now ready to define your environment.
Create a public database link called ASIA for all Spokane users that will allow them to access all the tables granted to the NIPPON user at the FUJI database.
Write a SQL statement to display all the contents of the CUSTOMER table in the FUJI database.
Create a mechanism that lets the Spokane user enter select * from customer; to see the CUSTOMER table in Japan.
Submitting the exercise
Type or paste your answers into the text box below, then click
to submit and view a results page.