oracle 9i Heterogeneous Services problem pls help [message #193693] |
Tue, 19 September 2006 00:40 |
reyazan
Messages: 53 Registered: February 2005
|
Member |
|
|
I have a BUDGET.mdb file in ms access2000 os windows2000 server.
I have create a system dsn odbc BUDGET for above mdb file using ms access driver.
I have oracle9i enterprise edition on windows 2000 server (database sid UDR on 1521 port).
Now i have performed the following step to use oracle Heterogeneous Services.
Oracle HS Initialization File configuration:
The init_odbc_data_source.ora file resides in the
$ORACLE_HOME/HS/ADMIN directory.
File entries for our example
(initBUDGET.ora):
§HS_FDS_CONNECT_INFO = BUDGET
§HS_FDS_TRACE_LEVEL = 0
§HS_FDS_TRACE_FILE_NAME = hsmsql.trc
Oracle Net8 Client configuration (tnsnames.ora):
BUDGET.DIVINE.COM =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)
(HOST=mymachine)
(PORT=1521))
(CONNECT_DATA=(SID=BUDGET))
(HS=OK) <======== Note the HS parameter )
)
Oracle DB Listener configuration (listener.ora):
(SID_DESC=
(SID_NAME=BUDGET)
(ORACLE_HOME = C:\oracle\ora81)
(PROGRAM=hsodbc))
Creation of a Database Link:
CREATE PUBLIC DATABASE LINK “BUDGET" USING ‘BUDGET';
Nowi issuse a following command in sqlplus
select count(*) from sites$@BUDGET.
it gives the followin error
ORA-28509: unable to establish a connection to non-Oracle system
Please help
|
|
|
|
|
|