Oracle - Connect SQL*Plus Session to Oracle Server in Oracle

Home > Oracle

Connect SQL*Plus Session to Oracle Server in Oracle

Q

How To Connect a SQL*Plus Session to an Oracle Server in Oracle?

✍: FYIcenter.com

A

In order to connect a SQL*Plus session to an Oracle server, you need to:

1. Obtain the connection information from the Oracle server DBA.

2. Define a new "connect identifier" called "FYI_XE" in your tnsnames.org file with the given connection information.

3. Run the CONNECT command in SQL*Plus as shown in the tutorial exercise below:

>cd c:\oraclexe\app\oracle\product\10.2.0\server\
>.\bin\sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Tue ...
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> CONNECT fyi/retneciyf@FYI_XE;
Connected.

SQL> SELECT SYSDATE FROM DUAL;

SYSDATE
---------
05-MAR-06

⇒Introduction to Command-Line SQL*Plus Client Tool

⇒⇒Oracle Database Tutorials

2016-10-17, 629👍, 0💬

💬 2017-07-10 sasi: Nice tutorial..

About dba.FYIcenter.com Website
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administrators) and database application developers looking for database server management tips, database programming tutorials, career information, and so on. Just browse through the site, you will find the b... 2016-10-17, 3713👍, 0💬

Testing Area
What is test testing area for? The testing area is provided to allow visitors to post testing comments. 2016-10-15, 706👍, 1💬

💬 2017-07-10 Kumar Kedi: ascdfwtwert

Set a READ ONLY Transaction in Oracle
How To Set a Transaction To Be READ ONLY in Oracle? If you want a transaction to be set as READ ONLY, you need to the transaction with the SET TRANSACTION READ ONLY statement. Note that a DML statement will start the transaction automatically. So you have to issue the SET TRANSACTION statement befor... 2019-08-19, 567👍, 0💬

Restrictions in a READ ONLY Transaction in Oracle
What Are the Restrictions in a READ ONLY Transaction in Oracle? There are lots of restrictions in a READ ONLY transaction: You can not switch to READ WRITE mode. You can not run any INSERT, UPDATE, DELETE statements. You can run SELECT query statements. The tutorial exercise below shows you some of ... 2019-08-19, 518👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.