12 Replies Latest reply on Oct 21, 2015 9:10 AM by Michel Ramirez

    Connection with TNSName.ora

    Michel Ramirez

      HI,

      The dev team  for connection to database, they use TNSNAME.ora

       

      If you change in tnsname file the HOST, SERVICE_NAME or PORT that working, but  if i change ALIAS NAME it doesn't work

       

       

       

      First connection with tnsname.ora

       

      ICWDEV4, ICWDEV4_71 =

      (DESCRIPTION =

         (ADDRESS_LIST =

           (ADDRESS = (PROTOCOL = TCP)(HOST = cbh150)(PORT = 1523))

         )

      (CONNECT_DATA =

         (SERVICE_NAME = ICWDEV4)

      )

      )

       

      Later, i change version number

       

      ICWDEV4, ICWDEV4_72 =

      (DESCRIPTION =

         (ADDRESS_LIST =

           (ADDRESS = (PROTOCOL = TCP)(HOST = cbh150)(PORT = 1523))

         )

      (CONNECT_DATA =

         (SERVICE_NAME = ICWDEV4)

      )

      )

       

      Here message errors

      TNSerror.JPG

      Do you know why or i need to check à case option like " refresh" in SQLDeveloper parameters?

       

      Best regards