Pro Oracle Database 12c administration
Pro Oracle Database 12c Administration is a book focused on results. Author Darl Kuhn draws from a well of experience over a decade deep to lay out real-world techniques that lead to success as an Oracle Database administrator. He gives clear explanations on how to perform critical tasks. He weaves...
Autor principal: | |
---|---|
Formato: | Libro electrónico |
Idioma: | Inglés |
Publicado: |
Berkeley, CA :
Apress
2013.
|
Edición: | 2nd ed |
Colección: | Expert's voice in Oracle.
|
Materias: | |
Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629407306719 |
Tabla de Contenidos:
- ""Contents at a Glance""; ""Contents""; ""About the Author""; ""About the Technical Reviewers""; ""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 11g Release 2 Scenario""; ""Oracle Database 12c Release 1 Scenario""; ""Step 7. Troubleshoot Any Issues""; ""Installing with a Copy of an Existing Installation""; ""Step 1. Copy the Binaries, Using an OS Utility""; ""Step 2. Attach the 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 Server""; ""Step 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""; ""Summary""; ""Chapter 2: Implementing 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 File""; ""Step 3: Create the Required Directories""; ""Step 4: Create the Database""; ""Step 5. Create a Data Dictionary""; ""Configuring and Implementing the Listener""; ""Manually Configuring a Listener""; ""Implementing a Listener with the Net Configuration Assistant""; ""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""; ""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""