The goal of this book is to help you understand the concepts behind Oracle Database. It teaches you how to perform all common administration tasks needed to keep the database operational, including how to perform basic troubleshooting and performance monitoring activities. Audience Oracle Database 2...
Part1–basicdatabaseadministration: – creatingdatabaseobjects:users,tables,indexes, tablespaces,datafilesetc. – managingdatabaseobjects – networking,connectingtoremotedatabases – SQLlanguage–SQLstandardandOracle extensions – programmingOracle–PL/SQLlanguage ...
In Oracle Database 10gRelease 2 (10.2), a new privilege,CREATE EXTERNAL JOBhas been added which will now be required for database users to execute jobs that run on the operating system outside of the database. During upgrade from Oracle Database 10grelease 1 this privilege is granted to a...
Basic CommandsPower Let’s start by understanding some very first commands you will need: powering on and off. The command for that is IPMITOOL. To power on a cell or database server, issue this from another server:# ipmitool -H prolcel01-ilom -U root chassis power on IPMI – ...
Performance:Reactive Streams Ingest (RSI) for streaming data into the Oracle Database (21c and later); Oracle connection manager (CMAN) in traffic director mode (CMAN-TDM) High Availability:Transparent Application Continuity (TAC); AC support in DRCP; and AC support for legacy Oracle JDBC types...
A new administration privilege, SYSBACKUP, allows Recovery Manager (RMAN) users to connect to the target database and run RMAN commands, no longer requiring SYSDBA. This feature enforces the separation of duty security model, whereby backup operators only need SYSBACKUP privilege to run RMAN comma...
This is crucial—if you are running Database 9i, 10g, 11g or another product with a long history, it is likely that Oracle has addressed the presented problem before. If they have already seen it, they will accept it. • New issues – Oracle Support reserves the r...
The database administrator might help here. You can find more information in PL/SQL User's Guide and Reference, PL/SQL Packages and Types Reference, and Oracle Database Performance Tuning Guide. xxviii I Some amount of database administration, if you need to maintain your own development or ...
2.1.2 Oracle® Database 11g Server Library Table 2-2 Oracle® Database Server Library DocumentationPart NumberDescription Administration, Concepts, and Reference Oracle Database JPublisher User's Guide E10587-01 Describes the JPublisher utility useful for Java programmers who want classes in ...
data 10G*1 5G*2 VMvare workstation创建共享磁盘 在安装VMware软件的操作系统上,以管理员权限打开命令行工具cmd,进入到计划存放共享磁盘的目录,如 E:\Program Files (x86)\VMware\rac11g_asmlib_3节点\racdb01 下,在节点1目录下创建共享磁盘; 创建共享存储 1个节点操作,剩余2个节点不用操作。 --进入存放共享...