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/ ;