Thursday, October 28, 2010
Wednesday, October 27, 2010
Hexaware Apps DBA Interview Questions (2+ exprienced) Part -1
---------------
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 ****
Sunday, October 24, 2010
Exporting PATH setting
here i am giving some examples which i faced in my forms upgradation patchset19..
This is the normal path of $ORACLE_HOME in 11i
echo $ORACLE_HOME
/ebiz/testappl/testora/8.0.6
as per the need of upgradation we have to set this path to iAS server..
export ORACLE_HOME=/ebiz/testappl/testora/iAS/6iserver
Now you can check the exported path using Echo command.
echo $ORACLE_HOME
/ebiz/testappl/testora/iAS/6iserver
------------------------------------------------------------------------------
Like wise if we have to add iAS path in $PATH
echo $PATH
/ebiz/testappl/testora/iAS/Apache/perl/bin:/ebiz/testappl/testora/8.0.6/bin:
/ebiz/testappl/testappl/fnd/11.5.0/bin:/ebiz/testappl/testappl/ad/11.5.0/bin:
/ebiz/testappl/testcomn/util/java/1.4/j2sdk1.4.2_04/bin:
/ebiz/testappl/testcomn/util/unzip/unzip/unzip-5.50::
/ebiz/testappl/testora/8.0.6/bin:/usr/bin:/usr/ccs/bin:
/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:
/usr/X11R6/bin:/ebiz/testappl/bin
export PATH=$PATH:/ebiz/testappl/testora/iAS/6iserver/bin
echo $PATH
/ebiz/testappl/testora/iAS/Apache/perl/bin:/ebiz/testappl/testora/8.0.6/bin:
/ebiz/testappl/testappl/fnd/11.5.0/bin:/ebiz/testappl/testappl/ad/11.5.0/bin:
/ebiz/testappl/testcomn/util/java/1.4/j2sdk1.4.2_04/bin:
/ebiz/testappl/testcomn/util/unzip/unzip/unzip-5.50::
/ebiz/testappl/testora/8.0.6/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:
/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:
/ebiz/testappl/bin:/ebiz/testappl/testora/iAS/6iserver/bin
**in the above echo we can see the exported path
----------------------------------------------------------------------------
echo $LD_LIBRARY_PATH
/ebiz/testappl/testora/8.0.6/network/jre11/lib/i686/native_threads:
/ebiz/testappl/testora/8.0.6/network/jre11/lib/linux/native_threads:
/ebiz/testappl/testappl/cz/11.5.0/bin:/ebiz/testappl/testora/8.0.6/lib:
/usr/X11R6/lib:/usr/openwin/lib
export
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/ebiz/testappl/testora/iAS/6iserver/lib
echo $LD_LIBRARY_PATH
/ebiz/testappl/testora/8.0.6/network/jre11/lib/i686/native_threads:
/ebiz/testappl/testora/8.0.6/network/jre11/lib/linux/native_threads:
/ebiz/testappl/testappl/cz/11.5.0/bin:/ebiz/testappl/testora/8.0.6/lib:
/usr/X11R6/lib:/usr/openwin/lib:[testappl@vmware:
/ebiz/testappl/testora/iAS/6iserver/lib
**in the above echo we can see the exported path
-----------------------------------------------------
Very important note is :
* This Export wont reflect in any other section
** Its just like a temporary setting if you use this in Putty.
*** After export we have to continue our task in the same window.
Thursday, October 21, 2010
OBIEE 11g
Installation Document of OBIEE 11g for Scriber
Custom Top - 2
Kindly follow the previous post
STEP 11
Register your Oracle Schema
Login to Applications with System Administrator responsibility
Navigate to
Application–>Register
STEP 12
Register Oracle User
Naviate to
Security-->Oracle-->Register
STEP 13
Add Application to a Data Group
Navigate to
Security-->Oracle-->DataGroup
STEP 14
This will act as a placeholder for any custom reports we wish to make available for the Custom Responsibility (which is defined at a later stage)
Navigate to
Security-->responsbility-->Request
STEP 15
Create custom menu
This will act as a placeholder for any menu items we wish to make available for the Custom Responsibility (which is defined at a later stage) We will create two menus, one for Core Applications and one for Self Service.
Navigate to
Application-->Menu
STEP 16
This is the CUSTOM_TOP we created in the above 15 steps.
All the best Flocks...
Custom Top - 1
STEP 1
Created the directory structure for your custom application files under $APPL_TOP/abdul
$cd $APPL_TOP
$ mkdir abdul
$ mkdir abdul/11.5.0
$ mkdir abdul/11.5.0/admin
$ mkdir abdul/11.5.0/admin/sql
$ mkdir abdul/11.5.0/admin/odf
$ mkdir abdul/11.5.0/sql
$ mkdir abdul/11.5.0/bin
$ mkdir abdul/11.5.0/reports
$ mkdir abdul/11.5.0/reports/US
$ mkdir abdul/11.5.0/forms
$ mkdir abdul/11.5.0/forms/US
$ mkdir abdul/11.5.0/log
$ mkdir abdul/11.5.0/out
$ mkdir abdul/11.5.0/$APPLLIB
$ mkdir abdul/11.5.0/$APPLOUT
STEP 2
Added entry ABDUL_TOP=/ebiz/testappl/testappl/abdul in Enviornment file custom_TEST_vmware.env
ABDUL_TOP=/ebiz/testappl/testappl/abdul
export ABDUL_TOP
STEP 3
Then Run "custom_TEST_vmware.env",
./custom_TEST_vmware.env
STEP 4
Then Run "APPSORA.env"
./APPSORA.env
STEP 5
Finally Run the Oracle Manager's bash profile,
.bash_profile
STEP 6
Now Check for "ABDUL" top
$cd $ABDUL_TOP
$pwd
/ebiz/testappl/testappl/abdul
STEP 7
Create datafile (.dbf) from the new customized top in database
Connect to database manager
connect into sys user.
create tablespace and datafile for ABDUL_TOP
STEP 8
SQL> create tablespace abdul datafile '/ebiz/testora/testdata/abduldbf' size 10M;
Tablespace created.
STEP 9
Create Schema (USER) and Grant connect,resource to the USER.
SQL> create user abdul identified by abdul default tablespace abdul temporary tablespace temp quota unlimited on abdul;
User created.
STEP 10
SQL> grant connect,resource to abdul;
Grant succeeded.