beginapps.blogspot.com
Oracle Apps DBA, Qatari Diar real Estate investment Company.: July 2009
http://beginapps.blogspot.com/2009_07_01_archive.html
How to change Apps 11i form color change after cloning. To differentiate dev/test from prod, we can change the form color by changing some profile options. Profile option change to be done:. 1 Set the Java Look and Feel. Profile option value to oracl. If you set it to generic, it will take the default values and you wont be able to set your own color. 2 Then set Java Color Scheme. Profile option value to any of the LOVs as per your choice. Remember to set this at site level. Links to this post. Craig Way...
beginapps.blogspot.com
Oracle Apps DBA, Qatari Diar real Estate investment Company.: June 2013
http://beginapps.blogspot.com/2013_06_01_archive.html
11g Grid Control: Using 'opmnctl startall status stopall' in OMS HOME Fails with "opmnctl: ORACLE INSTANCE is not set". Trying to start the 11.1.0.1 Grid Control with opmnctl command fails with the following errors. Oraoem@erputdb2 bin]$ ./opmnctl status. Opmnctl: ORACLE INSTANCE is not set. Opmnctl status requires that ORACLE INSTANCE be correctly set in your. Opmnctl utility should be used to start the OMS only in the 10g versions of Grid Control nad not in the 11g Grid Control version. SQL select targ...
beginapps.blogspot.com
Oracle Apps DBA, Qatari Diar real Estate investment Company.: APEX installation on Linux - apex_4.2.5.zip
http://beginapps.blogspot.com/2014/06/apex-installation-on-linux-apex425zip.html
APEX installation on Linux - apex 4.2.5.zip. APEX installation on Linux - Step by Step. 1 Download the Apex latest version(apex 4.2.5.zip). 2 Copy apex 4.2*.zip to Linux server (/u01/APEX). 3 Unzip apex 4.2*.zip :. Create the Tablespace for APEX :. CREATE TABLESPACE apex DATAFILE '/u01/apex/oradata/apexdev/apex01.dbf' SIZE 400M AUTOEXTEND ON NEXT 1M;. 4 Start APEX installation:. SQL @apexins.sql APEX APEX TEMP /i/. 5 Change ADMIN account password:. 8221;#$%&()“* ,-/:;? IF LOCKED - Unlock:. IF DBMS NETWOR...
beginapps.blogspot.com
Oracle Apps DBA, Qatari Diar real Estate investment Company.: September 2009
http://beginapps.blogspot.com/2009_09_01_archive.html
How to Check if a Patch requires Downtime. 1 Download the particular patch file. 2 Check the file . 3 If the following entry is present. Instance shutdown) true (/instance shutdown). Then it requires downtime. Links to this post. Subscribe to: Posts (Atom). You will find on some useful information on Oracle product and Oracle Application's. Oracle Apps Lead, Qatari Diar Real Estate investment Company. E-Mail : mr261277@gmail.com. Oracle Apps DBA, Qatari Diar real Estate investment Company. New To Apps DBA.
beginapps.blogspot.com
Oracle Apps DBA, Qatari Diar real Estate investment Company.: May 2013
http://beginapps.blogspot.com/2013_05_01_archive.html
Manual upgrade 11gR2 to later Version Time Zone Upgrade. Conn / as sysdba. Check if previous prepare window is ended. SELECT PROPERTY NAME, SUBSTR(property value, 1, 30) value. WHERE PROPERTY NAME LIKE 'DST %'. ORDER BY PROPERTY NAME;. Purge dba recyclebin;. TRUNCATE TABLE SYS.DST$TRIGGER TABLE;. TRUNCATE TABLE sys.dst$affected tables;. TRUNCATE TABLE sys.dst$error table;. This alter session might speed up DBMS DST on some db's. See Bug 10209691 / Bug 12658443. To avoid the issue in. Parallel = TRUE,.
beginapps.blogspot.com
Oracle Apps DBA, Qatari Diar real Estate investment Company.: April 2012
http://beginapps.blogspot.com/2012_04_01_archive.html
Oracle E-Business Suite Release 12 Configuration in a DMZ. Below are definitions of some of the terms that are used in this document:. Firewalls control access between the internet and a corporation's internal network or intranet. Firewalls define which internet communications will be permitted into the corporate network, and which will be blocked. A well-designed firewall can foil many common internet-based security attacks. Internal Applications Middle Tier. Web and Forms Services. The external applica...
beginapps.blogspot.com
Oracle Apps DBA, Qatari Diar real Estate investment Company.: June 2014
http://beginapps.blogspot.com/2014_06_01_archive.html
ORA-00119: invalid specification for system parameter LOCAL LISTENER. While startup the RAC database got following the error:. ORA-00119: invalid specification for system parameter LOCAL LISTENER. ORA-00132: syntax error or unresolved network name 'TEST1 LOCAL'. Missing below entry in RAC node tnsnames.ora file below entry. Just add below entry to tnsname.orafile. Links to this post. UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed. Following executables are active :. Classp...
balakaarthik.blogspot.com
All About Oracle Apps: April 2015
http://balakaarthik.blogspot.com/2015_04_01_archive.html
All About Oracle Apps. Saturday, April 25, 2015. PL/SQL Collection : Storing TABLE values into a TABLE TYPE. After a long time had a time to blog . Below are some of the PL/SQL Collections. Hope you can google about these to get more information. In this article I like to explain how to retrieve records from a table and store it in a TABLE type. Create a table emp tb as given below and insert some values. CREATE TABLE emp tb ( empid NUMBER , NAME VARCHAR2(20) );. INSERT INTO emp tb VALUES (10, 'Bala');.
balakaarthik.blogspot.com
All About Oracle Apps: July 2008
http://balakaarthik.blogspot.com/2008_07_01_archive.html
All About Oracle Apps. Wednesday, July 2, 2008. Delete duplicate rows in a table. To delete the duplicate rows from a table. Create table newtable as (select distinct * from oldtable);. Drop table oldtable;. Rename newtable to oldtable;. DELETE FROM mytable t1. WHERE t1.col1 = t2.col1 AND t1.col2 = t2.col2). Subscribe to: Posts (Atom). Reports Doc ID : 106549.1. Configure JDeveloper Doc ID : 357218.1. Oracle User guides and TRM. Delete duplicate rows in a table.
