Home » RDBMS Server » Server Administration » oracle 9i Heterogeneous Services problem pls help
oracle 9i Heterogeneous Services problem pls help [message #193693] Tue, 19 September 2006 00:40 Go to next message
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



Re: oracle 9i Heterogeneous Services problem pls help [message #193747 is a reply to message #193693] Tue, 19 September 2006 04:44 Go to previous messageGo to next message
AndreyPozhidaev
Messages: 9
Registered: December 2005
Location: St. Petersburg
Junior Member

1)
§HS_FDS_CONNECT_INFO = BUDGET
What is this '§' ?

not sure, maybe comment ???

2) Did you restart listener after new settings ?
Re: oracle 9i Heterogeneous Services problem pls help [message #193753 is a reply to message #193693] Tue, 19 September 2006 05:25 Go to previous messageGo to next message
reyazan
Messages: 53
Registered: February 2005
Member
§ just a typing mistake i have remove it.

i have also restart the listener
Re: oracle 9i Heterogeneous Services problem pls help [message #193759 is a reply to message #193753] Tue, 19 September 2006 05:37 Go to previous message
AndreyPozhidaev
Messages: 9
Registered: December 2005
Location: St. Petersburg
Junior Member

as it is ? CREATE DATABASE LINK ... USING 'BUDGET.DIVINE.COM'
Previous Topic: database growth script
Next Topic: error in kill the session
Goto Forum:
  


Current Time: Wed Dec 07 13:02:28 CST 2016

Total time taken to generate the page: 0.06049 seconds