Home » RDBMS Server » Networking and Gateways » Urgent: Transparent Gateway 2 MSSQL
Urgent: Transparent Gateway 2 MSSQL [message #193520] Mon, 18 September 2006 01:53 Go to next message
brandointheweb
Messages: 25
Registered: August 2005
Location: Germany
Junior Member
Hello from Germany!
I tried to setup transparent gateways for MSSQL-Server on my Oracle 9.0.1-machine!
Sincerely it isn't working:
From my point of view I tried everything:
Listener is starting up without any problems and tnsping is working also!

If I try a Select * from AUFTRAG@LAGER I get the ORA-02068, ORA-28511 and ORA-28509 failure-messages!
Details:
ORA-02068: aufgrund eines schwerwiegenden Fehlers von LAGER
ORA-28511: RPC-Verbindung zu heterogenem Fernagenten mit SID=%s abgebrochen
ORA-28509: Einrichten einer Verbindung zu Fremdsystem nicht möglich.

I'll give You my configuration-information hoping You can help me!

transparent gateway installed on Win2003 Server (Oracle 9.2i with 9.2.0.4-Patch)
MSSQL-Server installed on seperate Win2003-Server machine (IP: 10.1.1.007
Database to access: LVS
MSSQL-User: sa --> password:Yep

######### initLagersuite.ora ############
# HS init parameters

HS_FDS_CONNECT_INFO="SERVER=10.1.1.007;DATABASE=LVS"
HS_FDS_TRACE_LEVEL=DEBUG
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER


######### listener.ora ##############

# LISTENER.ORA Network Configuration File: Z:\oracle\ora92\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = TCP)(HOST = BOHNBNS)(PORT = 1521))
)
)
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = TCP)(HOST = BOHNBNS)(PORT = 1434)))
)
)


SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = BNS)
(ORACLE_HOME = D:\Programme\DB\Oracle\ora92)
(SID_NAME = bns)
)
(SID_DESC =
(SID_NAME = Lagersuite)
(ORACLE_HOME = D:\Programme\DB\Oracle\ora92)
(PROGRAM = tg4msql)
)
)



########## tnsnames.ora #########
# TNSNAMES.ORA Network Configuration File: Z:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

DB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = OTHER)
)
)

Lagersuite =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1434))
(CONNECT_DATA =
(SID=Lagersuite))
(HS=OK)
)


########## SQLNET.ora #########
SQLNET.AUTHENTICATION_SERVICES = (NONE)

########## Created database-link #######
create database link Lager
connect to SA identified by Yep
using 'Lagersuite';


It would be fantastic if someone could give me an useful hint!

Regards
Marlon
Re: Urgent: Transparent Gateway 2 MSSQL [message #194314 is a reply to message #193520] Thu, 21 September 2006 08:13 Go to previous message
Shamsher
Messages: 18
Registered: September 2006
Junior Member
Try this query

Select * from SA.AUFTRAG@LAGER

I assume SA is your schema name.


Regards
Shamsheer
Previous Topic: Shared server configuration
Next Topic: ORA 12203:TNS:unable to connect to destination
Goto Forum:
  


Current Time: Fri Dec 09 11:54:58 CST 2016

Total time taken to generate the page: 0.11224 seconds