Categories
Database vs. Instance Oracle Certification and Database The Value of Saving Time

Oracle Inventory Directory- Installing the Oracle Binaries

The Oracle inventory directory stores the inventory of Oracle software installed on the server. This directory is required and is shared among all installations of the Oracle software on a server. When you first install Oracle, the installer checks to see whether there is an existing OFA directory structure in the format /u[01-09]/app. If suchRead More

Categories
Installing in the Cloud Oracle Certification and Database Oracle Network Files Directory

Understanding the OFA- Installing the Oracle Binaries

There are several prerequisites for the server, users, groups, and parameters that need to be set up for the installation, and a big decision that needs to be made is where the data is going to be persisted. The disks can be configured with file systems or with raw disks and with Automatic Storage ManagementRead More

Categories
Installing in the Cloud Oracle Certification and Database Stopping the Database

The Value of Saving Time- A Little Bit of Everything

What I never stated but I hope is understood is that reducing the time for SAVSECDTA to run also reduces the time it will take should you ever have to restore your system. It should go without saying that you don’t want to have to waste your time restoring unneeded profiles, authorization lists, or authoritiesRead More

Categories
Installing in the Cloud Oracle Certification and Database The Value of Saving Time

Reducing the Time of Your SAVSECDTA- A Little Bit of Everything-2

Profiles contain attributes such as initial program, initial menu, output queue, etc., but the *USRPRF object also contains other information. Specifically, *USRPRF objects contain an entry for every object the profile owns, an entry for every private authority granted to it, an entry for every private authority granted to one of its owned objects, andRead More

Categories
Oracle Certification and Database Oracle Network Files Directory Stopping the Database

Reducing the Time of Your SAVSECDTA- A Little Bit of Everything-1

Saving your IBM i security data is a critical part of being able to recover your system, but when it starts to take too long, you may be tempted to stop this process. Don’t do it! It’s likely that it’s an accumulation of private authorities that’s causing the issue. Let me explain. What’s Saved WhenRead More

Categories
Oracle Certification and Database Oracle Network Files Directory Stopping the Database

Table Functions That Help Keep Your System Current- A Little Bit of Everything-2

Other menu options run either the Print Public Authority (PRTPUBAUT) or Print Private Authority (PRTPVTAUT) command with a specific object type already defaulted. For example, if you want the list of libraries whose *PUBLIC authority is not *EXCLUDE, take option 36. Or, for both the *PUBLIC and private authorities to directories, run option 28, DirectoryRead More

Categories
Oracle Certification and Database Oracle Network Files Directory The Value of Saving Time

Table Functions That Help Keep Your System Current- A Little Bit of Everything-1

One of my absolute favorite table functions that I want to make sure you’re aware of is SYSTOOLS.GROUP_PTF_CURRENCY. When run, it does a “phone home” to IBM to get the latest group PTFs and then performs a comparison to determine whether the system you’re running the table function on has the current group PTFs installedRead More

Categories
Database vs. Instance Installing in the Cloud Oracle Certification and Database Oracle Network Files Directory Stopping the Database The Value of Saving Time

Using Administration Runtime Expert (ARE)- Automating Your Analysis-2

Once you’ve built the template, go back to the Deployment Template Editor and click on Launch console. See Figure 13.4. From here you can select the template, specify the systems you want to verify, schedule the verification to run at a specific time (ARE has its own job scheduler), use the Runtime properties to specifyRead More

Categories
Installing in the Cloud Oracle Certification and Database Oracle Network Files Directory The Value of Saving Time

Using Administration Runtime Expert (ARE)- Automating Your Analysis-1

My final example for this chapter is truly one of those hidden gems of IBM i. Administration Runtime Expert (ARE) is a no-charge IBM i Licensed Program Product that allows you to automate various tasks such as PTF distribution, which is especially helpful when you’re managing multiple partitions. But in the context of checking securityRead More