this is the actual scenario:
I administer a database oracle8i 18.104.22.168 running in windows 2003 server in an organization datacentre.
this organization gave me sonicwall aventail vpn access so i can use remote desktop to connect the server.
I have the ip address and serveral ports free to connect including port 1521.
I also have a computer logged on the network in this organization, but I'm not allowed to install any 3rd party application like TOAD, DB Artisan or PLSQL Develope.
successfull connect database using TOAD or PL SQL Developer server via AVENTAIL VPN by configuring the oracle server listener.
-OR- diagnose the issue that is no leaving me connect
NOTE: I already conected and make a SQL Query, but after a while the listener stops working and i get the messages :" ORA-12541: TNS: no listener" or "ORA-12514: TNS: listener could not resolve SERVICE_NAME given in connect descriptor" THE ERROR IS RANDOM, just work for a while and then stop working.
work method: I will grant access to my computer while I supervise, log on and enter the passwords.
this is to start working tomorrow from 8:00 am GMT -6 TO 9:00 PM GMT -6
7 freelancers are bidding on average $124 for this job
I am oracle database expert, certified dba with more than 6 years of experience. I am expert in toad and other software too. I want to solve this. Please check my profile for relevant experience. Rgds, Shafiq