 Transparent Gareway Oracle 9i - MS SQL not working?! [message #132202] |
Thu, 11 August 2005 05:49 |
brandointheweb
Messages: 25
Registered: August 2005
Location: Germany
|
Junior Member |
|
|
Hello from Germany,
I tried to generate a gateway from my Oracle 9i Database to the MSSQL, both databases running on the same machine!
I don´t know why, but its not working! TNSPing is ok, Listener is starting up without problems but a select to the databaselink gives me the ORA-02068, 28511 and 28509- mistake.
Here are my facts:
MSSQL-User: sa Password: dd (everything granted)
SQL-Server-DB: "Videothek"
###########init.ora (initvideothek.ora)#########
# HS init parameters
HS_FDS_CONNECT_INFO=Localhost.Videothek
HS_FDS_RECOVERY_ACCOUNT=sa
HS_FDS_RECOVERY_PWD=dd
HS_FDS_TRACE_LEVEL=DEBUG
###########listener.ora###################
LISTENER=
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = TCP)
(HOST = 127.0.0.1)
(PORT = 1521)
)
)
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = IPC)
(KEY = EXTPROC0)
)
)
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = TCP)
(HOST = 127.0.0.1)
(PORT = 1521)
)
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = BNS)
(ORACLE_HOME = D:\Programme\DB\Oracle\Ora92)
(SID_NAME = BNS)
)
(SID_DESC =
(SID_NAME = VIDEOTHEK)
(ORACLE_HOME = D:\Programme\DB\Oracle\Ora92)
(PROGRAM = tg4msql)
)
)
#########tnsnames.ora#####################
VIDEOTHEK =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = VIDEOTHEK)
)
(HS=OK)
)
ONROAD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.48.15)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ONROAD)
(SERVER = DEDICATED)
)
)
DB2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.48.15)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = BNS)
(SERVER = DEDICATED)
)
)
BNS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = BNS)
(SERVER = DEDICATED)
)
)
########database-link#########
create database link VIDEOTHEK
connect to "sa" IDENTIFIED BY "dd"
using 'VIDEOTHEK';
select * from tbkunde@videothek gives me the mistake:
ORA-02068
ORA-28511 and
ORA-28509
I don't know where is my mistake: I tried several adaptions always with the same results!
what about the sqlnet.ora-file:
is it necessary to docertain specifications?
############my sqlnet.ora##################
SQLNET.AUTHENTICATION_SERVICES = (NONE) #no difference if I use NTS
# names.directory_path = (TNSNAMES,HOSTNAME)
# names.default_domain = world
# names.default_zone = world
It would be very kind of You to give me a hint!
Best Regards
Marlon Schreiber
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
