Create Oracle Database Instance

In this guide, it will explain how to create a database instance and also the configuration for database listener. Later in the guide it will tell how to configure listener after instance creation. However, it is better if the listener created first. In initialization parameter, there are several parameters that I used to change such as: Continue reading

Advertisements

Killing Oracle Jobs

This article is not purely mine, I take this from another source, which I already forgot. However, I already used this to solve several issue regarding Oracle Jobs. To solve this issue will require Oracle SYS and Oracle OS user. Let start with listing the jobs

select j.log_user,
j.job,
j.broken,
j.failures,
j.last_date||':'||j.last_sec last_date,
j.this_date||':'||j.this_sec this_date,
j.next_date||':'||j.next_sec next_date,
j.next_date - j.last_date interval,
j.what
from (select dj.LOG_USER, dj.JOB, dj.BROKEN, dj.FAILURES,
dj.LAST_DATE, dj.LAST_SEC, dj.THIS_DATE, dj.THIS_SEC,
dj.NEXT_DATE, dj.NEXT_SEC, dj.INTERVAL, dj.WHAT
from dba_jobs dj) j;

Continue reading