Contents
How do I access a local Oracle database from another computer?
4.4 Connecting to an Oracle Database from a Client Computer
- (UNIX, Linux, or Windows systems) Open a command window and enter the following command: sqlplus.
- (Windows systems only) Click Start, select Programs (or All Programs), then Oracle – HOME_NAME, then Application Development, and then SQL*Plus.
How do I connect to Sqlplus using putty?
Do the following steps to start SQL*Plus and connect to the default database:
- Open a UNIX terminal.
- At the command-line prompt, enter the SQL*Plus command in the form: $> sqlplus.
- When prompted, enter your Oracle9i username and password.
- SQL*Plus starts and connects to the default database.
Can you connect to the Oracle database from a remote computer?
Logging in to the Oracle Database XE host computer with an ssh (or telnet) session and then starting the SQL Command Line (or other Oracle command-line utility) is considered a local connection, even though you start the ssh (or telnet) application on a remote computer.
Can a SQL command line connect to an Oracle Database?
About Local and Remote Connections. Oracle Database XE supports connections between the SQL Command Line (SQL*Plus) and the database either locally, or remotely over a TCP/IP network. The method that you use to connect to Oracle Database XE with the SQL Command Line depends on whether you are initiating a local connection or a remote connection.
What does it mean to connect to a database from a remote computer?
Connectin g remotely means running the SQL Command Line (or any other Oracle command-line utility) on a computer other than the Oracle Database XE host computer, and then initiating a database connection from the SQL Command Line (or other utility) over the network. The remote computer must have Oracle client software installed.
How to connect to a database from a different computer?
Connecting remotely means running the 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 the SQL Command Line using the Oracle Database XE: