Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> tns error
Hi,
I have installed Oracle 10g on Solaris 10X86.
Install appears to have gone okay but when I type sqlplus the prompt asks me
for the username/pwd
Whatever I enter I get the following error :ORA-12162: TNS:net service name
is incorrectly specified
Don't fully understand what is wrong,
Any Pointers appreciated,
My tnsNames.ora file is below, My SID is MYORA
Thanking you
MYORA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MYORA)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
) Received on Fri Mar 11 2005 - 09:55:41 CST
![]() |
![]() |