Friday, December 22, 2017

Highway For Oracle Apex 


    In the name of Allah, Most Gracious, Most Merciful
Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,

       May be you are anxious to try Oracle Apex by yourself. This article mainly presents to you a high way to Oracle Apex.
     It offers you a free Oracle Apex work space to try it yourself easily and  simply. 
       Let's follow the next steps below you will be able to feel and taste the beauty and capabilities of this wonderful technology.    


Task Definition:   


Create a new free Oracle Apex workspace. 
Hence, i will share all the difficulties i faced and discuss it with you.


Task Solution:
  •      Created a new email for the new work space 'Demoo' as follow...
  • Go to Oracle Apex official web site https://apex.oracle.com/en/



  • Scroll down to the end of the page & press Get Started Button.



  •  The following page will be displayed > Press Free Work Space.

  •  The 'Request a Work space' page will be displayed > press Application Development button as it is set by default.


    • Press the Next Button > the following wizard steps displayed.
    • I completed the * required work space fields with the name i preferred but i got the following error since the name of the works pace is not unique. 
            Note: The work space  name has to be unique as your email account.                           This definitely helps ORACLE  to distinguish between your work space and other thousands of  its active work spaces. By default, The work space name is capital Letter.
            The red error message will not disappeared until you rewrite a unique name and press next.  I changed the works pace name as ' Demoo'.
    •  After rename the work space, i noticed that the web page didn't respond to any modified changes unless i press next button. In other words, when i manually closed the red rectangular message box located at the upper right side of the page there is no validation occurred against my new work space name...! 
    • I wonder, why still this red warning message exists under the work space name text box why it didn't disappear ?!!
    •   I pressed Next the work space wizard asks for the schema name to build it's default database objects. The schema name also has to be unique otherwise you will get an error the same as work space.
    •  It has a space allocation of  25MB which is temporary suitable for training, tests and further more for client's demonstrations.
    Note: At this stage i encountered problems with my internet connection, my lab had disconnected and the page step disappeared. Thanks to Allah, when i refresh the current page i got the current lost step back.

    • I rewrite the previous schema name i wrote before the internet dis-connection but it  was rejected, i don't know why may be the work space consider it invalid.
    • I rewrite another schema name 'OTT' for Oracle Training Tasks then press Next it accept the name and move forward to the next installation step.

    •  The next wizard step is a survey for ORACLE that gives you the right to accept or reject it. You can read Oracle rules and accept it to go on in creating the work space creation process steps. 
    • Check your check box preferences and press NEXT button.


    •  The following screen is just an agreement between  you and Oracle you must to check the check box to continue to Oracle Free Work Space.

    •  The following screen is a summary screen shoot that summaries all your input data  for the work space, schema and other Oracle work space related information etc.

    •   The following screen informs you that you have successfully create the work space. At this stage, when you press the blue button it is supposed to let you set the work space password. But, once again the internet is dis-connected.  
    • Due to my internet disconnection i faced an issue for missing the setting of  my password for the first time. Then i press reset password.

    •   I have just received the email for setting my password in less than a minute. The email contains:  The new work space as follow:
    • Workspace: DEMOO
      Username
      : APEX_DEMOS@HOTMAIL.COM
      Reset Password URL
      : Get it from the email screen shoot



    • I copied the given URL sent by ORACLE then paste it in the url browser
    • Then, set the new password as 'OTT' and conform it as 'OTT'.
           'OTT'  stands for Oracle Training Tasks
    •   I pressed 'Apply Changes' button. It starts to process the credential as follow..

    • Finally, we successfully log-in into Oracle apex Free Work Space. 

          Now, welcome you to Oracle Apex World ...!

    Add the following url to your browser favorite as a short cut to easily invoke your Free Work Space any time 
    Url:https://apex.oracle.com/pls/apex/
    Work Space:  DEMOO
    User : apex_demos@hotmail.com
    Pass Word: OTT
    Now, let's decide your new career path.    
     Enjoy it !
    Learn more about:

    ·        

    Hope this helps...

    My success only comes from Allah, pls. note your comments and suggestions are great help for me in progress thanks in advance.




    Thursday, December 21, 2017


    Oracle Forms 10G Installation
     On Windows 8.1 & Windows 10 64 bit



     In the name of Allah, Most Gracious, Most Merciful
    Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,


                 I believe that there is always a need to install Oracle  Developer Suite 10G. It is the most reliable version that lasts up to now. Although, Oracle is no longer support Oracle Developer Suite 10G is always available for download from Oracle Official Site for the need of Oracle Designer.
          
          The problem is Oracle  Developer Suite 10G is an old version which currently IS Microsoft Windows 8.1 Operating System.   NOT designed to run On  
      Even though, Oracle doesn't support it. But the old applications are still running and 
    the need for Oracle Designer is still increasing. 
    That's what push us forward to illegally create some work around  (May Allah Forgive Us ) to cope with the new Operating System progress and save our clients' running applications at least for now. Then, we can think seriously to upgrade our client's application to the new technology.


    Task Definition:   

        Oracle Developer Suite 10G Installation On Windows 8.1 64 bit


    Concept Solution:

         Let's recognize how Oracle Developer Suite installer works...

          The installer's job is to do an automatic prerequisite check on your computer before starting the installation process...

                
                   1.    Verify that the minimum swap space is available
                   2.     Verify the minimum CPU speed
                   3.     Verify Operating System requirements

        

             It gives you its feed back after each check either 'passed' or 'failed' .

             If the passed then the installation process will go forward to the next step.

             If failed then the installation process will stop.
            
           Today, we are concerning about the third step of the verification process. 
    If the Micro-Soft Windows 8.1 64 bit Operating System check  failed as a result of  the  incompatibility What will we do ? Please follow the suggested task solution steps. 


    Task Solution: 

    •  Right click on the Installer icon and  select Run as administrator.

     

    •  The Oracle Developer Suite's installer's will initialize its verification process. It will stopped while verifying its required Operating system configuration or files.



    • Right click on the installer property > Select Compatibility tab> Check the check box of  run this program in the Compatibility mode & select Windows XP Sp2 or Windows XP Sp3  Press apply and Ok.



    •   Note:

               There is a very important file called "oraparam"; this  file mainly contains all  Certified Operating Systems by Oracle.
    • The Oracle installer is programmed to look for this file as a pre-requisite to complete oracle developer suite installation.

    Follow the steps to pass the error

    • Open the oraparam file with Notepad++ program or any text editor program.


    • Press clt+ F to Look for  the word Certified

    • Then, add 6.2 for Windows 8.1 & 6.3 for Windows 10 


     [Certified Versions]
    Windows=5.0,5.1,5.2,6.2,6.3
    Solaris=5.8,5.9
    Linux=redhat-2.1AS
    HPUX=B.11.11



    • Copy the following shaded paragraph.

                                    
    •   paste the copied section in a free separate space followed to it's related windows section as follow:
      
    #Windows 2000 use winver.exe to find version
    [Windows-5.0-required]
    #Minimum display colours for OUI to run
    MIN_DISPLAY_COLORS=256
    SWAP_SPACE=1535
    SERVICE_PACK=3
    TEMP_SPACE=150
     
    [Windows-5.0-optional]
    #Minimum CPU speed required for OUI
    CPU=300 

    • Don't modify any content in the pasted section but only the title of the windows section to build a new certified windows version for Oracle as follow:  



      
    #Windows 8.1 use winver.exe to find version
    [Windows-6.2-required]
    #Minimum display colours for OUI to run
    MIN_DISPLAY_COLORS=256
    SWAP_SPACE=1535
    SERVICE_PACK=3
    TEMP_SPACE=150
    [Windows-6.2-optional]
    #Minimum CPU speed required for OUI
    CPU=300 

    • The same steps are followed for Windows 10 as it is defined to Oracle Developer Installer as 6.3 to make the required pre-requisite check for Microsoft Windows versions.

    • Save the changes you mad then restart running the Oracle Developer Suite installer as mentioned. Then, it will initialize its verification process and passed the Operating system verification process.


    • The welcome page of Oracle Developer Suite installer will be displayed.
    • Specify the source and Oracle Developer Suite target destination files or paths. 

    • Click Next button a progress bar appears loading the specified source file and forward the installation wizard to the next step.


    •    Specify the Oracle Developer Suite 10G 10.2.0.2 installation type.


    • Click Next button a progress bar appears loading the required selected installation  type and forward the installation wizard to the next step.



    •  No mail Server specified click Next to  forward the installation wizard to the next step.



    •   A progress bar appears loading the preference that no Out Mail Server Information required then forward the installation wizard to the next step.


    •   Finally, the actual installation progress bar appears loading its required installation files from its specified source to the specified destination file.  


    •  The installation progress bar will end  up at point 69% or 70%.  Then, a popup dialog window appears, asks you to specify the second source installation folder  in order to complete the installation process.

    • Specify its path and click OK.


    • Check the path again and click OK



    • Then, the progress bar will continue forward to the end of the installation process.


    • When, the progress bar is 100% complete, the following screen appeared.



    •    Press Exit button. Then press click Ok button to confirm.





    For now you accomplished the task successfully. You installed Oracle Oracle Designer On Windows 8.1 64 bit. You can configure Oracle Developer Suite to run it into the browser. You can also configure Oracle Designer to use it into your project in analysis and design.



    Learn more about:



    Hope this helps...

    My success only comes from Allah, pls. note your comments and suggestions are great help for me in progress thanks in advance.