Collections:
Connect SQL*Plus Session to Oracle Server in Oracle
How To Connect a SQL*Plus Session to an Oracle Server in Oracle?
✍: FYIcenter.com
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
⇒ Error: Could not Resolve the Connect Identifier in Oracle
⇐ What Is a Connect Identifier in Oracle
2020-08-13, 2458🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...