Solved

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

Posted on 2010-11-27
6
554 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 
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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to recover a database from a user managed backup

696 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