links today
TRANSCRIPT
-
8/10/2019 Links Today
1/6
softlinkhttp://www.computerhope.com/unix/uln.htmhttp://www.dba-oracle.com/t_linux_symbolic_links.htm
ORA-01237: cannot extend datafile 351 in DRhttp://www.dbasupport.com/forums/showthread.php?29821-ORA-01237-cannot-extend-da
tafilehttp://gavinsoorma.com/2009/06/resize-standby-datafile-if-disk-runs-out-of-space/
show sysdba connected sessions
http://becomeappsdba.blogspot.com/2007/01/oracle-apps-r12-file-system-changes.htmlDifference between Oracle Apps 11i and R12 (Technical) Online Identity & AccessManagement: One Stop Shop for Identity & Access Management
http://onlineappsdba.com/index.php/2007/04/08/difference-between-oracle-apps-11i-and-r12-technical/https://sites.google.com/site/oracledb009/oracle-apps-concepts/r12/oc4j-instead-of
http://onlineappsdba.com/index.php/2009/07/23/adoacorectlsh-adformsctlsh-adoafmctlsh-exiting-with-status-204/
application.log in r12
http://www.oracle-base.com/articles/11g/sql-access-advisor-11gr1.php
http://www.dba-oracle.com/tips_rittman_dbazine_sqlaccess.htmsql access advisor oracle enterprise manager
add files to a tar file in unixhttp://www.thegeekstuff.com/2010/04/unix-tar-command-examples/http://www.unix.com/unix-for-advanced-and-expert-users/19700-find-move.htmlfind and mv command in unix
https://community.oracle.com/thread/1011283?tstart=0RMAN-03002: failure of allocate command at RMAN-06171: not connected to target databasehttp://www.symantec.com/connect/forums/queries-data-replication-hadr-enviroment-
oracle-rachttp://www.oraclemasters.com/?p=1255http://www.dba-oracle.com/t_physical_standby_missing_log_scenario.htmcheck sync between primary standby database
Archive Log Creation Fails With Errors ORA-16014, ORA-00312 (Doc ID 1373314.1)Application Management Suite: Quick Provisioning of Oracle E-Business Suite Using Virtual Assemblies (Doc ID 1904928.1)
rename datafile in standbyAdd Datafile To Standby Database Fails With ORA-19502 (Doc ID 224735.1)
How to Resize a Datafile (Doc ID 1029252.6)ORA-01237: cannot extend datafile 351 ORA-01110: data file 351: '/u44/oracle/ora
-
8/10/2019 Links Today
2/6
data/CGISS/mrp_idx05.dbf' ORA-19502: write error on file on standby
'Error initializing server: Application: default is in failed state as initialization failed' When Upgrading JDBC Version in Oracle Containers For J2EE 10.1.3.X(Doc ID 849050.1)
Error In Oacorestd.err Log File (Doc ID 454432.1)
Error initializing server: At least one valid code-source or import-shared-library element is required for shared-library "oracle.jdbc" When Starting up OC4J Container Causes Application to Fail with HTTP-500 error (Doc ID 1494057.1)
Add Datafile To Standby Database Fails With ORA-19502 (Doc ID 224735.1)
Physical Configuration
Bug 9926291 : RETRY IS NOT A VALID OPTION FOR THE PING DIRECTIVE IN OPMN.XMLHow to Troubleshoot Problems with Starting Up OracleAS 10g OPMN Managed Componen
ts? (Doc ID 744433.1)LSX-00026: Unknown Attribute "Retry" in OPMN.XML for OC4J "Ping timeout" Element(Doc ID 364993.1)
DGhttp://rupamverma.blogspot.com/2011/03/how-to-check-whether-physical-standby.htmlhttp://emrebaransel.blogspot.com/2008/08/how-to-query-dataguard-status.html
mv command slow in nfshttp://www-01.ibm.com/support/docview.wss?uid=isg1IZ02870
mount optionshttp://h30499.www3.hp.com/t5/General/Query-regarding-FS-mount-point-options/td-p/5296131#.VDwjgPldU_ghttp://www.unix.com/unix-for-advanced-and-expert-users/77047-mount-points.html
https://en.opensuse.org/SDB:Basics_of_partitions,_filesystems,_mount_pointshttp://its.virginia.edu/os/linux/mount.htmlhttp://unix.stackexchange.com/questions/42338/how-can-i-determine-how-directories-filesystems-have-been-mountedhttp://unix.stackexchange.com/questions/72223/check-if-folder-is-a-mounted-remote-filesystem
oracle clear dbms_pipehttp://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_pipe.htmhttp://www.toadworld.com/platforms/oracle/w/wiki/2900.dbms-pipe-reset-buffer.aspx
concurrent program parameters table
http://yoonusp.blogspot.com/2012/07/tracingdiagnosing-oracle-11ir12.html
-
8/10/2019 Links Today
3/6
debug options of a concurrent program
interface trip stop program in oracle apps + debug optionPurpose of tripstop programhttp://eoracleapps.blogspot.com/2009/11/interface-trip-stop-its-in-order.html
query to get the concurrent program name form request id
create new password file oraclehttp://docs.oracle.com/cd/B28359_01/server.111/b28310/dba007.htm#ADMIN10241
Oracle Applications Performance Tuning Handbookhttp://sabdarsyed.blogspot.com/search/label/Unix%20and%20Linux
tuning query to use less temp oraclehttps://community.oracle.com/thread/547758?tstart=0
http://www.oracle-scripts.net/hints/http://www.informit.com/library/content.aspx?b=red_hat_linux7&seqNum=208http://www.tldp.org/HOWTO/Oracle-7-HOWTO-6.htmlhttp://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_3017.htm#REFRN30638http://dbafix.blogspot.com/2008/10/get-concurrent-request-id-from-sid.htmlhttp://rupamverma.blogspot.com/2011/03/how-to-check-whether-physical-standby.htmlhttp://www.oracle.com/technetwork/server-storage/linux/technologies/uek-overview-2043074.html
create user ddl statementhttp://www.oracle-scripts.net/generate-user-ddl/
cursor sharing exact vs forcehttp://psoug.org/reference/cursor_sharing.htmlhttps://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4608916500346512056
having too many partitions on a table in oraclehttps://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1001181800346992268avoid latch cache buffers chains in oracle partitioned tablehttp://www.toadworld.com/platforms/oracle/w/wiki/371.resolving-latch-contention.aspxhttp://oracleinaction.com/buffer-cache-wait-events/
_spin_count value oraclehttp://docs.oracle.com/cd/E13203_01/tuxedo/tux71/html/adfig25.htmhttp://www.dba-oracle.com/t_spin_count_tuning.htmhttps://andreynikolaev.wordpress.com/2011/12/22/latch-timescales/#more-3681
latch buffer cache chains + many subpartitions oraclehttp://jonathanlewis.wordpress.com/2006/12/15/index-operations/http://vikshar.hubpages.com/hub/Oracle-Hash-partitioning-Perspectives-on-perform
-
8/10/2019 Links Today
4/6
ance-improvement
select explain plan for a sqlidhttp://ss64.com/ora/explain.htmlhttp://psoug.org/reference/dbms_xplan.htmlhttp://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_xplan.htm
http://docs.oracle.com/cd/B10500_01/server.920/a96533/ex_plan.htm
resmgr:cpu quantumhttp://dbakevin.blogspot.com/2012/11/resmgrcpu-quantum.htmlhttp://www.dba-oracle.com/t_resmgr_cpu_quantum.htm
event 10949 direct path readhttp://blog.tanelpoder.com/2012/09/03/optimizer-statistics-driven-direct-path-read-decision-for-full-table-scans-_direct_read_decision_statistics_driven/Dion Cho Oracle Performance Storyteller ---very good
http://dioncho.wordpress.com/2009/07/21/disabling-direct-path-read-for-the-serial-full-table-scan-11g/
http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_7002.htm#SQLRF01402
MOS docsHow to Troubleshoot Problems with Starting Up OracleAS 10g OPMN Managed Componen
ts? (Doc ID 744433.1)
adoacorectl.sh: exiting with status 204https://community.oracle.com/thread/1021466?tstart=0http://appsdbaworkshop.blogspot.com/2012/11/adoacorectlsh-exiting-with-status-204.htmlhttps://community.oracle.com/thread/2166304?tstart=0http://www.pythian.com/blog/ebs-r12-default-oacore-memory-settings-are-not-enough/ORA-1167 When Creating a Controlfile with a Database Copy (Doc ID 471960.1)12c Cloud Console: Personalizing the Databases Target Page Results in Error forSubsequent Logins: ADFC-10009: An exception occurred.. (Doc ID 1399625.1)After deploying DB plugin 12.1.0.3, errors ADFC-10009 And ADF_FACES-60097 are intermittently popped-up in the EM console. (Doc ID 1540928.1)The Dataguard_sperf_112 Metric Does Not Exist For Oracle_database Target (Doc ID1530487.1)How to Generate a SQLTrace Including Binds and Waits for a Concurrent Program in11i and R12 (Doc ID 301372.1) To BottomTo Bottom
What To Do If A Concurrent Request Is Inactive With No Manager Status? (Doc ID 1311526.1)Interface Trip Stop Error Transfer Reservation Has Failed With Error. (Doc ID 46
4913.1)Internal Order Receipts Cannot be Found (APP-PO-14094) Because TripStop (WSHINTERFACE) Fails With "Receiving Transaction Manager Returned error" (Doc ID 1323849
-
8/10/2019 Links Today
5/6
.1)
High "Resmgr:Cpu Quantum" Wait Events In 11g Even When Resource Manager Is Disabled [ID 949033.1]Resource Manager and Sql Tunning Advisory DEFAULT_MAINTENANCE_PLAN [ID 786346.1]
How to Change SYS and SYSTEM Passwords (Doc ID 1051982.6)
How To Identify a Hot Block Within The Database Buffer Cache. (Doc ID 163424.1)Troubleshooting 'latch: cache buffers chains' Wait Contention (Doc ID 1342917.1)http://www.oracle.com/technetwork/database/enterprise-edition/partitioning-11g-whitepaper-159443.pdfInterval Partitioning Essentials - Common Questions - Top Issues (Doc ID 1479115.1)How to Move from ANALYZE to DBMS_STATS on Sub-Partitioned Tables - Some Examples(Doc ID 237539.1)
Poor Plan Intermittently on Very Large Partitioned Table with too Many Partitions (Doc ID 785108.1)
Oracle Applications Performance Tuning Handbook (Book/CD-ROM package)http://www.amazon.com/Oracle-Applications-Performance-Handbook-package/dp/0072125497
Even though this reference is not recent, I still use it for tuning Oracle Applications.
In addition to this reference, please refer to:
Note: 169935.1 - Troubleshooting Oracle Applications Performance Issueshttps://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=169935.1
Note: 244040.1 - Oracle E-Business Suite Recommended Performance Patcheshttps://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=244040.1
Note: 216205.1 - Database Initialization Parameters for Oracle Applications Release 11ihttps://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=216205.1
Note: 117648.1 - Troubleshooting Performance Issues in Oracle Applications/ E-Business Suitehttps://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=117648.1'Installing, Upgrading and Maintaining Oracle E-Business Suite Applications Release 11.5.10+' , by Barbara Matthews et al., ISBN 978-0-6151-4122-0
http://www.computerhope.com/unix/uln.htm
ORA-00932: inconsistent datatypes: expected CHAR got NUMBER
Alert Log Messages: Private Strand Flush Not Complete (Doc ID 372557.1)
-
8/10/2019 Links Today
6/6
EM 10g: The Enterprise Manager Grid Control 10.2.0.5 Agent Installation Fails with Error: subdirectory already exists in Oracle Inventory. Specify another homelocation (Doc ID 1435084.1)How To Close Database Link In An Distributed Transaction To Avoid Hang (Doc ID 1362546.1)Manual Log Switching Causing "Thread 1 Cannot Allocate New Log" Message in the A
lert Log (Doc ID 435887.1)
sql error exceptionhttp://psoug.org/reference/exception_handling.html
close database link oracle pl sqlhttp://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_sessio.htm