How Many Types of Tables Supported by Oracle
How Many Types of Tables Supported by Oracle? - Oracle DBA FAQ - Managing Oracle Database Tables Oracle supports 4 types of tables based on how data is organized in storage: Ordinary (heap-organized) table - This is the basic, general purpose type of table. Its data is stored as an unordered collect... 2016-11-18, 8122👍, 1💬
How To Export Your Connection Information to a File
How To Export Your Connection Information to a File? - Oracle DBA FAQ - Introduction to Oracle SQL Developer SQL Developer allows you to export your connection information into an XML file. Here is how to do this: Right-click on Connections Select Export Connection... Enter File Name as: \temp\conne... 2016-07-11, 28208👍, 1💬
How To Increment Dates by 1
How To Increment Dates by 1? - Oracle DBA FAQ - Understanding SQL Basics If you have a date, and you want to increment it by 1. You can do this by adding the date with a date interval. You can also do this by adding the number 1 directly on the date. The tutorial example below shows you how to addin... 2016-07-06, 26781👍, 1💬
What Are the Differences between CHAR and NCHAR
What Are the Differences between CHAR and NCHAR? - Oracle DBA FAQ - Understanding SQL Basics Both CHAR and NCHAR are fixed length character data types. But they have the following differences: CHAR's size is specified in bytes by default. NCHAR's size is specified in characters by default. A charact... 2016-06-25, 4875👍, 0💬
Can you use both ADPATCH and OPATCH in application ?
Can you use both ADPATCH and OPATCH in application ? Yes you have to use both in application , for application patches you will use ADPATCH UTILITY and for applying database patch in application you will use opatch UTILITY. 2011-12-29, 2982👍, 0💬
What is difference between ADPATCH and OPATCH ?
What is difference between ADPATCH and OPATCH ? # ADPATCH is utility to apply ORACLE application Patches whereas # OPATCH is utility to apply database patches 2011-12-29, 4721👍, 0💬
How to compile JSP in Oracle Applications ?
How to compile JSP in Oracle Applications ? You can use ojspCompile.pl perl script shipped with Oracle Applications to compile JSP files. This script is under $JTF_TOP/admin/scripts. Sample compilation method is perl ojspCompile.pl --compile --quiet 2011-12-28, 2710👍, 0💬
How to compile Invalid Objects in database ?
How to compile Invalid Objects in database ? You can use adadmin utility to compile or you can use utlrp.sql script shipped with Oracle Database to compile Invalid Database Objects. 2011-12-28, 2697👍, 0💬
What is Web Listener ?
What is Web Listener ? Web Listener is Web Server listener which is listening for web Services(HTTP) request. This listener is started by adapcctl.sh and defined by directive (Listen, Port) in httpd.conf for Web Server. When you initially type request like http://becomeappsdba.blogspot. com:80to acc... 2011-12-27, 2721👍, 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, 2501👍, 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, 2615👍, 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, 2507👍, 0💬
What is difference between Rename and Alias?
What is difference between Rename and Alias? Rename is actually changing the name of an object whereas Alias is giving another name (additional name) to an existing object. Rename is a permanent name given to a table or column whereas Alias is a temporary name given to a table or column which do not... 2011-12-22, 3598👍, 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, 2367👍, 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, 2414👍, 0💬
What is difference between SUBSTR and INSTR?
What is difference between SUBSTR and INSTR? INSTR function search string for sub-string and returns an integer indicating the position of the character in string that is the first character of this occurrence. SUBSTR function return a portion of string, beginning at character position, substring_le... 2011-12-19, 2638👍, 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, 2388👍, 0💬
How to confirm if Report Server is Up and Running ?
How to confirm if Report Server is Up and Running ? Report Server is started by executable rwmts60 on concurrent manager Node and this file is under $ORACLE_HOME/bin .execute command on your server like ps -ef | grep rwmts60 You should get output like applmgr ....... rwmts60 name=REP60_VISION 2011-12-16, 2320👍, 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, 2307👍, 0💬
Why I need two Concurrent Processing Nodes or in what scenarios PCP is Used ?
Why I need two Concurrent Processing Nodes or in what scenarios PCP is Used ? Well If you are running GL Month end reports or taxation reports annually these reposrts might take couple of days. Some of these requests are very resource intensive so you can have one node running long running , resourc... 2011-12-15, 2282👍, 0💬
What is PCP is Oracle Applications 11i ?
What is PCP is Oracle Applications 11i ? PCP is acronym for Parallel Concurrurent processing. Usually you have one Concurrent Manager executing your requests but if you can configure Concurrent Manager running on two machines (Yes you need to do some additional steps in order to configure Parallel C... 2011-12-15, 2342👍, 0💬
Can you write a program to interchange 2 variables without using the third one? a = 7; b = 2; a = a ...
How To Save Query Output to a Local File? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus C...
what is a service contract, operation contract and Data Contract? - part 1 In the below sample we ha...
When should the register modifier be used? Does it really help? The register modifier hints to the c...
How To Set session.gc_maxlifetime Properly? - PHP Script Tips - Understanding and Using Sessions As ...