Oracle - Requirements for SQL*Plus Connection in Oracle

Requirements for SQL*Plus Connection in Oracle

Q

What Information Is Needed to Connect SQL*Plus an Oracle Server in Oracle?

✍: FYIcenter.com

A

If you want to connect your SQL*Plus session to an Oracle server, you need to know the following information about this server:

The network hostname, or IP address, of the Oracle server.
The network port number where the Oracle server is listening for incoming connections.
The name of the target database instance managed by the Oracle server.
The name of your user account predefined on in the target database instance.
The password of your user account predefined on in the target database instance.

⇒Introduction to Command-Line SQL*Plus Client Tool

⇒⇒Oracle Database Tutorials

2016-10-17, 450👍, 0💬

Popular Posts:

sys.server_principal...

How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...

Creating a View with...

Can You Create a View with Data from Multiple Tables in SQL Server? Can You Create a View with Data ...

CONVERT() - Converti...

How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...

CREATE TABLE - Creat...

How to create new tables with "CREATE TABLE" statements in SQL Server? If you want to create a new t...

IF ... ELSE Statemen...

How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...