1 2 Previous Next 22 Replies Latest reply: Jul 15, 2014 2:00 PM by CraigB RSS

    TNS could not resolved the the connect identifier specified

    Praveen Kumar Singh

      Hi,

       

      When i am trying to run form in browser it is showing error. TNS could not resolved the the connect identifier specified.

      All the files location is oraclexe\app\oracle\product\11.2.0\server\network\ADMIN.

       

      I googled but not able to understand as i am trying to lean and all this things are new & confusing to me.

      OS is Windows 7

      Forms & Report:-11.1.2.2

      Database is Express Edition 11G.

       

      sqlnet.ora
      
      SQLNET.AUTHENTICATION_SERVICES = (NTS)
      #NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, HOSTNAME)
      
      tnsnames.ora
      XE =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = PKS-PC)(PORT = 1521))
          (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = XE)
          )
        )
      EXTPROC_CONNECTION_DATA =
        (DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
          )
          (CONNECT_DATA =
            (SID = PLSExtProc)
            (PRESENTATION = RO)
          )
        )
      ORACLR_CONNECTION_DATA = 
        (DESCRIPTION = 
          (ADDRESS_LIST = 
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 
          ) 
          (CONNECT_DATA = 
            (SID = CLRExtProc) 
            (PRESENTATION = RO) 
          ) 
        ) 
      
      listener.ora
      
      SID_LIST_LISTENER =
        (SID_LIST =
          (SID_DESC =
            (SID_NAME = PLSExtProc)
            (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
            (PROGRAM = extproc)
          )
          (SID_DESC =
            (SID_NAME = CLRExtProc)
            (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
            (PROGRAM = extproc)
          )
        )
      
      
      LISTENER =
        (DESCRIPTION_LIST =
          (DESCRIPTION =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
            (ADDRESS = (PROTOCOL = TCP)(HOST = PKS-PC)(PORT = 1521))
          )
        )
      
      
      DEFAULT_SERVICE_LISTENER = (XE)
      
        1 2 Previous Next