Normally, you use the SHUTDOWN IMMEDIATE statement to stop a database. The IMMEDIATE parameter instructs Oracle to halt database activity and roll back any open transactions. Without the IMMEDIATE, the shutdown process will wait for any open and active sessions to log out before shutting down, which could take a very long time, and chancesRead More
Category: Stopping the Database
Before we look at the SQL statement to create the database, remember all of the scripts and processes that were done as part of the DBCA. So, there are steps to follow to create the database manually using a SQL statement. These of course can be made into a script based on the scripts thatRead More
The storage options will depend on if you installed the grid infrastructure and created an ASM instance. This is similar to the database LISTENER, because the grid infrastructure will create one listener for the server, but you can create a new listener as part of the database creation. However, I recommend creating the listener inRead More
The last step before the installation starts using the GUI installer is to save the response file. The arrow in Figure 1-10 points to the button to save the response file. After reviewing everything that was configured by walking through the installation screens, click this button before clicking the Install button. Figure 1–10. Saving theRead More
Here are some of the steps for the graphical installation. Figure 1-5 shows the configuration options for the Oracle Grid Infrastructure installation. Figure1-5.Oracle Grid Infrastructure installation options Figure 1-6 shows the ASM disk groups and the discovery path of the raw devices. Figure 1–6. Oracle Grid installation ASM disks After a few more steps ofRead More
Usually, the easiest way to obtain the Oracle software is to download it from the Oracle website (oracle.com/downloads). Make sure you download the correct versions for the OS you want to install it on. If you are working with Linux systems, you can just install with yum and the RPM package. $ yum -y installRead More
Some Oracle utilities use the value TNS_ADMIN to locate network configuration files. This directory is defined as ORACLE_HOME/network/admin. It typically contains tnsnames. ora, listener.ora, and sqlnet.ora Oracle Net files. The listener.ora files are now typically with the Oracle grid installation and not in the database home. The listeners are normally maintained by the system thatRead More
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
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
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