DBA never sleep-DBA，永不眠

---使用 DBCA 创建数据库时会创建 SPFILE---SPFILE 必须在共享卷或共享raw设备上创建---所有实例使用同一个SPFILE---如果手工创建数据库，则通过PFILE创建SPFILE。[oracle@rac11 dbs]$ more initPROD1.oraSPFILE='+DATA1/PROD/spfilePROD.ora'[oracle@r

APPLIES TO:Oracle Exadata Storage Server Software - Version 11.2.2.3.5 to 11.2.3.2.1 [Release 11.2]Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.4 [Release 11.2]Information i

实验环境：Oracle 11g R2 RAC （11.2.0.3.5）               Oracle Enterprise Linux 5.6 x861、创建 ASM 磁盘组在两节点挂好磁盘后，在第一节点上对磁盘进行分区[root@rac1 ~]# fdisk -lDisk /dev/sde: 2147 MB, 2147483648 bytes2

Summary of DBMS_SERVICE SubprogramsTable 130-5 DBMS_SERVICE Package SubprogramsSubprogramDescriptionCREATE_SERVICE ProcedureCreates serviceDELETE_SERVICE Pr

1、使用 srvctl 工具创建 service 资源srvctl add service -d db_unique_name -s service_name {-r "preferred_list" [-a "available_list"] [-P {BASIC | NONE | PRECONNECT}] | -g server_pool [-c {UNIFORM | SI

Oracle 11gR2Grid Infrastructure (CRS) 中引入了 Single Client Access Name (SCAN) 来简化客户端对数据库服务的访问。本文将详细介绍如何配置 DNS 来解析 SCAN VIP

The following steps assume that a failover has been performed to aphysical standby database and that Flashback Database was enabled on the oldprimary database at the time of the failover. This proce

Oracle Database 软件提供了以下两个脚本来配置数据库随服务器自动启动和关闭：[oracle@prod bin]$ pwd/u01/app/oracle/product/11.2.0/db_1/bin[oracle@prod bin]$ ls -l dbs*-rwxr-x--- 1 oracle oinstall  6030 Jan  1  2000 dbshut-

To query the list of users that are CRS Administrators:[grid@rac1 ~]$ crsctl query crs administratorCRS Administrator List: *To enable role-separated management and grant privileges to non-p

Oracle Restart improves the availability of your single-instance Oracle database. Oracle Restart automatically restarts the database instance, the Automatic Storage Management (ASM) instance, the list

In this Document Goal Solution ReferencesApplies to: Oracle Database - Enterprise Edition - Version 9.0.1.0 to 11.2.0.3 [Release 9.0.1 to 11.2