1. I don't find any Gateway service being created in the services panel. What is the purpose of this inittg4msql.ora?
Is there any utility to create gateway service in oracle10g as it used to be in 8 like
CMD> Set GTW_EXE=TGMSQL80.exe
CMD> GTWSRV80 sid -create | more
2. As Gateway installation and database server is on the same machine with one Listener which reads from
Then what is the function of listener.ora under
Same with Tnsnames.ora file.
Please help me as I have been trying with this for many days and its going nowhere.
I used the gateway version from the page:
http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201winsoft.html (file 10201_gateways_win32.zip)
The oracle home was a bit different: C:\oracle\product\10.2.0\tg_1 instead of c:\oracle\product\10.1.0\db_1
In addition I found that most configuration files are located in $ORACLE_HOME\NETWORK\ADMIN instead of $ORACLE_HOME\tg4msql\admin
Some setting were correctly filled during the instalaction of the gateway, but I had to adjust some of them, for example I had to set SID to tg4msql
BTW, there is a good article about accessing Sql Server from Oracle at http://oracle-apps-dba.blogspot.com/2008/04/oracle-transparent-gateways-general.html