Command to get the patch set applied on oracle database

select * from sys.registry$history;

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

Steps for Recovering or Decrypting the forgotten WebLogic Server Admin Password

Note: We can do this only if we have boot.properties file under $DOMAIN_HOME/servers/AdminServer/security

Create a script decrypt_password.py in $DOMAIN_HOME/security directory 

Copy and paste the below code into it and save the file:

from weblogic.security.internal import *

from weblogic.security.internal.encryption import *

encryptionService = SerializedSystemIni.getEncryptionService(".")

clearOrEncryptService = ClearOrEncryptedService(encryptionService)

# Take encrypt password from user

pwd = raw_input("Paste encrypted password ({AES}fk9EK...): ")

# Delete unnecessary escape characters

preppwd = pwd.replace("\\", "")

# Display password

print "Decrypted string is: " + clearOrEncryptService.decrypt(preppwd)

Save and close the file

Set the environment variables as below:

Get encrypted username and password from boot.properties file of AdminServer as below:

Username: 

Password:

Copy this encrypted password and keep it with you

Decrypting the weblogic server admin password:

Navigate to $DOMAIN_HOME/security directory and run the following command to start decryption:

It will ask us to paste the encrypted password,

Paste the encrypted password we get above and click enter

We will get the decrypted password as below:

Step by step oracle golden gate integrated extract

Creating OGGUSER and granting permissions:

Creating OGGSRC and granting permissions:

Creating OGGTRG and granting permissions:

Altering database supplemental log data:

Applying patch:

Creating parameter file:

OGG Extract:

ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory

When we tried to start ggsci prompt in oracle golden gate some times we got the below error

ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory

To resolve this create a soft link as below

Now again try to start the manager