mardi 23 août 2011

1/2 - Database Compare Report duration example between Vanilla 9.0 and Production 9.0

When you upgrade a PeopleSoft Application you need to execute Compare report to define which objects you want to keep or upgrade.
This is also very valuable to understand what was customized by your Company.
But the full database compare process can take some time that you need to plan ... here is an example by object types in hour, for a total of 4 hours and 34 minutes.

Note: in step 2/2 we will compare a Vanilla HRMS 9.1 and Production HRMS 9.0

Here is the detailed duration for Compare report between Vanilla HRMS 9.0 and Production HRMS 9.0:
Pages    1:27
Records    0:58
Fields    0:22
SQL    0:19
Record PeopleCode    0:12
Style Sheets    0:11
Application Engine Sections    0:09
Permission Lists    0:08
Translate Values    0:05
Components    0:05
Messages    0:04
Subscription PeopleCode    0:03
Process Definitions    0:02
Images    0:02
XSLT    0:02
Queries    0:02
HTML    0:02
Component Rec Fld PeopleCode    0:02
Application Package PeopleCode    0:02
Component Interfaces    0:01
Page Field PeopleCode    0:01
Service Operation Versions    0:01
XMLP Data Src Defn    0:01
Indexes    0:01
Menus    0:01
Server Definitions    0:01
Component Record PeopleCode    0:01
URL Definitions    0:01
Service Operations    0:01
Service Operation Routings    0:01
XML Document    0:01
Tree Structures    0:01
Application Engine Programs    0:01
Page PeopleCode    0:01
WSRP Remote Producers    0:01
XMLP Template Defn    0:01
Field Formats    0:00
Menu PeopleCode    0:00
Activities    0:00
Business Processes    0:00
Colors    0:00
Styles    0:00
Business Interlink    0:00
File Layout Definitions    0:00
Job Definitions    0:00
Process Type Definitions    0:00
Recurrence Definitions    0:00
Application Engine PeopleCode    0:00
Approval Rule Sets    0:00
Comp. Interface PeopleCode    0:00
Message Channels    0:00
Message Nodes    0:00
Message PeopleCode    0:00
Component PeopleCode    0:00
Application Packages    0:00
Analytic Types    0:00
Archive Templates    0:00
CI Property PeopleCode    0:00
File References    0:00
Optimization Models    0:00
Relationships    0:00
Analytic Models    0:00
Archive Object Definitions    0:00
Archive Templates (Type 2)    0:00
File Type Codes    0:00
Java Portlet User Preferences    0:00
Services    0:00
WSRP Cloned Portlet Handles    0:00
WSRP Remote Portlets    0:00
Service Operation Handlers    0:00
IB Queues    0:00
XMLP File Defn    0:00
XMLP Report Defn    0:00
Message Schemas    0:00
WSDL    0:00
Connected Query Definitions    0:00
Dependency Documents    0:00
Document    0:00
Document Schema    0:00
Relational Document    0:00

0 tables displayed with error message o.d.db.DBUtil closed connection in SQL Developer 3.0.04


Whe I try to list the tables in my PeopleSoft SYSADM schema, no tables are listed and I have the following error message: o.d.db.DBUtil closed connection

SEVERE
65
0
oracle.dbtools.db.DBUtil
Warning, unhandled exception: Closed Connection

The problem occurs when SQL Developer 3.0.04 connects to a limited privilege schema via a shared server connection. The workaround is to connect using a dedicated server connection.

for reference:
BUG 12382135 - NO TABLES SHOWN IN NAV has been fixed and will be available in the next released version

How to start Gnome Connection Manager in English

Gnome Connection Manager is very nice tool, with interesting Cluster feature to manage a Cluster of servers.
On Solaris 11 Express, The LANGUAGE env parameter is not set, and the tool always start in Spanish.
If you want to run it in English, just run the following command line :

LANGUAGE=en_US:en /opt/gcm-0.9.4/gnome_connection_manager.py