| Urgent: Transparent Gateway 2 MSSQL [message #193520] |
Mon, 18 September 2006 01:53  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
