[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

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

Posted on 2010-11-27
6
Medium Priority
?
559 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:Richard Olutola
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:Richard Olutola
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
Managing Security Policy in a Changing Environment

The enterprise network environment is evolving rapidly as companies extend their physical data centers to embrace cloud computing and software-defined networking. This new reality means that the challenge of managing the security policy is much more dynamic and complex.

 
LVL 16

Expert Comment

by:Richard Olutola
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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses
Course of the Month11 days, 7 hours left to enroll

640 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