Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.2K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 436 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Oracle Form 6i With Oracle Database 19c
We have some some running in oracle forms 6i. We have recently upgraded database from 11g to 19c.
How, we can connect oracle forms 6i to Oracle Database 19c.
Sir @Michael Ferrante-Oracle Could u Please guide in this regard.
Answers
-
If you cannot upgrade your Forms modules, then you can try your luck using the
SQLNET.ALLOWED_LOGON_VERSION_SERVER parameter:
However I have never used this parameter myself, so I cannot advise you on its correct use.
-
It's time to upgrade your 20+ year old version of Forms to a new version. If you want to use a new DB, a new OS, or a new anything, you need to upgrade. Trying to use old and obsolete software versions against or on top of modern versions of its dependencies is extremely risky and something I would not do with production data. I especially would not do it with mission critical applications.
Michael Ferrante
Senior Principal Product Manager
Oracle
Twitter: @OracleFormsPM
-
Finally I made Developer6i with patch 9 working just fine with OracleXE21c. So here what I have done and hope it will work with everyone
on fresh installation
1) Install oracleXE-21c (I Installed it on Windows 10-64 bit)
2) Install Developer6i and you can install patch 19 or lower (I installed patch 9)
3) configure tnsnames.ora in Developer6i (C:\Developer6i\NET80\ADMIN\tnsnames.ora) as same as on tnsnames.ora in OracleXE(C:\oracle\product\21c\homes\OraDB21Home1\network\admin\tnsnames.ora)
4) connect to database AS SYSDBA and run the following commands
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8;
SHUTDOWN;
STARTUP RESTRICT;
SHUTDOWN;
STARTUP;
5) Make changes on sqlnet.ora which belong to the database (C:\oracle\product\21c\homes\OraDB21Home1\network\admin\sqlnet.ora) and add the following
SQLNET.AUTHENTICATION_SERVICES=(NTS)
NAMES.DIRECTORY_PATH=(TNSNAMES, EZCONNECT)
SQLNET.ALLOWED_LOGON_VERSION=8
6) on sqlnet.ora which belong to Developer6i (C:\Developer6i\NET80\ADMIN\SQLNET.ORA) add the following
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
Important Note: if you import data from backup then once completed you may need to alter user account again to make Forms Builder able to connect with OracleXE 21c. Hint: I was trying many times to connect after done all settings above and it was failing stating ORA-01017: invalid username/password; logon denied so I alter user
alter USER HR IDENTIFIED BY HR ACCOUNT UNLOCK;
Hope this work with everyone who is looking for solution
let me know your feedback
Wish everyone good luck
-
Regardless of whether or not this appears it can be made to work, I would strongly discourage attempting to do something like this in a business environment. Further, the idea of continuing to use 20+ year old software in a business is extremely risky, especially when that software is handling company, customer, and possibly employee data (some of which is often sensitive).
Michael Ferrante
Senior Principal Product Manager
Oracle
Twitter: @OracleFormsPM
-
Yes I agree dear
but most likely people develop light weight systems using such as Developer6i tool as front end. it's powerful and light. it depends weather you running the system online or internal in small or mid size companies.