Cedar’s Oracle Talent Acquisition Cloud Event / Team

Earlier this week Cedar held its Oracle Talent Acquisition Cloud event in Oracle’s London City office. We have a really strong team of UK-based Talent Acquisition specialists within our ranks:

Taleo Team 2 (plain background)

Jo, Prachi, Marc and Mel are all experts in the various aspects of Oracle Talent Aquisition Cloud – Taleo Recruit, Sourcing and Onboarding – and Cedar has multiple implementations under our belt covering all of the above products, so we were able to put on (more...)

Question: Table names singular or plural?

Yesterday I put a question on twitter, to find out what others prefer: table names using singular or plural form. I expected one or two replies, not an avalanche :-)

As expected there were all kind of replies going either singular or plural. Some (more...)

toad and oracle client are getting ora-12560 tns protocol adapter error after upgraded windows 10

Yesterday morning I came to office, One of my colleague complaint, My toad not working , I am getting “ora-12560 tns protocol adapter error” while connecting to target database through toad.

I asked him when was this issue started , He said, After upgraded my pc to windows 10. I am getting this issue. I told him, My pc also upgraded to windows 10 but I am not getting this issue. I can able to (more...)

benchmarking your disks

 

While at Delphix, we did a lot of storage benchmarking. The I/O response times of Delphix depends, as one would logically imagine, heavily on the underlying disks. Sure Delphix can cache a lot ( with 1 TB of ram and 3x compression that’s 3TB and that 3TB can be shared by 10 or a 100 copies being the equivalent to 30TB or 300TB of databases) but really there will always be important I/O coming (more...)

Should you learn Spring or Oracle ADF?

My answer on Quora to “Should I learn Spring or Oracle ADF?”:

Oracle ADF is a specialty skill, Java Spring is a general skill. Java Spring should be your default choice, unless:

  1. You work in an company that has made Oracle ADF their strategic choice, or
  2. You come from a 4GL tool like Oracle Forms and don’t know much Java yet

With ADF, you get higher productivity but less control. It was created by (more...)

Speaking at DOAG and RMOUG rocked

As I wrote a while back I was accepted to speak both at the User Group Leader summit at DOAG16 and at RMOUG Training Days.

The first one was a short presentation where I talked about a large bug in Oracle security and the need to patch and upgrade to not have that exposure. It was great fun as it was limited to a four-minute talk. I learned a lot from preparing for it as (more...)

Remove OEM 13c Management Repository

Background

Removing the SYSMAN schema and other OEM-related objects from a database consisted of disabling constraints and running a series of DDL scripts in earlier versions of OEM.  Always use RepManager to perform this cleanup for OEM 13c.

RepManager ‘-drop’ command drops the SYSMAN, SYSMAN_MDS, SYSMAN_OPSS, SYSMAN_RO, and SYSMAN_BIPLATFORM schemas and removes their artifacts, including tablespaces and datafiles.

Procedure

Note:  The following run-time example has been simplified from actual stdout and uses a reference to $MW_HOME (more...)

Best of Both Worlds with ADF

I’m seeing a lot of interest in developing client-side applications based on one JavaScript framework or another. Today, the leading contenders are AngularJS (the old version) and Angular2 (the new version, of course, incompatible with the old). Oracle is also entering the game with Oracle JET.

For some strange reason, developers tend to compare Javascript frameworks to full stack frameworks like ADF, forgetting that someone, somewhere, must build the REST web services that JavaScript applications (more...)

Get your virtual mojo on

I have for a few years created a play environment in a similar way. Getting a database installed in a VM is not too hard. But I found that I did it fairly often and not always in the same way and not always without having to resolve problems I know I had solved before but since forgotten the solution for.

Right, write everything down. Yes, it was time for that.

So I now have (more...)

FRM-93658 on Windows 2012 at runtime on Forms 12c Server

I don’t know about you guys but as we’ve doing more and more upgrades to 12c we’ve been seeing some bugs creeping up. So in hopes to assist in how to manage these bugs, we will be producing more posts to try to help you guys out. Thanks to Jan-Peter AuraPlayer’s Form’s Rockstar for leading the charge!

One thing we saw today in a few customers, was a strange crash that happened sometimes at runtime (more...)

Oracle Forms on Firefox 52 desupported NPAPI plugin

Today everyone got the very scary news that Firefox will no longer support Java applets. Well guess? It’s not news at all!

It’s just another attempt to scare poor Form’s users into to getting them to do a million dollar multi year migration project. Well have no fear, because we have found not one BUT two very simple ways for you to continue to work with Forms for the year to come without worry.

The (more...)

Postgres monitoring script pgmon.sh

Screen Shot 2017-03-09 at 8.13.35 AM

photo by Thomas Hawk

https://github.com/khailey/pgmon

$ ./pgmon.sh 
Usage: pgmon.sh [username] [password] [host] <sid=postgres> <port=5432> <runtime=3600>

$ ./pgmon.sh kyle kyle  mymachine.com

  psql -t -h mymachine.com -p 5432 -U kyle postgres < /tmp/MONITOR/tmp/mymachine.com:postgres_collect.pipe &

  RUN_TIME=-1
  COLLECT_LIST=
  FAST_SAMPLE=wts
  TARGET=mymachine.com:postgres
  DEBUG=0

  Connected, starting collect at Wed Mar 8 12:05:12 PST 2017
  starting stats collecting
  SET

  AAS| blks_hit | blks_read | tup_returned | tup_fetched | tup_inserted | tup_updated | tup_deleted  

    (more...)

HCM Cloud vs Workday – the Latest Figures

Both Oracle and Workday have recently announced figures for their Cloud application suites and it’s interesting to see how they both compare.

In its Q4 results Workday stated that they have 1,528 HCM customers with 136 of the Fortune 500, plus 320 financials customers. 70% of their HCM customers are live.

In its recent Analyst Briefing Oracle shared that they have 1,600+ HCM customers with 275+ of the Fortune 500, and 3000+ financials customers. 1,000 (more...)

AuraPlayer for PeopleSoft / JD Edwards Beta Program

pple AuraPlayer has been pretty busy working on new groundbreaking  solutions and we can’t wait to show you!

We developed a new version of our product that can create microservices from Peoplesoft and JD Edwards applications. If you’re challenged on how to mobilize your existing systems and want to try a breakthrough solution for fast mobilization, we’d be happy to have you see what we can do in our Beta testing program! All you would need (more...)

Object oriented logging

It is a very common requirement. You need to be able to log the start and end of procedure and function calls. You also need to log error and exception events and sometimes some informational messages as well. This is typically done by writing a simple logging package that uses autonomous transactions so that any transaction rollback does not rollback the diagnostic logging information as well. Apart from logging text (and usually other things as (more...)

Example Jmeter workload for Postgres and Oracle

pgload.jmx is JMX file you can load into Jmeter and run a substantial load on a Postgres database. Should work just as well on Oracle if you change the test SQL from “Select 1″ to “select 1 from dual”

Install jmeter on our machine . On my mac, I did

  • brew install jmeter

You will need the Postgres driver. I used

Which is the best career path: Oracle ADF or Java?

My answer on Quora to “Which is the best career path to choose, Oracle ADF, or Java?”

Concentrate on Oracle ADF. ADF skills are in high demand and pay better than pure Java skills.

Because Oracle ADF is a Java-based framework, you will need to learn some basic Java as you build you ADF skills. Once you land an ADF job, you will learn more Java as you work with ADF. This allows you (more...)

Who should create Oracle ADF skins?

My answer on Quora to “Who should create Oracle ADF skins: Developers or designers”

If you are on the latest ADF version (12.2.1.x.x), you have access to the web-based Theme Editor. In this case, your designer should use this user-friendly tool to create the skin. It has some limitations, but the designer is best placed to work around these.

In earlier ADF versions, a CSS developer is needed to develop the (more...)

Enable DDL logging

Enable DDL Logging:

ENABLE_DDL_LOGGING enables or disables the writing of a subset of data definition language (DDL) statements to a DDL log.

SQL> show parameter enable_ddl_logging

NAME TYPE VALUE
———————————— ———– ——————————
enable_ddl_logging boolean FALSE

SQL> alter system set enable_ddl_logging=TRUE scope=both;

System altered.

SQL> show parameter enable_ddl_logging

NAME TYPE VALUE
———————————— ———– ——————————
enable_ddl_logging boolean TRUE

SQL> select value from v$diag_info where name=’ADR Home’;

VALUE
——————————————————————————–
/premia/app/12c/oracle/diag/rdbms/oradb/oradb

SQL>

SQL> select value from v$diag_info where name=’ADR (more...)

Listener Exception : Could not create listener: TNS-04414: File error

When I tried to add listner using netca for my test database, I am getting below issue

“Listener Exception : Could not create listener: TNS-04414: File error’

It could be possible ” Listener file having some wrong entries, so you need to check” or renaming current listener and tried to add (Here Please be note, your current listener configuration will be removed).