Oracle SQL Developer Data Modeler

Oracle SQL Developer Data Modeler

SQL Developer Data Modeler is a free data modeling and design tool, proving a full spectrum of data and database modeling tools and utilities, including modeling for Entity Relationship Diagrams (ERD), Relational (database design), Data Type and Multi-dimensional modeling, with forward and reverse engineering and DDL code generation. The Data Modeler imports from and exports to a variety of sources and targets, provides a variety of formatting options and validates the models through a predefined set of design rules.

View Demo on Oracle Website

http://download.oracle.com/otn_hosted_doc/sqldev/DataModeler30NewFeaturesOverview/DataModeler30NewFeaturesOverview.html

EBS -R12 Log File Locations

EBS -R12 Log File Locations

Log Description	Log Location
Start up/Shutdown error message text files	$INST_TOP/apps/$CONTEXT_NAME/logs/appl/admin/log
Start up/Shutdown error message related to tech stack	$INST_TOP/apps/$CONTEXT_NAME/logs/ora/  (10.1.2 & 10.1.3)
	$INST_TOP/apps/$CONTEXT_NAME/logs/ora/10.1.3/Apache/error_log[timestamp]
	$INST_TOP/apps/$CONTEXT_NAME/logs/ora/10.1.3/opmn/ (OC4J~…, oa*, opmn.log)
	$INST_TOP/apps/$CONTEXT_NAME/logs/ora/10.1.2/network/ (listener log)
	$INST_TOP/apps/$CONTEXT_NAME/logs/appl/conc/log  (CM log files)
Pre-clone log files in source instance Database Tier	/$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/(StageDBTier_MMDDHHMM.log)
Pre-clone log files in source instance Application Tier	$INST_TOP/apps/$CONTEXT_NAME/admin/log/ (StageAppsTier_MMDDHHMM.log)
Pre-clone log files in target instance Database Tier	$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_<time>.log
Pre-clone log files in target instance Application Tier	$INST_TOP/apps/$CONTEXT_NAME/admin/log/ApplyAppsTier_<time>.log
Application Tier adpatch log	$APPL_TOP/admin/$SID/log/
Developer (Developer/Forms & Reports 10.1.2) Patch	$ORACLE_HOME/.patch_storage
Web Server (Apache) patch	$IAS_ORACLE_HOME/.patch_storage
Database Tier opatch log	$ORACLE_HOME/.patch_storage
Database Tier Autoconfig log	$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/MMDDHHMM/adconfig.log
	$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/MMDDHHMM/NetServiceHandler.log
Application Tier Autoconfig log	$INST_TOP/apps/$CONTEXT_NAME/admin/log/$MMDDHHMM/adconfig.log
Autoconfig context file location	$INST_TOP/apps/$CONTEXT_NAME/appl/admin/$CONTEXT_NAME.xml
Alert Log Files	$ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log