Understanding the listener
So far throughout this book, we've made a number of connections to our Oracle database using both SQL Developer and SQL*Plus, but we've yet to really discuss the details of what happens during these connections. Let's examine a simple connection that we've already used.
We make a connection to the database using SQL*Plus by providing a username and password, as we mentioned in our chapter on database security. This type of connection is known as a local connection—no remote database is specified. Thus, when no connection information other than a username and password are specified, an assumption is made that the connection ...
Get OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
