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.


Enhanced by Zemanta

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

ORA-12154: TNS:could not resolve the connect identifier specified

Most people will encounter this error when their application tries to connect to an Oracle database service, but it can also be raised by one database instance trying to connect to another database service via a database link.

Jeremiah Wilton | March 4, 2009

12c Upgrade Bug with SQL Tuning Advisor

Learn the steps to take on your 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

Work with Us

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


Work for Us

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