oracledbas.blogspot.com
Oracle Apps DBA: November 2009
http://oracledbas.blogspot.com/2009_11_01_archive.html
Tuesday, November 17, 2009. Creating physical standby using RMAN duplicate. Creating physical standby using RMAN duplicate without shutting down the primary. Database Name :- orcl. Primary db unique name :- orcl. Standby db unique name :- stdby. 1 Check if archiving enabled on primary. SQL select log mode from v$database;. SQL archive log list;. Database log mode No Archive Mode. Archive destination /home/oracle/oracle/product/10.2.0/oradata/orcl/archive/. Oldest online log sequence 1. SQL shut immediate;.
oracledbas.blogspot.com
Oracle Apps DBA: October 2008
http://oracledbas.blogspot.com/2008_10_01_archive.html
Wednesday, October 29, 2008. Upgrade Oracle iAS 10.1.3.1.0 to 10.1.3.4. Upgrade Oracle iAS Steps 10.1.3.1.0 to 10.1.3.4. Download Oracle iAS 10.1.3.4. Select 10.1.3.1 ORACLE HOME. Http:/ sys50.doyen.in/. ORACLE HOME% bin runstartupconsole.bat start. ORACLE HOME% opmn bin opmnctl startall. ORACLE HOME% bin runstartupconsole.bat stop. ORACLE HOME% opmn bin opmnctl stopall. ORACLE HOME% opmn bin opmnctl status. ORACLE HOME% opmn bin opmnctl status -l. Labels: Oracle Middle Tier. AS Instance Name : ias.
oracledbas.blogspot.com
Oracle Apps DBA: ORA-29540: class oracle/CDC/PublishApi does not exist
http://oracledbas.blogspot.com/2009/10/ora-29540-class-oraclecdcpublishapi.html
Friday, October 30, 2009. ORA-29540: class oracle/CDC/PublishApi does not exist. ORA-29540: class oracle/CDC/PublishApi does not exist. 2 DBMS CDC PUBLISH.CREATE CHANGE TABLE(. 3 owner = 'cdcpub',. 4 change table name = 'products ct',. 5 change set name = 'PRODUCTS CS',. 6 source schema = 'MFCAMS',. 7 source table = 'PRODUCTS',. 8 column type list = 'PROD ID NUMBER(6), PROD NAME VARCHAR2(50),PROD LIST PRICE NUMBER(8,2),JOB ID VARCHAR2(10), DEPARTMENT ID NUMBER(4)',. 9 capture values = 'both',. Oracle Str...
oracledbas.blogspot.com
Oracle Apps DBA: Enable Trace in Oracle E-Business Suite R12
http://oracledbas.blogspot.com/2009/12/enable-trace-in-oracle-e-business-suite.html
Monday, December 7, 2009. Enable Trace in Oracle E-Business Suite R12. Debugging tool for HTTP, OC4J and OPMN in E-Business Suite R12. How To Enable and Collect Debug for HTTP, OC4J and OPMN. Shutdown the http server, oc4j. Enable http ODL logging. ORA CONFIG HOME/10.1.3/Apache/Apache/conf/ httpd.conf. OraLogDir $LOG HOME/ora/10.1.3/Apache/oracle. Please use the full path to $LOG HOME e.g. OraLogDir /u01/inst/apps/JCB atg/logs/ora/10.1.3/Apache/oracle. Mkdir $LOG HOME/ora/10.1.3/Apache/oracle. RMAN-04004...
oracledbas.blogspot.com
Oracle Apps DBA: June 2008
http://oracledbas.blogspot.com/2008_06_01_archive.html
Tuesday, June 24, 2008. Enable SSL with Oracle Applications 11i. Implementing SSL with Oracle Applications 11i. Hypertext Transfer Protocol (HTTP) is a communications protocol for the transfer of information on the intranet and the World Wide Web. Its original purpose was to provide a way to publish and retrieve hypertext pages over the Internet. One common use of SSL is to secure Web HTTP communication between a browser and a Web server. This case does not preclude the use of non-secured HTTP. T...4The ...
oracledbas.blogspot.com
Oracle Apps DBA: October 2009
http://oracledbas.blogspot.com/2009_10_01_archive.html
Friday, October 30, 2009. ORA-29540: class oracle/CDC/PublishApi does not exist. ORA-29540: class oracle/CDC/PublishApi does not exist. 2 DBMS CDC PUBLISH.CREATE CHANGE TABLE(. 3 owner = 'cdcpub',. 4 change table name = 'products ct',. 5 change set name = 'PRODUCTS CS',. 6 source schema = 'MFCAMS',. 7 source table = 'PRODUCTS',. 8 column type list = 'PROD ID NUMBER(6), PROD NAME VARCHAR2(50),PROD LIST PRICE NUMBER(8,2),JOB ID VARCHAR2(10), DEPARTMENT ID NUMBER(4)',. 9 capture values = 'both',. Download J...
oracledbas.blogspot.com
Oracle Apps DBA: September 2008
http://oracledbas.blogspot.com/2008_09_01_archive.html
Tuesday, September 30, 2008. Install OFSA Clinet 4.5.2. Oracle Financial Services Client Release 4.5.2 for MS Windows. 2 Install OFSA Oracle Client 16 Bit . 3 Install OFSA Oracle Client 32 Bit. 4 Edit OFS.ini file in Windows Directory and Change Database Source. Eg Username,Database Name,Connection string). 5 Set Env. in Oracle Clinet 16 Bit. 6Change Tnsnames.ora in 16 bit ORACLE HOME and 32 bit ORACLE HOME. Wednesday, September 10, 2008. OFSA Installing Step 4.5.2. OFSA 4.5.2. Oracle HOME = c: ofsademo.
oracledbas.blogspot.com
Oracle Apps DBA: February 2009
http://oracledbas.blogspot.com/2009_02_01_archive.html
Monday, February 23, 2009. ORA-04030: out of process memory. SQL alter package apps.XLA 00200 AAD S 000010 PKG COMPILE BODY;. Alter package apps.XLA 00200 AAD S 000010 PKG COMPILE BODY. ERROR at line 1:. ORA-04030: out of process memory when trying to allocate 4108 bytes (PLS. Non-lib hp,pdzgM64 New Link). 1SQL select object name,object type from dba objects where status='INVALID';. OBJECT NAME OBJECT TYPE. XLA 00200 AAD S 000010 PKG PACKAGE BODY. XLA 00200 AAD S 000011 PKG PACKAGE BODY. After moving all...
oracledbas.blogspot.com
Oracle Apps DBA: Move Grid Control Agent Repository To Another Server
http://oracledbas.blogspot.com/2009/12/move-grid-control-agent-repository-to.html
Tuesday, December 22, 2009. Move Grid Control Agent Repository To Another Server. Change Grid Control Agent Repository To Another Server. 1 Stop the agent. AGENT HOME/bin: emctl stop agent. Oracle@test ]$ $AGENT HOME/bin/emctl stop agent. Oracle Enterprise Manager 10g Release 10.2.0.1.0. Stopping agent . stopped. 2 Edit the AGENT HOME/sysman/config/emd.properties file. Change the following lines to port 4889. Make sure to back up this file before editing:. 3 Delete these files from the agent home. Check ...