<< < 1 2 3 4 5 6 7 8 > >>   Sort: Rank

What is content of DBC file and why its important ?
What is content of DBC file and why its important ? DBC file is quite important as whenever Java or any other program like forms want to connect to database it uses DBC file. Typical entry in DBC file is GUEST_USER_PWD APPS_JDBC_URL DB_HOST
2011-11-28, 2766👍, 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, 3031👍, 0💬

Where is DATABASE/PLSSQL cache stored ?
Where is DATABASE/PLSSQL cache stored ? PLSSQL and session cache are stored under $IAS_ORACLE_HOME/ Apache/modplsql/cache directory.
2011-11-26, 2718👍, 0💬

What is plssql/database cache ?
What is plssql/database cache ? In order to improve performance mod_pls (Apache component) caches some database content to file. This database/plssql cache is usually of type session and plsql cache # session cache is used to store session information. # plsql cache is used to store plsql cache i.e....
2011-11-26, 2726👍, 0💬

What is Location of Jserv configuration files ?
What is Location of Jserv configuration files ? Jserv configuration files are located in $IAS_ORACLE_HOME /Apache/Jserv/etc .
2011-11-24, 2623👍, 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, 2791👍, 0💬

Whats is location of access_log file ?
Whats is location of access_log file ? access_log file by default is located in $IAS_ORACLE_HOME/ Apache/Apache/logs. Location of this file is defined in httpd.conf by patameter CustomLog or TransferLog
2011-11-23, 2664👍, 0💬

What is a pseudo column. Give some examples?
What is a pseudo column. Give some examples? Information such as row numbers and row descriptions are automatically stored by Oracle and is directly accessible, ie. not through tables. This information is contained within pseudo columns. These pseudo columns can be retrieved in queries. These pseudo...
2011-11-23, 2671👍, 0💬

How do you find the number of rows in a Table ?
How do you find the number of rows in a Table ? select count(*) from table, or from NUM_ROWS column of user_tables if the table statistics has been collected.
2011-11-22, 2714👍, 0💬

What is the purpose of a cluster?
What is the purpose of a cluster? A cluster provides an optional method of storing table data. A cluster is comprised of a group of tables that share the same data blocks, which are grouped together because they share common columns and are often used together. For example, the EMP and DEPT table sh...
2011-11-22, 2785👍, 0💬

What is a cursor?
What is a cursor? A cursor is a mechanism by which you can assign a name to a “select statement” and manipulate the information within that SQL statement.
2011-11-21, 2710👍, 0💬

What is difference between an implicit and an explicit cursor.
What is difference between an implicit and an explicit cursor. The implicit cursor is used by Oracle server to test and parse the SQL statements and the explicit cursors are declared by the programmers.
2011-11-21, 2697👍, 0💬

What are cursor attributes?
What are cursor attributes? Cursor attributes are used to get the information about the current status of your cursor. Both explicit and implicit cursors have four attributes, as shown: Name Description %FOUND Returns TRUE if record was fetched successfully, FALSE otherwise. %NOTFOUND Returns TRUE i...
2011-11-18, 2733👍, 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, 3443👍, 0💬

What is GSM in Oracle application E-Business Suite ?
What is GSM in Oracle application E-Business Suite ? GSM stands for Generic Service Management Framework. Oracle E-Business Suite consist of various compoennts like Forms, Reports, Web Server, Workflow, Concurrent Manager .. Earlier each service used to start at their own but managing these services...
2011-11-17, 2863👍, 0💬

What is difference between COMPILE_ALL=SPECIAL and COMPILE=ALL while compiling Forms ?
What is difference between COMPILE_ALL=SPECIAL and COMPILE=ALL while compiling Forms ? Both the options will compile all the PL/SQL in the resultant .FMX, .PLX, or .MMX file but COMPILE_ALL=YES also changes the cached version in the source .FMB, .PLL, or .MMB file. This confuses version control and ...
2011-11-17, 3588👍, 0💬

What is difference between mod_osso and mod_ose in Oracle HTTP Server ?
What is difference between mod_osso and mod_ose in Oracle HTTP Server ? mod_osso is Oracle Single Sign-On Module where as mod_ose is module for Oracle Servlet Engine. mod_osso is module in Oracle's HTTP Server serves as Conduit between Oracle Apache Server and Singl Sign-On Server where as mod_ose i...
2011-11-16, 2944👍, 0💬

Why does a worker fails in Oracle Apps Patch and few scenarios in which it failed for you ?
Why does a worker fails in Oracle Apps Patch and few scenarios in which it failed for you ? Apps Patch worker can fail in case it doesn't find expected data, object, files or any thing which driver is trying to update/edit/modify. Possible symptoms may be underlying tables/objects are invalid, a pre...
2011-11-16, 2907👍, 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, 3453👍, 0💬

Can C driver in application patch create Invalid Object in database ?
Can C driver in application patch create Invalid Object in database ? No , C driver only copies files in File System. Database Object might be invalidated during D driver when these objects are created/dropped/modified.
2011-11-15, 2766👍, 0💬

What are main configuration files in Web Server (Apache) ?
What are main configuration files in Web Server (Apache) ? Main configuration files in Oracle application Web Server are # httpd.conf, apps.conf, oracle_apache.conf, httpd_pls.conf # jserv.conf, ssp_init.txt, jserv.properties, zone.properties # plsql.conf, wdbsvr.app, plsql.conf
2011-11-14, 2681👍, 0💬

Where is applications start/stop scripts stored ?
Where is applications start/stop scripts stored ? applications start/stop scripts are in directory $COMMON_TOP/admin/scripts/$CON TEXT_NAME
2011-11-14, 2720👍, 0💬

Where is Jserv configuration files stored ?
Where is Jserv configuration files stored ? Jserv configuration files are stored in $IAS_ORACLE_HOME/Apache/Jserv/ etc
2011-11-12, 2819👍, 0💬

What is access_log in apache , what entries are recored in access_log ? Where is default location of this file ?
What is access_log in apache , what entries are recored in access_log ? Where is default location of this file ? access_log in Oracle Application Server records all users accessing oracle applications 11i. This file location is defined in httpd.conf with default location at $IAS_ORACLE_HOME/Apache/A...
2011-11-12, 2832👍, 0💬

<< < 1 2 3 4 5 6 7 8 > >>   Sort: Rank