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

  • From: velmanis@xxxxxxxxx (velumani sachidhanandham)
  • Date: Mon Mar 14 11:49:07 2005



Hi All,

I am trying to install Oracle 10g in Redhat Linux
Enterprise Advanced Server (AS). I have installed
Oracle successfully. But I am getting following error

ORA-12162:  TNS:net service name is incorrectly
specified.

while starting the following Oracle services

1. iSQLPlus  services.
2. SQLPlus  services.

Please let me know if anybody know the solution to
resolve this issue.


My tnsnames.ora file as follows


# tnsnames.ora Network Configuration File:
/u01/app/oracle/product/10.1.0/Db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

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

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )


Thanks & Regards,
Velumani S





                
__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/ ;

Other related posts:

  • » [Ilugc] how to resolve ORA-12162: TNS:net service name is incorrectly - velumani sachidhanandham