Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> tns error

tns error

From: Ian <not_at_available.com.au>
Date: Sat, 12 Mar 2005 02:25:41 +1030
Message-ID: <4231bf7c$1_4@news.chariot.net.au>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US