Monday, 1 January 2018

What is location of Oracle tnsname file

To connect with oracle database we may require tnsname.ora file present in this location
%User%virtual\product\12.2.0\dbhome_1\network\admin.......................


It has connection string like

ORACLEDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oracledb)
    )
  )

No comments:

Post a Comment