Connecting Remotely with SQL Command Line

Previous

Next

---

Connecting remotely means running SQL Command Line (SQL*Plus) on one computer (the remote computer), and then initiating a connection to Oracle Database XE on a different computer.

To initiate a remote connection from SQL Command Line using the Oracle Database XE Client:

1. On the remote computer, start a terminal session (Linux) or open a command window (Windows.)

   If prompted for host credentials, log in to the remote computer.

2. (Linux only) If the required environment variables are not already set for your session, set them as described in "Setting Environment Variables on the Linux Platform".

3. Enter the following command at the operating system prompt:

   SQLPLUS /NOLOG
   
   

4. Enter this command at the SQL Command Line prompt:

   CONNECT username/password@[//]host[:port][/service_name]
   
   

   See "About Remote Connections" for a description and examples of the connect command parameters.