Search
Tag Cloud
10.2 10.2.0.5 11.1 11.2 ADR alertlog ASM bug bundle patch cleanupDeploy database database appliance digest diskgroup enterprise manager gi grid control grid infrastructure GrindInst hashes LinkedIn listener localhost monitoring oak oakcli ODA odachk OEM one-off ORA oracle oracle database appliance password patch bundle PLSQL privileges RAC REDO sha1 solaris troubleshooting usable_file_mb x-windws xtermCategories
-
Recent Posts
Blogroll
Tag Archives: PLSQL
ORA-29283: invalid file operation using UTL_FILE.FREMOVE
I’ve been breaking my head over a problem I had with the UTL_FILE.FREMOVE command trying to remove a file created by another (not oracle) process. On *nix command line, logged in as user oracle (same as database) I’m able to … Continue reading
Posted in Database
Tagged database, FREMOVE, LinkedIn, ORA, oracle, PLSQL, solaris, troubleshooting, UTL_FILE, UTL_FILE.FREMOVE
Leave a comment
ORA-600 [kkpo_rcinfo_defstg:objnotfound] on a 11.2 RAC instance
RECOMMENDATION: Set the deferred_segment_creation parameter to FALSE for 11.2 RAC databases! Recently our monitoring picked up an ORA-600 from the alertlog of one of our 11.2 RAC instances. ORA-00600: internal error code, arguments: [kkpo_rcinfo_defstg:objnotfound],[87421], [], [], [], [], [], [], … Continue reading
Creating database links for another schema
There are situations (like after cloning databases) where you, as a DBA, want to create database links in other schema’s, for which you don’t have the password. Unfortunately the security of Oracle doesn’t allow (even SYS) you to drop/create database … Continue reading
Posted in Database
Tagged database, DBMS_IJOB, DBMS_SYS_SQL, LinkedIn, ORA-01031, oracle, PLSQL, privileges, run_sql_as
4 Comments
Calculating Compression Ratio
Before implementing one or more of the Oracle compression options that are available within an Oracle database, there are a couple of things you would like to examine before implementing one or more of these compression options. One thing you … Continue reading
Posted in Database
Tagged compress, compression, database, dbms_comp_advisor, DIRECT_LOAD, index key compression, LinkedIn, OAC, OLTP, oracle, oracle advanced compression, PLSQL
2 Comments
Unwrapping wrapped PLSQL in 10g, 11g and 12c
There are circumstances where you whish to have a look at the source of an wrapped PL/SQL package, procedure or function. The circumstances I want to have peek at the source is when some PL/SQL code becomes invalidated because an … Continue reading