"REP-56110: Failed to connect to security repository Oracle Portal" After Portal Password Changed (Doc ID 1348743.1)

Last updated on SEPTEMBER 07, 2012

Applies to:

Oracle Reports Developer - Version 10.1.2.0.2 to 10.1.2.3 [Release Oracle10g to 10gr2]
Information in this document applies to any platform.

Symptoms

You are no longer able to run reports from the AERS Application. This used to work, but suddenly began to fail.

The error shown in the Reports Server trace is:

REP-56110: Failed to connect to security repository Oracle Portal.


The PORTAL userid/password was changed.  You have already confirmed that the PORTAL userid/password works from SQL*Plus. 

Sample Portal Connection from SQL*Plus

D:\oracle\AS10gR2as\bin> sqlplus portal/mypassword@aersdev

SQL*Plus: Release 10.1.0.5.0 - Production on Thu Jul 14 09:44:02 2011
Copyright (c) 1982
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle DAta Mining options
JServer Release 9.2.0.8.0 - Production
SQL>



Sample Error Shown in RWSERVER.TRC

[2011/1/21 5:16:26:969] Debug 50103  (DBConnection:connectByThinJDBC): username: portal, dbconnect: ldap://hostname:389/aersdev,cn=oraclecontext
[2011/1/21 5:16:27:79] Debug 50103 (RWSecurity.isPortalConnected): Failed to connect to security repository Oracle Portal
[2011/1/21 5:16:27:79] Debug 50103  (RWSecurity:isPortalConnected): s_connection:null
[2011/1/21 5:16:27:94] Debug 50103  (DBConnection:connectByThinJDBC): username: portal, dbconnect: ldap://hostname:389/aersdev,cn=oraclecontext
[2011/1/21 5:16:27:204] Debug 50103  (RWSecurity.isPortalConnected): Failed to connect to security repository Oracle Portal
[2011/1/21 5:16:27:204] Debug 50103  (RWSecurity:isPortalConnected): s_connection:null
[2011/1/21 5:16:27:204] Debug 50103  (DBConnection:connectByThinJDBC): username: portal, dbconnect: ldap://sjarmt2-dev.clinimetrics.com:389/aersdev,cn=oraclecontext
[2011/1/21 5:16:27:329] Debug 50103  (RWSecurity.isPortalConnected): Failed to connect to security repository Oracle Portal
.........
.........
[2011/3/11 7:19:57:317] Info 56021 (EngineManager:spawnEngine): Engine rwEng-0 has been launched
[2011/3/11 7:19:57:317] State 56004 (EngineInfo:setState): Engine rwEng-0 state is: Initial
[2011/3/11 7:19:57:442] Debug 50103  (RWSecurity.isPortalConnected): Failed to connect to security repository Oracle Portal
[2011/3/11 7:19:57:442] Debug 50103  (RWSecurity:isPortalConnected): s_connection:null
[2011/3/11 7:19:57:442] (RWSecurity:jobCommandCheck) ...exit
[2011/3/11 7:19:57:442] Debug 50103 (ConnectionImpl:runJob): jobid = 230 Failed with exceptionoracle.reports.RWException: IDL:oracle/reports/RWException:1.0
[2011/3/11 7:19:57:458] Exception 56110 (): Failed to connect to security repository Oracle Portal.
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.utility.Utility.newRWException(Utility.java:758)
at oracle.reports.server.RWSecurity.jobCommandCheck(RWSecurity.java:292)
at oracle.reports.server.SecurityHelper.jobCommandCheck(SecurityHelper.java:411)
at oracle.reports.server.ConnectionImpl.runJob(ConnectionImpl.java:1198)
at oracle.reports.server._ConnectionImplBase._invoke(_ConnectionImplBase.java:401)
at com.sun.corba.se.internal.corba.ServerDelegate.dispatch(ServerDelegate.java:353)
at com.sun.corba.se.internal.iiop.ORB.process(ORB.java:280)
at com.sun.corba.se.internal.iiop.RequestProcessor.process(RequestProcessor.java:81)
at com.sun.corba.se.internal.orbutil.ThreadPool$PooledThread.run(ThreadPool.java:106)

[2011/3/11 7:19:58:270] Info 56026 (EngineManager:registerEngine): Reports Server started up engine rwEng-0
[2011/3/11 7:19:58:286] Debug 50103  (EngineManager:updateEngineState): Engine rwEng-0 status is 1
[2011/3/11 7:19:58:286] State 56004 (EngineInfo:setState): Engine rwEng-0 state is: Ready



Changes

Changed password for PORTAL userid.

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