Schema Creation failing due to Juniper firewall parameter
Last Updated July 23, 2011
Here's the situation:
1) Oracle database installed with dbt, protect user created using oracle_create_user.sql script, no errors in the alert.log
2) multi-tier system, Enforce to be installed on a Windows server.
3) Juniper firewall appropriately configured to allow communication on designated DLP/Oracle ports.
When the installer is run, it gets as far as "Schema creation". This runs numerous, large SQL scripts that create the objects to be used by DLP. Part way through the run, the installer stops. There are no errors either involving Oracle or the install. The install log simply seems to stop mid-create. The point where the install script fails may differ between attempts.