Remote database connections

Establishing a connection remotely means running the SQL command-line utility on a different host other than the Oracle Database 11g XE machine and initiating a database connection command using the valid database credentials over the network using a connect string.

The following screenshot is taken from Oracle Database 11g XE on Windows, and demonstrates establishing a remote database connection to the database:

As discussed earlier, a connect string defines which database server to connect to, on what port, and using what protocol. In the preceding example, xe is the name of the connect string.

Alternatively, we can connect to the database by providing the database host name and port as shown in the following screenshot:

The database hostname name and port information is basically encapsulated in the connect string.

Using the local sqlplus utility we can connect to the database via listener; thus, simulating remote client connections. To achieve this, we need to...