2013 Great Lakes Oracle Conference

Join the Northeast Ohio Oracle Users Group and the Ohio Oracle Users Group at their newly formed Great Lakes Oracle Conference (GLOC). The event has been re–branded as the Great Lakes Oracle Conference to attract participants from all over the Great Lakes region, not just Ohio. We anticipate this to be the largest Oracle user conference in […]

Creating public database link with/without username

Create a public database link without specifying a username CREATE PUBLIC DATABASE LINK LINK_TEST01 USING ‘(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server1.instabc.com)(PORT=1521))(CONNECT_DATA= (SERVER=dedicated)(SERVICE_NAME=inttest)))’; Create a public database link while specifying a username to use CREATE PUBLIC DATABASE LINK LINK_TEST01 CONNECT TO TESTUSER IDENTIFIED BY TESTPASS USING ‘(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server1.instabc.com)(PORT=1521))(CONNECT_DATA= (SERVER=dedicated)(SERVICE_NAME=inttest)))’; When creating a database link you have the option of using a username […]

Common commands for the Oracle Applications DBA – PART 1

These are common commands for the oracle applications dba.  Random order, but brief description above each. # Stop all services on an application or concurrent manager server $APPLCSF/scripts/$CONTEXT_NAME/adstpall.sh apps/ # Start all services on an application or concurrent manager server $APPLCSF/scripts/$CONTEXT_NAME/adstrtal.sh apps/ # Stop Apache on the application server $APPLCSF/scripts/$CONTEXT_NAME/adapcctl.sh stop # Start Apache on […]

Querying indexes on table and build script

Often times we are asked to rebuild indexes on tables, but are unaware of what all indexes are on the table. We can query dba_ind_columns to get indexes  on the columns or for general indexes against the table we can query dba_indexes. A general query would look like this: select owner,table_name,index_name from dba_indexes where table […]

Oracle Applications – set trace for an individual user

1. Navigate to – Profile – System 2. On the “Find System Profile Values” form, make sure the checkboxes for “User” and “Profiles with no Values” are checked 3. Beside the “User” checkbox, use the LOV to select the user who’s activity you need to trace 4. In the “Profile” field, enter the following profile […]