Connecting methods of SQLPLUS in Oracle
Connect SQLPLUS on the Operating system depends upon the various factors.
you can connect with database by using following methods. In Some case you also need to set the ORACLE_HOME and PATH environment variable to use the SQLPLUS. prompt.
Note: In case of multiple database is configured in one system. you need to use the ORACLE_SID environment variable.
1. Connect to local database user with sysdba priviliges
sqlplus sys as sysdba
2. Connect with Operating System Authentication with SYSDBA Privilege.
sqlplus / as sysdba
3. Connect with easy connect syntax
sqlplus hr@"databasehostname.example.com:1522/orcl"
4. Connect with Easy Connect Syntax with IP address and port is default (1521).
Note: If port is default then not need to specify the port number
sqlplus hr@"172.1.1.5/orcl"
5. Connecting with an IPv6 Address
Note: IPV6 is used in Square bracket
connect hr@"[2001:0DB8:0:0::200C:417A]/orcl"
6. Connecting with a Net Service Name
Note: tnsentry in tnsnames.ora for using as net service name
connect hr@orcl