Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Error while installing BI Applications
Hello guys,
I’m facing an issue while performing BI-Apps install (during the BI Applications configuration using ./configApps.sh script), in the logs Error is due to “ORA-01017: invalid username/password; logon denied” however I can get access to the database schema using SQL Developer.
Someone would have encountered this issue? Can you please help me to overcome it?
For the installation I’m using the following :
- Products :
- Oracle HTTP Server (11.1.1.9)
- Oracle Business Intelligence EE (11.1.1.9.0)
- Oracle Business Intelligence Applications (11.1.1.10.0)
- Oracle Data Integrator (11.1.1.9.0)
- Oracle Weblogic Server (10.3.6)
- Oracle Fusion Middleware Repository Creation Utility 11g (11.1.1.10.0)
- Oracle Database 12c (12.1.0.2)
- Oracle JRockit(R) (build R28.2.7-7_BR16569812-155426-1.6.0_45-20130409-1146-linux-x86_64, compiled mode)
- OS : Oracle Linux [Red Hat Enterprise Linux Server release 6.5 (Santiago)]
I’m having the error in 32% of ./configApps.sh, in the ODI Configuration step [configure_odi.py], bellow error logs
About to run command: /applis/app/oracle/Middleware/Oracle_BI1/common/bin/wlst.sh With arguments: [/applis/app/oracle/Middleware/Oracle_BI1/bifoundation/install/configure_odi.py, /applis/app/oracle/Middleware/Oracle_ODI1, jdbc:oracle:thin:@mesvobieebd:1521/pdbbiapps, PRD_BIA_ODIREPO, OracleDIAgent, mesvobieeapp, 15001, oraclediagent, http, OracleDIAgent, biaadmin, /applis/app/oracle/Middleware/user_projects/domains/bifoundation_domain, mesvobieeapp, 7001, weblogic, BIAppsSystemUser, PRD_DW, jdbc:oracle:thin:@mesvobieebd:1521/pdbbiapps, false, ldap://mesvobieeapp:7001, cn=admin, ou=people,ou=myrealm,dc=bifoundation_domain, ou=groups,ou=myrealm,dc=bifoundation_domain, PRD_BIACM_IO, jdbc:oracle:thin:@mesvobieebd:1521/pdbbiapps, /applis/app/oracle/Middleware/instances/instance1/biapps/logs, /applis/app/oracle/Middleware/instances/instance1/biapps/shared] In Working Directory: null CLASSPATH=/applis/app/oracle/Middleware/patch_wls1036/profiles/default/sys_manifest_classpath/weblogic_patch.jar:/applis/app/oracle/Middleware/patch_ocp371/profiles/default/sys_manifest_classpath/weblogic_patch.jar:/applis/app/oracle/Middleware/jrockit-jdk1.6.0_45-R28.2.7-4.1.0/lib/tools.jar:/applis/app/oracle/Middleware/wlserver_10.3/server/lib/weblogic_sp.jar:/applis/app/oracle/Middleware/wlserver_10.3/server/lib/weblogic.jar:/applis/app/oracle/Middleware/modules/features/weblogic.server.modules_10.3.6.0.jar:/applis/app/oracle/Middleware/wlserver_10.3/server/lib/webservices.jar:/applis/app/oracle/Middleware/modules/org.apache.ant_1.7.1/lib/ant-all.jar:/applis/app/oracle/Middleware/modules/net.sf.antcontrib_1.1.0.0_1-0b2/lib/ant-contrib.jar::/applis/app/oracle/Middleware/Oracle_BI1/common/wlst/lib/webcenter-admin-commands.jar:/applis/app/oracle/Middleware/Oracle_BI1/analytics-collector/archives/applications/analytics-collector-jee.jar:/applis/app/oracle/Middleware/Oracle_BI1/common/wlst/lib/webcenter-admin-commands.jar:/applis/app/oracle/Middleware/oracle_common/modules/oracle.jrf_11.1.1/jrf-wlstman.jar:/applis/app/oracle/Middleware/oracle_common/common/wlst/lib/adfscripting.jar:/applis/app/oracle/Middleware/oracle_common/common/wlst/lib/adf-share-mbeans-wlst.jar:/applis/app/oracle/Middleware/oracle_common/common/wlst/lib/mdswlst.jar:/applis/app/oracle/Middleware/oracle_common/common/wlst/resources/auditwlst.jar:/applis/app/oracle/Middleware/oracle_common/common/wlst/resources/igfwlsthelp.jar:/applis/app/oracle/Middleware/oracle_common/common/wlst/resources/jps-wlst.jar:/applis/app/oracle/Middleware/oracle_common/common/wlst/resources/jps-wls-trustprovider.jar:/applis/app/oracle/Middleware/oracle_common/common/wlst/resources/jrf-wlst.jar:/applis/app/oracle/Middleware/oracle_common/common/wlst/resources/oamap_help.jar:/applis/app/oracle/Middleware/oracle_common/common/wlst/resources/oamAuthnProvider.jar:/applis/app/oracle/Middleware/oracle_common/common/wlst/resources/ossoiap_help.jar:/applis/app/oracle/Middleware/oracle_common/common/wlst/resources/ossoiap.jar:/applis/app/oracle/Middleware/oracle_common/common/wlst/resources/ovdwlsthelp.jar:/applis/app/oracle/Middleware/oracle_common/common/wlst/resources/sslconfigwlst.jar:/applis/app/oracle/Middleware/oracle_common/common/wlst/resources/wsm-wlst.jar:/applis/app/oracle/Middleware/utils/config/10.3/config-launch.jar::/applis/app/oracle/Middleware/wlserver_10.3/common/derby/lib/derbynet.jar:/applis/app/oracle/Middleware/wlserver_10.3/common/derby/lib/derbyclient.jar:/applis/app/oracle/Middleware/wlserver_10.3/common/derby/lib/derbytools.jar:: Initializing WebLogic Scripting Tool (WLST) ... Welcome to WebLogic Server Administration Scripting Shell Type help() for help on available commands Adminserver name is AdminServer +-------------------------------+ | USING jdbc.drivers PROPERTY | +-------------------------------+ Loading JDBC Driver -> oracle.jdbc.driver.OracleDriver Connecting to -> jdbc:oracle:thin:@mesvobieebd:1521/pdbbiapps Connected as -> PRD_BIA_ODIREPO Closing down all connections... ODI Agent details updated +-------------------------------+ | USING jdbc.drivers PROPERTY | +-------------------------------+ Loading JDBC Driver -> oracle.jdbc.driver.OracleDriver Connecting to -> jdbc:oracle:thin:@mesvobieebd:1521/pdbbiapps Connected as -> PRD_BIA_ODIREPO Closing down all connections... +-------------------------------+ | USING jdbc.drivers PROPERTY | +-------------------------------+ Loading JDBC Driver -> oracle.jdbc.driver.OracleDriver Connecting to -> jdbc:oracle:thin:@mesvobieebd:1521/pdbbiapps Connected as -> PRD_BIA_ODIREPO Closing down all connections... ODI user added to ODI repository successfully Connecting to t3://mesvobieeapp:7001 with userid weblogic ... Successfully connected to Admin Server 'AdminServer' that belongs to domain 'bifoundation_domain'. Warning: An insecure protocol was used to connect to the
Admin port should be used instead. Retrieving embedded ldap credential Disconnected from weblogic server: AdminServer jps-config file created successfully jps-config-jse.xml file created successfully at:/applis/app/oracle/Middleware/user_projects/domains/bifoundation_domain/odi-client-config/embedded/jps-config-jse.xml configure_odi: 21 sept. 2016 15:08:48 oracle.security.jps.internal.common.util.XmlSchemaValidationUtil$StrictErrorHandler warning configure_odi: ATTENTION: Contenu XML non valide trouvé : SchemaLocation: schemaLocation value = 'http://xmlns.oracle.com/oracleas/schema/11/jps-config-11_1.xsd' must have even number of URI's.. Emplacement : line 2 column 272. key updated succesfully credential updated successfully +-------------------------------+ | USING jdbc.drivers PROPERTY | +-------------------------------+ Loading JDBC Driver -> oracle.jdbc.driver.OracleDriver Connecting to -> jdbc:oracle:thin:@mesvobieebd:1521/pdbbiapps Connected as -> PRD_BIA_ODIREPO Closing down all connections... List of matches users: [biappssystemuser, biaadmin] ODI repository switched to external ldap successfully Connecting to t3://mesvobieeapp:7001 with userid weblogic ... Successfully connected to Admin Server 'AdminServer' that belongs to domain 'bifoundation_domain'. Warning: An insecure protocol was used to connect to the
Admin port should be used instead. Location changed to domainRuntime tree. This is a read-only tree with DomainMBean as the root. For more help, use help(domainRuntime) BIA duty role is already assigned to user: biaadmin ODI repository file path: /applis/app/oracle/Middleware/user_projects/domains/bifoundation_domain/config/oracledi/repositories.xml Updating supervisor key for repository: Work Repository Updating supervisor key for repository: Master Repository
ODI Supervisor key updated successfully in repositories.xml Disconnected from weblogic server: AdminServer /applis/app/oracle/Middleware/user_projects/domains/bifoundation_domain/config/fmwconfig/default-keystore.jks keystore already exists. skipping keystore creation. ODI Data Server Provisioning API Command for DW to be executed is: /applis/app/oracle/Middleware/Oracle_BI1/jdk/bin/java -client -classpath /applis/app/oracle/Middleware/Oracle_ODI1/oracledi.sdk/lib/*:/applis/app/oracle/Middleware/Oracle_ODI1/inventory/Scripts/ext/jlib/*:/applis/app/oracle/Middleware/Oracle_ODI1/modules/oracle.jps_11.1.1/*:/applis/app/oracle/Middleware/Oracle_BI1/biapps/lib/bia-odi.jar -Doracle.security.jps.config=/applis/app/oracle/Middleware/user_projects/domains/bifoundation_domain/odi-client-config/embedded/jps-config-jse.xml oracle.apps.bi.odi.provision.ProvisionDataServer DW jdbc:oracle:thin:@mesvobieebd:1521/pdbbiapps PRD_BIA_ODIREPO **ODI_DB_SCHEMA_PWD** BIAPPS_WORKREP biaadmin **ODI_CONSOLE_USER_PWD** PRD_DW **DW_DB_PASSWORD** jdbc:oracle:thin:@mesvobieebd:1521/pdbbiapps PRD_DW ODI-10182: Exception hors catégories lors de laccès au référentiel. Could not get JDBC Connection; nested exception is java.sql.SQLException: Une exception est survenue lors de l'obtention de la connexion: oracle.ucp.UniversalConnectionPoolException: Impossible d'obtenir la connexion à partir de la source de données: java.sql.SQLException: ORA-01017: invalid username/password; logon denied configure_odi: Problem invoking WLST - Traceback (innermost last): configure_odi: File "/applis/app/oracle/Middleware/Oracle_BI1/bifoundation/install/configure_odi.py", line 362, in ? configure_odi: File "/applis/app/oracle/Middleware/Oracle_BI1/bifoundation/install/configure_odi.py", line 237, in _configureOdiDwIntegration configure_odi: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) configure_odi: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) configure_odi: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) configure_odi: at java.lang.reflect.Constructor.newInstance(Constructor.java:513) configure_odi: configure_odi: java.lang.Exception: java.lang.Exception: DW data server update failed with return code: 1 configure_odi:
at oracle.as.install.biapps.biappsconfig.standard.ODIConfigTask.doExecute(ODIConfigTask.java:57) at oracle.as.install.bi.biconfig.standard.AbstractProvisioningTask.execute(AbstractProvisioningTask.java:70) at oracle.as.install.bi.biconfig.standard.StandardProvisionTaskList.execute(StandardProvisionTaskList.java:66) at oracle.as.install.bi.biconfig.BIConfigMain.doExecute(BIConfigMain.java:113) at oracle.as.install.engine.modules.configuration.client.ConfigAction.execute(ConfigAction.java:403) at oracle.as.install.engine.modules.configuration.action.TaskPerformer.run(TaskPerformer.java:101) at oracle.as.install.engine.modules.configuration.action.TaskPerformer.startConfigAction(TaskPerformer.java:121) at oracle.as.install.engine.modules.configuration.action.ActionRequest.perform(ActionRequest.java:15) at oracle.as.install.engine.modules.configuration.action.RequestQueue.performSequentialExecution(RequestQueue.java:335) at oracle.as.install.engine.modules.configuration.action.RequestQueue.perform(RequestQueue.java:311) at oracle.as.install.engine.modules.configuration.standard.StandardConfigActionManager.start(StandardConfigActionManager.java:200) at oracle.as.install.engine.modules.configuration.boot.ConfigurationExtension.kickstart(ConfigurationExtension.java:81) at oracle.as.install.engine.modules.configuration.ConfigurationModule.run(ConfigurationModule.java:86) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.Exception: WLST Script task failed with status 1 at oracle.as.install.bi.biconfig.standard.WLSTScriptTask.doExecute(WLSTScriptTask.java:127) at oracle.as.install.biapps.biappsconfig.standard.ODIConfigTask.doExecute(ODIConfigTask.java:55) ... 13 more |
Answers
-
Hi,
Try logging in to below schema's from database and check if you are able to login (PRD_BIA_ODIREPO and PRD_DW).
Regards,
Yaswanth
0