OBIEE Blog

There are hundreds, if not thousands, of high tech computer jobs open for those with Oracle expertise. The highly reputable and popular Oracle products are used by firms in every part of the globe. As a result, experts who can walk in the door ready to start work on Oracle and keep the applications running efficiently are in great demand.

Knowing what employers are looking for when they seek to hire for high tech Oracle computer jobs helps students or would-be students and job candidates prepare their skills. So, let’s take a look at a few of these Oracle jobs available now.

In Phoenix Arizona, for example, we found 58 Oracle related high tech computer job openings. Positions included Windows Administrator II and III, business analyst and Oracle developer, database management senior specialist for Oracle 10g, Oracle DBA and senior Oracle DBA, business applications analyst, clinical applications support, Cerner PathNet support analyst, Oracle / Java developer, and database manager, among many others.

The high tech Windows administrator computer jobs were both senior level position in a OneNeck Windows administration group. Requirements were ability to administrate a medium to large environment of Windows server without supervision. The primary focus of these positions was work on projects directed by the firm’s customer management team.

The employer seeking the business analyst and Oracle developer wants someone with high tech computer knowledge whose job skills include writing functional specifications, analysis of programming activities and excellent team and communication capabilities. The candidate for this Oracle job should have a strong technical background including business analysis. Development of Crystal reports experience is a plus as well. This employer specifies that the firm does not seek DBAs.

A senior level data base management position including 10g RAC specialization requires two years of Oracle 9g RAC experience and five years of Oracle DBA. This is not a full time permanent position, but rather a contract position for one month, with responsibility for decision making critical to the database architecture, as well as the control and deployment processes to implement and maintain 10G databases using RAC.

Oracle DBA jobs at the senior level are abundant, full time and contract. One, a six-month contract position that might be extended to as long as one year, is a three-day week job. The work will be at two locations fifty miles apart, working with data services of the firm’s clients.

A more entry-level Oracle DBA computer job is as part of a high tech team environment that supports engineering and MIS groups within the firm. This employee will focus her or his efforts on product and service support both internal and external. The specific functions of this high tech Oracle computer jobs include maintaining the database as well as its applications. Requirements include technical expertise and user interface capabilities. User support will be a part of the job tasks too. Knowledge to qualify for this Oracle job include Oracle database in a Sun environment. At least two years experience with Oracle DBA is a must.

Additionally, this employer is looking for someone with excellent communication skills, autonomy, top-notch phone skills and vendor troubleshooting capability.

To land the advertised Oracle applications business analyst position, the candidate would need experience with Oracle applications and Order management.

For the highly specialized clinical applications support job in the medical field, the candidate would need to be an registered nurse who also has clinical application support training as well as Cerner clinical applications help desk proficiency.

A global provider of business solutions and information technology is seeking a Cerner PathNet support analyst to support the clinical departments’ business needs for project execution and enhancement. Application support and maintenance is the primary job task. Problem resolution will include system functions, operations, reporting, input and output, and general operations. This analyst will install patches, install vendor fixes to problems, create ad hoc reports and extraction of data and on call troubleshooting and system support.

The person who lands this high tech Oracle computer job will have knowledge of service operations in an acute care environment, experience in clinical applications support, as well as Cerner Classic PathNet and hospital acute care experience.

Familiarity with Cerner Millennium Lab application, Oracle database tools and VMS or AIX operating systems are plusses. Strong problem solving and analytical skills as well as effective communication skills both written and verbal are required.

www.oraclejobs.com
Copyright 2007 KC Dynamics Inc

I’m delighted to announce that a new useful OBIEE forum / discussion board is open. Idea was up in the air for a long time – and it seems as multiple people planned this for awhile independently (rnm1978, Mark Rittman, Adrian Ward, and other guys and myself included). Part of it was frustration with moderation on official Oracle’s board, and part of it was a need for a resource where OBIEE and business intelligent professionals could share secrets of the trade. The difficult part is keeping balance between sharing knowledge as well as  providing a moderated environment.

The board is already active with several interesting topics going. If you’re interested in participating – please apply at Google OBIEE group

Thanks to Mark Rittman who organized the movement and to all those who agreed to become moderators.

There’re some very interesting blog posts about handling OBIEE’s SCM process, however, the difficulty is that each project is different. For example, there’re so many environmental factors involved – everything depends on location. In some enterprises, they use corporate-wide version-control systems (such as TFS). In some places, they don’t. Some companies have a rigid DEV to SIT to UAT to PROD process, in some companies – such development is done ad-hoc.

Sometimes, webcat is copied manually. Sometimes, it’s merged online. Sometimes it’s archived and extracted.

Myriad options and almost endless number of possibilities.

Sometimes, the RPD is merged locally, sometimes it’s imported, sometimes, it’s done via MUDE projects. Everyone is different and each situation is different. And here’s when experience and expertise come into play – an experienced consultant can provide the best way of handling OBIEE’s deployment process.

Hello,

I’m back after being busy with some really interesting issues at work.  I found a minute and I’d like to post few items.

First of all – the question “In OBI, How to move System Wide default settings from one environment to another?” comes up a lot – here’s an official response that I found on the knowledge base:

System wide default settings cannot be moved from one environment to another by design. The recommended way to move any other changes is to perform an Archive and then an unarchive. But, this method does not work for System wide default settings

The following Bug has been logged to make this feature available in the future releases:
BUG 8271294 – ARCHIVING AND UNARCHIVING DOES NOT STORE SYSTEM WIDE DEFAULTS

So now you know what to tell your project manager.

Second item I found interesting is:

“How to reduce the space between multiple pivot tables placed side by side?”

1. Provided that s_oracle10 is in use; backup the following files before editing them
- C:\OracleBI\web\app\res\s_oracle10\b_mozilla_4\views.css
- C:\OracleBI\oc4j_bi\j2ee\home\applications\analytics\analytics\res\s_oracle10\b_mozilla_4\views.css

2. Set the following section in both files above:
.PTSectsTable

There is currently no way to make a query use a specific connection pool. The following bug has been raised to address this requirement- As you are already aware, current workaround is to have separate database defined in physical layer :

Bug 9392303 – FIRST CONNECTION POOL CHOSEN BY DEFAULT FOR ALL QUERIES

Customers requirement :

They have a new application that need connect to mutiple database, so under
physical layer root have two connection pool.
So under Database in physical layer 1st connection pool points to an oracle
instance and second connection pool points to a different oracle instance.
When we run report in answers, the connection information is always taken
from the 1st connection pool by default – hence we get table cannot be found
ora error. Reason being the table exists in the database instance referenced
in the 2nd connection pool.
When we do view data in RPD , the results return fine – this is because while
clicking on view data, we explicitly have to select the connection pool.
While creating the logical table/column, we only specify the database name
and the schema name and the table name- no place to provide connection pool
info – hence the server chooses the 1st one by default.
Need a way to fix this – current workaround suggested is to have multiple
database created in physical layer.

When trying to install Oracle Business Intelligence Suite Enterprise Edition, v. 10.1.3.4.0 for Microsoft Windows in Windows XP and getting the following error message.

“Oracle Business Intelligence is not supported on this Windows version. Oracle Business Intelligence is only supported on Windows XP x86, Windows 2003 x86, Windows 2003 AMD64, Windows 2003 EM64T, Windows Vista x86, Windows Vista AMD64, Windows Vista EM64T, and Windows 2000 x86.”

Installer uses systeminfo.exe command to get information on the architecture of the machine. If this command will cause any error, then there is a need to check and fix that error first.

Run the following command and see if any errors. In our case we had the following error.

The command systeminfo.exe is run from command line.

***
C:>\windows\system32\systeminfo.exe

Error:-

Back with error for Network Card
Information???????..Error:Provider Load failures.

***********

Since installer use the same command to get information on the architecture of the machine. In this case because of the above error installer was not able to drive the machine detail and as a result installation failed.

The errors from the above command systeminfo.exe (if any) needs to be fixed first.  In our case after we fixed the Network Card issue, installation went fine.