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…
Author: Steve
Getting DDL for a scheduler job
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,…
Standard exception pragmas
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:…
Extracting SCN range from an online redo log or archived redo log
I can’t imagine that this would be useful in a well managed system, but if you find yourself with a “raw” log file that is not in the dictionary, you can at least extract the SCN range it encompasses using…
ASM device structure
Today, we had an issue where the asmlib disk label was removed from a disk at some point in the past. When we added new storage and issued oracleasm scan disks , the disk was “cleaned”, rendering it unavailable on…
Converting ASCII to binary
This is pretty useless, but I know some people like this kind of thing 🙂 10:11:42 oracle@emgrid01 ~ >echo “if you can read this you are a geek” | xxd -b | awk ‘{printf(“%s %s %s %s %s %s “,$2,$3,$4,$5,$6,$7)}…
Creative ways to do simple things
I always like exercises such as this, especially for interview questions. In an interview, I am never looking for the correct answer as often as I am how the question is answered, and how creative the person is. For example,…
Additional cursor trace information in 11.2.0
Oracle has added a lot of additional trace output in the 10046 optimizer trace files. As I have posted previously, I find the output in these files to be useful not only for troubleshooting performance issues, but also understanding the…
Posting GV$SESSION_LONGOPS from a user procedure
The GV$SESSION_LONGOPS view can save you if you are nervous about how much time a long running operation has remaining, and are asked for an update from someone in a higher “zip code”. Oracle posts an entry to this memory…
Which transaction is being rolled back?
This morning, we had an issue in a development database where we couldn’t drop an UNDO tablespace as a transaction was currently using it. We saw nothing in the GV$TRANSACTION view, so we knew it must be rolling back a…