I am trying to install Oracle 8i and oracle Forms and reports on my personal system for prectise purpose,
I have window XP on my system and I installed Oracle Forms & Reports first on my system in C: drive,
then I installed Oracle 8i(sql, pl/sql) in D: drive on my system, both installed successfully
but whenever I am trying to connect oracle(sql)
with scott/tiger then it is showing below error message and unable to connect with oracle(sql)
ORA-12203 TNS : Unable to connect to destination.
Please suggest how can I solve that problem.
i think you now have two seperate oracle homes for forms and database.
thus, you'll have two (or more) files tnsnames.ora, where the information for the connections is stored.
can you connect to the database using sql plus? if so, take the tnsnames.ora from database (located on d:, typically in ...\network\admin) and overwrite tnsnames.ora on drive c: (look in ..\NET80\admin).
make a copy of the old files before overwriting!
but I am unable to connect to database using sqlplus, whenever I am trying to connect sqlplus by scott/tiger or system/manager then it is showing error message "ORA-12203 TNS :Unablet to connect to destination"
Just check the environment variables i.e., right click 'my computer'-->properties-->advance tab, in that u can find the path there or else you can also check from the cmd prompt, just entering 'path' it would display.
As there are several fixes to this issue, one unique place to look for is the iptables/firewall in Redhat server. Even though EBS applications worked fine until the reboot, we looked at the iptables that was disabled using ‘service iptables stop’ but was never turned off in rc. Nonetheless, this forced the iptables to be enabled during startup and blocked the tns port.
running ‘service iptables off’ helped to fix the issue.
Also, you can confirm if this is the case by simply running telnet dbserver port number . If it doesn’t connect, above fix is valid.