How to connect remote database using forms 6i? [message #420900] |
Thu, 03 September 2009 03:00 |
itztamr
Messages: 9 Registered: August 2009 Location: Kuwait
|
Junior Member |
|
|
Dear all,
I installed oracle 10g and developed simple software using
forms 6i. Its working well as a stand alone system.
I want to share it in network. so I installed forms 6i as oracle client , copied the tnsnames.ora from the oracle installation pth to forms installation path.(inside NET80/Admin folder)
When i try to connect with user name and password , it comes ORA-12203 Unable to connect to destination.
I checked LSNRCTL in the database machine, it is listening.
Hope u understand my question? Appreciate your help..
Thanks in advance
Tam.R ( Kuwait)
|
|
|
|
Re: How to connect remote database using forms 6i? [message #421946 is a reply to message #420900] |
Sat, 12 September 2009 01:34 |
itztamr
Messages: 9 Registered: August 2009 Location: Kuwait
|
Junior Member |
|
|
Dear Nitesh,
Thanks for your reply. But i am able to call 10g(forms 6i,oracle 10g database) in my system.
only thing when i try to access the database from other systems the problem rises...
I will appreciate if u could elaborate your solution...
Thanks in advance
Best Regards,
Tam.R
|
|
|
|
|
Re: How to connect remote database using forms 6i? [message #422015 is a reply to message #421967] |
Sun, 13 September 2009 08:24 |
itztamr
Messages: 9 Registered: August 2009 Location: Kuwait
|
Junior Member |
|
|
Thanks everyone... i attach my tnsnames.ora and sqlnet.ora files in oracle installation folder which i copied in the remote forms folder.. just have a glance..suggest me whats wrong.
TNSNAMES.ORA
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLE2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.1.1.25)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracle2)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
SQLNET.ORA
# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
I am getting 12203 error.. Listener is running on the server side...
Thanks for all your replies again...
Best Regards,
Tam.R ( Kuwait)
|
|
|
|
|
|
|
Re: How to connect remote database using forms 6i? [message #423239 is a reply to message #423068] |
Wed, 23 September 2009 00:41 |
itztamr
Messages: 9 Registered: August 2009 Location: Kuwait
|
Junior Member |
|
|
Dear All,
Thanks everyone..
Finally it worked..
My database installed PC's firewall is ON.
After turning it off,remote system is able to connect to that...
Thanks Mr.David... ( I got this idea when i search for tns_admin)
Best Regards,
Tam.R ( Kuwait)
|
|
|
Re: How to connect remote database using forms 6i? [message #545248 is a reply to message #423239] |
Tue, 28 February 2012 02:19 |
tanveerall
Messages: 2 Registered: November 2008 Location: Rawalpindi Pakistan
|
Junior Member |
|
|
Dear all,
I was also getting the same issue. I resolved the issue by turning off the firewall installed at Oracle database server.
After that my clients with forms 6i started connecting the database server normally with no problem.
Tanveer Ahmad
|
|
|