INSTALLATION DOCUMENTS BY RAVI

Showing posts with label OBIEE 11G. Show all posts
Showing posts with label OBIEE 11G. Show all posts

Friday, May 31, 2019

Collecting Diagnostic Information for OBIEE Security Issues Analysis using RDA utility


Important information:
Ensure you are logged on to the host machine experiencing the problem as the Operating System user that owns the files to be collected.
If your issue involves multiple processes distributed across different hosts, follow the instructions for each host machine.

Run RDA:
Navigate to ORACLE_HOME/oracle_common/rda










Set the below environment variables:
ORACLE_HOME
ORACLE_INSTANCE (for 11g only)
DOMAIN_HOME (for 11g, 12c only)








Run the below command:

rda.sh -s OutputFileName  -v -p FM12c_Bi










Note: We may get this issue due to older rda version and resolution is to upgrade the rda utility to newer version.

Checking rda version:























Upgrading RDA:
Download and stage the Patch set 29687335 as below
















































Backup the current rda folder and replace it with rda folder from downloaded patch.




















Check the version now:

























Collecting diagnostic information:

























































































































Note: Upload this zip file to oracle support if we raise any service request.

Thursday, May 30, 2019

Archiving Catalog through Catalog Manager


Open Catalog Manager



























Go to File and Click on Open Catalog





















Provide the details below and click on ok



















Type: Online
User: weblogic
Password: ********
Locale: English



Click on Ok















Double click on Catalog Root and select the folder we want to Archive


















Provide the path and select time stamps and permissions and click on ok



















Click on OK



















Archived catalog file


















Friday, April 27, 2018

obiee 10.1.3.4 installation on windows

Right click on the setup file and select run as administrator






































Click Next

















Provide installation location, data location and installation type

Click Next

















Choose the setup type as complete and click next

















Provide java home and administrator password and click next

















Provide local system account details and click next

















Select the language and click next

















Review the summary and click next

















Wait until installation process completes

































Click Next

















Review the installation summary and click next

















Click Next

We must restart the the system to complete the installation successfully.

After reboot start obiee as below


























Saturday, January 6, 2018

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:













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