How to Use SQL*Plus to Connect to Database Without Setting Up tnsnames.ora File
(Doc ID 376578.1)
Last updated on DECEMBER 03, 2019
Applies to:
SQL*Plus - Version 9.2.0.6 and laterInformation in this document applies to any platform.
Goal
Usually you use a connect string provided in the tnsnames.ora file to connect to a database, for example:
sqlplus <dbuser/password>@dbconnection
However, you have a requirement to connect to a database using SQL*Plus, without a tnsnames.ora file.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
Scenario #1 |
Scenario #2 |
Scenario #3 |