We have been having a lot of fun with the latest Oracle Fusion Middleware 11g stack. Are you having trouble getting WebCenter 11g properly integrated with Identity Management 11g and OID? We can help.
ORA-00845 on Oracle 11g DB in a Virtual Machine (OVM)
If you run across this error when trying to start a database instance within a virtual machine, chances are that you may have reduced the allocated RAM to the VM. This is due to the automatic memory management module of Oracle DB 11g. One solution is the increase your memory allocation back. ORA-00845: MEMORY_TARGET not supported on this system Problem Description While creating a startup database using dbca the database creation GUI gives error message in a pop up window, ORA-00845: MEMORY_TARGET not supported on this system from where you can ignore the error message. The similar scenario also occur … Read More
Oracle OpenWorld OOW 2010 – Middleware
As has become tradition, I will be attending Oracle OpenWorld again this year joined by a few other M&S team members focused on Oracle Fusion Middleware. Let us know if you will be around and want to meet up. The most solid agenda items I have are the authors’ seminar for a new WebCenter 11g book we are releasing (more on that to come), a few of the SOA, BPM, Governance, and Enterprise 2.0 events with Product Management teams, and, of course, the concert.
Oracle DBMS_SCHEDULER vs DBMS_JOB (Create, Run, Monitor, Remove)
DBMS_SCHEDULER is a newer, more complex job scheduling engine released in 10g, intended to replace DBMS_JOB going forward. DBMS_JOB, the older job scheduler, as of now is still available for quick and easy DB based job scheduling.
Job scheduling comprises the core of the functionality of DBMS_SCHUDULER, however here are some additional benefits available to DBMS_SCHEDULER:
- Logging of job runs (job history)
- Simple but powerful scheduling syntax (similar to but more powerful than cron syntax)
- Running of jobs outside of the database on the operating system (see below)
- Resource management between different classes of jobs
- Use of job arguments including passing of objects into stored procedures
- Privilege-based security model for jobs
- Naming of jobs and comments in jobs
- Stored, reusable schedules
Installing APEX 4 on Windows Server 2003 64 bit edition with Oracle Database 11g
Overview
This tutorial article and it’s associated video will help guide you through the process of installing APEX version 4.0 in a Windows Server 2003 64 bit OS environment with Oracle Database 11g R2 installed.
Tutorial Video
[youtube]http://www.youtube.com/watch?v=pLK1r8UY42I[/youtube]
High Level steps
1. Create destination directory and extract APEX files. (0:20)
2. Login via SQLPLUS (1:13)
3. Install APEX 4.0. (1:58)
4. Change APEX ADMIN password (2:40)
5. Configure PL/SQL Gateway and unlock Anonymous User. (3:15)
6. Verify XML DB HTTP Port (4:04)
7. Enabling Network Services (4:32)
8. Enable Indexing on online help for 11g R2 (4:32)
9. Check Job Queue Processes and Shared Servers (6:45)
10. Check for Previous Releases and remove if needed. (7:00)
11. Remove Invalid ACL’s if needed (7:27)
12. Verify Install by logging in. (8:00)
Oracle Enterprise Manager (EM) 11g – Adobe AIR Desktop Widgets
I like seeing Oracle leverage non-Oracle technology, like Adobe Flex and AIR. I hope that trend continues for Oracle…while Microsoft goes off to build things like Silverlight and Apple simply decides to avoid support for Flash altogether on their iPhone and iPad devices. I haven’t played with these widgets myself yet, but I do like the idea and sure we will be leveraging them. Click to Download – Oracle Enterprise Manager 11g Desktop Widgets Click to Blog – Oracle Enterprise Manager 11g Desktop Widgets
WebLogic and WebCenter SSO with IIS – Windows Native Authentication (WNA), SPNEGO using Active Directory (AD)
Setting up Windows Native Authentication (with Kerberos) Single Sign-On (SSO) within WebLogic can be tricky. One way to accomplish this is to use IIS to front-end the WebLogic cluster. You need to use an IISIdentityAsserter in this scenario. Using an Identity Asserter based on HTTP headers has security implications and it’s important to ensure the communications are locked down between the IIS front-end to the WebLogic cluster. I don’t have much time to type more about this, but was excited about some recent work and wanted to get a quick post up in reference to this.
SQL to Query Oracle, Return XML – with SQLX
Like many days, I had a need to query data stored in Oracle. But today was different. I needed to return the data in an XML format. I started with a very simple need and generated the XML brute-force while traversing my cursor. However, I realized the data would not be escaped properly and knew/assumed Oracle has created built-in functionality to accomplish what I was trying to do. I then recreated my logic using DBMS_XMLGEN. This worked well, in that it created the desired result set, but I hate the idea of storing SQL in a string to be passed … Read More