3 Replies Latest reply on Aug 3, 2012 12:59 PM by athompson88

    client wallet file permissions

      I am going to be using oracle wallets to store passwords on hosts for per/shell scripts. I created the wallet with the local auto-login option. Updated the sqlnet.ora file, created an entry in the new wallet, and when I'm logged into the OS (RHEL 5) as the oracle user, I can access the wallet and connect to the db just fine. However when I switched to another OS user account to see if our application owner could connect as well, I get

      SQL*Plus: Release Production on Thu Aug 2 16:15:41 2012

      Copyright (c) 1982, 2009, Oracle. All rights reserved.

      ORA-12578: TNS:wallet open failed

      The file permissions are:

      203076 8 -rw-r----- 1 oracle owallet 3965 Aug 2 15:40 cwallet.sso
      195860 8 -rw-r----- 1 oracle owallet 3888 Aug 2 15:40 ewallet.p12

      and the application owner, my_app_owner, is part of the owallet group

      -bash-3.2$ grep ediuser /etc/group

      I am able to connect to the database from the my_app_owner OS account using the credentials stored in the wallet if I provide them directly to SQL*Plus as we would normally.

      Any ideas?