I take it you like the little examples in the hs/admin directory eh?
The examples intermingle "hsagent" with the agent and the ODBC DSN name thus
rendering forth much confusion.
;-)
Here goes my first try at helping you:
1. Your ODBC DSN has been created as a system DSN called "DBTEXT" and you
have successfully connected through the DSN to the database.
2. Create your initDBTEXT.ora in the %ORACLE_HOME%\hs\admin directory
containing the following::
HS_FDS_CONNECT_INFO = DBTEXT
HS_FDS_TRACE_LEVEL = 0
3. edit your %ORACLE_HOME%\network\admin\listener.ora to include the
following:
listener.ora:
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=DBTEXT)
(ORACLE_HOME=C:\oracle\ora92)
(PROGRAM=hsodbc)
)
)
# give ODBC some time to come up the first time
CONNECT_TIMEOUT_LISTENER = 30
4. edit your %ORACLE_HOME%\network\admin\tnsnames.ora to include the
following:
DBTEXT =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1526))
(CONNECT_DATA=(SID=DBTEXT))
(HS=OK)
)
5. open up a dos window (start|run, cmd, enter
6. type lsnrctl and press enter. you should have the listener control
prompt.
7. type stop and press return
8. type start and press return
9. look at the information and make sure you have a handler for the DBTEXT
service.
10. type exit and press return
11. close the dos window.
12. open a sqlplus session
13 enter "create database link dbtext connect to thedbtextschemaowner
identified by thedbtextschemaownerspassword using 'DBTEXT';" and press
enter.
14. enter "select sysdate from [Email Address Removed] and press enter.
If you did everything right AND the ODBC driver conforms to what Oracle HS
needs then you will observe a short pause as the ODBC layers initialize
followed by the sysdate being returned.
If you continue to get errors then I suggest you create a system dsn
pointing to a schema on your local database and crete the necessary
components described above to establish an HS connection directly to the
local database.
Let us know how things go.
Regards,
Steve Tilson
----- Original Message -----
From: "Hugo Bouckaert "
<oracledba-ezmlmshield-x59885981.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, August 18, 2004 3:18 AM
Subject: Using Oracle's Heterogeneous Service Agent
> Hi
>
> I would like to make a client connection from my Oracle 9i database
> using ODBC to another database, called InMagic DBtext (a library
> catalogue database). The Inmagic server resides on the same machine as
> the Oracle database.
>
> I found what to do (see below) from the "Oracle 9i Heterogeneous
> Connectivity Administrator's Guide". However, it is not working.
>
> I have:
>
> - installed the ODBC driver for Inmagic and made a System DSN client
> connection, called gex_library
>
> - in the %oracle_home%\hs\admin directory I made a file called
> initDBTEXT.ora with the following content:
>
> # HS init parameters
> #
> HS_FDS_CONNECT_INFO = gex_library
> HS_FDS_TRACE_LEVEL = ON
>
> - in the %oracle_home%\network\admin directory I changed two files:
> listener.ora and tnsnames.ora
>
> I have added the following to listener.ora:
>
> LISTENER =
> (ADDRESS_LIST=
> (ADDRESS=(PROTOCOL=tcp)(HOST=geodb)(PORT=1526))
> (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
>
> SID_LIST_LISTENER=
> (SID_LIST=
> (SID_DESC=
> (SID_NAME=DBTEXT)
> (ORACLE_HOME=C:\oracle\ora92)
> (PROGRAM=hsodbc)
> )
> )
>
> CONNECT_TIMEOUT_LISTENER = 0
>
> (Note that the port number is the port number of my oracle database -
> this may be wrong. However I cannot find a port number for the Inmagic
> database.)
>
> At the line "PROGRAM=hsodbc" I also tried:
>
> PROGRAM=hsagent
>
> Lastly, I have added the following entry to tsnames.ora
>
> DBTEXT =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = geodb)(PORT = 1526))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = DBTEXT)
> )
> (HS = OK)
> )
>
> ( Here again the port number may be wrong as it is the port number of my
> client to Inmagic i.e. the Oracle database.)
>
> With these additions to listener.ora and tnsnames.ora, my listener
> services won't even start up. Obviously the connection to the dbtext
> Inmagic database is not working either.
>
> Would anyone be able to help with this?
>
> Thanks very much.
>
> Hugo
> <mailto:[Email address protected]
>
>
> Dr Hugo Bouckaert
> Systems and Programming Engineer
>
> Geoinformatics Exploration Australia P/L
> 57 Havelock St
> West Perth, WA 6005
> PO Box 1675, West Perth 6872
>
> Ph: 61 08 9420 7400
> Fax: 61 08 9226 1299
>
> www.geoinformex.com
>
> ------------------------------------------------------------------------
>
> This email and any attachments may be confidential or legally
> privileged. If you received this message in error or are not the
> intended recipient, you should destroy the e-mail message and any
> attachments or copies, and you are prohibited from retaining,
> distributing, disclosing or using any information contained herein.
> Please inform us of the erroneous delivery by return e-mail. Thank you
> for your cooperation.
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>
Oracle LazyDBA home page