O'Reilly logo

Oracle® 11g For Dummies® by Michael Wessler, Chris Ruel, Chris Zeis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5. Connecting to and Using an Oracle Database

In This Chapter

  • Starting and stopping the database

  • Connecting to the database instance

  • Avoiding pitfalls

You can't use a database until it's running and you connect to it. In this chapter we cover how to make that happen. First, we cover the setup of your DBA environment so you can log in to the database and begin your startup work. Next, we cover the various startup modes and states that a database can be in depending on your type of work. Furthermore, shutting down a database can happen several different ways. We cover all the options so that you can start up and shut down with the proper parameters.

You can connect locally or remotely to a database with Oracle Net. We examine the role of the database listener process and how to configure, start, and stop it. Next, we show how to set up client-side connections to the database. Finally, we cover a few common problems you might encounter when setting up Oracle Net.

Starting and Stopping the Database

Before users connect to a database instance to do work, it obviously must be running. This entails starting up the database instance memory, processes, and opening the control and database files in a mode accessible and appropriate for the users. Depending on the type of work being done, there are several different states a database can be in for the users or DBA to access. Alternatively, it is sometimes necessary to shut down a database instance for a multitude of reasons. The key with ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required