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 MoreIf 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 MoreQuick 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 MoreORA-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 MoreThis 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 MoreThe 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 MoreAt 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 MoreIt 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 MoreEverything 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 MoreWhile 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