oracle 11g book

Tags: Linux oracle 11gOracle 11g installation on Linux Create the required users and groups Vim mk_user.sh GROUPADD-G 501 OinstallGROUPADD-G 502 DBAGROUPADD-G 503 OperUseradd-u 501-g oinstall-g Dba,oper Oracle SH mk_user.sh Create the desired directoryVim mk_dir.sh Mkdir-p/u01/app/orainventoryChmod-r 775/u01/app/orainventoryMkdir-p/

Oracle 11g Automatic Optimization and oracle11g Optimization--: Automatic Plan OptimizationBeginDbms_workload_repository.create_snapshot ();End;Select/* + result_cache */count (*) from (select * from HJ. dbtan where object_type = 'table' order by 1 DESC, 2 ASC, 3 DESC, 4 ASC );BeginDbms_workload_repository.create_snapshot ();End;-- Ft8s1pfmz9ph0SET SERVEROUTPUT ONDECLARERochelle SQL _tune_task_id VARCHAR2 (

64-bit Windows 8/7 32-bit PLSQL connection 64-bit Oracle 11g, plsql11g64-bit Windows 8/7 32-bit PL/SQL connection 64-bit Oracle 11gNote: Oracle's oci. dll is 64-bit after installation, while 32-bit application PL/SQL Developer cannot loadSolutionStep 1: Download the Instant Client for Microsoft Windows (32-bit) package address: http://www.oracle.com/technetwork/t

Oracle Database 11g Release 2 Standard Edition and Enterprise Edition software DownloadsOracle Database 11g 2nd edition Standard Edition,Software download for Enterprise EditionOracle download also requires a user name I registered a convenience for everyone to use the downloadDirect Click on the prompt can not find this to go through Oracle's official website li

Then unzipClick setup.exeI'm using the default installation D drive.The database password is Wangxiaofei.NextFirst, on your own Windows 7 flagship edition, Oracle 11g prompts you for errors when "product-specific prerequisite condition checks":In, we can see that when Oracle checks the operating system compatibility, it does not pass the check, at this time, we c

Use rman to migrate 10 Gb servers across databases and servers: 192.168.182.133Oracle10.2.0.1.0RHEL432bit11g server: Server 192.168 Use rman to migrate 10 Gb servers across databases and servers: 192.168.182.20.oracle 10.2.0.1.0 RHEL 4 32bit 11g server: Server 192.168 Using rman for cross-database and cross-server migration10g server: 192.168.182.20.oracle 1

Tags: OracleOracle Database 11g Some important initialization parameters (i)Initialize parameter file locationD:\app\Administrator\admin\orcl1\pfile\init.oraInit.ora1, Diagnostic_destIn 11g, there is a new structure for storing diagnostic information called the Automated Diagnostics repository (AUTOMATICD Diagnostic Repository ADR).Specify the directory location with some parameters, such as $ORACLE_BASE/DI

/s99oracle11Ln-s/etc/init.d/oracle11/etc/rc.d/rc5.d/s99oracle11Ln-s/etc/init.d/oracle11/etc/rc.d/rc0.d/k10oracle11Ln-s/etc/init.d/oracle11/etc/rc.d/rc1.d/k10oracle11Ln-s/etc/init.d/oracle11/etc/rc.d/rc6.d/k10oracle11Effect and execution Chkconfig--add Oracle11 is the same.Here, so the setup process is over, let's test it out:#cd/ETC/INIT.DSH oracle11 startAfter executing, look at the Oracle11log file in the/var/log directory, is there a script to start the branch output information?SH oracle11 s

Tags: open fast overwrite selected format finish home record Select1. Find the Repository control file path FirstFind the path to the control file on the repository first, as in the main library, but just in case, check is OK. Sql> select name from V$controlfile;NAME--------------------------------------------------------------------------------/oracle/app/oracle/oradata/powerdes/control01.

I. Problem Description Install RAC of 11.2.0.1 on Oracle Linux 6.1 and run the root. Sh script when installing grid. The error is as follows: [Root @ Rac1 bin] #/u01/APP/11.2.0/GRID/root. Sh Running Oracle 11g root. Sh script... The following environment variables are Setas: Oracle_owner = Oracle ORACLE_HOME =/u01/AP

Oracle oinstall 30416896 Jan 22:05 temp01.dbf-rw-r-----1 Oracle Oinstall 110108672 Jan 24 22:05 UNDOTBS01.DBF-RW-R-----1 Oracle oinstall 26222592 Jan 22:05 users01.dbf[[emailprotected] prod]$ Exit[emailnbs p;protected]> ALTER DATABASE Open;alter database Open*error at line 1:ora-03113:end-of-file on communication channelpr Ocess id:2951session id:125 Serial Numb

Label:1. Download Oracle 11g R2 for Windows version: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.htmlThese include two compressed packages: Win64_11gr2_database_1of2.zip,win64_11gr2_database_2of2.zip2, unzip two compressed packets into the same directory, namely "database", and then click the "setup.exe" file under the extracted directory:3. In the Configure Security Update

The mongoel DG technology uses redo log transmission and application to ensure consistent data on the standby end and the primary end. In this process, Redo Transport and Redo Apply are two core actions. Redo Transport transmits the Redo Log information to the Standby end and waits for the Apply operation. Redo Apply is to execute these log applications and change the Standby data to achieve consistency. The following experiment uses alert log to observe the situation where a pair of Primary and