Archive for January, 2012

We use java for a lot of our jobs, and using it to access SQL Server is no exception. We wanted to have controlled access, and avoid “user sprawl” across servers. As such, we use Windows authentication from our java programs. Below is an example: 1 2 3 4 5 6 7 8 9... »

Periodically, I will want to compare the RPM installations between two or more servers. Sometimes, I may not care about the specific versions of each RPM, but only that *some* version exists. To do this, I can use awk and print only the name of the RPM up to but not including where the... »

After restarting a test server, I found the RAC VIP would not start. This post is just a quick note as to how I troubleshot the problem, as well as its ultimate resolution. I frequently use the find -mmin 5 -type f | xargs grep -i "whatever you want" command to find any recently... »

If you need to copy the DDL to create a scheduler job from one schema to another, what is below works well… 13:28:56 oracle@oh1xpwcdb01 ~ >./dynColumns.py "select dbms_metadata.get_ddl('PROCOBJ','CHECK_TEMP_FREE','HOWARDS') from dual" -----------------------------------------------   BEGIN dbms_scheduler.create_job('"CHECK_TEMP_FREE"', job_type=>'PLSQL_BLOCK', job_action=> 'begin oclc_checks.check_temp_free(10); end;' , number_of_arguments=>0, start_date=>TO_TIMESTAMP_TZ('03-OCT-2009 04.40.00.000000000 PM AMERICA/NEW_YORK','DD-MON-RRRR HH.MI.SSXFF AM TZR','NLS_DATE_LANGUAGE=english'), repeat_interval=> 'FREQ=MINUTELY;INTERVAL=5' , end_date=>NULL, job_class=>'"DEFAULT_JOB_CLASS"', enabled=>FALSE,... »

Oracle provides several standard exception pragmas (essentially, a compiler directive) for exceptions found on a fairly frequent basis. These are documented in the PL/SQL User Guide and Reference, but you can also get them at runtime using what is below: 1 2 3 4 5 6 7 8 9 10 11 12 13 14... »