hi all,
my clients are getting ORA-12154 error while running the application.
they are able to run some of the modules within the application but some
modules through this error.

i am able to connect to database using SQL and when I run the
application on the server itself i donot get any errors. tnsping from
the client is working fine.
setting are as follows

SQLnet.ora

SQLNET.AUTHENTICATION_SERVICES= (NTS) both on client and server

tnsnames.ora

MYP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = myp)
)
)

listener.ora

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)



help will be appreciated


Thanks and Regards,
Aijaz



DISCLAIMER:
Notice : This e-mail and any attachments may contain information which is confidential to the addressee and may also be privileged. If you are not the intended recipient of this e-mail, you may not copy, forward, disclose or otherwise use it in any way whatsoever. If you have received this e-mail by mistake, please e-mail the sender by replying to this message, and deleting the original and any printout thereof.

Oracle LazyDBA home page