newbie27
asked on
Unable to run oracle report; Single Sign-On page appears.
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.
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.
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.
You'll need to unprotect Reports.
Do you not use SSO? Do you not authenticate users?
Is this a new installation?
R.
I will also suggest you change this question to the correct zone Oracle IAS to get more help from relevant experts.
R.
R.
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Problem solved by myself.
ASKER
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)
)
)