Installing SQLcl
SQLcl is the new command line tool from Oracle, more specifically from the SQL Developer team. It is currently an Early Adopter (EA) release and you can download it from: http://www.oracle.com/technet Source: Installing SQLcl
List all running jobs
SET PAUSE ON SET PAUSE ‘Press Return to Continue’ SET PAGESIZE 60 SET LINESIZE 300 SET VERIFY OFF SELECT a.job “Job”, a.sid, a.failures “Failures”, Substr(To_Char(a.last_date,’DD-Mon-YYYY HH24:MI:SS’),1,20) “Last Date”, Substr(To_Char(a.this_date,’DD-Mon-YYYY HH24:MI:SS’),1,20) “This Date” FROM dba_jobs_running a /
ORA-01450 maximum key length (3118) exceeded
All of a sudden, deploying a new version of the apps, I got this error. The fix is simple. The error is related to the block size of the tablespace where you want to deploy your object. In my case it was about the creation of an index an the key was exceeding the size…
12cR1 not being able to connect “as / sysdba” locally
This came as a surprise when I came back from vacation to discover that all of a sudden can’t do this on my Linux box sqlplus / as sysdba. I was getting ORA-01017. Something like this: [oracle@dbtest dbs]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Wed Aug 3 09:59:29 2016 Copyright (c) 1982,…
ORA-20000: ORU-10027: buffer overflow
Recently I got this error when I tried to execute a script with lots of dbms_output lines in it and the solution was to alter the script and to add the following: SET LINESIZE 999 SET PAGES 500 SET TIMING ON SET SERVEROUTPUT ON size UNLIMITED ……………………. BEGIN begin dbms_output.enable(NULL); end; ……………………….. END; /
How to create manualy the AWR reports
Not everyone has a GUI to extract the AWR reports from an Oracle database, hence here is what you need to do: SCOTT@DB_TEST> @$ORACLE_HOME/rdbms/admin/awrrpt.sql Current Instance ~~~~~~~~~~~~~~~~ DB Id DB Name Inst Num Instance ———– ———— ——– ———— 3621956494 DB_TEST 1 DB_TEST Elapsed: 00:00:00.03 Elapsed: 00:00:00.01 Specify the Report Type ~~~~~~~~~~~~~~~~~~~~~~~ Would you like…
Login as sysdba for ORA-00020: maximum number of processes 0 exceeded
sqlplus -prelim “/as sysdba”
