- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Forms3.0 with Oracle8i
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-20-2005 05:07 PM
тАО10-20-2005 05:07 PM
Forms3.0 with Oracle8i
We plan to upgrade our Database to Oracle 8i or 9i on IBM AIX 5L.
I have tested the connection with oracle 8i and 9i , but it doesn't work, I obtain:
"ORA-03113 end-of-file on communication channel"
The Forms30 and the oracle 9i are on the same server, but in different HOME.
I am using BEQ protocol adapters and TWO_TASK to connect the sqlforms30 to oracle9i.
I've references that this work fine.
anybody help me with this issue.
Thanks!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-21-2005 01:07 AM
тАО10-21-2005 01:07 AM
Re: Forms3.0 with Oracle8i
I have upgraded a 7.3.4 database to 8i and was still able to access forms3.0 and forms 4.5.
When you login as the user accessing forms are all your environment variables still pointing to the 7.3.4 Oracle Home.
Also can you login to sqlplus from the forms user account (using the TWO_TASK setting).
You may want to setup the TCP protocol instead of BEQ when going from Forms 3.0 to Oracle 8i.
Patti
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-21-2005 01:48 AM
тАО10-21-2005 01:48 AM
Re: Forms3.0 with Oracle8i
we have been using form30 with oracle 8i and tested ok with oracle9i.
however, with oracle 10g, it does not work at all!
these configuration is indeed not supported by Oracle since long ago.
good luck
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-21-2005 06:47 AM
тАО10-21-2005 06:47 AM
Re: Forms3.0 with Oracle8i
I also tried with TCP protocol, but still the problem persist.
I've two HOME, one for the Oracle9i and other for the forms30. The forms30 has the environment variable of the Oracle 7.3.
I believe that problem is the characterset of my database Oracle9i.
The runtime forms work fine.I tested some of our forms built in forms30 also work fine, but the sqlforms has problem and shows the ORA-03113.
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-07-2005 02:03 AM
тАО11-07-2005 02:03 AM
Re: Forms3.0 with Oracle8i
We also had this problem. We used the WE8ISO8859P15 Character set in the 9i database. Had to change it to WE8ISO8859P1:
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 WE8ISO8859P1;
shutdown immediate
startup
Best regards
Josef