A blog from a DBA
SQL> alter system set compatible='12.2.0.1' scope=spfile ; System altered. SQL> startup force nomount ORACLE instance started. Total System Global Area 1073741824 bytes Fixed Size 8801008 bytes Variable Size 671089936 bytes Database Buffers 390070272 bytes Redo Buffers 3780608 bytes SQL> create database cdb1 user sys identified by oracle user system identified by oracle extent management local … Continue reading Creation of CDB 12.2
I am collecting information about REST.. http://crunchify.com/how-to-build-restful-service-with-java-using-jax-rs-and-jersey/ https://github.com/zorkian/nagios-api
I want to write only necessary steps which I have executed on the RAC and show the whole datapatch! I do basically the same as opatchauto, but in a step by step manner. Since January 2017 you can conditially rolling patch a RAC. So what I have done is, patching a 2 Node RAC with … Continue reading Patching a RAC, OJVM is rolling installable!
Hi all, after long time I am finally back with something very interresting. Upgrade to 12c(12.1 /12.2) through RMAN Duplicate using BACKUP LOCATION with NOOPEN clause (Doc ID 2022820.1) If you check this note, you get a pretty simple upgrade scenario. The funny thing is, as described here or in the docs, it simply does … Continue reading 12.2 SE2 Upgrade
There is not much to write about this. It's a purge job for the audit trail 😀 E: it will not work 😅 i have changed it a little 😅 DECLARE lat TIMESTAMP := TO_TIMESTAMP('30-06-17 00:00:00.00','DD-MM-YYYY HH24:MI:SS.FF'); BEGIN dbms_audit_mgmt.init_cleanup(AUDIT_TRAIL_TYPE => dbms_audit_mgmt.audit_trail_aud_std, DEFAULT_CLEANUP_INTERVAL => 1); DBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP(audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD, last_archive_time => lat); DBMS_AUDIT_MGMT.CREATE_PURGE_JOB(AUDIT_TRAIL_TYPE => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD, AUDIT_TRAIL_PURGE_INTERVAL => … Continue reading Purge Job for Auditing
.While reading Oracle 12.2 New Features I discovered that we can create filesystems on tablespaces. So I had to try it and it works, but somehow wrong. Docs used: Database PL/SQL Packages and Types Reference In the Large Objects guide you will not find very much: 😀 Database SecureFiles and Large Objects Developer's Guide I … Continue reading Oracle FS 12.2 New Feature
Yesterday I have installed GI for Standalone, I wanted to install my VBox with AFD, but I got this error. I don't know, it's sad I think. AFD-620: AFD is not supported on this operating system version: 3.10.0-514.10.2.el7.x86_64 So I had to install asmlib and continue with. I don't understand why I had to restart … Continue reading Installing GI for Standalone
