Solved

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

Posted on 2010-11-27
6
551 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
querying by the sum of a column in decimal 7 56
Oracle TEXT search question 9 43
SSRS Problems 9 56
Get the parent node - XMLTYPE 9 55
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
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…

948 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

19 Experts available now in Live!

Get 1:1 Help Now