A report in Oracle BI Publisher Enterprise v11.1.1 returned “No data found.” for all elements in the report when viewed by guests and administrative users. The report used several data sources and only worked for the sysman user. The problem data source turned out to be the default data source, EMREPOS, which stores all of the Oracle Enterprise Manager data and for this installation is also the BI Publisher repository. EMREPOS is a hidden data […]
Category: Oracle
Intro: SSO for EBS R12
There are four essential components to enabling Active Directory (AD) logins to Oracle EBS R12 including: Identity Management (IDM), Unified Directory (OUD), Access Manager (OAM) and Access Manager WebGate. Only the WebGate is installed on the EBS application tier. IDM uses Directory Integration Platform (DIP) to integrate AD users into OUD. OAM handles requests from the WebGate on EBS to authenticate AD users in OUD. IDM, OUD and OAM each require a WebLogic server (WLS). If all […]
Selective Oracle Logon Trigger for Auditing
The Oracle logon trigger can be a very powerful tool for recording who or what is accessing your database. However, you may not need to know when every user or every host or even a specific application logs into Oracle. The following trigger shows one possibility for selectively auditing user logons.
ORA-28221: REPLACE not specified
I came across a problem today in which a user could not reset her password without getting the “ORA-28221: REPLACE not specified” error. The correct “alter user” syntax to resolve this error is: alter user USERNAME identified by NewPassword replace OldPassword;
Create Table DDL from Oracle to MS-SQL
So you want to create some tables in Microsoft SQL based on tables that exist in Oracle? The Microsoft SQL Migration Assistant (MSSMA) can help, but it’s a bit tedious and if you have triggers on your tables, MSSMA will create rowid columns in SQL that don’t really exist in Oracle except as pseudo-columns used to indicate where data is stored in a file on disk which is subject to change. I will cover a […]