database – Geek 2.0 https://www.stormacq.com Some not-so random thoughts about this small IT World Mon, 04 Aug 2014 19:04:05 +0000 en-US hourly 1 https://wordpress.org/?v=4.9.1 Installing Oracle SOA Suite atop XE Database https://www.stormacq.com/installing-oracle-soa-suite-atop-xe-database/ https://www.stormacq.com/installing-oracle-soa-suite-atop-xe-database/#comments Thu, 20 Jan 2011 09:08:13 +0000 https://www.stormacq.com/?p=421 Although not officially supported, installing Oracle SOA Suite a top of the lightweight XE database is often convenient for development, demo or training purpose.  It avoids going through the complete installation of her big brother : the complete Oracle Database 11g system.

XE is less than 220 Mb download and Installing it on  a Linux system is as simple as

rpm -ivh oracle-xe.rpm

However, there is some caveats, i.e. some system parameters to tweak before installing SOA Suite’s database schemas using Repository Creation Utility (RCU).

In the same spirit as my previous blog entry : here are the magical incantations for the database gods, to be executed before RCU.

First connect to the database :

sqlplus sys/yourpassword@XE as sysdba

(be sure to have /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin in your PATH)

SQL> show parameter processes //processes should be 40 – must be 200
SQL> alter system set processes = 200 scope=spfile;
SQL> show parameter session;
SQL> alter system reset sessions scope=spfile sid='*';
SQL> shutdown immediate;
SQL> exit;

then restart XE with :

sudo /etc/init.d/oracle-xe start

Finally, as stated on SOA Suite download page :

“If you want to use XE you can set the RCU_JDBC_TRIM_BLOCKS environment variable to TRUE *prior* to running RCU. As a reminder as to support level, when running RCU against XE you will receive a warning stating that the database version is not supported by Oracle.”

You must issue

export RCU_JDBC_TRIM_BLOCKS=true

before starting RCU. Failing to do so will cause WebLogic to issue a bunch of database related exceptions at startup time.

That’s it !  You can now proceed with RCU to install SOA Suite’s database schemas.

Enjoy !

]]>
https://www.stormacq.com/installing-oracle-soa-suite-atop-xe-database/feed/ 5
Do More with Less https://www.stormacq.com/do-more-with-less/ https://www.stormacq.com/do-more-with-less/#respond Sun, 11 Oct 2009 21:52:28 +0000 https://www.stormacq.com/?p=176 Sun-Oracle TPC-C benchmark result announcement is loud and clear :

  • 8x less hardware
  • 4x less power

 

= 16x better performance 

]]>
https://www.stormacq.com/do-more-with-less/feed/ 0