APPS Blogs
UKOUG 2009 ? Server Manageability Roundtable
UKOUG Birmingham 2009
Hi All
Just letting you know we will be exhibiting at the UKOUG Conference in Birmingham 30th November until the 2nd of December 2009.
Please come and visit us at stand 54 & 59
Drop by and register your details with us to win a ROVIO
We look forward to seeing you there
Rebecca
Exception in thread “main” java. lang. NoClassDefFoundError : weblogic/WLST
This is my first attempt with WLST (WebLogic Scripting Tool) which is scripting tool to create , manage and monitor webLogic domains, more information here .
.
You can invoke WLST by running “java weblogic.WLST”
I tried this on my WebLogic Server and straight hit error
_________
Exception in thread “main” java.lang.NoClassDefFoundError: weblogic/WLST
_________
I soon realised that jar file which contains class weblogic.WLST is missing from classpath and quick fix is to set environment variable using setWLSEnv.sh (under WL_HOME/server/bin) . For Fusion MiddleWare (FMW) 11g, it should be under $MW_HOME/ wlserver_10.3/ server/ bin
______
set environemnt variable for weblogic server
cd WL_HOME/server/bin
. ./setWLSEnv.sh
______
$ java weblogic.WLST
Initializing WebLogic Scripting Tool (WLST) …
Welcome to WebLogic Server Administration Scripting Shell
Type help() for help on available commands
wls:/offline>
__________
.
More on WLST commands coming in next posts but here are some WLST basics
.
1. WebLogic Scripting Tool (WLST) – is command line scripting tool to create , manage and monitor webLogic domains and resources/applications deployed on WebLogic
2. WLST is based on Jython based scripting language, which in turn is Java implementation of Python.
3. WLST is used
- To automate common tasks
- If administration console is not available or as alternative to Administration Console
4. WLST can be run in offline and online mode
a) online mode> interact with running weblogic server
b) offline mode> servers in domain should be shutdown and WLST updates directly config.xml on file system
5. If you do not supply any script file then WLST runs in interactive mode.
6.You can generate WLST scripts via WebLogic Console as well -> click on Record button on console after clicking ‘Lock and Edit’ button on change center. To end recording click on ‘Activate Changes’
.
7. WLST communicates with Weblogic’s MBean to retrieve and update resources on a running server.
Related Posts for WLST- Exception in thread “main” java. lang. NoClassDefFoundError : weblogic/WLST
Oracle SOA Suite Consultant required in Gosforth or Glasgow
Our End Client is seeking an Oracle SOA Suite Implementer (With Current UK Security Clearence) for a project in Glasgow or Gosforth.
You will be working on a Oracle SOA Suite Implementation.
Your Desired Skills:
Current UK SC Level
Oracle SOA Suite (SOA, BPEL, ESB)
Oracle JDeveloper for building Web Services Interfaces and User interfaces
Implementation experience of the Oracle SOA Suite & Database components.
Develop Documentation
This project will be 3-9 months.
If you would be interested please send your CV to email rebecca.bragg@oraclecontractors.com
Siebel Technical Designer Required in Leeds
Our End Client Requires a Siebel Technical Designer for a Contractor role in the UK.
You will need to be Working/ Familiar with Siebel Public Sector Application, the Siebel Technical Designer will be responsible for the Technical Design, and configuration of the Siebel application.
Key Responsibilities:
• Interact with functional teams and customer user groups to understand the functional requirements and design/configure solution
• Prepare Technical Design Specification
• Development and configuration for the Siebel 8.1 application, particularly for Siebel Public Sector
• Recommend appropriate technical solutions, Identifies and documents data schema, user interface and base Siebel software changes
• Provide technical design by configuring Applets, Screens, Views, BO, BC’s, Automation, Assignments, EAI, TBUI, Business Rules OPA.
• Coordinate with multiple teams for ensuring the solution implementation.
• Coordinate with Offshore developers to get the build done and provide any technical design clarifications
• Coordinate with Testing team to provide fixes with the help from Offshore team.
Key Skills:
• Experience in customizing Siebel 8.1 using Tools, experience in configuration and scripting, workflows, EAI, Assignment Manager. Must be confident in the configuration of Siebel Views / Applets / Business Components / workflows, EAI, Assignment Manager, and the avoidance of using scripting is essential.
• Experience of OPA, Webservices advantageous
• Exposure to Smart scripts, Correspondence
• Experience in translating functional specs into Technical specs/design, Code Review, sound knowledge of coding standards & best practices is a must.
• Strong experience in Siebel data model, basic DBA knowledge, strong SQL knowledge, troubleshooting along with experience in Technical specs/design, Code Review
• * Experience in Siebel Public Sector and Siebel Financial Services.
You will need to have Negotiating, client facing, communication, assertive, team leading/team member skills, supportive skills.
This role will be 3-6 Months based in Leeds.
Please email daniel.warren@oraclecontractors.com if you would be interested.
Tuning the Oracle E-Business Suite Environment (OpenWorld 2009 Recap)
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:
White Paper Mentor Series: Burned Out
Authored by Khalil Rehman
About Khalil;
Khalil has over 20 year’s functional experience with Oracle Applications having started out in the late 1980s with Oracle General Ledger and Accounts Payables. His in depth knowledge of the Oracle Applications makes him an expert in every sense. He has implemented over 18 different applications in over 54 projects across 14 different countries worldwide. Khalil has spearheaded some of the largest Shared Service Centre projects in the last 7 years.
Heres a snipit:
One of the common reasons for project failure is the burn out of senior project team members during an ERP implementation. It’s not surprising given the increasing demands placed upon them.
We are asked to achieve more results with fewer resources and keep everyone happy.
If you would like request a copy please email myself on rebecca.bragg@oraclecontractors.com or register via the White Paper library today.
How to install weblogic server on 64 bit O.S. (Linux /Solaris) ?
In my first post on WebLogic here here, I discussed about Weblogic installation using 32 bit of JDK so How to install 64 bit WebLogic on 64 bit Operating System (Linux/Unix) ?
.
Install 64 bit WebLogic on 64 bit O.S (Unix/Linux)
1. Download jar file wlsXXX_generic.jar from here under column “Additional Platform”
2. Install 64 bit of JDK on your Unix/Linux machine (steps below)
3. Install WebLogic Server using 64 bit JDK with option -d64 and wlsXXX_generic.jar like
$JDK1.6/bin/java -d64 -jar wlsXXX_generic.jar
.
.
How to install 64 bit JDK on Solaris Sparc ?
Steps mentioned here are for 64 bit Solaris Sparc (If you are using Linux download 64 bit JDK for Linux)
1. Download JDK 1.6 from here and copy it to /tmp
mkdir /usr/java/1.6
cd /usr/java/1.6
2. Install jdk-6u16-solaris-sparc.sh
/tmp/jdk-6u16-solaris-sparc.sh
3. Install jdk-6u16-solaris-sparcv9.sh
cd /usr/java/1.6
/tmp/jdk-6u16-solaris-sparcv9.sh
4. Check JDK version
bash-3.00# cd /usr/java/1.6/bin
bash-3.00# ./java -d64 -version
_______
java version “1.6.0_16″
Java(TM) SE Runtime Environment (build 1.6.0_16-b01)
Java HotSpot(TM) 64-Bit Server VM (build 14.2-b01, mixed mode)
_______ .
References
- Download WebLogic Software
- Install 32 Bit Java
- Install 64 bit Java
- WebLogic Server Installation Guide
- Oracle WebLogic Installation Steps
- Domain , Administration & Managed Server, Cluster in Oracle WebLogic
- Create Domain in Oracle WebLogic
- Oracle WebLogic Server - Startup/Shutdown
- Oracle WebLogic Server 10g R3 10.3 is out now
- Deploy Application on Oracle WebLogic Server
- Cluster Architecture : Oracle WebLogic Server
- Start WebLogic Server on Linux on port 80, 443 <= 1024
- JDBC (Java DataBase Connectivity ) in Oracle WebLogic - Overview
- WebLogic Server JDBC for Database connection : Step by Step
- Security in Oracle WebLogic : Realm, Security Provider, Authentication, Authorization, Users
- Deploy ADF application to Oracle WebLogic Server
- Node Manager in Oracle WebLogic Server
- Configure Oracle HTTP Server infront of Oracle WebLogic Server mod_wl_ohs
- How to install weblogic server on 64 bit O.S. (Linux /Solaris) ?
Integration Architectures for Oracle EBS (OpenWorld 2009 Recap)
Oracle SOA Designers & Developers Required in the UK
Our End Client is currently seeking the below Oracle SOA Consultants
*** Oracle SOA Architects ***
The Oracle SOA Designer is responsible for understanding high level specifications and producing / maintaining low level designs. The Designer should have excellent communication skills and be capable of guiding developers during implementation and deployment phases.
The Designer must have hands-on experience of Oracle’s SOA Suite and be capable of producing complex artefacts to standard.
Responsibilities will include:
• Production of detailed design specifications for SOA Services and Composite Applications using common Design Patterns
• Mentoring teams of developers in an agile environment
• Production of XML artifacts using Oracle AIA standards
• Critical review of design and high level specifications. Quality review of code, documentation, reports and other deliverables produced by other team members.
• Production of quality code where project timescales demand
• Ability to create and maintain quality standards
• Support during the deployment of software artefacts
Essential Skills will include the following
Oracle SOA Suite (10.1.3.*)
Enterprise Service Bus
BPEL
SCA
Web Services
Java
XML (xsd, xslt, etc)
Oracle 8i, 9i,10g and/or 11g
PL/SQL
*** Oracle SOA Developers ***
The developer is responsible for the production and ongoing support of software that meets the needs of the customer and is developed to agreed quality standards and timescales within a structured development framework.
Responsibilities will include:
• Development and unit testing of SOA-enabled applications and business processes using Oracle JDeveloper and Oracle SOA Suite
• Production of XML artefacts and XSD’s.
• Production of program specifications from low level designs
• Critical review of design and specifications. Quality review of code, documentation, reports and other deliverables produced by other team members.
• Liaising with other teams, business areas and third parties where assistance to or from Applications Support is required in incident resolution.
Essential Skills will include the following:
Oracle SOA Suite (10g)
Enterprise Service Bus
Web Services
Java
XML
Oracle 8i, 9i and/or 10g
We have an opening for an *** Oracle Lead SOA Developer also. If you would be interested please email on rebecca.bragg@oraclecontractors.com
EBS 12 Certified with 10gR2 10.2.0.4 DB on Windows Server x64 (64-bit)
More thoughts on AS/400 and World
RMAN backup-based duplicate database without connection to the source in 11GR2
11g release 1 introduced the RMAN active database duplication feature, where you can duplicate a database without having to take a backup of the source database.
A new feature in 11g release 2 is the ability to use RMAN to duplicate a database without having to connect to the source database. At the time of writing, most of the RMAN documentation tends to refer you back to 10gR2 documents for backup-based restores, whilst 11gR2 documents tend to focus on active database duplication, so I thought that a blog on this topic could be of use.
This functionality would be useful if you have thought about using the 11g active database duplication feature, but are concerned about possible network performance issues during the process.
Another situation where this procedure could be used, is where you have been asked to create a copy of a database on an isolated test server, where connection to the source database is not possible.
As in previous Oracle versions, it is still possible to create a clone of the source database by just extracting the database files from the RMAN backuppieces using DBMS_BACKUP_RESTORE. (See my previous blog “Extracting database files from RMAN backuppieces using DBMS_BACKUP_RESTORE” for an example of this). 11gR2 introduces a much more straightforward method of cloning the database without a connection to the source database.
An example of this process is shown below. In this scenario we’ll assume that the server that you’re duplicating the database to, has the same directory structure as the source server and that you want the cloned database to have the same name as the original source database. The source database is using an SPFILE. We’ll also assume that you’re not using a recovery catalog on the source or target servers, as this would probably be the situation if restoring to a remote test server. The SID of the database is ORCL, so replace with your own SID where appropriate.
The cloned database needs to be on the same platform as the source database and also have 11gR2 installed.
WARNING/DISCLAIMER: Before running any of these commands, you should ensure that you have current backups of any databases on the server. Refer to the more comprehensive Oracle support site notes and Oracle documentation before carrying out any work in a formal environment. The author accepts no responsibility for any damage to your data, server or database, by carrying out the commands below.
1) Take a full backup of the source database.
——————————————-
Our example database is running in archivelog mode, so we can take a hot backup.
a) create a directory to store the output from the backup. (For this example, I created the directory /u02/oradata/backup_orcl ).
b) Set your environment to the required database. (e.g. by running . oraenv)
c) Run RMAN commands to take the backup. We’ll specify an alternate location for the backups, otherwise they’ll just default to the flash recovery area (FRA). Whilst you could use the contents of the FRA for the clone, there may be files from other database in the same shared area and there could also be files here from previous backups, which you don’t need for this clone. Sending the backup to a separate location makes it easier to identify the files that you need.
rman
connect target
spool log to ‘/u02/oradata/backup_orcl/full_database_orcl.log’;
configure channel device type disk format ‘/u02/oradata/backup_orcl/orcl_%U’;
backup database plus archivelog;
exit
(You can run tail -f /u02/oradata/backup_orcl/full_database_orcl.log as the backup runs, if you wish to monitor progress).
2) Configure the environment on the destination server
—————————————————
a) Create a password file in $ORACLE_HOME/dbs using the orapwd utility.
b) Configure the $ORACLE_HOME/network/admin/listener.ora file. The only entries used for this work were:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/opt/oracle/product/11gR2/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
c) Configure the $ORACLE_HOME/network/admin/tnsnames.ora file. The only entry added for this work was:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
d) Create directories on the target server that are present on the source server. (e.g. archive destination, scripts, application directories, utl_file/dba_directories, flash recovery area, external table locations, database/redo log/controlfile/admin/diag directories, backup locations etc.)
e) Create the $ORACLE_HOME/dbs/initSID.ora file for the duplicate database. The only entry needed is:
db_name=’orcl’
No other information is required, as we’ll extract the source database SPFILE from the backup.
f) Add an entry to /etc/oratab for the database.
g) Set your environment to the new database and then startup the clone instance.
sqlplus / as sysdba
startup nomount
exit
h) Run RMAN command to clone the database. (We don’t need to specify the database name or DBID, as these are obtained from the backups).
rman auxiliary /
DUPLICATE DATABASE TO orcl
SPFILE
BACKUP LOCATION ‘/u02/oradata/backup_orcl’
NOFILENAMECHECK;
exit
Note: Be careful when running any duplicates on the same host as the source database when specifying the NOFILENAMECHECK option. This option could mean that you over-write your source database files.
i) Finally, you will need to re-create a tempfile for your temporary tablespace. From 10gR2, this would normally be created for you in a standard RMAN clone, but it is not re-created at present when using this method.
A tempfile is created, but it is not recognised as being part of the database - i.e. select file_name from dba_temp_files; returns the errors: “ORA-01157: cannot identify/lock data file X“ From the trace files it looks like there are some issues with the tempfile creation process. Sample errors are “Cannot re-create tempfile dbf, the same name file exists“ and “ORA-03214: File Size specified is smaller than minimum required“. It seems that the file creation works, but the file created is too small to be usable at 8MB - the original tempfile was 29MB in this test database.
This may be due to a bug, or due to the current design of this feature, or it could be due to the configuration of the test database used for this scenario. Fixing the issue is pretty straightforward - just drop and re-create the tempfile:
alter database tempfile ‘/u01/opt/oracle/oradata/orcl/temp01.dbf’ drop;
alter tablespace temp add tempfile ‘/u01/opt/oracle/oradata/orcl/temp01.dbf’ size 100M reuse autoextend on maxsize 5120M;
Other useful features of the duplicate process are that you can choose to exclude selected tablespaces and you can also choose to carry out a point-in-time duplicate of the source database.
References used: Oracle Support notes 228257.1, 259694.1, 452868.1, 452868.1, 568034.1, 374934.1,
Oracle Database Backup and Recovery User’s Guide 11g Release 2 (11.2) - ch 23: Duplicating a Database
Apex Seminarie: Bouw professionele toepassingen met Oracle APEX (Dutch Only)
De uitnodiging is als volgt:
"Stap voor stap zullen we aantonen hoe je op een snelle en eenvoudige manier veilige en mooi ogende data-driven webtoepassingen bouwt en uitrolt, en dit allemaal zonder zware architectuur en zonder lange leertrajecten. Om dit alles te staven, kan je tijdens het seminarie live de installatie van Oracle Apex volgen, bouwen we een volledig nieuwe applicatie met Apex, en plaatsen we deze webtoepassing ook nog eens in productie.
Na het seminarie beschik je over de nodige informatie om zelf onmiddellijk aan de slag te gaan. 'Express' in de productnaam is geen ijdele marketing kreet. Laat je enkele uren op sleeptouw nemen en laat je overtuigen!"
Wanneer: 8 December vanaf 13:30
Waar: kantoren te Kontich
Inschrijven kan via deze weg.
Permanent Hyperion Planning Developer located in London 50-55 K
Our End Client is Seeking a Permanent Hyperion Planning Developer located in London. 50-55k
You will be responsible for:
Build business relationships with internal clients, Provide business analysis. Technical and system design for new applications or enhancements to existing applications. Develop and Implement new Applications. Provide support for existing applications on a day to day basis. Develop Reports, load rules, calc scripts, forms, task lists, menu items, business rules and look after the Production of all forms of technical documentation, including architecture, technical design, support documents and end user manuals.
Key Requirements:
Extensive Planning V9 experience
Extensive Essbase knowledge
Skilled in Microsoft applications software (Word, Excel, Outlook etc)
Understanding of Wholesale Financial Services would be helpful
Ability to develop new skills and understand new technology as required
Ability to design and build databases
Ability to Optimise Databases
Ability to build Rules, Load Rules and develop calc scripts
Understanding of Security
Please note you must have a Work permit in place for the UK for this role. This role is due to start ASAP If interested please email me your current availability and an up to date CV to rebecca.bragg@oraclecontractors.com
Critical Data Protection + Security in EBS (OpenWorld 2009 Recap)
Fixed Term Oracle HR Discoverer Developer required in the UK
Our End Client in the UK requires a Oracle HR Discoverer Developer. You must be very strong in your Discoverer experience.
Working as a member of the HR Systems Team, this role will play a key part in moving the HR systems strategy forward using Oracle E-business suite. The position will provide essential technical development skills to the team and help us to deliver scalable management information via Discoverer reporting to the business.
Role & Responsibilities:
Working with the HR Systems Team on requirements, priorities & technical guidance.
Ownership, design, development and maintenance of required Discoverer EUL structures.
Working with existing strategic suppliers and playing a role in selection and procurement of new technologies and solutions.
Create relationships with both key stakeholders and users of the HR systems ensuring support is delivered in an effective and efficient way.
Deliver support and maintenance of all HR Systems with the Group IS change management processes and contribute to the ongoing streamlining of HR processes.
Support ad hoc project work, contributing to the production of project documentation including business case, project plans and solution designs.
Essential Skills & Experience:
Oracle Discoverer 10g development (Reports, Forms & Customisations).
Solid experience of Oracle E-business Suite - to include Fast formula, HR, CWB, Payroll and learning and development modules.
Discoverer 10g Development & Administration (including EUL Design).
SQL and PL/SQL.
TOAD.
Knowledge of HR processes and HR systems.
Confident and self motivated.
Experience of problem solving and user support.
Excellent written and verbal communication skills.
Please note you must have a UK working permit to apply for this position.
If you would be interested in this position please email your current CV and availability to rebecca.bragg@oraclecontractors.com.
Application Change Management Pack for EBS (OpenWorld 2009 Recap)
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:
Fundamentals of Change Management in an Oracle ERP Transformation Programme
Authored by Khalil Rehman
About Khalil;
Khalil has over 20 year’s functional experience with Oracle Applications having started out in the late 1980s with Oracle General Ledger and Accounts Payables. His in depth knowledge of the Oracle Applications makes him an expert in every sense. He has implemented over 18 different applications in over 54 projects across 14 different countries worldwide. Khalil has spearheaded some of the largest Shared Service Centre projects in the last 7 years.
He is an accomplished author and has written articles on accountancy and Oracle Applications since the early 1980s Khalil is a member of the UKOUG White Paper panel and regularly reviews the latest trends on behalf of Oracle.
This paper is split in 4 key areas
Content
The process of Change
Obstacles of Change
How to Manage Change
If you would like request a copy please email myself on rebecca.bragg@oraclecontractors.com or register via the White Paper library today.


