Configure a Reports Server *without* SSO Authentication

. Back up the following files first

    $ORACLE_HOME/reports/conf/rwservlet.properties
    $ORACLE_HOME/reports/conf/<Reports Server>.conf
   
2. Assume SINGLESIGNON=YES in rwservlet.properties

3. Modifiy the $ORACLE_HOME/reports/conf/<Reports Server>.conf file to disable this specific Reports Server’s authentication.

FROM

    <security id="rwSec">
        <!--property name="securityUserid"   value="%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%" confidential="yes" encrypted="no"/-->
        <property name="oidEntity" value="reportsApp_<hostname>.us.oracle.com_BE6D095BE1044A70957E041E3DB98DE6"/>
    </security>
    <destination destype="oraclePortal">
        <!--property name="portalUserid" value="%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%" confidential="yes" encrypted="no"/-->
    </destination>

    <job jobType="report" engineId="rwEng" securityId="rwSec"/>
    <job jobType="rwurl" engineId="rwURLEng" securityId="rwSec"/>

TO

    <!--security id="rwSec">
        <property name="securityUserid" value="%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%" confidential="yes" encrypted="no"/>
        <property name="oidEntity" value="reportsApp_<hostname>.us.oracle.com_BE6D095BE1044A70957E041E3DB98DE6"/>
    </security-->
    <!--destination destype="oraclePortal">
        <property name="portalUserid" value="%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%" confidential="yes" encrypted="no"/>
    </destination-->

    <job jobType="report" engineId="rwEng"/>
    <job jobType="rwurl" engineId="rwURLEng"/>

 

Restart the services and test it.

 

 

About Sher khan

Senior Oracle DBA, Oracle 10g and 11g OCE and OCS, Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g and 11g. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com
This entry was posted in Oracle Application server. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s