Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error connection Oracle to SQL Server using tg4msql, HELP Please....

491224Feb 16 2006 — edited Jun 15 2009
Hi, my name is Gregory,
I am a newbie in oracle forum here, and need some help from the database guru here...
I am trying to create the database link from Oracle database to SQL Server.
here are the information:
host name of OracleDB = a3500
host name/Ip of SQL Server = 172.16.1.58
SQL Server database name = CKS_VSSD
i had create the new initntchsql.ora file under tg4msql\admin folder, and i also had create the new listener.
here is the file contains

############ initntchsql.ora ###################
HS_FDS_CONNECT_INFO="SERVER=172.16.1.58;DATABASE=CKS_VSSD"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER

############ listener.ora ######################
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = a3500)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS LIST=
(ADDRESS = (PROTOCOL = TCP)(HOST = a3500)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orclems)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = orclems)
)
(SID_DESC =
(GLOBAL_DBNAME = cps4)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = cps4)
)
(SID_DESC =
(PROGRAM = tg4msql)
(SID_NAME = NTCHSQL)
(ORACLE_HOME = C:\Oracle\Ora92)
)

)

#################### tnsnames.ora #################
...
...
...

NTCHSQL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = a3500)(PORT = 1521))
)
(CONNECT_DATA =
(SID = NTCHSQL)
)
(HS = OK)
)

and i had created databaselink named ntchsql
then i select statement:
select * from vssd50@ntchsql

and error occured:
ORA-02068: Following severe error from NTCHSQL
ORA-28511: lost RPC connection to heterogenous remote agent using SID=%s
ORA-28509: unable to establish a connection to non-Oracle system


did i missed something on the configuration?
oya... i also see other thread that said i have to comment
SQLNET.AUTHENTICATION_SERVICES = (NTS)
from sqlnet.ora file, and i did that, and the error still the same...

can somebody help me?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 13 2009
Added on Feb 16 2006
22 comments
2,412 views