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
Oracle DBA Roles
Connect Database
PW Files Data Dictionary
Rebuilding Password File
Manage PW Conclusion
Enterprise Manager
OEM Architecture
OEM Architecture
Install OEM
DBA Management Pack
Using Instance Manager
View Information
Using Security Manager
Examine Objects Schema Manager
Using SQL Plus
SQL* Plus CLI
SQL Plus Reports
SQL Plus Column
SQL Plus Formatting
Formatting Numeric Columns
Oracle Date Columns
SQL Plus Scripting
SQL Plus Command
Suppress Repeating Columns
Line Page Break Reports
Report Headers Footers
Spooling Printing Report
Substitution Variables
Accept Prompt Commands
SQL Plus Editing Commands
SQL Plus Settings
SQL Plus Script
SQL Plus Conclusion
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 Listener - Exercise
Configuring and Editing the listener.ora file
Objective:
Add the
COIN
instance to the list of SIDs in your listener.ora file.
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
Instructions
Find the listener.ora file on your system and add an entry to the
SID_LIST
for the
COIN
instance.
Hints
Adding a SID to the
SID_LIST
is best done by copying and pasting an existing entry, and then modifying the new entry to point to your new database. You already should have an entry for the starter database in the
SID_LIST
. You can copy from that.
Submitting your Exercise
When you are done, click on the
Submit
btton to receive full credit for this exercise.
x