Category Archives for Database

Enterprise User Security (EUS) overview for Oracle Database 10/11g

Enterprise User Security (EUS) is process of integrating Oracle Database with LDAP compliant directory server like Oracle Internet Directory (OID) or Microsoft Active Directory so that database Users can be centrally managed in LDAP Directory Server.     When EUS feature of databases is configured and enabled, all EUS enabled databases can authenticate users based on information […]

Read More

11g Database Installation failed with “File not found .. WFMLRSVCApp.ear”

If you are installing 11g database and hit error “File not found… WFMLRSVCApp.ear” ensure that you have downloaded two disks (for software) and both disks are unzipped in same folder.

Read More

How to compile Apps Schema (invalid objects) in R12 ?

Quick tip on how to compile apps schema (or invalid objects in database) in Oracle applications R12 You can compile invalid objects (or Apps Schema) using below three methods (compiling invalid is not limited to these three methods) 1. From Database Tier a) Login as database tier user (ovisr12 in my case) b) Set environment […]

Read More

ORA-19566: exceeded limit of 0 corrupt blocks for file ….. found same corrupt data (r12)

ORA-19566: exceeded limit of 0 corrupt blocks for file ….. found same corrupt data Yesterday, during RMAN (11g) backup the aforementioned issue was raised and resolved by following the enclosed Document. Error: ORA-19566: exceeded limit of 0 corrupt blocks for file /oracle/PROD/db/apps_st/data/system09.dbf Alert Log Entry: Reread of blocknum=165656, file=/oracle/PROD/db/apps_st/data/system09.dbf. found same corrupt data Dont forget to […]

Read More

Migrating Non ASM DB to ASM DB

This is a sample document showing how to migrate Non ASM DB to ASM DB 1 create the ASM instance 2.Create the required  DISK groups according to  the needs DB name DEVEL SQL> select file_name from dba_data_files; FILE_NAME ——————————————————————————– /oracle/DEVEL/system01.dbf /oracle/DEVEL/undotbs01.dbf /oracle/DEVEL/sysaux01.dbf /oracle/DEVEL/users01.dbf /oracle/DEVEL/example01.dbf SQL> select name from v$controlfile; NAME ——————————————————————————– /oracle/DEVEL/control01.ctl SQL> select MEMBER […]

Read More

Duplicating the DB from PRODUCTION to DEVELOPMENT using RMAN

The topic is related to creating a duplicated copy of  DB from production  to Development  using rman. The below steps are applicapable in 9i,10g and 11g.In 11g there are some new methods for creating duplicate DB  which I will be covering  in coming topics The database names used here database names: Primary Database SID:       PROD  server […]

Read More

Exporting and Importing policies in Oracle Entitlement Server.

At times, it is important to import/export policies from Database. I am explaining the scripts to be used to achieve this. The policies are present in the XML config file policyIX_config.xml in the location BEA_HOME/ales32-admin/bin. To export policies from Database to an XML file: Assume you are running from the location  BEA_HOME/ales32-admin/bin. ./policyIX.sh -export ../config/policyIX_config.xml […]

Read More

Re-install ALES Schema

It is pretty straight forward to create the ALES schema using DB Config tool. I am writing here something which is not documented anywhere as to how to re-run the DB config tool if wrong values are specified for oes username or password etc.,               Here are the steps to be followed to revert and re-run […]

Read More

Oracle eBusiness Export Function Stopped Working (11i export report to Excel)

Everything was okayed before and now the aforesaid issue occurs. Login to SQL*Plus as apps user and run the following: set serveroutput on declare db_file NUMBER; mime_type VARCHAR2(255) := ‘text/plain’; out_string VARCHAR2(32767) := ‘Just some plain text that is stored.’; web_server_prefix VARCHAR2(500); url VARCHAR2(500); begin db_file := fnd_gfm.file_create(content_type => mime_type, program_name =>’export’); fnd_gfm.file_write_line(db_file, out_string); db_file := fnd_gfm.file_close(db_file); […]

Read More

opatch requires response file for Oracle Configuration Manager (OCM) : One-off patch installation failed during configuration

While upgrading one of Oracle Software using runInstaller, I received error One-off patch installation failed during configuration . I looked at inventory log$INVENTORY_LOCATION/ logs/ installActions[YYYY]-[MM]-[DD]_[hh]-[mm]-[ss][PM|AM].log and realised error was related to Oracle Configuration Manager ( OCM ) _______ ERROR: OPatch failed because of cmd. args. problem. To run in silent mode, OPatch requires a response file for […]

Read More
1 6 7 8 9 10 13
Not found