Solved

Unable to run oracle report; Single Sign-On page appears.

Posted on 2010-11-27
6
550 Views
Last Modified: 2012-05-10
Hello Experts,

Need urgent help please!

I intend to connect a report from form through a push button..

But when i click that button during run time, it is re-directing to the page of Single Sign-On instead of displaying the report.

Application and Database version details.

Oracle Application 10.1.2
Rac Database 11.1.0.6.0
Entry in Tns File :

TESTDB =
 (DESCRIPTION =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP) (HOST = XX.XX.XXX.XX) (PORT = 1521))
    )
   (CONNECT_DATA =
    (SERVICE_NAME = TESTDB)
  )
 )

Report server is running. Single Sing-On service is disabled i.e. the parameter is commented under the report config file. Still i am facing the same single sign-on page when ever i try to generate the report from the forms.

Please advise.

Thanks in advance.
0
Comment
Question by:newbie27
  • 3
  • 3
6 Comments
 
LVL 8

Author Comment

by:newbie27
ID: 34221948
Correction in the TNS file.

TESTDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.xxx.xx)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.xxx.xx)(PORT = 1521))
      (LOAD_BALANCE = YES))
    (CONNECT_DATA =
      (SERVICE_NAME = testdb)
    )
  )
0
 
LVL 16

Expert Comment

by:rolutola
ID: 34224507
You must have installed Identity Management which includes SSO. Reports is protected by SSO.
You'll need to unprotect Reports.

Do you not use SSO? Do you not authenticate users?
Is this a new installation?

R.
0
 
LVL 16

Expert Comment

by:rolutola
ID: 34224520
I will also suggest you change this question to the correct zone Oracle IAS to get more help from relevant experts.

R.
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 16

Expert Comment

by:rolutola
ID: 34224602
See if this helps

http://download.oracle.com/docs/html/B14048_02/pbr_sec_arch.htm

I'll try and go through it later to see how to unprotect reports services (if you don't get there before me). I'm very busy today so please have a look through the doc.

R.
0
 
LVL 8

Accepted Solution

by:
newbie27 earned 0 total points
ID: 34225239
Thanks for your advices. Problem got solved by re-installing the application server.
0
 
LVL 8

Author Closing Comment

by:newbie27
ID: 34265156
Problem solved by myself.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now