Skip to Main Content
Forums

SQL & PL/SQL

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

PL/SQL & Form Builder

561207Feb 11 2007 — edited Mar 4 2007
Hey

I used Oracle 8i when i was at uni to develop databases using PL/SQL and Form Builder. I was able to purchase Oracle 9i a few years so that i could practice my developing skills. Now i do not know what has happened to the Oracle 9i i bought, probably got misplaced when i moved house.
Does anyone know where i can purchase it from or download it from?
I need PL/SQL to program and create my tables and Form Builder to have the front end to link to my tables.

Any help would be most appreciated.

Kind Regards
Zak

Comments

jevans2017

Please take a look at the following.

SOLUTION

An in-depth review of the network between the HFM application server(s) and the database server(s) is required to identify the cause of the dropped or reset connections.

Workaround:

On Oracle databases, if a firewall or load balancer is between tiers, tune the parameters for Dead Connection Detection (DCD) at the database side (SQLNET.EXPIRE_TIME). In ORACLE_HOME/network/admin/sqlnet.ora file set DCD interval.  Interval should be set to at least half the idle connection timeout to ensure connection remains active.  So if idle timeout is 30 minutes, set the DCD interval to 15 minutes eg:

   sqlnet.expire_time = 10

More details about DCD can be found in Resolving Problems with Connection Idle Timeout With Firewall Document 257650.1

Thanos A

Hi there,

We have similar issues but we have not managed to identify the issue.

Try to confirm if 2 or more consolidations were running at the same time in the same POV.

Cheers,

Thanos

iArchSolutions-Joe
Answer

@"983332"  and @"Thanos A." - What release of HFM are you running?  11.1.2.4.???  .200-.208?

Have you checked out this KB article yet for any applicable issues?

Oracle Support Document 2408794.1 (Hyperion Financial Management (HFM) Performance Slow and Tasks Fail or Abort with Errors in System Messages: "Database connection failure" "Stale DB connection found!! Replaced with new DB connection." "Wait time expired. Block") can be found at:

https://support.oracle.com/epmos/faces/DocumentDisplay?id=2408794.1

Can you provide any more details on the issue?  Any event log snippets, etc?  Please ensure you cleanse anything client specific though before posting.

Let us know if we can help!

Kind Regards,

Joe Malewicki

Please remember to click “Mark as Answered” on the post that helps you.  This can be beneficial to other community members reading the thread.

Marked as Answer by User_138K0 · Sep 27 2020
1 person found this helpful
user8824552

Does anyone still have the Oracle document  Document 2408794.1? We have the same issues, but I don't seem to have access to this document.

Thanos A

Hi all,

We had this issue with 205 and I think that this issue is fixed in 206.

Unfortunately, this document is not accessible to me.

Cheers,

Thanos

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

Post Details

Locked on Apr 1 2007
Added on Feb 11 2007
4 comments
546 views