Display status of all Concurrent Managers

set head on column OsId format A10 justify left column CpId format 999999 column Opid format 999 column Manager format A30 column Status format A20 column Started_At format A30 column Cpid heading ‘Concurrent|Process ID’ column OsId heading ‘System|Process ID’ column Opid heading ‘Oracle|Process ID’ column Manager heading ‘Concurrent Manager Name’ column Status heading ‘Status|of Concurrent|Manager’…

Print Oracle Apps versions

SELECT substr(a.application_short_name, 1, 5) code, substr(t.application_name, 1, 50) application_name, p.product_version version FROM fnd_application a, fnd_application_tl t, fnd_product_installations p WHERE a.application_id = p.application_id AND a.application_id = t.application_id AND t.language = USERENV(‘LANG’) /

Script to migrate data from FileMaker Pro to Oracle

use strict; use DBI qw(:sql_types); my $db_connect_string_oracle = ‘contact_management_ora_dsn’; my $db_connect_string_fmpro = ‘contact_management_fmp_dsn’; my $filemaker_database_name = ‘contact_management’; my $oracle_tablename = ‘contact_management’; my $schema_name = ‘user1’; my $schema_password = ‘user1pwd’; my $debug=0; # DBI tracing enable/disable my $long_readlength = 100000; # maximum number of bytes for CLOB, BLOB type data read from FileMaker – inscrease this…

Load Oracle NameServer from TNSNAMES.ORA file

$TNSNAMES = “./tnsnames.ora”; @NAMESERVERS = (oranamesrvr0,oranamesrvr1,oranamesrvr2); foreach $NS (@NAMESERVERS) { print “\nset server ” . $NS . “\n\n”; &register_name_servers; &load_tnsnames; } print “\n\nexit\n”; exit; #————————————————————————– sub register_name_servers { # # Register all NameServers. The defualt port is 1575. # print “register oranamesrvr0.world -t ORACLE_NAMESERVER -d ” . “(ADDRESS=(PROTOCOL=TCP)(HOST=oranamesrvr0)(PORT=1575))\n\n”; print “register oranamesrvr1.world -t ORACLE_NAMESERVER -d “…

Oracle Alert Log Monitor

=head1 NAME trlogmon – Oracle alert log monitor =head1 SYNOPSIS trlogmon.p [-sleep ] =head1 DESCRIPTION Monitors the Oracle instance alert log for problems (i.e. ORA-00600, block corruption errors, etc). The log file is monitored in a manner similar to the B command, using the ‘-f’ switch. This is done by resetting the error flag on…

List Developer Repository Owners

select distinct owner from sys.dba_segments where segment_name = ‘SDD_ELEMENTS’; REM D2K user privs: REM REM Run this from your PC as SYS to create role des2000_owner REM @c:\repadm20\utl\ckrorole.sql REM grant des2000_owner to &&repos_owner; REM REM grant execute on dbms_lock to &&repos_owner; REM grant execute on dbms_pipe to &&repos_owner; REM grant select on dba_rollback_segs to &&repos_owner;…

Simple script for checking log switches

format top = LOG SWITCH REPORT +++++++++++++++++ Time Sequence __________________ _____________ . format STDOUT = @