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;

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: