Wednesday, October 27, 2010

Hexaware Apps DBA Interview Questions (2+ exprienced) Part -1

What is Symbolic Links?

---------------

A symbolic link is a special file type which points to another file. The
contents of this special file is the name of the file that it points to.
Symbolic links are created by the ln -s command.

Once a file which is pointed to by a symbolic link is deleted, the link still
points to it, leaving a hanging link.

You can use the find command to locate symbolic links:

find ./* -type l -ls

Examples:
---------
Consider a file 'example' to which there is a hard link 'hlink' and a symbolic
link 'slink'.

Check the contents of the directory for the file 'example':

% ls -li
427222 -rw-r--r-- 2 osupport dba 50 Oct 23 11:35 example

-----------------------------------------------------------------------
what is FRM-3000 ?

When it will come ?

How to overcome this FRM-3000 ?
----------

Take the following steps to help you troubleshoot REP-3000 errors:

1. First, test the integrity of DISPLAY by issuing "xclock" command.
- Login to the machine where Reports Server is installed.
- From the UNIX command prompt, set the DISPLAY to a valid
X Windows session:
setenv DISPLAY :0.0
- Ensure that DISPLAY was set correctly:
echo $DISPLAY
- Type command "xclock"
If you see a clock come up, then the DISPLAY is set correctly.
If you do not see the clock, then DISPLAY is not set to an active Xterm.

You must have xclock working before running any reports.

Another way to test whether an X server is running on given machine
and you have permissions to connect to it, you can use the following command:

xterm -display :0.0

If you do not have permissions to access the display or if there is no
such display running on the given machine, an error similar to the
following is displayed:

Xlib: connection to ":0.0" refused by server
Xlib: Client is not authorized to connect to Server
xterm Xt error: Can't open display: :0.0

----------------------------------------------

2. If the error occurs when running report on the Web, then you need
to first test it using Reports Runtime on the machine where your Reports
Server is running. Steps:
- Set DISPLAY to a valid X Windows session
- Run report using sample syntax:
rwrun60 report=test.rdf userid=username/password@db destype=file desname=test.html desformat=html batch=yes

If rwrun60 works, go to step 3.
If rwrun60 does not work, then:
- Re-check your DISPLAY environment variable
- Go back to step 1 and test the integrity of DISPLAY
- Review Section VI (below) to see if any of the scenarios
match your situation.
- If nothing else works, then try to relink Oracle Reports executables.
See Note:154512.1 for details.
----------------------------------------------

-----------------------------------------------------------------

How to check the Concurrent request's ?
From which table we can find the concurrent request informations ?

FND_NODES

------------


FND_CONCURRENT_REQUESTS
This table contains a complete history of all concurrent requests.

FND_RUN_REQUESTS
When a user submits a report set, this table stores information about the reports in the report set and the parameter values for each report.

FND_CONC_REQUEST_ARGUMENTS
This table records arguments passed by the concurrent manager to each program it starts running.

FND_DUAL
This table records when requests do not update database tables.

FND_CONCURRENT_PROCESSES
This table records information about Oracle Applications and operating system processes.

FND_CONC_STAT_LIST
This table collects runtime performance statistics for concurrent requests.

FND_CONC_STAT_SUMMARY
This table contains the concurrent program performance statistics generated by the Purge Concurrent Request and/or Manager Data program.
The Purge Concurrent Request and/or Manager Data program uses the data in FND_CONC_STAT_LIST to compute these statistics.


------------------------------------------------------------------------

What is Single Sign-On Server (SSO) ?

As name says Single-Sign On Server is set of services (Software) which enables login to Application once which will allow you to login to partner
Applications with no need to login again. Lets assume I have configured single SSO Server for Portal , E-Business Suite,
Collaboration Suite plus some other other applications, Now if I login to any one of them & after that if I wish to login to other applications
I should be able to login without supplying passwords again.



*** Refered from various Blogs and Sites ****

No comments:

Post a Comment