Monday, September 10, 2012

[gslusw]:Error reading 'ods' passwd from wallet [gsdsiConnect]:Error reading 'ods' passwd from wallet


[gslusw]:Error reading 'ods' passwd from wallet  [gsdsiConnect]:Error reading 'ods' passwd from wallet

If you are getting this error than the wallet password cant be read and not able to make the Connection to the database from the mid tier box
While you are trying to create a wallet the error appears


[oracle@fah oracle]$ /u03/app/oracle/product/fmw/idm/ldap/bin/oidpasswd connect=oiddb change_oiddb_pwd=true
current password:
    new password:
confirm password:
Replication password file exists
[gslusw]:Error reading 'ods' passwd from wallet
[gsdsiConnect]:Error reading 'ods' passwd from wallet
password set


Step1
Check the env variables


[oracle@fah ~]$ export ORACLE_INSTANCE=/u03/app/oracle/admin/oid_inst1
[oracle@fah ~]$ export ORACLE_HOME=/u03/app/oracle/product/fmw/idm
[oracle@fah ~]$ export PATH=$ORACLE_HOME/bin:$PATH
[oracle@fah ~]$ export PATH=$ORACLE_HOME/ldap/bin:$PATH
[oracle@fah ~]$ export PATH=/u03/app/oracle/product/fmw/idm/opmn/bin:$PATH

Set the ENV variables According to your environment

Step 2 
Check the Wallet files permission and check whether it is in the expected location
 when you are creating the wallet it will create the two new files in the  $ORACLE_HOME/ldap/admin
cd /u03/app/oracle/product/fmw/idm/ldap/admin

 oidpwdlldap1
 oidpwdroidm   oidpwdro<databaseSID>


[oracle@fahtestapp admin]$ ll oidpwd*
-rw-r--r-- 1 oracle oinstall 207 Sep  9 23:42 oidpwdlldap1
-rw-r--r-- 1 oracle oinstall 215 Sep  9 23:42 oidpwdroidm
backup these files and rename  the file

Step3
Check the database connection and the tnsnames.ora file location


If the tnsnames.ora file or the database connection has some issue you can cet an another error message also while creating the wallet

[oracle@fahtestapp oracle]$ /u03/app/oracle/product/fmw/idm/ldap/bin/oidpasswd connect=oiddb change_oiddb_pwd=true
current password:
    new password:
confirm password:
Unable to Connect to Database: Incorrect location for tnsnames.ora (derived from ORACLE_INSTANCE) or Incorrect TNS Connect string or Invalid Password

Check the tnsnames.ora file in the location of the $ORACLE_HOME/network/admin
/u03/app/oracle/products/fmw/idm/network/admin
check Whether the tnsnames.ora file is present in the specified directory $ORACLE_HOME/network/admin if it is not in the directory create a tnsnames.ora file with the necessary values..

Setp4
Check the tnsping from the Mid-tier to the database 

check the tnsping it shoud use the TNSNAMES ADAPTER TO RESOLVE IF it is using the host names ADAPTER then you need to check the string in the tnsnames.. 

[oracle@fahtestapp config]$ tnsping OIDDB

TNS Ping Utility for Linux: Version 11.1.0.7.0 - Production on 09-SEP-2012 23:00:47

Copyright (c) 1997, 2008, Oracle.  All rights reserved.

Used parameter files:

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=<host name>)(PORT=<port number>))(ADDRESS=(PROTOCOL=TCP)(HOST=<host name>)(PORT=<port number >))(ADDRESS=(PROTOCOL=TCP)(HOST=<host name>)(PORT=<port number >)))

[oracle@fah ~]$ tnsping OIDDB

TNS Ping Utility for Linux: Version 11.1.0.7.0 - Production on 10-SEP-2012 13:07:49

Copyright (c) 1997, 2008, Oracle.  All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = OIDM)))
OK (0 msec)


 tnsping is working fine and set the proper env variables and proceed to create the wallet


[oracle@fah admin]$ sqlplus ods/<password>@OIDDB

SQL*Plus: Release 11.1.0.7.0 - Production on Sun Sep 9 23:41:13 2012

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
and Real Application Testing options

SQL> show parameter db_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      OIDM
SQL> exit


Step 5


[oracle@fah admin]$ $ORACLE_HOME/ldap/bin/oidpasswd connect=OIDDB create_ wallet=true                                                                                   
password:
confirm password:
password set

[oracle@fahtestapp admin]$ ls oidpwd*
oidpwdlldap1  oidpwdroidm  oidpwdroidm_backup  oidpwdrOIDM_backup

The wallet had been created with the two new files had been create in the $ORACLE_INSTANCE/OID/admin
















No comments:

Post a Comment