Chapter 3. Connecting and Configuring Oracle Database 11g XE

Motivation is what gets you started. Habit is what keeps you going. - Unknown

This chapter focuses on establishing a connection to Oracle Database 11g XE from client machines. There are different ways in which you can establish a connection to the database; for example, local and remote connections. We will explore these in detail. Also, we will learn to configure the database listener. Oracle memory management is another topic that will be covered in this chapter. The following topics will be covered in this chapter:

• Local database connections

• Oracle Net Listener

  • Configuring Oracle Net Listener

  • Viewing the status of Oracle Net Listener

  • Starting and stopping the listener

  • Configuring the tnsnames.ora file

• Remote database connections

• Changing the SGA and PGA sizes

Local database connections

Establishing a connection locally means running the SQL command-line utility on the same computer where Oracle Database 11g XE is installed, and initiating...