-
Book Overview & Buying
-
Table Of Contents
Oracle Database XE 11gR2 Jump Start Guide
By :
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...
Change the font size
Change margin width
Change background colour