.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

<< < … 15 16 17 18 19 20 21 22 23 24 > >>   Sort: Date

What is ADSPLICE UTILITY ?
What is ADSPLICE UTILITY ? ADSPLICE UTILITY in ORACLE application is utility to add a new product. 2011-11-09, 3893👍, 0💬

What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?
What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function? 1000000 2011-09-05, 3875👍, 0💬

What is difference between ICM, Standard Managers and CRM in Concurrent Manager ?
What is difference between ICM, Standard Managers and CRM in Concurrent Manager ? # ICM stand for Internal Concurrent Manager, which controls other managers. If it finds other managers down , it checks and try to restart them. You can say it as administrator to other concurrent managers. It has othe... 2011-12-19, 3871👍, 0💬

What is FNDSM ?
What is FNDSM ? FNDSM is executable and core component in GSM ( Generic Service Management Framework discussed above). You start FNDSM services via application listener on all Nodes in Application Tier in E-Business Suite. 2011-11-18, 3844👍, 0💬

What is *.DBC file and whats is location of DBC file ?
What is *.DBC file and whats is location of DBC file ? DBC as name stands for is database connect descriptor file used to connect to database. This file by default located in $FND_TOP/secure directory also called as $FND_SECURE directory. 2011-11-28, 3840👍, 0💬

How will you find Invalid Objects in database ?
How will you find Invalid Objects in database ? using query SQLPLUS&gt; select count(*) from dba_objects where status like 'INVALID'; 2011-12-27, 3820👍, 0💬

What is dev60cgi and f60cgi ?
What is dev60cgi and f60cgi ? CGI stands for Common Gateway Interface and these are Script Alias in Oracle application used to access forms server . Usually Form Server access directly via http://hostname:port/dev60cgi/ f60cgi 2011-11-15, 3810👍, 0💬

What is different between NO DATA FOUND and %NOTFOUND
What is different between NO DATA FOUND and %NOTFOUND NO DATA FOUND is an exception which is raised when either an implicit query returns no data, or you attempt to reference a row in the PL/SQL table which is not yet defined. SQL%NOTFOUND, is a BOOLEAN attribute indicating whether the recent SQL st... 2011-11-02, 3801👍, 0💬

Output and Logfiles for requests executed on source Instance not working on cloned Instance
Output and Logfiles for requests executed on source Instance not working on cloned Instance Here is exact problem description - You cloned an Oracle Apps Instance from PRODBOX to another box with Instance name say CLONEBOX on 1st of August. You can any CM logs/output files after 1st of August only b... 2011-12-16, 3800👍, 0💬

What are various joins used while writing SUBQUERIES?
What are various joins used while writing SUBQUERIES? =, , IN, NOT IN, IN ANY, IN ALL, EXISTS, NOT EXISTS. 2011-12-23, 3767👍, 0💬

How to start Applications listener ?
How to start Applications listener ? In Oracle 11i, you have script adalnctl.sh which will start your apps listener. You can also start it by command lsnrctl start APPS_$SID (Replace sid by your Instance SID Name) 2011-12-26, 3758👍, 0💬

What is difference between UNIQUE and PRIMARY KEY constraints?
What is difference between UNIQUE and PRIMARY KEY constraints? An UNIQUE key can have NULL whereas PRIMARY key is always not NOT NULL. Both bears unique values. 2011-12-22, 3702👍, 0💬

How to confirm if Apps Listener is Up and Running ?
How to confirm if Apps Listener is Up and Running ? execute below command lsnrctl status APPS_$SID (replcae SID with your Instance Name) so If your SID is VISION then use lsnrctl status APPS_VISION out put should be like Services Summary... FNDFS has 1 service handler(s) FNDSM has 1 service handler(... 2011-12-26, 3679👍, 0💬

What is difference between SQL and SQL*PLUS?
What is difference between SQL and SQL*PLUS? SQL is the query language to manipulate the data from the database. SQL*PLUS is the tool that lets to use SQL to fetch and display the data. 2011-12-20, 3677👍, 0💬

Where GWYUID defined and what is its used in Oracle Applications ?
Where GWYUID defined and what is its used in Oracle Applications ? GWYUID is defined in dbc i.e. Database Connect Descriptor file . It is used to connect to database by think clients. 2011-12-01, 3654👍, 0💬

What are few profile options which you update after cloning ?
What are few profile options which you update after cloning ? Rapid clone updates profile options specific to site level . If you have any profile option set at other levels like server, responsibility, user....level then reset them. 2011-11-29, 3645👍, 0💬

What is RRA/FNDFS ?
What is RRA/FNDFS ? Report Review Agent(RRA) also referred by executable FNDFS is default text viewer in Oracle Applications 11i for viewing output files and log files. As most of Applications DBA's are not clear about Report Server and RRA, I'll discuss one on my blog and update link here . 2011-12-14, 3644👍, 0💬

What is an UTL_FILE? What are different procedures and functions associated with it?
What is an UTL_FILE? What are different procedures and functions associated with it? The UTL_FILE package lets your PL/SQL programs read and write operating system (OS) text files. It provides a restricted version of standard OS stream file input/output (I/O). Subprogram -Description FOPEN function-... 2011-09-13, 3629👍, 0💬

What is your Oracle application 11i Webserver Version and how to find it ?
What is your Oracle application 11i Webserver Version and how to find it ? From 11.5.8 to 11.5.10 Webserver version is iAS 1.0.2.2.2, In order to find version under $IAS_ORACLE_HOME/Apache/Apache /binexecute ./httpd -version ./httpd -version Server version: Oracle HTTP Server Powered by Apache/1.3.1... 2011-11-24, 3616👍, 0💬

What is use of Applications listener ?
What is use of Applications listener ? Apps Listener usually running on All Oracle Applications 11i Nodes with listener alias as APPS_$SID is mainly used for listening requests for services like FNDFS and FNDSM. 2011-12-23, 3596👍, 0💬

Which data type is used for storing graphics and images?
Which data type is used for storing graphics and images? Raw, Long Raw, and BLOB. 2011-12-20, 3578👍, 0💬

What is different between TRUNCATE and DELETE?
What is different between TRUNCATE and DELETE? The Delete command will log the data changes in the log file where as the truncate will simply remove the data without it. Hence Data removed by Delete command can be rolled back but not the data removed by TRUNCATE. Truncate is a DDL statement whereas ... 2011-08-30, 3578👍, 0💬

Where would I find .rf9 file, and what it dose ?
Where would I find .rf9 file, and what it dose ? These files are used during restart of patch in case of patch failure because of some reason. 2011-10-18, 3555👍, 0💬

Whats is difference between two env files in &lt;CONTEXT>.env and APPS&lt;CONTEXT>.env under $APPL_TOP ?
Whats is difference between two env files in &lt;CONTEXT>.env and APPS&lt;CONTEXT>.env under $APPL_TOP ? APPS&lt;CONTEXT>.env is main environment file which inturn calls other environment files like &lt;CONTEXT>.env under $APPL_TOP, &lt;CONTEXT>.env under 806 ORACLE_HOME and cust... 2011-10-04, 3543👍, 0💬

<< < … 15 16 17 18 19 20 21 22 23 24 > >>   Sort: Date

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML