Category Archives: Oracle Database

ORA-27492 Oracle scheduler job doesn’t run

Scheduled a job inside database but it doesn’t run. Try this SQL> exec dbms_scheduler.run_job(‘job1’,false); ORA-27492: unable to run job “<job_name>”: scheduler unavailable Oracle recommended following solution in Doc ID 1190580.1 1- Log in as SYS 2- Startup Database in upgrade … Continue reading

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

Install emcli

I used emctl in monitoring target machine. However, it is less powerful compare to emcli which exists in OMS server by default. Furthermore, it has a bug which prevent creating blackout on pluggable database. So it is time to install … Continue reading

Posted in oem, Oracle Database, Uncategorized | Tagged , , , , | Leave a comment

Remove OEM agent and relevant monitoring targets

Once I decommissioned Oracle databases from specific server. It is time to clean up EM 13c agent and all monitoring targets on top of it. At first, shutdown agent.$ emctl stop agent Now, it is time to remove them.$ emcli … Continue reading

Posted in oem, Oracle Database, Uncategorized | Tagged , , , | Leave a comment

Export Oracle database with Data Pump API DBMS_DATAPUMP

This is the alternative way to unload/load data against Oracle database. It could help in scenario DBA prefer to use SQL script or has to utilize PL/SQL tool. Example of export specified database schemas in parallel. SQL> create or replace … Continue reading

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

Enable DEBUG mode in EM 13c trace file

Important Note: it doesn’t need downtime in OMS. — Receive exiting OMS logging mode $ ./emctl get property -name “log4j.rootCategory” -module logging Oracle Enterprise Manager Cloud Control 13c Release 2 Copyright (c) 1996, 2016 Oracle Corporation. All rights reserved. SYSMAN … Continue reading

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

Copy files from remote to remote through local host

Well, I just realized I have to copy oracle data pump files from Data Center A to Data Center B and they can’t reach each other. But I can reach both of them from my local machine, named C. In … Continue reading

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

Run Python script in Oracle database (2)

Well, Oracle database has another way to run Python script, not need to involve Java this time. External table support external runnable thing (such as OS command, C program, script) with key word preprocessor! actually, it is a better deal … Continue reading

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