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

Step by step installing oracle golden gate

Download and stage the software
Oracle GoldenGate 12.2.0.2.2 for Oracle on Linux x86-64 (584 MB)

Installing required rpms:

Installing the Oracle Golden Gate software for the replication source

Login as oracle user

Create a directory for installing ogg for source as below

Change to software directory and run the installer as below

Select database and click Next

Provide the details and click next

Click on install

Click close to finish the installation

Installing the Oracle Golden Gate software for the replication target

Create a directory for installing ogg for target as below

Change to software directory and run the installer as below

Click next

Provide details and click next

Click install

Click close to complete the installation

Starting manager:

Login to ggsci prompt

Now start the manager as below