| MS SQL-Server not working [message #171135] |
Mon, 08 May 2006 11:08  |
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@Lagersuite I get the ORA-28545 and ORA-02063 failure-messages!
I'll give You my configuration-information hoping You can help me!
Transparent gateway installed on Win2003 (Oracle 9.2i with 9.2.0.4-Patch)
MSSQL-Server installed on seperate Win2003-machine (IP: 10.1.1.
Database to access: LVS
MSSQL-User: sa --> password:lager
######### initTG2Lagersuite.ora ############
# HS init parameters
HS_FDS_CONNECT_INFO="SERVER=10.1.1.5;DATABASE=LVS"
HS_FDS_TRACE_LEVEL=DEBUG
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
######### listener.ora ##############
# LISTENER.ORA Network Configuration File: C:\oracle\ora92\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = digital-db03)(PORT = 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = BOHNEN)
(ORACLE_HOME = d:programme\db\oracle\ora92)
(SID_NAME = BOHNEN)
)
(SID_DESC =
(GLOBAL_DBNAME = CLD)
(ORACLE_HOME = d:programme\db\oracle\ora92)
(SID_NAME = CLD)
)
(SID_DESC =
(GLOBAL_DBNAME = OR701010)
(ORACLE_HOME = d:programme\db\oracle\ora92)
(SID_NAME = OR701010)
)
(SID_DESC =
(GLOBAL_DBNAME = OR701023)
(ORACLE_HOME = d:programme\db\oracle\ora92)
(SID_NAME = OR701023)
)
(SID_DESC =
(SID_NAME = Lagersuite)
(ORACLE_HOME = d:programme\db\oracle\ora92)
(PROGRAM = tg4msql)
)
)
########## tnsnames.ora #########
# TNSNAMES.ORA Network Configuration File: D:\Programme\DB\Oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
BOHNEN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = BOHNEN)
)
)
CLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = CLD)
)
)
OR701010 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = OR701010)
)
)
OR701023 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = OR701023)
)
)
Lagersuite =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))
(CONNECT_DATA =
(SID=TG2Lagersuite))
(HS=OK)
)
########## SQLNET.ora #########
SQLNET.AUTHENTICATION_SERVICES = (NTS)
########## Created database-link #######
create database link Lager
connect to SA identified by Lager
using 'Lagersuite';
It would be fantastic if someone could give me an useful hint!
Regards
MArlon
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
