In this video we will review the Oracle network configuration files and understand how Oracle clients use the TNSNAMES.ORA file to connect with remote Oracle databases
- [Narrator] So now that we understand the roles…and responsibilities of the Oracle Listener process,…which is basically to act as a gateway between…clients and the Oracle database.…Let's talk a bit about how clients actually…establish a connection to an Oracle database…going through an Oracle Listener.…In order to connect, Oracle clients…need to use a connection string.…That connection string will point to the correct…Oracle Listener and the correct Oracle instance.…
An Oracle connection string is a type of address…used by all Oracle clients to establish…a connection to an Oracle database.…In order to establish a connection with an Oracle database,…our Oracle client will need to know the following.…One, the host name of the machine…where the Oracle Listener is running.…Remember, the listener and instance are usually running…and located on the same physical machine.…Two, the network port the listener…is using for, well, listening.…
The default network port most database administrators…choose for the listener is 1521.…
After completing this course, you'll have fundamentals required for installation, configuration, and administration of an Oracle 12c database.
- Database instance and storage
- Instance memory pools
- Instance background processes
- Client connections
- Database storage file types
- Control files and backup files
- Multitenant databases
- Starting and stopping the database
- Installing Oracle 12c software
- Using the developer tools
- Database management
Skill Level Beginner
Database Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Database Foundations: Administrationwith Adam Wilbert1h 14m Beginner
Learning Relational Databases (2014)with Adam Wilbert2h 39m Beginner
2. Instance Memory Pools
3. Instance Background Processes
4. Client Connections
5. Physical Database Structures
6. Mulitenant Database
7. Start and Stop the Database
8. Install Oracle 12c software
9. Create a Database Instance
Use DBCA to create a database14m 55s
10. Tools for Developers and DBAs
Next steps1m 17s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.