Technical Debt

As a system grows, it accumulates technical debt – improvements and cleanup that your really ought to get around to doing. However, no-one ever budgets time for this kind of refactoring and cleanup.

The consequence is that any major change opens a Pandora’s box of interrelated problems. I’m involved in a project where we thought we could simply make a minor change to all 2768 tables, but due various historical design decisions over the year (more...)

Tools that I use – uptimerobot.com


http://uptimerobot.com is service that can monitor if you sites are up and running. I have been using it for more than 3 years and it works very well.
The service is free and you can add up to 50 monitors. It is easy to configure a monitor. You don’t have many options, but it can do just what I need.

You can create 4 types of monitors.

  • http(s): that’s perfect for website monitoring. The (more...)

Free developer day in Perth

Got a massive day of goodies coming to anyone in Perth..for absolutely no cost – just your time and your enthusiasm.

There’s something for

  • database developers
  • Apex developers
  • ADF developers

See you all there …

http://bit.ly/oddperth20140218


ORA-65131 grrrr

So…the future is container databases ?

Cool ! I’ll create all my databases as container databases….I’m so happy….until

SQL> CREATE FLASHBACK ARCHIVE longterm TABLESPACE demo RETENTION 1 MONTH;
CREATE FLASHBACK ARCHIVE longterm TABLESPACE demo RETENTION 1 MONTH
*
ERROR at line 1:
ORA-65131: The feature Flashback Data Archive  is not supported in a pluggable database.

It is documented but seriously….that’s not so flash :-)


Man…I really really like this :-)

Yeah yeah, you can argue with me about backward compatibility, but I’m so glad someone snuck this into 12c…

11.2

SQL> grant resource, connect to demo identified by demo;

Grant succeeded.

SQL> select privilege
  2  from   dba_sys_privs
  3  where  grantee = 'DEMO';

PRIVILEGE
----------------------------------------
UNLIMITED TABLESPACE

12.1

SQL> grant resource, connect to demo identified by demo;

Grant succeeded.

SQL> select privilege
  2  from   dba_sys_privs
  3  where  grantee = 'DEMO';

no rows selected

Tips and tricks for installing and maintaining FMW products

I have written an article for the winter 2014 issue of OTech Magazine.

Unfortunately, something went wrong in the layout process so it does not look too good everywhere, but it is readable.

The site uses some kind of widget to display the magazine. I could not get it working on my iPad and a colleague had problems with IE. If you run into problems, you can download the pdf directly via this link.

The (more...)

desc dba_views does not exist in database open stage

While you issued this dba_*  dictionary views on database mount

SQL> alter database mount;

Database altered.

SQL> desc dba_views;
ERROR:
ORA-04043: object dba_views does not exist

After database opened

SQL> alter database open;

Database altered.

SQL> desc dba_views;
ERROR:
ORA-04043: object dba_views does not exist

Don’t issue this command on database mount stage

Restart the database normal

or

SQL> alter system flush shared_pool;

System altered.

SQL> desc dba_views;
Name Null? Type
—————————————– ——– —————————-

OWNER (more...)

How do i check versions of *.fmb?

 

[appltrng@ebsdev ~]$ strings -a /u02/backup/appltrng/apps/apps_st/appl/au/12.0.0/forms/US/GLXCORUN.fmb | grep Header
FDRCSID(‘$Header: APPSTAND.fmb 115.33 2002/04/04 11:13:40 pkm ship $’);
$Header: APPSTAND.fmb 115.33 2002/04/04 11:13:40 pkm ship $
FDRCSID(‘$Header: GLXCORUN.fmb 120.34.12010000.1 2008/07/28 05:17 appldev ship $’);
$Header: GLXCORUN.fmb 120.34.12010000.1 2008/07/28 05:17 appldev ship $
[appltrng@ebsdev ~]$ adident Header /u02/backup/appltrng/apps/apps_st/appl/au/12.0.0/forms/US/GLXCORUN.fmb
/u02/backup/appltrng/apps/apps_st/appl/au/12.0.0/forms/US/GLXCORUN.fmb:
$Header APPSTAND.fmb 115.33 2002/04/04 11:13:40 pkm ship $
$Header APPSTAND.fmb 115.33 2002/04/04 11:13:40 pkm ship $
$Header GLXCORUN.fmb 120.34.12010000.1 2008/07/28 05:17 appldev ship $
$Header GLXCORUN.fmb 120.34.12010000.1 2008/07/28 05:17 appldev ship $


Is any email configuration required for Oracle Alert manager?

Yes. If once you email configured on workflow notification mailer, It will automatically send alert mail to you .No need to configure in oracle alert manager mail server options.

So please check it, Whether workflow notification mailer running or not.


Caching in a JEE : don’t write it yourself, use LoadingCache from Google Guava libraries.

Caching data is something you use in almost every JEE project. Most of the time it’s pretty simple : put your data in a .properties file and use a PropertyManager to fetch the data.

But that’s not very flexible and manageable. Updating the values means, updating your property file, repackaging the ear file, and redeploying, and only developers can update the data.

Putting the data in JNDI entries, and using JNDI lookup’s may solve the (more...)

The Twelve Days of NoSQL: Day Twelve: Concluding Remarks

Reblogged from So Many Oracle Manuals, So Little Time: On the twelfth day of Christmas, my true love gave to me Twelve drummers drumming. (Yesterday: Mistakes of the relational camp)(Back to Day One: Disruptive Innovation) The relational camp put productivity, ease-of-use, and logical elegance front and center. However, the mistakes and misconceptions of the relational […]

The Twelve Days of NoSQL: Day Nine: NoSQL Taxonomy

On the ninth day of Christmas, my true love gave to me Nine ladies dancing. NoSQL databases can be classified into the following categories: Key-value stores: The archetype is Amazon Dynamo of which DynamoDB is the commercial successor. Key-value stores basically allow applications to “put” and “get” values but each (more...)

Increase space in Linux Volumegroup while running linux in vmware

If you like to increase space in linux volume group, you can do it on while machine up.

Afer added harddisk on existing hard disk. you can’t identify that hard disk on machine. So in this case you need to rescan the hard disk using below command.

$echo ’1′  > (more...)

Merry Xmas and a project goes live

I hope all my readers have a Merry Xmas and a Happy 2014.

My company has finally delivered an online delivery solution (we are a major food retailer in the UK  for anyone who does not recognise the branding). It is always nice to see a major project go-live and (more...)

When the Oracle wait interface isn’t enough, part 2: understanding measurements.

In my blogpost When the oracle wait interface isn’t enough I showed how a simple asynchronous direct path scan of a table was spending more than 99% of it’s time on CPU, and that perf showed me that 68% (of the total elapsed time) was spent on a spinlock unlock (more...)

Clear memory cache in linux

The below command will remove cache memory

 sudo sh -c “sync; echo 3 > /proc/sys/vm/drop_caches” 

 

 

 


Are younger employees better?

The CEO of a Danish IT company just posted a heretical article (in Danish) where he stated that he preferred younger employees, because they were more productive and more open to new ideas.

Naturally, older IT guys immediately started flaming him. Interestingly, they exactly proved his point: Many older employees (more...)

OpenWorld 2014 Afterparty: The Rock’n’Roll San Jose Half Marathon

Björn Rost and I have appointed the 2014 Rock’n'Roll San Jose Half Marathon to be the  the official OpenWorld 2014 afterparty. It’s Sunday, October 5, 2014 – the Sunday right after Oracle OpenWorld.

Last year, the event was the Santa Cruz triathlon, but this year we’ll go for something (more...)

#desc

Here’s a good tip In SQL*Plus, that I have learned only recently; You’re in the middle of typing in some SQL or a PL/SQL Anonymous block, and can’t remember the column name, or other table information? At the start of the next line type “#desc <table_name>” and the table is (more...)

Criminal negligence

Negligence: Failure to take the care that a responsible person usually takes : lack of normal care or attention

A worrying number of organizations run outdated, unsupported software.

There might have been a time when you could install software and leave it running unchanged for decades. But your IT infrastructure (more...)