Login  Register

Re: tnsmname error

Posted by ErmanArslansOracleBlog on Nov 28, 2016; 7:44am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/tnsmname-error-tp1621p1627.html

If you need assistance, you need to provide the details and requested info.

send me the following command outputs  (executed from the client)

ping srv-webdw
nslookup srv-webdw
telnet srv-webdw 1521

send me the following command outputs  (executed from the server)
sqlplus "/as sysdba"  <--select * from v$instance;
sqlplus <user>/<password>@your_database_TNS_entry
lsnrctl status <your_listener_name>
lsnrctl services <your_listener_name>

*Also ensure this is not a firewall issue..

2016-11-28 7:34 GMT+03:00 Arsala saleem [via Erman Arslan's Oracle Forum] <[hidden email]>:

Bro.

i  edite  host file on my client site ( 192.168.2.101 srv-webdw)  --this is client site

and also


edite server  host file on server (10.10.3.141     crd-sig1-arsala )   --this is server site


i copied tnsname.ora file from server and past on client so when we connect it give error

ora 12170

I did many practice to solve but i could not .. please find the technical solution.



If you reply to this email, your message will be added to the discussion below:
http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/tnsmname-error-tp1621p1626.html
To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML



--

Erman Arslan, MBA 

Applications and Database Operations Manager

Oracle Certified Expert, Certified Exadata and Linux Administrator


Author,  Practical Oracle E-Business Suite

Blog:     ermanarslan.blogspot.com

Forum:  http://ermanarslan.blogspot.com/p/forum.html


Mobile: 05301567803