Category Archives: Oracle

Configuration for BI Publisher Server Level Log

Posted on February 26, 2013 by SoCRaT

Here are the steps to change your BI Publisher Enterprise Server to be in a debug mode: Login to BIP as Administrator Select Admin -> System Maintenance -> Server Configuration Change Debug Level to ‘Debug’ under General Properties Click on … Continue reading →

Posted in Oracle | Tagged , , , , , , , | Leave a comment

How to manually modify DB initialization parameters by creating pfile from spfile

Posted on January 19, 2013 by SoCRaT

pfile is the initialization parameters of DB in plain text, while spfile is the binary one, so to be able to change it, you have to: Extract the pfile from the spfile: “create pfile=’my_path/file_name.ora‘ from spfile;” Shutdown the DB: “shutdown … Continue reading →

Posted in Oracle | Tagged , , , , , , | Leave a comment

Managing the Oracle DB 11g Scheduler Windows (DBMS_SCHEDULER)

Posted on November 25, 2012 by SoCRaT

To display existing scheduler windows, you should query the “dba_scheduler_windows” table: e.g. SELECT WINDOW_NAME,REPEAT_INTERVAL,DURATION,ENABLED FROM dba_scheduler_windows In my case, I needed to disable a window, so that it doesn’t run any scheduled jobs, so I had to run the following: … Continue reading →

Posted in Oracle | Tagged , , , , , , | Leave a comment

Get List of ASM Disks in an 11gR2 Database

Posted on October 23, 2012 by SoCRaT

select * from v$asm_disk

Posted in Oracle | Tagged , , , | Leave a comment