oracle 11g book

name. Simple command description about vi: After you enter vim/home/oracle/. bash_profile to create a configuration file, you must press I (enter insert mode) to add and modify the file. After modification, Press ESC and press shift +: And enter wq to save and exit. In addition, if you directly copy the preceding variables from a windows system file to a linux configuration file, run the vi command to open the file and check whether there are any sp

Oracle Performance Diagnosis art (milestone book on Oracle Database optimization) [Original book name] troubleshooting Oracle Performance[Original Publishing House] apress[Author] (Swiss) Christian antognini [same as the author's work] [Translator's introduction][Translated

Bkjia.com exclusive Article]Oracle 11gR1 provides the ability to capture application loads in the production environment and replay loads in the testing environment, this technology is used to determine the impact on the performance of the system, database, or application after modification. In this article, I will describe how to capture and prepare the load from the current production database in the p + 0 environment, and how to replay the same loa

Tags: capacity www. Lib BST ksh opening an ace share pictureReference article:Http://www.cnblogs.com/lightnear/archive/2012/10/07/2714247.htmlHttp://www.cnblogs.com/xqzt/p/5456401.htmlHttp://www.cnblogs.com/anzerong2012/p/7528311.htmlFirst, installation environmentCentOS Linux release 7.2.1511 (Core)Oracle Database 11g Release 2 (11.2.0.4)Second, before the installation of 2.1 modify host nameModify the hos

[[email protected] admin]$ Rman target Sys/[email protected] Auxiliary/Rman> duplicate target database for standby nofilenamecheck;Rman> exitClose the databaseShutdown immediate 5. Start the Redo applicationStartup Nomount;ALTER DATABASE mount standby database; sql> ALTER DATABASE recover managed standby database using current logfile disconnect from session; Database altered.6. VerificationMain LibrarySql> Archive Log ListDatabase Log Mode Archive modeAutomatic Archival EnabledArchive Destin

SQL> select * from v $ version; BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionPL/SQL Release 11.2.0.1.0-ProductionCORE 11.2.0.1.0 ProductionTNS for Linux: Version 11.2.0.1.0-ProductionNLSRTL Version 11.2.0.1.0-Production Sometimes there is a background wait event: db file async I/O submit This w

How to manually delete an Oracle 11g database in Linux The following steps teach you how to manually delete an Oracle 11g Database in a Linux environment. I installed the Oralce 11G database on CentOS 6. Use SQLPlus or other command line tools you like to log on to the data

After migrating the data of a test system from Oracle 10 Gb to 11 GB, I heard the developers say that they failed to execute an SQL statement to create an index, but it can be executed normally in 10 Gb. This index is a function index with duplicate columns. It may be incorrect and this index is not useful. Therefore, you have never paid attention to this index. I felt quite interesting, so I tried it myself: 1. First, let's look at the

Tags: Oracle 11g ASM Installation1. Oracle 11g InstallationSlightlyFor detailed procedures, please refer to:Http://blog.sina.com.cn/s/blog_7c5a82970101excf.html2. Install the ORACLEASM packageRPM-IVH oracleasm-support-2.1.7-1.el5.x86_64.rpm oracleasmlib-2.0.4-1.el5.x86_64.rpm oracleasm-2.6.18-164.el5-2.0.5-1.el5.x86_64

Oracle 11gThe clientLinuxThe configuration process is a little bit difficult, but as long as we configure step by step, there is nothing. This article describes how to configure the Oracle 11g client on Linux. First download several compressed packages from OTN, for: http://www.oracle.com/technology/software/tech/oci/instantclient/index.html, And then according t

Tags: 11g hand-built libraryCreate a password fileCD $ORACLE _home/dbsOrapwd file=orapwogg02 password=oracle entries=5Mkdir-p $ORACLE _base/flash_recovery_areaMkdir-p $ORACLE _base/admin/$ORACLE _sid/adumpMkdir-p $

wasn't restored from a sufficiently old backupOra-01110:data file 1: '/OPT/ORACLE/ORADATA/TPY100/SYSTEM01.DBF 'Is the standby monitoring is not open, using lsnrctl start, start monitoring, and then open the database will not error.sql> ALTER DATABASE recover managed standby database using current logfile disconnect from session;The test has the following statement:Sql> select sequence#,applied from V$archived_log;Sql> select Process,status from V$man

Tags: ada parameter mode space min Ram Create base IAREnvironment: Simulating the creation of the main library use the Install option in the DBCA Start graphical interface option---> select Create and configure a databaseCreate a mock-up library using the Install option in the DBCA Startup graphical interface option---> Check the install database software onlyPreparation using the Oracle 11g Rman feature fo