kushpaw
asked on
ORA-12541 :TNS: no listener, open port on client?
I am conneting to oracle server via vpn, i have sqlnet.ora and tnsnames.ora files exactly how i was instructed by the network deptment. But i can receiving this ORA-12541 error when i try to run my .net app. The hostname and service name in tnsnames.ora are same as everyone else is using. So i am confused why it is not working for me. I have installed only oracle client on my machine.
I am not sure if i have to start some service on my machine, if so where would it be, it's name etc. Do i have to open port 1521 on my side?
Either the tnsname files they gave me are wrong or something else is wrong on my machine.
thanks!
kushpaw
I am not sure if i have to start some service on my machine, if so where would it be, it's name etc. Do i have to open port 1521 on my side?
Either the tnsname files they gave me are wrong or something else is wrong on my machine.
thanks!
kushpaw
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
so there is nothing i have to change on my client machine? i will check with them
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
On the server side:
1. Turn off all firewalls and antiviruses
2. Investigate the Listener status:
a) read and publish here listener .ora fie
b)C:>lsnrctl status
C:>lsnrctl services
3. Try to start the Listener:
c:>lsnrctl start
1. Turn off all firewalls and antiviruses
2. Investigate the Listener status:
a) read and publish here listener .ora fie
b)C:>lsnrctl status
C:>lsnrctl services
3. Try to start the Listener:
c:>lsnrctl start
ASKER
i am working remotely for a client. all other developers are using same ora files. they are not having any problem so i am guessing there must be something on my side blocking it. tnsnames.ora is using port 1521, could my router/modem is blocking it? i don't know how i can check it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
no my firewall is turned off. vpn is not restricting port 1521.
ASKER
I have tried all the suggestions, my port is open but i am still the only developer having trouble connecting to remote oracle database. I am sorry, but my problem is not SOLVED. As a result i am not accepting any solution. Thanks to all those who tried.
-kushpaw
-kushpaw
You have to ask the professionals who have installed the VPN.
ASKER
All, every comment pointed me to right direction. Utimately it was my DSL modem firewall which was blocking my port 1521.
thanks,
kushpaw
thanks,
kushpaw
ASKER
used parameter files:
C:\ ..... \sqlnet.ora
Used EZConnect adapter to resolve the alias
Attempting to contact <description = <.........
(gives me a list of host and address combinations)
ORA-12541: TNS: no listener
-kushpaw