Is anyone still using Transparent Gateway for RMS (tg4RMS) ?

Hi

We're trying to move an application to Windows (from VMS) but it is
currently accessing a few RMS files (native indexed filesystem on VMS).
While finializing the conversion (lots of programming to do) which may take
a few more months, we'd like to do the port and maintain accessibility of
the RMS files by using the Transaparent Gateway for RMS

I set it up using the guide, but something must be missing in the config as
I get errors when trying to register a file definition :

SQL> exec dbms_tg4rms.addl_to_add('IVAF001.ADL','tg4rms')
BEGIN dbms_tg4rms.addl_to_add('IVAF001.ADL','tg4rms'); END;

*
ERROR at line 1:
ORA-04053: error occurred when validating remote object
ORACLE9205.DBMS_HS_PASSTHROUGH@TG4RMS
ORA-00604: error occurred at recursive SQL level 2
ORA-28500: connection from ORACLE to a non-Oracle system returned this
message:
[Transparent gateway for RMS]ADD-RMS
ORA-02063: preceding 2 lines from TG4RMS
ORA-06512: at "SYS.DBMS_TG4RMS", line 33
ORA-06512: at line 1

I enabled tracing with HS_FDS_TRACE_LEVEL=ON and the trace file shows

************************************************** *****
************************************************** *****

Oracle Corporation --- WEDNESDAY FEB 22 2012 09:19:16.797


Heterogeneous Agent Release
9.2.0.5.0


[C078] Dynamic library 'NVDB_RMS' was not found


PATH = ora$disque:[oracle9205]


[C077] Could not find symbol 'ADD-RMS' in dynamic library


[Transparent gateway for RMS] version: 3.3.00.00.0040
Setting NAVDEF to ora_tg4rms_dd
connect string is: defTdpName=TG4RMS;SYNTAX=(ORACLE8_HOA, BASED_ON=ORACLE8,
IDENTIFIER_QUOTE_CHAR="",
CASE_SENSITIVE=CASE_SENSITIVE_QUOTE);BINDING=<navo bj>
<binding>
<datasources>
<datasource name='TG4RMS' type='ADD-RMS' connect='ora_tg4rms_dd'
readOnly='true'>
<driverProperties/></datasource></datasources><remoteMachines/><environment>
<misc year2000Policy='-1' consumerApi='1'
sessionBehavior='4'/><queryProcessor
parserDepth='2000' noInsertParameterization='true'
noThreadedReadAhead='true'/></environment></binding></navobj>
ORACLE RMS GATEWAY Log File Started at 22-Feb-12 09:19:17
ADD-RMS

Closing log file at WED FEB 22 09:19:17 2012.
:
************************************************** *****
************************************************** *****

I figured those 2 messages were related and the 2nd must be the result of
the 1st.:
[C078] Dynamic library 'NVDB_RMS' was not found
[C077] Could not find symbol 'ADD-RMS' in dynamic library

I guessed that 'NVDB_RMS' must be a logical name pointing to the library
containing the ADD-RMS routine. Such logical name was not defined.
After some research I found that ORA_ROOT:[lib32]hsdb_rms.exe contained
ADD-RMS so I went

$ define/sys/exec NVDB_RMS ORA_ROOT:[lib32]hsdb_rms

and did a test again. This time there is no error message, it simply sits
there and wait (in SQLPLUS)

Now looking up the process with $ ANALYZE/SYSTEM it shows that the library
is called, and the other associated programs and libraries are loaded, but
it just goes into circles (only CPU, no IO).
No trace or log are written to.

I just don't know what to do next, still researching.
Metalink apparently had everything removed regarding this product which is
not supported for a while.

If you are using it, or the 10gR1 flavor, let me know. You can contact me
directly by removing zulu from my email address.

BTW I patched this installation to 9.2.0.7 but it did not re-link this
particular product and it looks like no patches apply to it.

Thanks !

Syltrem

On Feb 22, 9:35*am, "Syltrem" <syltremz...@videotron.ca> wrote:
> Hi
>
> We're trying to move an application to Windows (from VMS) but it is
> currently accessing a few RMS files (native indexed filesystem on VMS).
> While finializing the conversion (lots of programming to do) which may take
> a few more months, we'd like to do the port and maintain accessibility of
> the RMS files by using the Transaparent Gateway for RMS

I have never paid attention to this product and probably should have.
(http://docs.oracle.com/html/B10538_01/ch2.htm#i40200)
It appears to based on the Attunity Connect product.

There are likely to be LOG files with details in a [.TMP] directory,
parallel to a [.DEF] directory.

Has it ever worked for you?
What changed? SYLOGIN? Logicals?

You may want to try a brute force solution:
use MCR DFU SEARCH/FILE=NVDB_RMS.EXE
Once found, define a system logical to point there and try again?


Btw... you may want to check out Attunity's RMS-CDC offering.
And can help you keep an Oracle Database up to date in (near) real
time with changes made to RMS (indexed) files.

Hope this helps some,
Hein van den Heuvel
Attunity

In article <x271r.78645$Xo4.16461@en-nntp-13.dc1.easynews.com>, "Syltrem" <syltremzulu@videotron.ca> writes:
>Hi
>
>We're trying to move an application to Windows (from VMS) but it is
>currently accessing a few RMS files (native indexed filesystem on VMS).

It's obviously not an important or critical application.

Can't offer you much help with Transparent Gateway but you might want
to take a look at Attunity's offerings of this doesn't work for you.

--
VAXman- A Bored Certified VMS Kernel Mode Hacker VAXman(at)TMESIS(dot)ORG

Well I speak to machines with the voice of humanity.

Syltrem wrote 2012-02-22 15:35:
> Hi
>
> We're trying to move an application to Windows (from VMS) but it is
> currently accessing a few RMS files (native indexed filesystem on VMS).
> While finializing the conversion (lots of programming to do) which may take
> a few more months, we'd like to do the port and maintain accessibility of
> the RMS files by using the Transaparent Gateway for RMS
>

This is "*Oracle* Transaparent Gateway for RMS", right?

Not "Rdb Transaparent Gateway for RMS" that us part of the
(now de-supported) DBI (Database Integrator) package?

Just to clearify...

I have done some testing/reading around the Rdb product for
similar needs, but never got the itme to actualy set it up.

Jan-Erik.


> I set it up using the guide, but something must be missing in the config as
> I get errors when trying to register a file definition :
>
> SQL> exec dbms_tg4rms.addl_to_add('IVAF001.ADL','tg4rms')
> BEGIN dbms_tg4rms.addl_to_add('IVAF001.ADL','tg4rms'); END;
>
> *
> ERROR at line 1:
> ORA-04053: error occurred when validating remote object
> ORACLE9205.DBMS_HS_PASSTHROUGH@TG4RMS
> ORA-00604: error occurred at recursive SQL level 2
> ORA-28500: connection from ORACLE to a non-Oracle system returned this
> message:
> [Transparent gateway for RMS]ADD-RMS
> ORA-02063: preceding 2 lines from TG4RMS
> ORA-06512: at "SYS.DBMS_TG4RMS", line 33
> ORA-06512: at line 1
>
> I enabled tracing with HS_FDS_TRACE_LEVEL=ON and the trace file shows
>
> ************************************************** *****
> ************************************************** *****
>
> Oracle Corporation --- WEDNESDAY FEB 22 2012 09:19:16.797
>
>
> Heterogeneous Agent Release
> 9.2.0.5.0
>
>
> [C078] Dynamic library 'NVDB_RMS' was not found
>
>
> PATH = ora$disque:[oracle9205]
>
>
> [C077] Could not find symbol 'ADD-RMS' in dynamic library
>
>
> [Transparent gateway for RMS] version: 3.3.00.00.0040
> Setting NAVDEF to ora_tg4rms_dd
> connect string is: defTdpName=TG4RMS;SYNTAX=(ORACLE8_HOA, BASED_ON=ORACLE8,
> IDENTIFIER_QUOTE_CHAR="",
> CASE_SENSITIVE=CASE_SENSITIVE_QUOTE);BINDING=<navo bj>
> <binding>
> <datasources>
> <datasource name='TG4RMS' type='ADD-RMS' connect='ora_tg4rms_dd'
> readOnly='true'>
> <driverProperties/></datasource></datasources><remoteMachines/><environment>
> <misc year2000Policy='-1' consumerApi='1'
> sessionBehavior='4'/><queryProcessor
> parserDepth='2000' noInsertParameterization='true'
> noThreadedReadAhead='true'/></environment></binding></navobj>
> ORACLE RMS GATEWAY Log File Started at 22-Feb-12 09:19:17
> ADD-RMS
>
> Closing log file at WED FEB 22 09:19:17 2012.
> :
> ************************************************** *****
> ************************************************** *****
>
> I figured those 2 messages were related and the 2nd must be the result of
> the 1st.:
> [C078] Dynamic library 'NVDB_RMS' was not found
> [C077] Could not find symbol 'ADD-RMS' in dynamic library
>
> I guessed that 'NVDB_RMS' must be a logical name pointing to the library
> containing the ADD-RMS routine. Such logical name was not defined.
> After some research I found that ORA_ROOT:[lib32]hsdb_rms.exe contained
> ADD-RMS so I went
>
> $ define/sys/exec NVDB_RMS ORA_ROOT:[lib32]hsdb_rms
>
> and did a test again. This time there is no error message, it simply sits
> there and wait (in SQLPLUS)
>
> Now looking up the process with $ ANALYZE/SYSTEM it shows that the library
> is called, and the other associated programs and libraries are loaded, but
> it just goes into circles (only CPU, no IO).
> No trace or log are written to.
>
> I just don't know what to do next, still researching.
> Metalink apparently had everything removed regarding this product which is
> not supported for a while.
>
> If you are using it, or the 10gR1 flavor, let me know. You can contact me
> directly by removing zulu from my email address.
>
> BTW I patched this installation to 9.2.0.7 but it did not re-link this
> particular product and it looks like no patches apply to it.
>
> Thanks !
>
> Syltrem
>
>

On Feb 22, 10:25*am, Hein RMS van den Heuvel
<heinvandenheu...@gmail.com> wrote:
> On Feb 22, 9:35*am, "Syltrem" <syltremz...@videotron.ca> wrote:
:
> You may want to try a brute force solution:
> use MCR DFU SEARCH/FILE=NVDB_RMS.EXE
> Once found, define a system logical to point there and try again?
:

Oops, i now see to already tried that and got further.
And it looks like you used SDA> SHOW PROC/CHAN to 'see' the open files
and found no LOG files. Darn.
It should have GW*.NOS files open as data dictionary.

In the mean time I received confirmation that this gateway is a an
read-only OEM version for the Attunity 'AIS' offering, long out of
contract/support.
It may be more productive to investigate a current ODBC , JDBC or
ADO.Net connection to RMS offering (preferably from Attunity :-)
I also suspect that Change Data Capture is a more convenient (more
reliable) way to deal with this transition situation.
Attunity may be able to come up with a limited duration license deal
for either approach.

Hope this helps,
Hein.



>
> Btw... you may want to check out Attunity's RMS-CDC offering.
> And can help you keep an Oracle Database up to date in (near) real
> time with changes made to RMS (indexed) files.
>
> Hope this helps some,
> Hein van den Heuvel
> Attunity

On Feb 22, 5:17*pm, Jan-Erik Soderholm <jan-erik.soderh...@telia.com>
wrote:
> Syltrem wrote 2012-02-22 15:35:
>
> > Hi
>
> > We're trying to move an application to Windows (from VMS) but it is
> > currently accessing a few RMS files (native indexed filesystem on VMS).
> > While finalizing the conversion (lots of programming to do) which may take
> > a few more months, we'd like to do the port and maintain accessibility of
> > the RMS files by using the Transparent Gateway for RMS
>
> This is "*Oracle* Transparent Gateway for RMS", right?
>
> Not "Rdb Transparent Gateway for RMS" that us part of the
> (now de-supported) DBI (Database Integrator) package?
>
> Just to clarify...
>
> I have done some testing/reading around the Rdb product for
> similar needs, but never got the time to actually set it up.
>
> Jan-Erik.

The Database Integrator (DBI) package can be downloaded (see bottom of
page) from OTN here...
http://www.oracle.com/technetwork/da...ads/index.html
Important: DBI V7.0.2 for OpenVMS 7.3-x to 8.3-x is provided as-is,
without Support or commitment to new releases.

Cheers!

Keith Cayemberg

"Jan-Erik Soderholm" <jan-erik.soderholm@telia.com> wrote in message
news:ji34ds$8ji$1@news.albasani.net...
> Syltrem wrote 2012-02-22 15:35:
>> Hi
>>
>> We're trying to move an application to Windows (from VMS) but it is
>> currently accessing a few RMS files (native indexed filesystem on VMS).
>> While finializing the conversion (lots of programming to do) which may
>> take
>> a few more months, we'd like to do the port and maintain accessibility of
>> the RMS files by using the Transaparent Gateway for RMS
>>
>
> This is "*Oracle* Transaparent Gateway for RMS", right?
>

Yes

>
>> Syltrem
>>
>>
>

"Hein RMS van den Heuvel" <heinvandenheuvel@gmail.com> wrote in message
news:4ce95e4a-0ff4-49c1-bd7d-a297e35fc44f@w5g2000vbv.googlegroups.com...
On Feb 22, 10:25 am, Hein RMS van den Heuvel
<heinvandenheu...@gmail.com> wrote:
> On Feb 22, 9:35 am, "Syltrem" <syltremz...@videotron.ca> wrote:
:
> You may want to try a brute force solution:
> use MCR DFU SEARCH/FILE=NVDB_RMS.EXE
> Once found, define a system logical to point there and try again?
:

>>Oops, i now see to already tried that and got further.
>>And it looks like you used SDA> SHOW PROC/CHAN to 'see' the open files
>>and found no LOG files. Darn.
>>It should have GW*.NOS files open as data dictionary.
>>
>>In the mean time I received confirmation that this gateway is a an
>>read-only OEM version for the Attunity 'AIS' offering, long out of
>>contract/support.
>>It may be more productive to investigate a current ODBC , JDBC or
>>ADO.Net connection to RMS offering (preferably from Attunity :-)
>>I also suspect that Change Data Capture is a more convenient (more
>>reliable) way to deal with this transition situation.
>>Attunity may be able to come up with a limited duration license deal
>>for either approach.
>>
>>Hope this helps,
>>Hein.
>>
>>

The app needs to see the ROWID. We tried the Connx ODBC but it doesn`t have
the ROWID.

I may try the Oracle 10.1 version and see if I can get this one to work
instead.

The Attunity product is interesting but probably too costly for this. We
will probably change the app that writes to RMS to instead write to Oracle,
albeit temporarily, to alleviate the problem. The RMS app will be completely
rewritten in the course of this year.

>
> Btw... you may want to check out Attunity's RMS-CDC offering.
> And can help you keep an Oracle Database up to date in (near) real
> time with changes made to RMS (indexed) files.
>
> Hope this helps some,
> Hein van den Heuvel
> Attunity

"Syltrem" <syltremzulu@videotron.ca> wrote in message
news:x271r.78645$Xo4.16461@en-nntp-13.dc1.easynews.com...
> Hi
>

SNIP

>
> I figured those 2 messages were related and the 2nd must be the result of
> the 1st.:
> [C078] Dynamic library 'NVDB_RMS' was not found
> [C077] Could not find symbol 'ADD-RMS' in dynamic library
>
> I guessed that 'NVDB_RMS' must be a logical name pointing to the library
> containing the ADD-RMS routine. Such logical name was not defined.
> After some research I found that ORA_ROOT:[lib32]hsdb_rms.exe contained
> ADD-RMS so I went
>
> $ define/sys/exec NVDB_RMS ORA_ROOT:[lib32]hsdb_rms
>
> and did a test again. This time there is no error message, it simply sits
> there and wait (in SQLPLUS)
>
> Now looking up the process with $ ANALYZE/SYSTEM it shows that the library
> is called, and the other associated programs and libraries are loaded, but
> it just goes into circles (only CPU, no IO).
> No trace or log are written to.
>
> I just don't know what to do next, still researching.

Well I tried to upgrade my installation to 9.2.0.8 (latest available).

It did fix the problem I already found and added the missing logical name in
ORA_ROOT:[tg4rms]tg4rmsuser.com
But the result is the same (process gets into an infinite loop)

So I'm still with a broken thing at this point

Syltrem