Category: Stopping the Database

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

Stopping the Database- Creating a Database

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

Categories
Oracle Certification and Database Stopping the Database

Creating a Database Using a SQL Statement- Creating a 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

Categories
Database vs. Instance Oracle Certification and Database Stopping the Database

Using the Database Configuration Assistant- Creating a Database-2

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

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

Save the Response File for Additional Installations- Installing the Oracle Binaries

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

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

Run the Installer for Grid- Installing the Oracle Binaries-2

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

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

Obtain the Oracle Installation Software- Installing the Oracle Binaries

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

Categories
Database vs. Instance Oracle Certification and Database Stopping the Database

Oracle Network Files Directory- Installing the Oracle Binaries

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

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
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