Check for any firewall enabled on server side.

--
Anand Diwan

________________________________

From: Mir Aijaz A [mailto:oracledba-ezmlmshield-x11411886.[Email address protected]
Sent: Sun 7/1/2007 12:21 PM
To: LazyDBA Discussion
Subject: ora-12514



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.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





Oracle LazyDBA home page