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

Full description

Bibliographic Details
Main Authors: Malcher, Michelle, Kuhn, Darl (Author)
Format: eBook
Language:English
Published: [Place of publication not identified] Springer Nature 2019
Edition:Third edition
Series:Expert's voice in Oracle
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
LEADER 04609nmm a2200493 u 4500
001 EB001941405
003 EBX01000000000000001104307
005 00000000000000.0
007 cr|||||||||||||||||||||
008 210123 ||| eng
020 |a 9781484244241 
050 4 |a QA76.9.D32 
100 1 |a Malcher, Michelle 
245 0 0 |a Pro Oracle Database 18c Administration  |b Manage and Safeguard Your Organization's Data  |c Michelle Malcher, Darl Kuhn 
250 |a Third edition 
260 |a [Place of publication not identified]  |b Springer Nature  |c 2019 
300 |a 1 online resource 
505 0 |a 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 
505 0 |a 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 
505 0 |a 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 
505 0 |a 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 
653 |a Oracle (Computer file) / http://id.loc.gov/authorities/names/n91015760 
653 |a Bases de données / Gestion 
653 |a Bases de données relationnelles 
653 |a Oracle (Computer file) / fast 
653 |a Relational databases / fast 
653 |a Databases / fast 
653 |a Database management / http://id.loc.gov/authorities/subjects/sh85035848 
653 |a Relational databases / http://id.loc.gov/authorities/subjects/sh86007768 
653 |a COMPUTERS / General / bisacsh 
653 |a Databases / http://id.loc.gov/authorities/subjects/sh86007767 
653 |a Database management / fast 
700 1 |a Kuhn, Darl  |e author 
041 0 7 |a eng  |2 ISO 639-2 
989 |b OREILLY  |a O'Reilly 
490 0 |a Expert's voice in Oracle 
015 |a GBB968431 
776 |z 1484244249 
776 |z 9781484244241 
776 |z 9781484244234 
856 4 0 |u https://learning.oreilly.com/library/view/~/9781484244241/?ar  |x Verlag  |3 Volltext 
082 0 |a 658 
082 0 |a 005.75/65 
520 |a 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