Select Page

Art of BI: Keystore Wallet File – cwallet.sso – Zum Teufel!

Christian Screen | | August 30, 2012

One of the items that trips up a FMW implementation, if only for mere minutes, is the cwallet.sso file.  This file is an encrypted trusted storage or wallet file (as it is referred) that contains password credentials and other security information.  The data stored here is typically used to connect to other external systems such as a mail server, RPD, Hyperion, etc. from WLS/EM. In relation to modifying or managing this in Oracle BI 11g, you may want to look into the Action Framework capability to learn more as it relates to extending the functionality of the tool and leveraging the credential store to manage third party tool credentials.

However, this file and its permissions can affect a basic out of the box Oracle BI 11g implementation which is mainly the gist of this post.

In a Windows environment, even when installing as an administrator on the server these credential store files can appear to be secured or “locked down” and will rear its bad ACL permission “Access Denied” error message when starting or restarting the BI System even if the user who installed the Oracle BI system attempts to start the Oracle BI System.

On a *Nix environment this issue is seldom, if ever, seen.  So when using an Oracle BI system on a Windows environment, as part of the post-installation process be sure to go through to the following locations and update the ACL so that the Administrators group – or simply the service accounts that are starting the system – have modify permissions to the cwallet.sso files in the following directories.

  • F:OracleFMWinstancesinstance1configOPMNopmnwallet
  • F:OracleFMWuser_projectsdomainsbifoundation_domainconfigfmwconfigbootstrap
  • F:OracleFMWuser_projectsdomainsbifoundation_domainconfigfmwconfig
  • F:OracleFMWinstancesinstance1configJPS
  • F:OracleFMWuser_projectsdomainsbifoundation_domainopmninstance1wallet

Hopefully that saves you a few minutes in the future.  If anyone has any technical data contrary to this tactic please let me know.

References:

Enhanced by Zemanta

12c Upgrade Bug with SQL Tuning Advisor

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018

Scripting Out the Logins, Server Role Assignments, and Server Permissions

Imagine there are over one hundred logins in the source server and you need to migrate them all over to the destination server. Wouldn’t it be awesome if we could automate the process by generating the scripts for the required tasks?

JP Chen | October 1, 2015

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS