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.
- 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
- 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:
- 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/
- load the apex images
- start the EPG configuration:
- 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;
- check the DAD authorization:
select * from dba_epg_dad_authorization;
if no rows are returned use this:
exec dbms_epg.authorize_dad('APEX', 'ANONYMOUS');
- set the SHARED_SERVERS environment:
ALTER SYSTEM SET SHARED_SERVERS=5 SCOPE BOTH;
- execute this
SET SERVEROUTPUT ON;
l_value VARCHAR2(5) := 'true'; -- (true/false)
l_configxml := DBMS_XDB.cfg_get();
IF l_configxml.existsNode('/xdbconfig/sysconfig/protocolconfig/httpconfig/allow-repository-anonymous-access') = 0
-- 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"')
-- 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"')
- 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);
- start your browser and open the apex page.
I hope this helps, but be aware EPG on 10g is not supported by Oracle.
Martin Giffy D’Souza on Oracle APEX: Variables in APEX: “When I first started using APEX I was unsure about which method to use when referencing variables (values in session state). The purpose of …”
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.
APEX 4.0.2 has been installed without any trouble. just follow the instructions provided by Oracle.
As soon as I find the time I’m going to investigate further:
Oracle Database Development Tools (ODDT): APEX 4.0.2 is here, and its got two new themes!: “Oracle Application Express (APEX) 4.0.2 patch is now available on MySupport and a re-release is available on OTN as of last Friday November …”
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:
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.