Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using APEX for database administration

abhinivesh.jainFeb 27 2015 — edited Jan 11 2016

Do you know Application Express (APEX) is free tool that comes pre-configured from Oracle 11g onwards. It is very easy to use tool to create database based applications. There are lots of use cases for using APEX by DBAs.

1. for creation of small utilities like- daily backup reporting

2. for creation of db portal kind of thing where your entire DB estate details are present

One can learn using this tool in less than 1 hr. there is no installation required. application created by APEX are web based applications and entire development in APEX is also web based.

Thanks,

Abhi

Comments

John_K

I don't believe Act As is supported when using EBS authentication, primarily because you would need to go back and reinitialize your EBS session. I.e. you might have an initblock which does:

Select organization_id from hr_organization_units.

As that is a secure view, it is dependent on your EBS context (i.e. your user_id, resp_id, and so on). So you couldn't run that "Acting As" someone else.

ather.shaikh

Hi ORA-01033,

I understand that and that's why i raised this question on the community.

We need to implement only 4 or 5 user for this. is there any we can do this.

Thanks,

Ather

2725705

Hello,

We are getting issue while accessing the OBIEE from EBS . we are getting Obiee login page instead of direct dashboard page.

Could you please share your experience on this issue

ather.shaikh

What i understand that you did not set the configuration files updated.

authenticationschema.xml should have these

<AuthenticationSchema name="EBS-ICX"

<SchemaKeyVariable source="cookie" forceValue=”EBS-ICX”

<RequestVariable source="cookie" type="auth" nameInSource="DEV" biVariableName="NQ_SESSION.ICX_SESSION_COOKIE" />

if it is OBIEE 12c then you have mentioned following as well.

<RequestVariable source="constant" type="auth" nameInSource="ssi" biVariableName="NQ_SESSION.SERVICEINSTANCEKEY" />

2725705

Hi Shaikh,

We have followed all the steps and modified config files as per Oracle documents, what ever steps you mentioned above all are taken care of.

Please let me know any other solution

1 - 5

Post Details

Added on Feb 27 2015
11 comments
486 views