FAILED TO DO DATA ASSOCIATION FOR OES DOMAIN(ORA_01017)
Error log:
Problem Description
-------------------
1.Prepare Database
Run the RCU utility
Create Prefix: DEV
Select:IdentityManagement->Oracle Adaptive Access Manager
IdentityManagement->Oracle Access Manager
2.Install IDM Suite
3:Configure IDM Suite
4.Configure Security Store
oracle_common/common/bin/wlst.sh
$ORACLE_HOME/common/tools/configureSecurityStore.py -d
@ $DOMAIN_HOME -c IAM -m create -p <OPSS_SCHEMA_PASSWORD>
I found following error:
--------------------------------------------
Info: DB JDBC URL:
jdbc:oracle:thin:@infbjrac2-scan.cn.oracle.com:1521/db000004.cn.oracle.com
Error: failed to do data association for OES Domain. Caused by:ORA-01017:
@ invalid username/password; logon denied
Problem invoking WLST - Traceback (innermost last):
File
"/home/oracle/mdwAlice/Oracle_IDM1/common/tools/configureSecurityStore.py",
line 899, in ?
Diagnostic Analysis
-------------------
[oracle@infbjvm165 mdwAlice]$ oracle_common/common/bin/wlst.sh
Oracle_IDM1/common/tools/configureSecurityStore.py -d
/home/oracle/mdwAlice/user_projects/domains/base_domain -c IAM -m create -p
Welcome1
...............
Initializing WebLogic Scripting Tool (WLST) ...
Welcome to WebLogic Server Administration Scripting Shell
Type help() for help on available commands
Info: Data source is: opss-DBDS
Info: DB JDBC driver: oracle.jdbc.OracleDriver
Info: DB JDBC URL:
jdbc:oracle:thin:@infbjrac2-scan.cn.oracle.com:1521/db000004.cn.oracle.com
Error: failed to do data association for OES Domain. Caused by:ORA-01017:
@ invalid username/password; logon denied
Problem invoking WLST - Traceback (innermost last):
File
"/home/oracle/mdwAlice/Oracle_IDM1/common/tools/configureSecurityStore.py",
line 899, in ?
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:600)
at
oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:4
45)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at
oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:380)
at
oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:760)
@ at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:401)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
at
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32
)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at
oracle.security.oes.util.DBSchemaUpgrade.getConnection(DBSchemaUpgrade.java:62
)
at
oracle.security.oes.util.DBSchemaUpgrade.isAnyPolicyStoreInSchema(DBSchemaUpgr
ade.java:69)
at
oracle.security.oes.util.DBSchemaUpgrade.isAnyPolicyStoreInSchema(DBSchemaUpgr
ade.java:56)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.j
ava:43)
at java.lang.reflect.Method.invoke(Method.java:606)
java.sql.SQLException: java.sql.SQLException: ORA-01017: invalid
@ username/password; logon denied
-----------------------------------------
Workaround:
The error message indicates the failure:
==========
jdbc:oracle:thin:@infbjrac2-scan.cn.oracle.com:1521/db000004.cn.oracle.com
Error: failed to do data association for OES Domain. Caused by:ORA-01017:
@ invalid username/password; logon denied
==========
@ When running configureSecurityStore.py, you supplied schema user password as
"Welcome1".
Please check the opss-DBDS data source configured in WSL for the schema
@ user/password [WLS has test connection function], and ensure that you
@ supplied the correct DB OPSS schema username/password when creating the
domain with OPSS template and when running configureSecurityStore.