Oracle Application Server Completes Common Criteria Security Evaluation

Oracle Application Server 10g has achieved Common Criteria (ISO/IEC 15408) Evaluation Assurance Level 4+ (EAL4+)

Sphere: Related Content

Document Exchange vs. RPC models

Here is a good discussion on Document Exchange vs. RPC models

Sphere: Related Content

Ruby on Rails on Oracle: A Simple Tutorial

Rails is easy to work with to create simple applications, like Oracle Application express it is a far better than the Microsoft options.

Read more at www.oracle.com/technolo...

Sphere: Related Content

- Google News

Oracle buys Portal Software (Billing system ISV) for USD220M

Read more at news.google.se/news?hl=...

Sphere: Related Content

Object Role Modeling

I worked with the Visual Studio ORM tools earlier so I think the following is good news:

>>

NORMA (Neumont ORM Architect) is a new modeling tool under development that supports the next generation of ORM (ORM 2). Implemented as an open-source plug-in to Microsoft's Visual Studio.NET 2005, NORMA requires at least the standard version of Visual Studio 2005. For further details on the ORM 2 graphical notation, see ORM 2 Technical Report 1. A technical preview of NORMA is available on SourceForge. The software is currently in the pre-beta stage, but extensive functionality enhancements and user-interface improvements are planned for the near future. Currently the tool supports entry of ORM2 schemas, verbalization of of most constraints, and code generation (for basic constraints) to a variety of DBMSs (including SQL Server, DB2, Oracle, and PostgreSQL) as well as class models and XML schema. NORMA is capable of importing ORM schemas entered in Visio for Enterpise Architects, but the diagrams need to be laid out manually.

>>

Read more at www.orm.net/index.html

Sphere: Related Content

Routing around the WS-* vendor stacks (Loud Thinking)

This is a link to an intresting article, quotes includes:

"The gulf between Web Services™ and web services have been widening as of late. HTTP awareness is on the rise, atompub is shining a light for best-practice REST, and the complexity of the WS-* stack is reaching astronautical heights.>>A comment in to the post states: >>So SOAP feels more like the doorknob to the gates of hell. In itself, a doorknob is hardly evil. But once you turn... :)"

Read more at www.loudthinking.com/ar...

Sphere: Related Content

Oracle BPEL PM and Biztalk interop

See this link for a Biztalk - and Oracle BPEL PM & Security WS example:
http://weblogs.asp.net/gsusx/archive/2006/03/22/440881.aspx

Also:
1. See this microsoft technote on Application Interoperability: Microsoft .NET and J2EE
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag/html/JDNI.asp

2. For MSMQ interop see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag/html/jdni_ch05.asp

3. BizTalk Adapters for JMS,
http://www.topxml.com/biztalkutilities/biztalk2004.asp

4. iWAY MSMQ adapter
http://www.iwaysoftware.com/messaging.html

5. Custom .NET code to access an Oracle Streams AQ
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=e97ee3ed-71c0-4fe2-995b-f00418ac7e0b
http://www.codeproject.com/cs/database/aqlib.asp
http://www.oracle.com/technology/sample_code/tech/dataint/index.html

Sphere: Related Content

APPS: Finding Flexfields per table

This SQL gave me a nice report on Oracle Apps flexfields used in a set of tables:

select distinct
fdf.APPLICATION_TABLE_NAME,
fcu.APPLICATION_COLUMN_NAME,
fcu.descriptive_flex_context_code,
fcu.END_USER_COLUMN_NAME,
fcu.ENABLED_FLAG,fcu.REQUIRED_FLAG,fcu.DISPLAY_FLAG,fcu.DISPLAY_SIZE, fcu.FLEX_VALUE_SET_ID
,fvs.FLEX_VALUE_SET_NAME, fvs.DESCRIPTION VALUESETDESC, fvs.VALIDATION_TYPE
from APPLSYS.FND_DESCRIPTIVE_FLEXS fdf
left outer join APPLSYS.FND_DESCR_FLEX_COLUMN_USAGES fcu
on fdf.application_id = fcu.application_id
and fdf.descriptive_flexfield_name = fcu.descriptive_flexfield_name
left outer join APPLSYS.FND_FLEX_VALUE_SETS fvs
on fcu.FLEX_VALUE_SET_ID = fvs.FLEX_VALUE_SET_ID
where fdf.application_table_name in (....list_of_tables...)
order by 1,2,3

Sphere: Related Content

DVM in Oracle BPEL PM

There is a couple of options for Domain value mapping (DVM) in Oracle BPEL PM

A) The XSLT Mapper provides the following database functions for DVM .

1. execute-query() Execute a database query and obtain a result set
2. lookup-table() - Look up a DB table and get a value back

B) Database Adapter

C) Use one of the above to create a BPEL PM Service to do the DVM you need

Sphere: Related Content

AOSD tools for SOA?

Aspect-oriented software development (AOSD) is a holistic approach to developing applications with tools (eg AspectJ, Spring AOP) that uses tools that help abstract concern that crosscuts between different domains/objects.

The definition of AOSD is as follows:

AOSD is an emerging paradigm that provides explicit abstractions for concerns that tend to crosscut over multiple system components and result in tangling in individual components. By representing crosscutting concerns or aspects as first-class abstractions, and by providing new composition techniques for combining aspects and components, the modularity of the system can be improved leading to a reduced complexity of the system and easier maintainability.

AOSD is mostly about single systems and SOA is about interaction between systems or enterprise architectures. But I still think that there are AOSD tools that can help when you design your enterprise systems.

One of this tools is presented in the book "Aspect-Oriented Software Development with Use-Cases" Ivar Jacobson and Pan-Wei NG gives us a AOSD extention to the well known and mature use-case-driven approach.

Sphere: Related Content

glassfish: About GlassFish

"GlassFish is the name for the open source development project for bulding a Java EE 5 application server. It is based on the source code for Sun Java System Application Server PE 9 donated by Sun Microsystems and TopLink persistence code donated by Oracle. " or ... "who needs JBOSS and hibernate..."

Read more at glassfish.dev.java.net/...

Sphere: Related Content

HowTo: Reinstall/Secure EM DBconsole in 10.2

This is the commands to drop and reinstall the EM DBconsole repository and setup TLS security to secure your "SYS" passwords on the network. (If you only want to secure, start at step 3.)

1. emca -deconfig dbcontrol db -repos drop
2. emca -config dbcontrol db -repos create
3. emctl stop dbconsole
5. emctl secure dbconsole
6. emctl start dbconsole

Note that the emca syntax has changed in 10.2. (In 10.1 the commands are emca -x and emca -r ... I think.)

Sphere: Related Content

The Data Administration Newsletter

The Data Administration Newsletter avaliable at http://tdan.com seemes to be a good source of information.

Sphere: Related Content

Never Use Raid 5 for Oracle disks

I have never ever before seen such an excellent collection of articles on the Topic Never Use Raid 5 for your Oracle disks!

Sphere: Related Content

AspectJ 1.5.0 released

News here and here.

Sphere: Related Content

ora-1000 errors, "Maximum open cursors exceeded."

When ora-1000 errors, "Maximum open cursors exceeded." happens most Oracle DBAs think "damned java developers, close your statements!!!". Which is true in 99% of the cases. However sometimes there might be more to it than some statements left open by developers.

Natalka Roshak has an article called "Monitoring Open and Cached Cursors" that helps with some of the debugging pain. Additionally you may use the trace to get a snapshot of the offending cursors when ORA-1000 is thrown.

Enable the errorstack by using alter system or alter session:

alter system set events = '1000 trace name ERRORSTACK level 3'

alter session set events = '1000 trace name ERRORSTACK level 3'

disable by settin it back to off as in ....ERRORSTACK off'

Sphere: Related Content

Content Services Backup

I had a question about how to do enable single file backup from Oracle Content Services for deleted files. The answer is that Oracle Content Services has a two level trash. When users delete a file it goes into their Trash folder - and they can recover files from the Trash themselves. If the user empty their Trash folder the contents are moved to the Archive. The subscriber adminstrator can recover files from the Archive. Each Site contains an Archive folder. Depending on how the Site has been configured, items in the Archive may be automatically deleted after a specified period of time.

Full size backups are handled by RMAN as usuall and the new features in R1 and R2 apply, I hope that you read up on incremental backups and the flash recovery area.

Sphere: Related Content

DBDebunk site

Pascal and Date's DBDebunk site has a lot of good information in it, and there is also a lot of fun!

Sphere: Related Content

Oracle donates ADF Faces to Apache project

Jonas Jacobi and Lucas Jellema both Blog about that Oracle will donate the ADF Faces technology to the Open Source community, as Cherokee - a subproject under the Apache MyFaces project, see

http://www.orablogs.com/jjacobi/archives/001533.html
http://technology.amis.nl/blog/?p=947

This is very good news!

Sphere: Related Content

How to register a XSD schema and use it in a object table

Just a quick example on how to use XMLDB with xml schemas. For more info check the documentation out or purchase some books.

First create a user for your table.

create user mytest identified by nice
default tablespace USERS
temporary tablespace TEMP;
grant connect,resource to mytest;
grant alter session to mytest;
grant create type to mytest;
grant create table to mytest;
grant create procedure to mytest;
grant create trigger to mytest;
grant create view to mytest;

Connect with the new user

connect mytest/nice

Register a schema

BEGIN
DBMS_XMLSCHEMA.registerSchema('region.xsd',
'
xmlns:xsd="http://www.w3.org/2001/XMLSchema">








', TRUE, TRUE, FALSE);
END;

anonymous block competed

Check that the schema was registred

select * from user_xml_schemas

SCHEMA_URL |LOCAL|SCHEMA |INT_OBJNAME |QUAL_SCHEMA_URL |HIER_TYPE |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
region.xsd |YES | |XDBgMQGI96d9zgQAB/AQBiwA== |http://xmlns.oracle.com/xdb/schemas/MYTEST/region.xsd |CONTENTS |

1 rows selected

Create a table

CREATE TABLE region_xmltab OF XMLType
XMLSchema "region.xsd" ELEMENT "region";


CREATE TABLE succeeded.

Insert some XML

INSERT INTO region_xmltab
VALUES (XMLType(
'
xsi:noNamespaceSchemaLocation="region.xsd">
5
Japan
'));

1 rows inserted

Create a OV

CREATE OR REPLACE VIEW region_xmltabv OF XMLType
XMLSchema "region.xsd" ELEMENT "region"
AS SELECT value(r) FROM region_xmltab r;

Get the some information and the XML out of the view

select v.ISSCHEMABASED(),v.GETSCHEMAURL(), v.GETSTRINGVAL() from region_xmltabv v

V.ISSCHEMABASED() |V.GETSCHEMAURL() |V.GETSTRINGVAL() |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 |region.xsd |
5
Japan

|

1 rows selected

Sphere: Related Content