Pro Oracle Database 18c Administration : Manage and Safeguard Your Organization's Data /

Pro Oracle Database 18c Administration : Manage and Safeguard Your Organization's Data /

Saved in:
Bibliographic Details
Author / Creator:Malcher, Michelle, author.
Edition:Third edition.
Imprint:[Place of publication not identified] : Springer Nature : Apress, 2019.
Description:1 online resource
Language:English
Series:Expert's voice in Oracle
Expert's voice in Oracle.
Subject:
Oracle (Computer file)
Oracle (Computer file)
Database management.
Relational databases.
Databases.
Database management.
Databases.
Relational databases.
Format: E-Resource Book
URL for this record:http://pi.lib.uchicago.edu/1001/cat/bib/11852304
Hidden Bibliographic Details
Other authors / contributors:Kuhn, Darl, author.
ISBN:9781484244241
1484244249
9781484244234
Notes:Online resource; title from PDF title page (EBSCO, viewed April 2, 2019).
Summary:Chapter 3: Configuring an Efficient Environment; Customizing Your OS Command Prompt; Customizing Your SQL Prompt; Creating Shortcuts for Frequently Used Commands; Using Aliases; Using a Function; Rerunning Commands Quickly; Scrolling with the Up and Down Arrow Keys; Using Ctrl+P and Ctrl+N; Listing the Command History; Searching in Reverse; Setting the Command Editor; Developing Standard Scripts; dba_setup; dba_fcns; tbsp_chk.bsh; conn.bsh; filesp.bsh; login.sql; top.sql; lock.sql; users.sql; Organizing Scripts; Step 1. Create Directories; Step 2. Copy Files to Directories
Table of Contents:
  • Intro; Table of Contents; About the Authors; About the Technical Reviewer; Acknowledgments; Introduction; Chapter 1: Installing the Oracle Binaries; Understanding the OFA; Oracle Inventory Directory; Oracle Base Directory; Oracle Home Directory; Oracle Network Files Directory; Automatic Diagnostic Repository; Installing Oracle; Step 1. Create the OS Groups and User; Step 2. Ensure That the OS Is Adequately Configured; Step 3. Obtain the Oracle Installation Software; Step 4. Unzip the Files; Step 5. Creating oraInst.loc File; Step 6. Configure the Response File, and Run the Installer
  • Oracle Database 12c Release 1 ScenarioOracle Database 18c Release 1 Scenario; Step 7. Troubleshoot Any Issues; Step 8. Apply Any Additional Patches; Installing with a Copy of an Existing Installation; Step 1. Copy the Binaries, Using an OS Utility; Step 2. Attach the Oracle Home; Installing Read-Only Oracle Home; Upgrading Oracle Software; Reinstalling After Failed Installation; Applying Interim Patches; Installing Remotely with the Graphical Installer; Step 1. Install X Software and Networking Utilities on the Local PC; Step 2. Start an X Session on the Local Computer
  • Step 3. Copy the Oracle Installation Media to the Remote ServerStep 4. Run the xhost Command; Step 5. Log In to the Remote Computer from X; Step 6. Ensure that the DISPLAY Variable Is Set Correctly on the Remote Computer; Step 7. Execute the runInstaller Utility; Step 8. Troubleshoot; Installation in the Cloud; Summary; Chapter 2: Creating a Database; Setting OS Variables; A Manually Intensive Approach; Oracle's Approach to Setting OS Variables; Understanding oratab; Using oraenv; My Approach to Setting OS Variables; Creating a Database; Step 1. Set the OS Variables
  • Step 2. Configure the Initialization FileStep 3. Create the Required Directories; Step 4. Create the Database; Step 5. Create a Data Dictionary; Configuring and Implementing the Listener; Implementing a Listener with the Net Configuration Assistant; Manually Configuring a Listener; Connecting to a Database through the Network; Creating a Password File; Starting and Stopping the Database; Understanding OS Authentication; Starting the Database; Stopping the Database; Using the dbca to Create a Database; Dropping a Database; How Many Databases on One Server?; Understanding Oracle Architecture

Similar Items