Archive for August, 2009

Top 5 CV / Resume Tips to secure you an Interview

Friday, August 28th, 2009 by Kirsten Campbell

The Oracle Contract market is more competitive than it has ever been with more and more Contractors able to work across multiple countries without the need for Visa’s etc as well as more and more people with Oracle capability as the market is now at such a level of maturity.

If you consider our own Global Contractor Management System has over 10,000 people registered with all of 16 offices able to select from a global pool not just a local system.

Clients in the Oracle world will receive dozens of applications for each role, and in most cases from multiple agencies / staffing companies, so it is important that you make your CV / Resume stands out from the crowd to get short listed for an interview.

I have often been amazed how a great contractor has not even been selected for an interview, when a less capable contractor gets the job! When I have compared the CV / Resume’s, I realise why one never even got to the interview stage

Your CV / Resume is your personal brochure, giving you a chance to show off all the attributes that make you the perfect choice for clients. Even though we may have known you for years and have all your skills properly presented in our system the client will in all most all cases choose to use their own judgement first, so the CV / Resume is the only tool to get past first base.

These tips show you the key things you need to consider to make sure your CV / Resume shows you in the best possible light. I will expand on each Tip in later articles.

1. Show what makes you unique
 
For every job you apply for you could be up against dozens of other contractors so you need to make sure you stand out from the crowd. Clients don’t just buy skills, they buy solutions, so show how can you save the company money and how can you resolve the problems that they have. Full article to follow…

2. Choose a clear layout

People spend around 20 to 30 seconds scanning a CV / Resume so it needs to remain clutter-free and easy to read. The last thing a person wants to do is to go hunting for the information that they are looking for so don’t hide it amongst an array of elaborate graphics or pages and pages of text. Full article to follow…

3. Tailor your CV / Resume to your audience

It may sound like a time consuming process, but making the effort to tailor your CV / Resume to suit the requirements of each contract that you are applying for can greatly increase your chances of securing an interview. Full article to follow…

4. Keep it error free

It’s deceptively easy to make mistakes on your CV / Resume and exceptionally difficult to repair the damage once someone reads it. As well as checking your spelling and grammar make sure your project dates match up, remember a contractor you have worked with on a previous site may be at the prospective client. Full article to follow… 

5. Keep your CV / Resume up-to-date

When you put together a CV / Resume it’s often difficulty remembering the projects you have been involved with and the achievements you have made. To avoid missing important pieces of information out, revisit your CV / Resume every month adding anything of importance, and cutting any information that is no longer required. Full article to follow…

 

New Release White Paper through Contractors Network

Friday, August 28th, 2009 by

New Release White Paper through Contractors Network

Contractors Network is pleased to announce the latest free of charge release into our extensive Oracle Apps related White Paper Library of:

‘Using the PL/SQL Profiler’

Authored by Dan Hotka

About Dan;

Dan Hotka is a Training Specialist who has over 31 years in the computer industry and over 26 years of experience with Oracle products.  He is an internationally recognized Oracle expert with Oracle experience dating back to the Oracle V4.0 days.  Dan’s latest book is the TOAD Handbook by Pearson.  He is also the author of SQL Developer Handbook by Oracle Press, SQL Developer Handbook by Oracle Press, Oracle9i Development by Example, and Oracle8i from Scratch by Que and has co-authored 7 other popular books including the Database Oracle10g Linux Administration by Oracle Press.

The Purpose of  Paper is to To allow for the tuning of PL/SQL Routines.

If you would like request a copy please email myself on rebecca.bragg@oraclecontractors.com or register via the White Paper library later today and request your copy today.

Dealing with a lost SPFILE

Thursday, August 20th, 2009 by

In various internet forums you’ll find people asking the question - “I’ve lost my spfile - what do I do now?” 

Below is a quick checklist of items that could be used as a starting point to resolve this issue:
 

1) Are you looking in the correct place for the PFILE/SPFILE? 
   - In follow-up postings to this one, you’ll see that these files may not always be in the default location of   $ORACLE_HOME/dbs on Unix or %ORACLE_HOME%\database on Windows.

2) Use information in the database alert log.  A useful new 11g feature is that you can just copy and paste the entries from the alert log that have been written when the database last started up, into a file called INITSID.ORA.  (Replacing SID with the name of your database). If you then place this file in the default location, you can use it to start the database. (The entries have been formatted as they were written to the file, so that it can be used in this manner). Even in 9i and 10g, a listing of any non-default parameter file entries is still written to the alert log.

3) If you have previously run any “alter database backup controlfile to trace;”  commands, then the output trace file doesn’t contain a full list of all database parameters, but in 11g it will provide you with details of the locations for the CONTROL_FILES parameter, together with a section entitled:

“…current System-scope REDO Log Archival related parameters … can be included in the database initialization file.” 

which may be of use.

4) Check your backup location, as there should be a copy of the SPFILE stored in this location. 

        a) Can you restore it from tape?
        b) Do you have a disk-based/SAN-based copy or backup of the files?
            - Have you automated scripts which copy the files to a backup location.
            - Any previous “Create pfile…” or “Create spfile…” commands could have been used to create backup copies elsewhere.
            - If the database is currently open, then you can just run the new 11g commands: “Create spfile from memory;”
                                  alternatively, you may prefer to just query v$parameter/v$spparameter or similar views.
        c) Has the SPFILE been backed up by RMAN?
            -  If using RMAN with autobackup configured, then your spfile will have been backed up automatically along with the controlfile.
            -  You could also manually extract the SPFILE from the backuppiece using dbms_backup_restore.RestoreSpfileTo

5) Do you have a copy stored within your source control/version control, change management or similar system? 
            - Ideally all your database scripts and parameter files should be stored within these systems.

6) Oracle Enterprise Manager (OEM)/Grid Control/Database Control offer various options for restoring database files.

7) If your database in running in a clustered, replicated or standby database configuration, could you just copy the files from another site?
       (Obviously they will need to be edited before use).

8) Are there other databases you can access that have a similar configuration whose files you could edit and then re-use?

9) If you have a DR site, are there copies of the files on the DR site?
     - Do you also have a “hot box” for your DR site? - If so, then you should have electronic and paper-based copies of the files there.

10) At the final section of an Automatic Workload Repository (AWR) or Statspack report there is a section listing database parameters that could be used to re-construct the files. Other Oracle supplied scripts, tools and utilities such as the Remote Diagnostics Agent (RDA), Streams Configuration Report and Health Check script (streams_hc_11GR1.sql) and the RAC Diagnostic Information script (racdiag.sql) also report on parameter file settings. 

As a basic guide don’t forget that Oracle also provide an example init.ora file in $ORACLE_HOME/dbs on unix and %ORACLE_HOME%\dbs on Windows.  
Note: When editing pfiles manually, it would be good practice to ask someone else to check your work. This is to prevent errors from typing in parameter names incorrectly and also to check that the settings in the file are appropriate for the database.

References:
Oracle Database Administrator’s Guide 11g Release 1 (11.1),232587.1,162491.1,811788.1,378021.1,135714.1,314422.1,273674.1

Troubleshooting Oracle Streams / CDC

Wednesday, August 12th, 2009 by

Note: Always where possible use the CDC API’s (dbms_cdc_publish) and not the streams API’s to stop/start/trouble shoot Oracle CDC (Change Data Capture)

Stop & Start CDC from stage database:
sqlplus  cdc_stg_pub/cdc_stg_pub

begin
dbms_cdc_publish.alter_change_set(
change_set_name => ‘WFWH_PRD_TO_PRD_SET1′,
enable_capture => ‘Y’) ;
end;

begin
dbms_cdc_publish.alter_hotlog_change_source(
change_source_name => ‘WFWH_PRD_TO_PRD_SRC1’,
enable_source => ‘Y’) ;
end;
Switch archive logs on source database to start propagation.

Check Apply:
Run this from source and stage:
select * from dba_apply_error;
Increase Apply Parallelism:
DBMS_APPLY_ADM.Set_parameter(‘applyName’,’parallelism’,’4’);
Check source for archive log needed to restart CDC / Streams:
set serveroutput on
DECLARE lScn number := 0;
alog varchar2(1000);
begin select min(required_checkpoint_scn)into lScn from dba_capture ; DBMS_OUTPUT.ENABLE(2000);
dbms_output.put_line(’Capture will restart from SCN ‘ || lScn ||’ in the following file:’);
for cr in (select name, first_time from DBA_REGISTERED_ARCHIVED_LOG where lScn between first_scn and next_scn order by thread#) loop dbms_output.put_line(cr.name||’ (’||cr.first_time||’)');
end loop;
end;
Stop / Start propagation (source):
exec DBMS_PROPAGATION_ADM.stop_propagation(’CDC$P_WFWH_PRD_UAT_SET1′);
exec DBMS_PROPAGATION_ADM.start_propagation(’CDC$P_WFWH_PRD_TO_PRD_SET1′);

Stop / Start Capture:
EXEC DBMS_CAPTURE_ADM.STOP_CAPTURE(capture_name => ‘CDC$C_WFWH_PRD_TO_PRD_SRC1′);
EXEC DBMS_CAPTURE_ADM.START_CAPTURE(capture_name => ‘CDC$C_WFWH_PRD_TO_PRD_SRC1′);

How to Enable Capture tracing on SOURCE site:
1. Stop the capture
2. alter system set events ‘26700 trace name context forever, level 6′;
exec dbms_capture_adm.set_parameter(’yourcapturename’,'trace_level’,'127′);
Start capture
— set trace off after 30 minutes:
3. To turn off capture tracing:
exec dbms_capture_adm.set_parameter(’yourcapturename’,'trace_level’,null);
alter system set events ‘26700 trace name context off’;
Restart capture

How to Enable Propagation tracing on SOURCE site:
1. Stop/Disable Propagation
2. alter system set job_queue_processes=0;
alter system set events ‘ 24040 trace name context forever,level 10′;
alter system set job_queue_processes=10;
3. Start propagation
4. To disable the Propagation tracing
alter system set events ‘ 24040 trace name context off’;
Restart propagation

Run a healthcheck on both source and target:

Metalink: Note.273674.1 Streams Configuration Report and Health Check Script

New Release White Paper through Contractors Network

Tuesday, August 11th, 2009 by

New Release White Paper through Contractors Network

Contractors Network is pleased to announce the latest free of charge release into our extensive Oracle Apps related White Paper Library of:

“Top 8 Considerations When Selecting your Consulting Partner”

Authored By John Klien

Further to John’s Blog we have released it as a White Paper.

About John;

John Klein is a seasoned technology consultant specializing in Oracle Fusion Enterprise Content Management.  John has eleven years of content management experience and his previous employer started the Stellent channel partner program in the US in 1998

A snipit of John’s Paper;

Content Management outsourcing is gaining popularity, particularly due to the various options that are available to those who are seeking assistance - such as project-based consulting or staff augmentation.

If you would like to read more please feel free to email me on rebecca.bragg@oraclecontractors.com to request a copy or or register via the White Paper library and request your copy today.


Celexa Buy Lortab Soma Ativan Buy Celexa Buy Valium Online Seroquel Zovirax Buy Biaxin Buy Hydrocodone Hydrocodone Alprazolam Buy Lexapro Buy Vicodin Buy Oxycontin Buy Paxil Buy Lexapro Buy Zithromax Buy Alprazolam Propecia Biaxin Lorazepam Cialis Glucophage Phentermine Buy Effexor Buy Tramadol Buy Clonazepam Zyprexa Buy Percocet Buy Diflucan Buy Xanax Online Ativan Hydrocodone Seroquel Lorazepam Flexeril Bupropion Tenuate Buy Fioricet Prozac Buy Prozac Buy Tramadol Online Buy Prozac Adipex Levitra Zyprexa Buy Adderall Buy Flexeril Ultram Buy Tramadol Online Lexapro Buy Lipitor Zocor Oxycontin Flexeril Buy Adderall Viagra Buy Levitra Buy Ativan Nexium Buy Valium Online Buy Diflucan Buy Phentermine Cheap Phentermine Acyclovir Darvocet Buy Ambien Butalbital Ultram Bontril Clonazepam Buy Norco Buy Alprazolam Buy Adipex Zyprexa Buy Vicodin Oxycontin Zovirax Buy Phentermine Buy Darvocet