Portable DBA—Oracle by Robert G. Freeman

By Robert G. Freeman

This convenient, cheap reference is perfect for on-the-job DBAs short of easy accessibility to administrative instructions, blunders resolutions, and top practices. overlaying the main established Oracle database models, the e-book comprises useful tables so difficulties will be clinically determined speedy and contains examples and syntax diagrams for every command.

Show description

Read Online or Download Portable DBA—Oracle PDF

Best oracle books

Oracle PL/SQL Programming 4Th Edition

За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle types, так и администраторам - используйте PL/SQL на полную мощь.

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication permit real-time info entry and knowledge sharing throughout your allotted framework utilizing the specialist info during this Oracle Press consultant. Oracle Streams 11g info Replication explains easy methods to arrange and administer a unified company facts sharing infrastructure.

Oracle Application Express 4 Recipes

Oracle program exhibit four Recipes presents an example-based method of studying program exhibit - the ground-breaking, speedy software improvement platform incorporated with each Oracle Database license. The recipes layout is perfect for the quick-study who simply wishes a great instance or to kick begin their considering and get pointed within the correct course.

Additional info for Portable DBA—Oracle

Sample text

Typically, the admin directory would be called admin (go figure) and you would have a directory structure that looks like this: /ora01/oracle/admin. 2. Create a directory under the admin base directory for the database that you are creating. For example, if your database is to be called mydb, then you would create a directory under the admin base directory called mydb. An example of this would be /ora01/oracle/admin/mydb. 3. Create the directory structures under the database admin directory structure you created in Step 2.

The DBCA isn’t just for neophyte database administrators. The DBCA gets better with later versions of Oracle Database. In Oracle Database 10g, for example, the DBCA will create an Oracle Real Application Clusters (RAC) cluster for you as well as help you to configure Oracle Database 10g’s new Automatic Storage Management (ASM). Creating a Database: Prerequisites You must complete a number of prerequisites before you can issue the create database command. Some operating systems (OSs) may have operating system–specific prerequisites (such as Windows, which requires the creation of a service for your Oracle database).

Rr is the reincarnation number (Oracle Database 10g and later). This additional parameter 50 Chapter 2: Database Creation and Management Chapter 2: Database Creation and Management 51 makes it easier to perform recovery through a resetlogs operation. rdo. log in the online redo log filename? log extension. log extension. log extension? Not a good day for the DBA. ctl where: ♦ dbnm is the name of the database. ♦ ctrl simply identifies the file as a control file. ). ctl. arc where: ♦ dbnm is the name of the database.

Download PDF sample

Rated 4.66 of 5 – based on 14 votes