Thursday, October 06, 2011

SQL connect Tip



I am lazy to make Tns entry in TNSNAMES.ORA file
But, still you can connect sqlplus session using following tip
make the tns entry as shown below , First  open sqlplus connect window then follow below steps


Syntax:


(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xyzabc.com)(PORT=1521))(CONNECT_DATA=(SID=Devep11i)))


Username : apps
Password : apps
Host string : < paste above tns entry here>






click on ok , it will connect to specified dbserver with making entry in TNSNAMES.ORA 

1 comment:

Smith said...

Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Live Meeting Support. Please Check https://www.oracleappstechnical.com