I’m a nerd. I know. I simply “love” the command-line.

For years I’ve been using 4NT and TakeCommand, registered the product years ago (www.jpsoft.com).

Now I made the switch to Windows 7 (64-bit). I still have to get used to it. Some Oracle issues on PL/SQL developer etc.

When I wanted to install my command-lines. click-click.. it worked. However it wouldn’t register to the registered product no more. 🙁

So I wrote the guys at JP-software an email. They returned the mail allmost immediately (what a service). The answer is that the product is no longer supprted under Windows 7. I can imagine that.

To my surprise there is a free alternative to my 4NT and TakeCommand command-lines. It’s called “TCC LE” and it’s from the guys at JPSoftware. Best of all.. it’s free.

So guys (and dolls offcourse): If you need a full powered commandline, please have a look at: http://www.jpsoft.com/download.htm

Today I published the plugins we’ve written to the plugin-library at www.apex-plugin.com.

  1. Warp11 CSS Menu
    The menu is based upon Jessica Wilson’s drop-down menu, but has unlimited levels and more control on the styles used. We also used a different JQuery plugin
  2. Warp11 GMaps item
    The item shows a Google map with some buttons within the application-builder to play around with

You can have a look at www.apex-plugin.com .

 

Ok. I just finished creating two extra Apex-environments (TEST and PROD)

Where I mention “SQL>” you are logged in in your sqlplus as SYS as SYSDBA privileges.

I now have a plan-of-attack for getting Apex 4 on a 10g database with EPG:

  1. Start the APEX installer (I unzipped my apex.zip into D:APEX, so there is a D:APEXapex folder!)
    @apexins apex_ts apex_files_ts /i/
  2. load the apex images
    
    
    @apxldimg D:APEX
  3. start the EPG configuration:
    
    
    @apex_epg_config D:APEX
  4. unlock some accounts:
    alter user ANONYMOUS account unlock;
    alter user APEX_PUBLIC_USER account unlock;
    alter user APEX_040000 account unlock;
    alter user FLOWS_FILES account unlock;
    alter user XDB account unlock;
  5. check the DAD authorization:
    select * from dba_epg_dad_authorization;

    if no rows are returned use this:

    exec dbms_epg.authorize_dad('APEX', 'ANONYMOUS');
    commit;
  6. set the SHARED_SERVERS environment:
    
    
    ALTER SYSTEM SET SHARED_SERVERS=5 SCOPE BOTH;
  7. execute this
    SET SERVEROUTPUT ON;
    DECLARE
         l_configxml XMLTYPE;
         l_value VARCHAR2(5) := 'true'; -- (true/false)
         BEGIN
           l_configxml := DBMS_XDB.cfg_get();
           IF l_configxml.existsNode('/xdbconfig/sysconfig/protocolconfig/httpconfig/allow-repository-anonymous-access') = 0
           THEN
             -- Add missing element.
             SELECT insertChildXML(l_configxml, '/xdbconfig/sysconfig/protocolconfig/httpconfig', 'allow-repository-anonymous-access', XMLType('' || l_value || ''), 'xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd"')
             INTO l_configxml
             FROM dual;
    
             DBMS_OUTPUT.put_line('Element inserted.');
           ELSE
             -- Update existing element.
             SELECT updateXML(DBMS_XDB.cfg_get(), '/xdbconfig/sysconfig/protocolconfig/httpconfig/allow-repository-anonymous-access/text()', l_value, 'xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd"')
             INTO l_configxml
             FROM dual;
    
             DBMS_OUTPUT.put_line('Element updated.');
    
           END IF;
         DBMS_XDB.cfg_update(l_configxml);
         DBMS_XDB.cfg_refresh;
    END;
    /
  8. Find the HTTP port on which the EPG is running:
    
    
    SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

    you can change it using:

    
    
    exec DBMS_XDB.SETHTTPPORT(portnumber of your choice);
  9. 
    
    shutdown;
  10. 
    
    startup;
  11. start your browser and open the apex page.

I hope this helps, but be aware EPG on 10g is not supported by Oracle.

 

Today I found a really neat plug-in to Oracle’s APEX.

Have a look here: http://www.apex-plugin.com/oracle-apex-plugins/item-plugin/skillbuilders-super-lov_75.html

All’s well, ut there is a downside to using this plug-in. Cascading Parent LOV’s are not supported yet. I hope they will soon. So I came up with an alternative that does use the native popup LOV.

  • I altered the template that displays the LOV to use a fixed with font for the body
  • I use LPAD and RPAD in combination with ‘ | ‘ to neatly outline the columns

the result looks like this:

Maybe is not the most beautiful solution, but it suffices for now.

 

Wow. I have broken my thoughts about this for a loooooong time. In the end stuff can be so simple:

When you get the errormessage that it cannot start the DBConsole do this:

  • Make sure you have the MS loopback adapter installed (remember my previos Blog-entry)
  • Make an entry in your hosts file:
    xx.xx.xx.xx yyyy
    where xx.xx.xx.xx is your fixed IP-number on the MS Loopbackadapter and yyyy is your computrename
  • Restart the service

That should do the trick

Great thanks to http://www.ywema.com/yweblog/2008/09/oracle-11g-dbconsole-en-apex/

If you want to install an Oracle database on a notebook, then it is essential that beforehand you install the MS Loopback adapter. This is a “virtual” network adapter.

After installation assign it a fixed IP-addres (192.168.99.99 for example) and you’re ready to install the Oracle Listener and Database instances.

You should not believe people who claim that Oracle doesn’t need it anymore. Maybe Oracle can do without the loopback adapter, but it will prevent a lot of issues that you would need to solve manuallly.