[Ilugc] how to resolve ORA-12162: TNS:net service nameis incorrectly

  • From: anand.kumar@xxxxxxxxxx (Anand Kumar Saha)
  • Date: Mon Mar 14 11:54:42 2005


   | ORCL =
   |   (DESCRIPTION =

'(ADDRESS_LIST =' is missing here.

   |     (ADDRESS = (PROTOCOL = TCP)(HOST =
   | vmspltaroon)(PORT = 1521))
   |     (CONNECT_DATA =
   |       (SERVER = DEDICATED)
   |       (SERVICE_NAME = orcl)
   |     )
   |   )
   | 

Replace your ORCL entry with this:

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = vmspltaroon)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

saha
--

Other related posts:

  • » [Ilugc] how to resolve ORA-12162: TNS:net service nameis incorrectly - Anand Kumar Saha
  1. Home
  2. ilugc
  3. Archive
  4. 03-2005