Cargando…
Pro Oracle Database 18c Administration : Manage and Safeguard Your Organization's Data /
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...
| Clasificación: | Libro Electrónico |
|---|---|
| Autores principales: | , |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
[Place of publication not identified] :
Springer Nature : Apress,
2019.
|
| Edición: | Third edition. |
| Colección: | Expert's voice in Oracle.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- 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