INSTALLATION DOCUMENTS BY RAVI

Sunday, February 11, 2018

Oracle database RMAN and archive logs

Starting rman















Connecting to the target database:






Archivelog List:



















Delete archive logs


















Enter yes to delete 












Failure -Test failed: ORA-00257: archive error. Connect internal only, until freed














Check the status of the archive log






Check the database archive log destination








It is showing archive log space is full

Remove some archive log files






If we get limit exceed error, increase the archive log size as below

ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=20048576000 SCOPE=BOTH;





Restart the database


































How to kill forcefully running oracle database process in linux


Connect to server through putty and issue the below command

ps -ef |grep pmon





Now kill the port running the process ora_pmon_orcl as below




Command to get the patch set applied on oracle database


select * from sys.registry$history;














Sunday, February 4, 2018

OBIEE 12 C SCHEMAS AND DESCRIPTION

DEV_IAU : Audit Services
DEV_IAU_VIEWER : Audit Services Viewer
DEV_IAU_APPEND : Audit Services Append
DEV_BIPLATFORM : Business Intelligence Platform
DEV_MDS : Metadata Services
DEV_WLS : WebLogic Services
DEV_WLS_RUNTIME : Runtime WebLogic Services
DEV_OPSS : Oracle Platform Security Services
DEV_STB : Common Infrastructure Services



Steps for enabling auto startup for essbase applications using maxl script

Below are the steps to enable auto startup for essbase applications on servers reboot

Navigate to $MW_HOME/instances/instance1/Essbase/essbaseserver1/bin and start the maxl shell








Login to essbase








Enable startup and auto startup for the essbase application with below commands

alter application 'OBIA' enable startup;
alter application 'OBIA' enable autostartup;







Now the applications will start automatically on restarts

Quit the maxl shell as below









HYPERION FINANCIAL REPORTING STUDIO “RUN-TIME ERROR 429”

After installing Oracle Financial Reporting Studio When we tried to launch the studio sometimes we will face the below error














Solution:
To resolve this error
Navigate to the below path
E:\Oracle\Middleware\EPMSystem11R1\products\FinancialReportingStudio\products\financialreporting\install\bin
And run “HRRunAnt.cmd” administrator










Now try to launch the Financial Reporting Studio again















  Opatch reports 'Cyclic Dependency Detected' error when patching ODI   Issue: When applying a Patch Set Update (PSU) to WebLogic Se...