Friday, August 25, 2017

Monday, August 21, 2017

Richard Olrichs: Jarvis Pizzeria: Setting up the Jarvis 1.0 process...

Richard Olrichs: Jarvis Pizzeria: Setting up the Jarvis 1.0 process...: For the Jarvis pizzeria process we have distinguished three phases: payment, preparation and delivery. Hence, the main process is comprised...

Sunday, August 20, 2017

The Arup Nanda Blog: Enough with AFIEDT.BUF

The Arup Nanda Blog: Enough with AFIEDT.BUF: You are in SQL*Plus. You entered a command and urgh, there was a typo. No worries, you bring up the command in an editor by typing: SQL&gt...

Tuesday, April 18, 2017

Brendan Tierney - Oralytics Blog: ODM Model View Details Views in Oracle 12.2

Brendan Tierney - Oralytics Blog: ODM Model View Details Views in Oracle 12.2: A new feature for Oracle Data Mining in Oracle 12.2 is the new Model Details views. In Oracle 11.2.0.3 and up to Oracle 12.1 you needed to...

Friday, April 14, 2017

Database administrator workshop: How to create a pluggable database PDB in a multit...

Database administrator workshop: How to create a pluggable database PDB in a multit...: The new architecture provided by Oracle Database 12c enables an Oracle database to function as a multitenant container database (CDB): it c...

Database administrator workshop: How to create a pluggable database by cloning an e...

Database administrator workshop: How to create a pluggable database by cloning an e...: Using the CREATE PLUGGABLE DATABASE ... FROM command you can clone an existing pluggable database (the source pdb) to create a new pdb (the...

elcarOnOsdnaH: Load SQL Plans into SQL Plan Management (SPM) fro...

elcarOnOsdnaH: Load SQL Plans into SQL Plan Management (SPM) 
fro...
: Load SQL Plans into SQL Plan Management (SPM)  from the  Automatic Workload Repository (AWR)  Managing performance can be tricky thing ...

elcarOnOsdnaH: 12c Pluggable DB Point In Time RecoveryWhile work...

elcarOnOsdnaH: 12c Pluggable DB Point In Time Recovery
While work...
: 12c Pluggable DB Point In Time Recovery While working with pluggable database in our test environment, we came across situation where we...

elcarOnOsdnaH: Change Public/SCAN/Virtual IP/Name in 11g/12c RAC...

elcarOnOsdnaH:
Change Public/SCAN/Virtual IP/Name in 11g/12c RAC...
: Change Public/SCAN/Virtual IP/Name in 11g/12c RAC When working with Real Application Cluster DB, changing the infrastructure properties...

elcarOnOsdnaH: Recovery with Expired Backup Piece with Net Backup...

elcarOnOsdnaH: Recovery with Expired Backup Piece with Net Backup...: Recovery with Expired Backup Piece with Net Backup Recently during one of our recovery of production DB we ran into strange issue. This ...

elcarOnOsdnaH: Partial DB Recovery To ReClaim User ObjectsThere ...

elcarOnOsdnaH: Partial DB Recovery To ReClaim User Objects
There ...
: Partial DB Recovery To ReClaim User Objects There are cases where users drops the objects and later they realize, what they have done. I...

elcarOnOsdnaH: Remote ASM File Copy IssueRecently during one of o...

elcarOnOsdnaH: Remote ASM File Copy IssueRecently during one of o...: Remote ASM File Copy Issue Recently during one of our restore exercise, we need to transfer the backup files from ASM  of Cluster A to AS...

elcarOnOsdnaH: De-Configure & Re-configure GI / Cluster Nodesw...

elcarOnOsdnaH:

De-Configure & Re-configure GI / Cluster Nodes
w...
: De-Configure & Re-configure GI / Cluster Nodes when you are De-configuring the cluster there are various reasons. One of the most ...

Tuesday, April 11, 2017

elcarOnOsdnaH: Change Public/SCAN/Virtual IP/Name in 11g/12c RAC...

elcarOnOsdnaH:
Change Public/SCAN/Virtual IP/Name in 11g/12c RAC...
: Change Public/SCAN/Virtual IP/Name in 11g/12c RAC When working with Real Application Cluster DB, changing the infrastructure properties...

elcarOnOsdnaH: De-Configure & Re-configure GI / Cluster Nodesw...

elcarOnOsdnaH:

De-Configure & Re-configure GI / Cluster Nodes
w...
: De-Configure & Re-configure GI / Cluster Nodes when you are De-configuring the cluster there are various reasons. One of the most ...

elcarOnOsdnaH: Remote ASM File Copy IssueRecently during one of o...

elcarOnOsdnaH: Remote ASM File Copy IssueRecently during one of o...: Remote ASM File Copy Issue Recently during one of our restore exercise, we need to transfer the backup files from ASM  of Cluster A to AS...

Thursday, April 6, 2017

Steven Feuerstein on Oracle PL/SQL: Does level 3 optimization change PL/Scope data? No...

Steven Feuerstein on Oracle PL/SQL: Does level 3 optimization change PL/Scope data? No...: I gave a webinar on April 6, 2017 for the Taste of Kscope17 series for ODTUG (odtug.com) on Change Impact Analysis with PL/Scope. Here are t...

Monday, April 3, 2017

The Arup Nanda Blog: Can I Fit a 80MB Database Completely in a 80MB Buf...

The Arup Nanda Blog: Can I Fit a 80MB Database Completely in a 80MB Buf...: This is in the Series " 100 Things You Probably Didn't Know About Oracle ". If you haven't already, I urge you to read the...

The Arup Nanda Blog: Python for PL/SQL Developers Series

The Arup Nanda Blog: Python for PL/SQL Developers Series: How hard it is to learn a new language? It depends on the learner, of course; but everyone will agree that it is easier to get your feet wet...

elcarOnOsdnaH: PSU bundle patch 5 Database Patch Set Update : 12....

elcarOnOsdnaH: PSU bundle patch 5 Database Patch Set Update : 12....: PSU bundle patch 5 Database Patch Set Update : 12.1.0.2.x : Installed in the CDB but not in the PDB  OR  validate_con_names: PDB$SEED ...

elcarOnOsdnaH: Convert Single Instance DB to RAC Why do we nee...

elcarOnOsdnaH:

Convert Single Instance DB to RAC
 Why do we nee...
: Convert Single Instance DB to RAC   Why do we need this? There are requests from Apps team to load humongous amount of data...

alt.oracle: Move That Datafile!

alt.oracle: Move That Datafile!: Moving datafiles has always been a pain.  There are several steps, it’s fairly easy to make a mistake and it requires the datafile to be of...

alt.oracle: Tightening Security with SELECT ANY DICTIONARY in ...

alt.oracle: Tightening Security with SELECT ANY DICTIONARY in ...: Developers and users sometimes request the SELECT ANY DICTIONARY system privilege to enable them to view various data dictionary tables.  T...

alt.oracle: Data Pump 12c – Pumping Data with the LOGTIME Para...

alt.oracle: Data Pump 12c – Pumping Data with the LOGTIME Para...: Since its release, Oracle Data Pump has been a worthy successor to the traditional exp/imp tools.  However, one area lacking with Data Pump...

Sunday, April 2, 2017

Steven Feuerstein on Oracle PL/SQL: Wikileaks bombshell: PL/SQL source of all other mo...

Steven Feuerstein on Oracle PL/SQL: Wikileaks bombshell: PL/SQL source of all other mo...: Copyright @2017 CodeNewsWire "News coders can use", dateline 1 April 2017 Wikileaks dumped its latest batch of revelations on th...

Thursday, March 30, 2017

The Arup Nanda Blog: Restoring Controlfile When AUTOBACKUP Fail

The Arup Nanda Blog: Restoring Controlfile When AUTOBACKUP Fail: Allow me to present the snapshot of a day from the life of John--the DBA at Acme Bank. On this particular day a database John manages crashe...

Oracle Database 12c: RMAN Restore and Recover for Multitenant Architect...

Oracle Database 12c: RMAN Restore and Recover for Multitenant Architect...: In this demo I will show how to handle different types of RMAN restore and recover in a Multitenant environment. In a Multitenant envir...

Oracle Database 12c: RMAN Restore and Recover for Multitenant Architect...

Oracle Database 12c: RMAN Restore and Recover for Multitenant Architect...: In this demo I will show how to handle different types of RMAN restore and recover in a Multitenant environment. In a Multitenant envir...

Database administrator workshop: How to encrypt the data (tablespace or column's ta...

Database administrator workshop: How to encrypt the data (tablespace or column's ta...: To create a standard Oracle wallet and then add a master key to it you have to follow few basic steps: 1) Configure the sqlnet.ora file to ...

Database administrator workshop: How to configure Transparent Data Encryption using...

Database administrator workshop: How to configure Transparent Data Encryption using...: Oracle uses an operating system file to contains authentication and signing credentials: this file, named ewallet.p12, is the so called Orac...

Database administrator workshop: Steps to create, open and close an Oracle Wallet u...

Database administrator workshop: Steps to create, open and close an Oracle Wallet u...: It's possible to create the Oracle Wallet using the owm gui utility or from sqlplus with a new set of key management statements (ADMI...

Database administrator workshop: Steps to create, open and close an Oracle Wallet u...

Database administrator workshop: Steps to create, open and close an Oracle Wallet u...: It's possible to create the Oracle Wallet using the owm gui utility or from sqlplus with a new set of key management statements (ADMI...

Database administrator workshop: Software only installation of Oracle Database 12c ...

Database administrator workshop: Software only installation of Oracle Database 12c ...: In this post I'm going to install only the software of the Oracle Database 12c release 1. Download from Oracle website and extract it ...

Database administrator workshop: Installing Oracle Database 12c as Container Databa...

Database administrator workshop: Installing Oracle Database 12c as Container Databa...: Here is a video recorded during the creation of the first database. Go on if you want to see all the screenshots. So we have already ins...

Database administrator workshop: How to create a pluggable database by unplugging a...

Database administrator workshop: How to create a pluggable database by unplugging a...: So I want to create a new pluggable database into the CDBTEST container located into vsi08devpom machine (@vsi08devpom in this post) and I w...

Database administrator workshop: How to unplug a PDB and plug it back into the same...

Database administrator workshop: How to unplug a PDB and plug it back into the same...: You have just unplugged a PDB and want to know how to eventually plug it back into the same container. Let's assume I have a pluggable ...

Database administrator workshop: How to create a PDB from a Non-CDB using DBMS_PDB ...

Database administrator workshop: How to create a PDB from a Non-CDB using DBMS_PDB ...: To test this scenario I have recently created using DBCA a non container database named ORCL. CDB001 and CDBTEST are instead two container d...

Database administrator workshop: How to create a PDB from a Non-CDB (12c) using Ora...

Database administrator workshop: How to create a PDB from a Non-CDB (12c) using Ora...: Beside the DBMS_PDB package you can use Oracle Data Pump to create a pluggable database from a non-container database: it consists to expo...

Database administrator workshop: Differences in default RMAN configuration settings...

Database administrator workshop: Differences in default RMAN configuration settings...: I wanted to write a post on configuring the RMAN environment using the SHOW and CONFIGURE commands in Oracle Database 12c, but after few c...

Database administrator workshop: How to recover a table in a pluggable database fro...

Database administrator workshop: How to recover a table in a pluggable database fro...: I'm going to test some useful recovery scenarios for the Oracle Database 12c release. An interesting option introduced with this releas...

Database administrator workshop: How to recover a table in a pluggable database fro...

Database administrator workshop: How to recover a table in a pluggable database fro...: I'm going to test some useful recovery scenarios for the Oracle Database 12c release. An interesting option introduced with this releas...

Database administrator workshop: How to identify which pdbs a backup set belong to

Database administrator workshop: How to identify which pdbs a backup set belong to: I want to see what useful information are returned by few RMAN commands such as report schema or list backup when using the default RMAN c...

Database administrator workshop: RMAN and SQL statement enhancements in Oracle Data...

Database administrator workshop: RMAN and SQL statement enhancements in Oracle Data...: One of the most useful enhancement Oracle has introduced within the release 12c in RMAN is the possibility to execute more SQL statements. ...

Database administrator workshop: How to rename everything on Oracle Database (redol...

Database administrator workshop: How to rename everything on Oracle Database (redol...: Few days ago I was wondering how many RENAME clauses are available on Oracle Database. I have summarized them here: Renaming redolog membe...

Database administrator workshop: How to use the new SYSBACKUP privilege to perform ...

Database administrator workshop: How to use the new SYSBACKUP privilege to perform ...: The SYSBACKUP is a new privilege introduced in the Oracle Database 12c release that allows a user to perform any backup or recovery operatio...

Wednesday, March 29, 2017

Brendan Tierney - Oralytics Blog: Something new in 12c: FETCH FIRST x ROWS

Brendan Tierney - Oralytics Blog: Something new in 12c: FETCH FIRST x ROWS: In this post I want to show some example of using a new feature in 12c for selecting the first X number of records from the results set of a...

MP Oracle Blog: Adaptive Plans in 12c

MP Oracle Blog: Adaptive Plans in 12c: Gestern habe ich im OTN Forum ein paar Fragen zum grundsätzlichen Verhalten der in 12c eingeführten Adaptive Plans gestellt, aber inzwisc...

elcarOnOsdnaH: 12c Pluggable DB Point In Time RecoveryWhile work...

elcarOnOsdnaH: 12c Pluggable DB Point In Time Recovery
While work...
: 12c Pluggable DB Point In Time Recovery While working with pluggable database in our test environment, we came across situation where we...

Database administrator workshop: How to create a pluggable database by unplugging a...

Database administrator workshop: How to create a pluggable database by unplugging a...: So I want to create a new pluggable database into the CDBTEST container located into vsi08devpom machine (@vsi08devpom in this post) and I w...

Database administrator workshop: How to unplug a PDB and plug it back into the same...

Database administrator workshop: How to unplug a PDB and plug it back into the same...: You have just unplugged a PDB and want to know how to eventually plug it back into the same container. Let's assume I have a pluggable ...

Database administrator workshop: Oracle 11gR2 RAC installation: install and configu...

Database administrator workshop: Oracle 11gR2 RAC installation: install and configu...: T his post will describe how to install and configure OCFS2, the Oracle Cluster File System, a shared disk file system developed by Oracle C...

Database administrator workshop: How to delete an Oracle VM virtual machine

Database administrator workshop: How to delete an Oracle VM virtual machine: Its' so easy to delete a Oracle virtual machine. Just expand your Server Pools and select your virtual machine you don't need anymo...

Database administrator workshop: Oracle 11gR2 RAC installation: kernel, ssh user eq...

Database administrator workshop: Oracle 11gR2 RAC installation: kernel, ssh user eq...: T his post will describe how to configure SSH user equivalency, set some kernel parameters, the network, sync the time between the two nodes...

Database administrator workshop: How to create a pluggable database by unplugging a...

Database administrator workshop: How to create a pluggable database by unplugging a...: So I want to create a new pluggable database into the CDBTEST container located into vsi08devpom machine (@vsi08devpom in this post) and I w...

alt.oracle: Data Pump 12c – Pumping Data with the LOGTIME Para...

alt.oracle: Data Pump 12c – Pumping Data with the LOGTIME Para...: Since its release, Oracle Data Pump has been a worthy successor to the traditional exp/imp tools.  However, one area lacking with Data Pump...

Monday, March 27, 2017

Database administrator workshop: How to create a pluggable database by unplugging a...

Database administrator workshop: How to create a pluggable database by unplugging a...: So I want to create a new pluggable database into the CDBTEST container located into vsi08devpom machine (@vsi08devpom in this post) and I w...

Database administrator workshop: How to unplug a PDB and plug it back into the same...

Database administrator workshop: How to unplug a PDB and plug it back into the same...: You have just unplugged a PDB and want to know how to eventually plug it back into the same container. Let's assume I have a pluggable ...

Sunday, March 26, 2017

The Infra Diary: How to grow aka extend ZFS datasets and Volumes?

The Infra Diary: How to grow aka extend ZFS datasets and Volumes?: ZFS Chapters: 1). How to Manage and Maintain ZFS file systems? 2). How to create ZFS file system and Volumes ? 3). How to set ZFS...

Wednesday, March 15, 2017

Osama Mustafa Oracle Blog: Configure Putty to connect to the cloud

Osama Mustafa Oracle Blog: Configure Putty to connect to the cloud: After posting different blog about Cloud and how to use the console what about the putty ? How to use it :- Download and install PuTT...

Brendan Tierney - Oralytics Blog: Presentations from OUGN17

Brendan Tierney - Oralytics Blog: Presentations from OUGN17: Here are the presentations I gave at OUG Norway last week. These are also available on SlideShare SQL: The one language to rule all yo...

Tuesday, March 14, 2017

Joords Oracle DBA blog: Oracle Database 12c (Multitentant) Archiecture Ove...

Joords Oracle DBA blog: Oracle Database 12c (Multitentant) Archiecture Ove...: Oracle Learning Library : Oracle Database 12c Architecture Overview This video explains some of the Oracle Database 12c architecture chang...

Thursday, March 9, 2017

Barry McGillin: Add a new hard drive to your Oracle Developer Days...

Barry McGillin: Add a new hard drive to your Oracle Developer Days...: For those of you who end up using the Oracle Developers Day VM for more that just demo's but playing with other things too, will find t...

Hemant's Oracle DBA Blog: 12cR1 RAC Posts -- 8a : Setting up SingleInsta...

Hemant's Oracle DBA Blog: 12cR1 RAC Posts -- 8a : Setting up SingleInsta...: This is the first of a small series of subposts on setting up SingleInstance DataGuard Standby for my 12cR1 RAC environment. Primary Data...

Wednesday, March 8, 2017

Barry McGillin: Add a new hard drive to your Oracle Developer Days...

Barry McGillin: Add a new hard drive to your Oracle Developer Days...: For those of you who end up using the Oracle Developers Day VM for more that just demo's but playing with other things too, will find t...

Joords Oracle DBA blog: Oracle Database 12c (Multitentant) Archiecture Ove...

Joords Oracle DBA blog: Oracle Database 12c (Multitentant) Archiecture Ove...: Oracle Learning Library : Oracle Database 12c Architecture Overview This video explains some of the Oracle Database 12c architecture chang...

Monday, March 6, 2017

Hemant's Oracle DBA Blog: 12cR1 RAC Posts -- 7 : OCR Commands

Hemant's Oracle DBA Blog: 12cR1 RAC Posts -- 7 : OCR Commands: [Yes, I know that 12.2 is now available for download but it will be some time before I have a running 12.2 RAC environment] Some OCR / OL...

Brendan Tierney - Oralytics Blog: Blog posts on Oracle Advanced Analytics features i...

Brendan Tierney - Oralytics Blog: Blog posts on Oracle Advanced Analytics features i...: A couple of days ago Oracle finally provided us with an on-premises download for Oracle 12.2 Database. Go and download load it from here ...

Friday, March 3, 2017

Glenn Schwartzberg's Essbase Blog: Three Little Words

Glenn Schwartzberg's Essbase Blog: Three Little Words: Others and I answer a lot of questions on the Oracle Technical Network and other forums and there is a ubiquitous little phrase that sen...

Brendan Tierney - Oralytics Blog: Blog posts on Oracle Advanced Analytics features i...

Brendan Tierney - Oralytics Blog: Blog posts on Oracle Advanced Analytics features i...: A couple of days ago Oracle finally provided us with an on-premises download for Oracle 12.2 Database. Go and download load it from here ...

Thursday, March 2, 2017

Grassroots Oracle: Apex Listener Issues

Grassroots Oracle: Apex Listener Issues: The configuration for my Apex 4.0 environment on my laptop is basically as you see on the front page for the Apex Listener . I have Goo...

Tuesday, February 21, 2017

Hemant's Oracle DBA Blog: 12cR1 RAC Posts -- 6 :Running the Cluster Verif...

Hemant's Oracle DBA Blog: 12cR1 RAC Posts -- 6 :Running the Cluster Verif...: With a successful RAC Cluster, running the Cluster Verification Utility [oracle@collabn1 ~]$ cluvfy stage -post crsinst -n collabn1,colla...

Friday, February 10, 2017

Javier's PeopleSoft blog: Installing Update Images in Amazon Web Services

Javier's PeopleSoft blog: Installing Update Images in Amazon Web Services: The last PeopleSoft Update Manager (PUM) images have been delivered in two formats: the traditional VirtualBox image and a newly introduce...

Saturday, February 4, 2017

Exploits in Hyperion: Installing Classic Hyperion Financial Management i...

Exploits in Hyperion: Installing Classic Hyperion Financial Management i...: Well, this one is a long pending item for me. I have been wanting to do this for quite some time, but I could never get around to doin...

Exploits in Hyperion: Hyperion Essbase – Creating a data source on a Lin...

Exploits in Hyperion: Hyperion Essbase – Creating a data source on a Lin...: In this blog, I will be talking about how to create a data source for a relational system on a Linux machine and using this data source for...

Exploits in Hyperion: Essbase Log File parser – Shell script

Exploits in Hyperion: Essbase Log File parser – Shell script: In this blog, I will be publishing the Essbase log file parser shell script that I have created. I had designed a JAR file for the same. Bu...

Exploits in Hyperion: DATAEXPORT – Using environment variables for setti...

Exploits in Hyperion: DATAEXPORT – Using environment variables for setti...: In this blog, I would be talking about using environment variables for setting substitution variables and automating your data exports. Wel...

Exploits in Hyperion: DATAEXPORT – Using environment variables for setti...

Exploits in Hyperion: DATAEXPORT – Using environment variables for setti...: In this blog, I would be talking about using environment variables for setting substitution variables and automating your data exports. Wel...

Exploits in Hyperion: Installing Classic Hyperion Financial Management i...

Exploits in Hyperion: Installing Classic Hyperion Financial Management i...: Well, this one is a long pending item for me. I have been wanting to do this for quite some time, but I could never get around to doin...

Exploits in Hyperion: Hyperion Essbase – Creating a data source on a Lin...

Exploits in Hyperion: Hyperion Essbase – Creating a data source on a Lin...: In this blog, I will be talking about how to create a data source for a relational system on a Linux machine and using this data source for...

Exploits in Hyperion: Hyperion Shared Services – Understanding the roles...

Exploits in Hyperion: Hyperion Shared Services – Understanding the roles...: In this blog, I am going to be talking about the roles available for a business user in Hyperion Shared Services. This tries to cover all t...

Exploits in Hyperion: Hyperion Shared Services – Understanding the roles...

Exploits in Hyperion: Hyperion Shared Services – Understanding the roles...: In this blog, I am going to be talking about the roles available for a business user in Hyperion Shared Services. This tries to cover all t...

Exploits in Hyperion: Hyperion Shared Services – Understanding the roles...

Exploits in Hyperion: Hyperion Shared Services – Understanding the roles...: In this blog, I am going to be talking about the roles available for a business user in Hyperion Shared Services. This tries to cover all t...

Exploits in Hyperion: Hyperion Shared Services – Understanding the roles...

Exploits in Hyperion: Hyperion Shared Services – Understanding the roles...: In this blog, I am going to be talking about the roles available for a business user in Hyperion Shared Services. This tries to cover all t...

Exploits in Hyperion: Hyperion Shared Services – Understanding the roles...

Exploits in Hyperion: Hyperion Shared Services – Understanding the roles...: In this blog, I am going to be talking about the roles available for a business user in Hyperion Shared Services. This tries to cover all t...

Exploits in Hyperion: Hyperion Shared Services – Understanding the roles...

Exploits in Hyperion: Hyperion Shared Services – Understanding the roles...: In this blog, I am going to be talking about the roles available for a business user in Hyperion Shared Services. This tries to cover all t...

Adashek EPM: A Holiday Season Patch! HFR Web Studio 704

Adashek EPM: A Holiday Season Patch! HFR Web Studio 704: Oracle is so nice and giving for this holiday season and heading into the New Year! Patches! Patches! Patch Set Update for Oracle Hyper...

Only Hyperion - Oracle Hyperion EPM blog: Loading data into PBCS ASO using Smart-view HsSetV...

Only Hyperion - Oracle Hyperion EPM blog: Loading data into PBCS ASO using Smart-view HsSetV...: Let me cover a simple one this time, how to load data to a ASO cube using smart view in PBCS using HsSetValue & HsGetValue Just ma...

Exploits in Hyperion: Installing Classic Hyperion Financial Management i...

Exploits in Hyperion: Installing Classic Hyperion Financial Management i...: Well, this one is a long pending item for me. I have been wanting to do this for quite some time, but I could never get around to doin...

Monday, January 30, 2017

Hemant's Oracle DBA Blog: 12cR1 RAC Posts -- 5 : Relocating OCR and Vote...

Hemant's Oracle DBA Blog: 12cR1 RAC Posts -- 5 : Relocating OCR and Vote...: Most default installation guides for Grid Infrastructure will have you creating a DATA Disk Group during the install.  This results in the ...

Saturday, January 28, 2017

MacNix: Set Password policy for specific users or groups i...

MacNix: Set Password policy for specific users or groups i...: Working in a SEN (Special Educational Needs) School with a single user directory has its issues... Some of our pupils need very simple log...

MacNix: How to create a bootable Mac OS 10.11 El Capitan I...

MacNix: How to create a bootable Mac OS 10.11 El Capitan I...: This guide will quickly show you how to make a Mac OS 10.11 El Capitan bootable USB installer it will work with the Gold Master candidat...

Friday, January 27, 2017

Sasank's PeopleSoft Log: Using PSSpreadsheet Class in App Engine

Sasank's PeopleSoft Log: Using PSSpreadsheet Class in App Engine: Jim Marion brought the PSSpreadsheet class to our notice during Oracle OpenWorld conference last year. If you want a copy of his slide deck...

MacNix: How to reset Software Update Server on Mac OS 10.1...

MacNix: How to reset Software Update Server on Mac OS 10.1...: This article briefly details how to reset a misbehaving Software Update Server on Mac OS 10.10 Yosemite or 10.11 El Capitan.  It was tested ...

MacNix: How to create a bootable Mac OS 10.11 El Capitan I...

MacNix: How to create a bootable Mac OS 10.11 El Capitan I...: This guide will quickly show you how to make a Mac OS 10.11 El Capitan bootable USB installer it will work with the Gold Master candidat...

MacNix: How to cut down and sand your SIM or Micro SIM to ...

MacNix: How to cut down and sand your SIM or Micro SIM to ...: This is the method I have been working on to cut down a mini or micro sim to a nano sim size, together with pitfalls I found along the way....

Sunday, January 22, 2017

Hemant's Oracle DBA Blog: 12cR1 RAC Posts -- 4 : Adding a Disk of a diff...

Hemant's Oracle DBA Blog: 12cR1 RAC Posts -- 4 : Adding a Disk of a diff...: How does 12.1.0.2 ASM handle adding a disk of a different size to an existing DiskGroup ? I currently have 4 disks of 5GB each in 2 DiskG...

Tuesday, January 17, 2017

Hemant's Oracle DBA Blog: Copying a Tablespace from NonCDB to a PDB (using ...

Hemant's Oracle DBA Blog: Copying a Tablespace from NonCDB to a PDB (using ...: A Tablespace can be "transported"  from a NonCDB to a PDB as a way of copying the Tablespace.  Here I work with ASM as well . F...

Cameron's Blog For Essbase Hackers: The Compleat Idiot's Guide to PBCS, No. 19 -- Dele...

Cameron's Blog For Essbase Hackers: The Compleat Idiot's Guide to PBCS, No. 19 -- Dele...: Introduction I have, somehow yet again convinced others to write my blog for me.  I must be getting good at this, or others must be losin...

Monday, January 16, 2017

Oracle related stuff: Oracle Parallel Execution Deep Dive Session

Oracle related stuff: Oracle Parallel Execution Deep Dive Session: Here is a recording of a session I did a while ago, covering how to understand the essentials of Oracle Parallel Execution and how to read t...

Sunday, January 15, 2017

External Table: Diagnose High-Latency I/O Operations Using SystemT...

External Table: Diagnose High-Latency I/O Operations Using SystemT...: Topic: this post is about some simple tools and techniques that can be used to drill down high-latency I/O events using SystemTap probes. ...

External Table: Event Histogram Metric and Oracle 12c

External Table: Event Histogram Metric and Oracle 12c: Topic:  event histogram metric, a script and some related discussions on collecting and displaying wait event latency histograms for Oracle ...

Monday, January 9, 2017

Hyperion Error of the Day: A Look Inside EPMVirt: Automation Scripts - Oracle...

Hyperion Error of the Day: A Look Inside EPMVirt: Automation Scripts - Oracle...: Continuing on with the EPMVirt deep dive I will now discuss the automated installation and configuration of the Oracle Database for EPM. T...

Hemant's Oracle DBA Blog: V$RMAN_BACKUP_JOB_DETAILS, a caveat

Hemant's Oracle DBA Blog: V$RMAN_BACKUP_JOB_DETAILS, a caveat: Building on a previous blog post (you could read it before or after this post), here's a quick demo of a caveat or quirk with V$RMAN_B...

Hyperion Error of the Day: A Look Inside EPMVirt: Automation Scripts - EPM In...

Hyperion Error of the Day: A Look Inside EPMVirt: Automation Scripts - EPM In...: Finally, this post will get into the EPMVirt automation for EPM. The installation is performed using a simple response file: /uo/automat...

Osama Mustafa Oracle Blog: Oracle Data Integrator repository is not accessibl...

Osama Mustafa Oracle Blog: Oracle Data Integrator repository is not accessibl...: When trying to access to the http://hostname:9704/biacm the following warning appeared on the Dashboard :- Oracle Data Integrator repos...

Hemant's Oracle DBA Blog: V$RMAN_BACKUP_JOB_DETAILS, a caveat

Hemant's Oracle DBA Blog: V$RMAN_BACKUP_JOB_DETAILS, a caveat: Building on a previous blog post (you could read it before or after this post), here's a quick demo of a caveat or quirk with V$RMAN_B...

Thursday, January 5, 2017

Hyperion Error of the Day: A Look Inside EPMVirt: Automation Scripts - Oracle...

Hyperion Error of the Day: A Look Inside EPMVirt: Automation Scripts - Oracle...: Continuing on with the EPMVirt deep dive I will now discuss the automated installation and configuration of the Oracle Database for EPM. T...

Hyperion Error of the Day: A Look Inside EPMVirt: Automation Scripts - Oracle...

Hyperion Error of the Day: A Look Inside EPMVirt: Automation Scripts - Oracle...: Continuing on with the EPMVirt deep dive I will now discuss the automated installation and configuration of the Oracle Database for EPM. T...

External Table: Listener.ora and Oraagent in RAC 11gR2

External Table: Listener.ora and Oraagent in RAC 11gR2: Topic: An investigation of a few details of the implementation of listeners in 11gR2, including the configuration of listener.ora in RAC an...

Wednesday, January 4, 2017

Brendan Tierney - Oralytics Blog: Explicit Semantic Analysis in Oracle 12.2c Databas...

Brendan Tierney - Oralytics Blog: Explicit Semantic Analysis in Oracle 12.2c Databas...: A new Oracle Data Mining algorithm in the Oracle 12.2c Database is called Explicit Semantic Analysis. [ The following examples are built u...

Brendan Tierney - Oralytics Blog: Explicit Semantic Analysis in Oracle 12.2c Databas...

Brendan Tierney - Oralytics Blog: Explicit Semantic Analysis in Oracle 12.2c Databas...: A new Oracle Data Mining algorithm in the Oracle 12.2c Database is called Explicit Semantic Analysis. [ The following examples are built u...

Monday, January 2, 2017

berxblog: interconnect fragmentation kills the cluster

berxblog: interconnect fragmentation kills the cluster: On a particular Oracle 2 node cluster (12.1) we faced random instances failing. Servicerequests at Oracle were open with limited result, as ...

Hyperion Error of the Day: A Look Inside EPMVirt: OS Install

Hyperion Error of the Day: A Look Inside EPMVirt: OS Install: I will be doing a multi part series of articles on the details of how EPMVirt works. This deep dive can help strengthen your automation skil...

Hyperion Error of the Day: A Look Inside EPMVirt: Automation Scripts - buildE...

Hyperion Error of the Day: A Look Inside EPMVirt: Automation Scripts - buildE...: Finally, in this installment, we will look at the automation scripts. They control the actual installation and configuration of the Oracle E...

Hyperion Error of the Day: A Look Inside EPMVirt: The EPMVirt RPM Package

Hyperion Error of the Day: A Look Inside EPMVirt: The EPMVirt RPM Package: The EPMVirt RPM is what deploys all the custom automation scripts and OS configurations needed to perform the EPM installation. An RPM c...

Hemant's Oracle DBA Blog: 12cR1 RAC Posts -- 2 : Convert AdminManaged DB...

Hemant's Oracle DBA Blog: 12cR1 RAC Posts -- 2 : Convert AdminManaged DB...: I have an AdminManaged Database in my (2node) RAC Cluster. How do I convert it to PolicyManaged ? (Yes, let me admit :  It makes no sen...

Tim Tow's Hyperion Blog: Essbase Cloud Service Webcast Available Online

Tim Tow's Hyperion Blog: Essbase Cloud Service Webcast Available Online: Essbase Cloud Service is coming soon and, if you haven't had a chance to learn about it, here is how you can learn about it at your leis...

Joords Oracle DBA blog: Database-As-A-Service with Copy on Write

Joords Oracle DBA blog: Database-As-A-Service with Copy on Write: Database Cloning; Done in minutes and with minimal storage usage  

Hyperion Error of the Day: A Look Inside EPMVirt: The EPMVirt RPM Package

Hyperion Error of the Day: A Look Inside EPMVirt: The EPMVirt RPM Package: The EPMVirt RPM is what deploys all the custom automation scripts and OS configurations needed to perform the EPM installation. An RPM c...

Hyperion Error of the Day: A Look Inside EPMVirt: Automation Scripts - buildE...

Hyperion Error of the Day: A Look Inside EPMVirt: Automation Scripts - buildE...: Finally, in this installment, we will look at the automation scripts. They control the actual installation and configuration of the Oracle E...