Connect to SQL*Plus with no TNSnames

Oracle's easy connect naming method. EZCONNECT 


sqlplus [user]/[password]@//[database_host]:[port]/[service_name] 

service_name=SID

In order to be prompted for a password while using the EZCONNECT naming adapter, use the following syntax:

sqlplus username@\"[hostname]:[port]/[service name]\"

example: sqlplus system@\"netfl-unix1:1521/v10.us.oracle.com\" 


If you performed a "typical" Oracle database server installation, the default service name for the instance will be ORCL. Use the following easy connect syntax to connect to that instance:




SQL> select NAME from v$database; 

NAME
---------
ORCL


database DEV01

sqlplus scott/tiger@apt-lnxtst-01/orcl
if port no is default i.e. 1521 then there is no need for port

sqlplus scott/tiger@BIGSERVER:1616/DEV01


oracle@apt-lnxtst-01:~> 


sqlplus scott/tiger@192.168.2.232/orcl

sqlplus scott/tiger@apt-lnxtst-01/orcl


sqlplus scott/tiger@192.168.2.232:1521/orcl


sqlplus scott/tiger@192.168.2.232:1521/orcl


=================

**************
sqlplus anuj@'(DESCRIPTION_LIST=(LOAD_BALANCE=off)(FAILOVER=on)(DESCRIPTION=(ENABLE=broken)(ADDRESS=(PROTOCOL=TCP)(HOST=***-scan.****)(PORT=1521))(CONNECT_DATA=(UR=A)(SERVICE_NAME=arac))))'

SQL*Plus: Release 12.2.0.1.0 Production on Fri Dec 17 01:40:14 2021

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Enter password:
ERROR:
ORA-28002: the password will expire within 7 days


Last Successful login time: Sat Oct 23 2021 07:48:12 -05:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

primary:anuj@******** sqlplus>


**************



sqlplus /@"(DESCRIPTION=(FAILOVER=ON)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.211.106.64)(PORT=1521)))(CONNECT_DATA=(SID=orcl)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=5)(DELAY=10))))"



ww
HOST=4.106.245.35 = vip ip

sqlplus anuj@'(DESCRIPTION_LIST=(LOAD_BALANCE=off)(FAILOVER=on)(DESCRIPTION=(ENABLE=broken)(ADDRESS=(PROTOCOL=TCP)(HOST=4.106.245.35)(PORT=1521))(CONNECT_DATA=(UR=A)(SERVICE_NAME=brac))))'

sqlplus anuj@'(DESCRIPTION_LIST=(LOAD_BALANCE=off)(FAILOVER=on)(DESCRIPTION=(ENABLE=broken)(ADDRESS=(PROTOCOL=TCP)(HOST=4.106.245.35)(PORT=1521))(CONNECT_DATA=(UR=A)(SERVICE_NAME=brac)(SID=brac1))))'

sqlplus anuj@'(DESCRIPTION_LIST=(LOAD_BALANCE=off)(FAILOVER=off)(DESCRIPTION=(ENABLE=broken)(ADDRESS=(PROTOCOL=TCP)(HOST=4.106.245.35)(PORT=1521))(CONNECT_DATA=(UR=A)(SERVICE_NAME=brac)(SID=brac1))))'

sqlplus anuj@'(DESCRIPTION_LIST=(LOAD_BALANCE=off)(FAILOVER=off)(DESCRIPTION=(ENABLE=broken)(ADDRESS=(PROTOCOL=TCP)(HOST=64.106.245.35)(PORT=1521))(CONNECT_DATA=(UR=A)(SID=brac1))))'

sqlplus anuj@'(DESCRIPTION_LIST=(LOAD_BALANCE=off)(FAILOVER=off)(DESCRIPTION=(ENABLE=broken)(ADDRESS=(PROTOCOL=TCP)(HOST=64.106.245.35)(PORT=1521))(CONNECT_DATA=(SID=brac1))))'


sqlplus anuj@'(DESCRIPTION_LIST=(LOAD_BALANCE=off)(FAILOVER=off)(DESCRIPTION=(ENABLE=broken)(ADDRESS=(PROTOCOL=TCP)(HOST=64.106.245.35)(PORT=1521))(CONNECT_DATA=(SID=ibrac1))))'