Skip to Main Content
Forums

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!

Oracle Gateway for ODBC Listener does not get created after install

tx103108Aug 23 2012 — edited Aug 28 2012
O/S: Windows 7 64-bit
DB: Oracle XE 11.2
Gateway: Oracle ODBC 11.2
==================

When installing the Oracle Gateway for ODBC on one Windows 7 system, everything works fine.
However, after installing the Oracle Gateway for ODBC on another Windows 7 system, the Gateway listener does not exist/appear as a service.
I noticed that on the second install there were no REGISTRY_KEY values for the Gateway installed under HKEY_LOCAL_MACHINE->SOFTWARE->Oracle.
Has anyone experienced this? What could be the cause?
Thanks.

Comments

Billy Verreynne

Oracle APEX with Oracle ORDS are good alternatives, and are no-cost options too.
ORDS (Java web app) can be run in Apache Tomcat - an Open Source minimal/no-cost option.

Wayne_Duke

@billy-verreynne thanks for this, I have been looking at a number of products that can I could use, but what I seem to remember being at an Oracle event/webinar where there where it was mentioned that as we are paying a forms and report license, we could use some form of Oracle BI publisher without additional cost

Michael Ferrante-Oracle
Answer

To be very clear, Oracle Reports is NOT planned to be desupported at this time. It has merely been deprecated, which is not at all the same as desupported. This simply means that no new features are planned for it going forward unless changes are required to make it compatible with whatever new stack contains it.
The recommended migration is Analytics Publisher (previously BI Publisher). If you already have proper licensing to use Oracle Reports and are using a Supported version, your license includes entitlements to use it (Analytics Publisher), at no additional cost. Refer to the FMW Licensing Guide for a more official reference. Also, contact your Account Representative or Oracle Sales for the latest information.
https://docs.oracle.com/en/middleware/fusion-middleware/fmwlc/
Regarding the use of APEX as a "reporting" tool, I would recommend caution. APEX is not a reporting technology. Although it does have some basic reporting functionality, it may not meet the needs of more complex reporting requirements that can be easily and more appropriately handled by actual "reporting" technologies like Analytics Publisher and others.

Marked as Answer by Wayne_Duke · Apr 14 2021
1 person found this helpful
Wayne_Duke

Hi @michael-ferrante-oracle thanks for the clarification and the information on Analytics Publisher, that was what I remembered you saying, but when we tried asking our accounts team they didn't seem aware of it so the link will be very useful.
With regards to the current state of Oracle reports, I understand we are at the terminal release and reviewing the statement of direction of reports its says "Oracle is not planning any functional enhancements for Oracle Reports in its terminal release, or any subsequent releases, if any." The "if any" intimates that following versions of Oracle forms may not have reports included or am I misunderstanding the statement?

regards
Wayne

@wayne-duke1
I had written a three paragraph lengthy answer to your question then decided it might not be a good idea to share my entire opinion here. Feel free to contact me privately and maybe I can help explain.
In short, a formal commitment has not yet been made regarding the inclusion of Reports in the next FMW release.

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 25 2012
Added on Aug 23 2012
#heterogeneous-connectivity
2 comments
251 views