TNS ora error [message #348114] |
Mon, 15 September 2008 12:24 |
|
Hi All,
I have install oracle 9i in window m/c. while installation oracle I have given following Credential
After installation I saw the tnsora file .It's having below entry.
OMKAR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = sagar-wxp)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = omkar)
)
)
when I am trying to connect oracle through below command I am getting ORA-12154: TNS:could not resolve service name.
sqlplus scott/tiger@omkar
but I am able to connect through sqlplus scott/tiger. Could you please advice what is the problem.
Thanks,
Sagar
|
|
|
|
|
|