ORA-01017 Connecting To Portal Schema In OPCA Called From RCU 11.1.1.5.0 (Doc ID 1534501.1)

Last updated on NOVEMBER 08, 2016

Applies to:

Portal - Version 11.1.1.1.0 to 11.1.1.6.0 [Release FMW11g]
Generic Windows

Symptoms


On Windows, creation of Portal schemas is failing with the following error:

'ERROR: Portal Configuration Assistant aborted'


The rcu.log shows that Repository Creation Utility (RCU) is connecting as SYS and completing tasks:

2013-02-22 05:48:10.844 NOTIFICATION rcu: oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine::connect: Connecting to database: user:sys, role:SYSDBA, connectString:(description=(address=(host=hostname)(protocol=tcp)(port=1521))(connect_data=(service_name=ASDB)(server=dedicated)))
2013-02-22 05:48:10.859 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.JDBCAction::perform: current user=sys
2013-02-22 05:48:10.859 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.JDBCAction::perform: Performing Inline Action Command: CREATE TABLESPACE "DEV_PORTAL" EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO DATAFILE 'D:\ORADATA\ASDB/DEV_portal.dbf' SIZE 105M AUTOEXTEND ON NEXT 3840K MAXSIZE 32767M
2013-02-22 05:48:11.078 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.JDBCAction::perform: **** Sql script DONE****
2013-02-22 05:48:11.078 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: Execution time for Create tablespaces in the repository database : 484 milliseconds

 
The rcu.log shows the failure at this point:

2013-02-22 05:48:17.817 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: Executing Task: Portal
2013-02-22 05:48:17.817 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: JavaAction command=oracle.ias.version.SchemaVersionUtil:utilCreateRegistryEntry
2013-02-22 05:48:17.817 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: JavaAction method=utilCreateRegistryEntry
2013-02-22 05:48:17.817 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: Connect As Owner: false
2013-02-22 05:48:17.817 NOTIFICATION rcu: oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine::connect: Connecting to database: user:sys, role:SYSDBA, connectString:(description=(address=(host=hostname)(protocol=tcp)(port=1521))(connect_data=(service_name=ASDB)(server=dedicated)))
2013-02-22 05:48:17.848 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: JavaAction command=oracle.webdb.config.PortalConfigAssistant:main
2013-02-22 05:48:17.879 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: JavaAction method=main
2013-02-22 05:48:18.659 INCIDENT_ERROR rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: Failed to execute method: Excepton:
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.sysman.assistants.rcu.backend.action.ActionThread.run(JavaAction.java:462)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.RuntimeException: ERROR: Portal Configuration Assistant aborted
at oracle.webdb.config.PortalConfigAssistant.(Unknown Source)
at oracle.webdb.config.PortalConfigAssistant.main(Unknown Source)
... 6 more

2013-02-22 05:48:18.659 ERROR rcu: oracle.sysman.assistants.rcu.backend.action.AbstractAction::handleNonIgnorableError: Received Non-Ignorable Error: ERROR: Portal Configuration Assistant aborted

2013-02-22 05:52:41.052 ERROR rcu: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: RCU Operation Failed
oracle.sysman.assistants.common.task.TaskExecutionException: RCU-6135:Error while trying to execute Java action.
at oracle.sysman.assistants.rcu.backend.task.AbstractCompTask.execute(AbstractCompTask.java:300)
at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:306)
at java.lang.Thread.run(Thread.java:662)
Caused by: oracle.sysman.assistants.common.task.ActionFailedException: RCU-6135:Error while trying to execute Java action.
at oracle.sysman.assistants.rcu.backend.action.ActionThread.run(JavaAction.java:489)
... 1 more
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.sysman.assistants.rcu.backend.action.ActionThread.run(JavaAction.java:462)
... 1 more
Caused by: java.lang.RuntimeException: ERROR: Portal Configuration Assistant aborted
at oracle.webdb.config.PortalConfigAssistant.(Unknown Source)
at oracle.webdb.config.PortalConfigAssistant.main(Unknown Source)
... 6 more

 
The Portal.log shows:


STEP 4 (PORTAL) : Creating Portal Schema...
INSTALL_ACTION:installGlobalComponents() :
In sqlExecuter, OH = D:\rcuHome
Will invoke sqlplus with full path: D:\rcuHome\bin\sqlplus -S /nolog
INSTALL_ACTION:installGlobalComponents() :
In sqlExecuter, OH = D:\rcuHome
Will invoke sqlplus with full path: D:\rcuHome\bin\sqlplus -S /nolog
INSTALL_ACTION:installGlobalComponents() :Loading Java class for MD5 encryption...
INSTALL_ACTION:installGlobalComponents() : loadjava.bat -resolve -verbose -thin -user DEV_PORTAL/*****"@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ASDB)))" D:\rcuHome\portal\admin\plsql\wwc\SSOHash.class
C:\Windows\system32>ECHO OFF
D:\rcuHome
arguments: '-user' 'DEV_PORTAL/***@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ASDB)))' '-resolve' '-verbose' '-thin' 'D:\rcuHome\portal\admin\plsql\wwc\SSOHash.class'
SQL Error while connecting with thin driver to (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ASDB))): ORA-01017: invalid username/password; logon denied
Error while processing class oracle/security/sso/SSOHash
  Exception oracle.aurora.server.tools.loadjava.ConnectionError: could not open connection
SQL Error while connecting with thin driver to (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ASDB))): ORA-01017: invalid username/password; logon denied
exiting : could not open connection
INSTALL_ACTION : Set the component loading flag for Portal
ERROR: Cannot retrieve the database version: ORA-01017: invalid username/password; logon denied

 

Trying to connect with SQLPLUS the error occurs:

"This application failed to start because MSVCR71.dll was not found.Re-Installing the application may fix this problem."

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms