Database
FGA Demo (Storing IP Address of the browser where the SQL statements come from)
Let me introduce you a little expansion of my previous VPD demo to include FGA. Web applications have some issues not only with authentication but also with auditing. For example, the client IP shown in the audit records belongs to Read more…
Database
VPD Demo
I think globally accessed contexts and VPD are the most underused database security mechanisms. Probably, it’s because they’re still a bit unknown despite of being here since Oracle 9. I created this simple themo those days that it’s still valid Read more…
laequipa.com
Welcome To laequipa.com
Hi everybody, Starting this project has been in my head for some time: a technical blog contributed by the instructors related somehow with Oracle University Spain, in and out the company. Most of us have some tips&tricks, FAQs, code examples… Read more…
UCM / WebCenter Content
How to raise the limit of 999999 Content Elements?
If you activate Content ID automatic generation in Oracle Content Server (both versions 10 and 11), you’ll find 6-digit numbers are being generated. That limits the maximum number of content items to 999999, which is too short on most production Read more…
UCM / WebCenter Content
Localization Files in Oracle Content Server 11g
This is not a well-documented thing. Translation to different languages is done through system component “Localization” and we should look for the files in its resource directory: <Middleware_Home>/Oracle_ECM1/ucm/idc/components/Localization/lang/<language code> . My advice is to take a look to all the files to check what’s inside them, but probably, the most useful one of them is ww_strings.xlf, which contains many of the interface strings, as well as the localized values for metadata “Content Type”. These files are XML and you can edit them with the editor of yoour choice.
(more…)
UCM / WebCenter Content
Tutorial: Content Replication between 2 Oracle Content Server instances
Content Replication in Oracle Content Server is one of those “not-so-well-documented features”. It’s mentioned in the product documentation, but it’s not so easy to find a step-by-step tutorial, and that’s what I tried to do. For this example, I’ve setup 2 instances in the same machine: Test1(source) and Test2(target). First step is to start the “System Properties” Application in Test2 and define a new proxy password. We should also make sure that “IP Address Filter” property allows connections from Test1 Machine.
UCM / WebCenter Content
Show Profile links selectively in UCM
Suppose we have created several content profiles as shown in the image below:
(more…)
UCM / WebCenter Content
No LDAP – User metadata mapping shown?
If you’re trying to map LDAP Attributes with user metadata fields in WebCenter Content, but you can’t see the option (please see screenshot)
UCM / WebCenter Content
Some thoughts about “Oracle WebCenterContent 11g Essentials” (1z0-542) exam
I passed this exam recently and got the associated certification. If you’re thinking about it, I’d like to give you a warning: this exam is complex, because questions go far beyond Webcenter Content to cover the whole suite: Site Studio, Document Capture, URM, IP/M and URM.
I strongly suggest a close look at the exam guide and using some of the preparation exams offered by a lot of companies. Good Luck!