Migration to Uniface 9.4 and Oracle 11g - configuratin

Author: arialds.trankals@gmail.com (ArT_LV)

Hi, all,
I read this forum and articles as careful as possible...
This may be the right place to post this topic.
We are migrating client/server application from Uniface 8 + Oracle 10 to Uniface 9 and Oracle 11.
This application was developed under Uniface 7 and deployed to production in the middle of 90’s. Then we successfully migrate this application to Uniface 8. And till today there is no substitution for this on the market – so client is forced to migrate this stuff to Uniface 9 and Oracle 11.
The funny point is – till today – we were not in deal with Uniface administration. This task was complete covered by client and it works fine.
Today – client IT side is reorganized in a way – there is no UNIFACE competence on board...
We got access to preinstalled Uniface 9.4 environment with SOLID db as repository (Oracle was or previous repo) and ORACLE 11g.
We can access this environment using Citrix Metaframe.
We imported the application code, compiled it, fixed bugs and warnings and ... STOP!
We are struggling now with configuration tasks without any experience in Uniface admin...
The old configuration used polyserver. According to customer requirements we couldn't use in the new environment polyserver.
And – we don’t really know – where to start...
May be we can there perform something like – STEP-by-STEP configuration exercise?
First Step – under control of experts I will answer questions (show asn/ini files etc), and define the initial conditions. Because everything was preinstalled – may be there is something – what was important during installation as well – let’s discuss and describe these aspects there as well. I can ask client to answer questions or look for answers – when is clear what for and where to look :)...
And then – based on Your suggestions we will try to let or grandma-application run again :)...
If You like to help me doing this way – I’m quite sure at the end we will have a good and tested configuration tutorial – which may be interesting not only for me and for sure is missing for me today...
This is not a „DO IT FOR ME and FOR FREE” style request. We spent about 2 weeks reading books and performing experiments without any success, it’s not easy to be stupid :)...
And – sorry about my English, I’m working on it...




  1. Hi,

    If I understand correctly your customer used Polyserver and now does not want it anymore?
    That is possible but you will have to access your data through other middleware.
    In your case that will be Oracle Client, which you have to install on the PC's where the application is run from.
    Look in the psv.asn file what Oracle database and password were used and which connector options were used.
    Now change the application asn file so data access is no longer done via polyserver but "directly" to Oracle.
    ("directly" because Uniface won't notice that Oracle Client is in between)
    When implementing the connector options in your application asn file please read your Uniface documentation, some options will have changed from Uniface 7 to Uniface 9.

    That was my free advice, now a commercial message:
    - Compuware offers an Enviroment Management training where you can learn all about these things.
    - Compuware has consultants that can come to you and help you fix this.

    With kind regards,

    Theo Neeskens
    Uniface Solution Architect

    Author: Theo Neeskens (tneeskens@itblockz.nl)
  2. Thank You for Your replay!

    The point  is - both development and production environments for UNI8+ORA10 are located in one data center where UNIX was used, but the new environments are created in dofferent data center starting from scratch and running pure Windows. So there is no discussion about like or not like to use poly - poly is just not there.

    The new middleware suuposed to be in use is SQL*NET.

    And - thank You for pointing me to commertial info sources. I'm sure - its will be useful for custumer IT operations guys - I will be just happy to have running and ORACLE accessing dev and test environments - accessable through Citrix.

    So the first question is - during installation - do there some ORACLE specific options should be set - or all ORACLE access specific configurations are possible - after installation is completed for SOLID DB only? Same question is valid regarding TXT driver for ASCII file access?

    Author: ArT_LV (arialds.trankals@gmail.com)
  3. Ok, there are the first results now.

    For Oracle 11R1 we have the uora63 driver and for Oracle 11R2 we have the uora64 driver.
    An example for Oracle 11R1:
    ORA U6.3

    All samples I saw - used maximum U6.1 ... Mnemoniq U6.3 - I got first time in mail from Peter Beugel. Thx a LOT!

    Fine - we have 11gR2, but the driver we can find on customers maschine is U6.3 ( uora64.dll - NOT FOUND ) - but from IDF side with SQL Workbench - I can see my data from ORACLE DB now. Corresponding client ASN file section.

    ==========> !!!   The 6.4 driver was added in patch R102 only !!! ( thankYou again - Peter! )

    USYS$ORA_PARAMS   oc 250, dhfr , nclob_ext
    $ORA1 = ORA:SERDEV_RZ3|username|password
    $ORA2 = ORA:SERDEV_RZ3|username|password

    Now - the next step is - ro find a sample with repository in SOLID DB, but Data in ORACLE. Starting application from IDF - debug showed the correct created SQL statement - but it is sent to SOLID DB not ORACLE. Attempt explicit map entities to PATH - dont help:

    *.SER = ORA1:*.SER

    Follow with reading the books... :)

    Thx again!

    Author: ArT_LV (arialds.trankals@gmail.com)
  4. Maybe try to redirect the default pathes like:

    $IDF     SOL:xxx

    $DEF   ORA:xxx

    $SYS   ORA:xxx

    Maybe this helps

    Best regards


    Author: Thomas.Young (thomas.young@young-consulting.de)