CONNECT DATABASE THROUGH SID IN ORACLE

To connect the oracle database use below steps:

Step 1:- Win+R -> cmd

Step 2:- SQLPLUS hr/hr@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.01)(PORT=1521))(CONNECT_DATA=(SID=ORCL)))

Here

·         hr/hr  is my username/password

·         192.168.0.01 default IP address you need to pass the IP address of your oracle database server.

·         1521 is oracle database port number

·         In place of ORCL you need to pass the SID of your oracle database