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: LinkedIn
Oracle Database Appliance – Problem Replacing Shared Disk (2.4)
As with all systems, a disk failure can happen and so we had a failing disk on one of our ODA’s. As mentioned in the ODA documentation, replacing a disk is easy and OAK does everything for you. Actually it … Continue reading
Posted in Database Appliance
Tagged 2.4.0.0.0, ASM, bug, bundle patch, database appliance, grid infrastructure, LinkedIn, oak, ODA, oracle, oracle database appliance, troubleshooting
Leave a comment
Oracle Database Appliance – /opt filling up
Last time we had the /opt filesystem on a couple of ODA nodes filling up. It turned out that the OS Watcher archive directory structure (/opt/oracle/oak/osw/archive) contained lots of old files that should have been cleaned by OSWatcher. When OSWatcher … Continue reading
Posted in Database Appliance
Tagged database appliance, LinkedIn, ODA, oracle, oracle database appliance, OSWatcher, troubleshooting
Leave a comment
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
ORA-19809: limit exceeded for recovery files
In our cloning procedures we use the RMAN “DUPLICATE” command for duplicating databases. This all went fine for a long time until one moment we start getting errors during the duplication process (from the point where media recovery gets started). … Continue reading
Posted in Database
Tagged 11.2, bug, database, LinkedIn, ORA, oracle, RMAN, troubleshooting
Leave a comment
Oracle Database Appliance – /boot filling up
After the installation of the ODA bundle patch 2.4.0.0.0, the /boot filesystem on the ODA nodes was filled up to 84% (16 MB of 99 MB was free) and so Oracle Enterprise Manager started sending warnings about the default 80% … Continue reading
Determine versions of connected Oracle clients
Last week I was trying to find a way to determine the version of the Oracle clients that are connected/connecting to databases from these databases. We cannot connect to each application server to figure out the used version and certainly … Continue reading
Posted in Database
Tagged 11.1, 11.2, client, database, LinkedIn, oracle, troubleshooting
Leave a comment
Cryptographic flaws in Oracle Database authentication protocol
Recently a security researcher (Esteban Martinez Fayo) made the world aware of a problem with the O5LOGON Oracle database authentication protocol (used in 11g – 11.1 & 11.2). This problem, known as CVE-2012-3137, makes it relatively simple for attackers to … Continue reading
Posted in Database, Security
Tagged 11.1, 11.2, 1492721.1, 192, ADR, AES, AUTH_SESSKEY, AUTH_VFR_DATA, brute force, CVE-2012-3137, database, digest, encryption, Esteban Martinez Fayo, flaw, hashes, LinkedIn, O5LOGON, oracle, password, SALT, SHA-1, stealth, TNS
12 Comments
Linking Oracle BBED in 11g
Warning: I use the Oracle Block Browser and Edit tool (bbed) for studying the internal structure of database blocks. Be very careful using the tool, you can destroy blocks using this tool so make sure you know what you are … Continue reading
Posted in Database, Uncategorized
Tagged 11.2, bbed, database, LinkedIn, oracle, troubleshooting
Leave a comment
Grid Infra – ASM 11.2.0.3 bug on Solaris – slice 2 CANDIDATE
We recently ran into a bug (at least that how I look at it) that is introduced with ASM 11.2.0.3. As of this version, ASM shows slice 2 (the complete disk, starting a cylinder 0 thus inlcuding the VTOC) as … Continue reading
Posted in Grid Infrastructure, Uncategorized
Tagged 11.2, 11.2.0.3, 12.2, 14577881, ASM, backport, bug, candidate, disk, diskgroup, fixed, LinkedIn, member, oracle, slice, solaris, troubleshooting
2 Comments