oca oracle database 11g administrator certified associate study guide

Oracle 11g archive log study _ 1, oracle11g ARCHIVE _ 1 Oracle Database Operations are recorded in the redo log for undo (rollback) Or redo (redo) in case of database exceptions ). Redo logs are divided into online logs and archiv

It's sometimes said that the true job of an Oracle database administrator can be summed up in one, essential skill: to be able to recover your database. there's much wisdom in that statement. of all the things you are responsible for as a database

can start by using the "Oracle 11g", "Application Development", "SQL Developer or SQL Plus" connection in the application. note for the first time, when you use SQL Developer, you are prompted to specify the path to Java.exe, so don't specify your own java_home here (I just don't know, specify a JDK6, end up saying incompatible.) The following JDK paths can be used with the Oracel installation path specif

\ System-application.xml F:\app\Administrator\product\11.2.0\dbhome_2\oc4j\j2ee\OC4J_DBConsole\config\ System-jazn-data.xml F:\app\Administrator\product\11.2.0\dbhome_2\oc4j_applications\applications\em.ear F:\app\ Administrator\product\11.2.0\dbhome_2\oc4j_applications\applications\em\em.war [NS-20802]Oracle Net Confi

Oracle 11g Installation Prior to installation to determine their own computer configuration, in Windows, for example, if it is Win7 the following systems such as XP, you can choose Oracle 10g. Because the 10g program files only 200 trillion, and 11g and reached 2G, the official download path to the file can not be fou

Oracle Database AdministratorI have already introduced daily, weekly, and monthly jobs for you, this section describes the monthly responsibilities and daily management of Oracle Database administrators, the weekly responsibilities of Oracle

Label:1 Viewing version information for Oracle (1) Connect to the database with the client, execute SELECT * from V$instanceView version Items (2) SELECT * FROM Product_component_version (3) or Query V$version View component-level information 1.1. Oracle parameter Settings 11g data pump export, importEnter the CMD inte

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 Re

:\app\Administrator\ Product\11.2.0\dbhome_2\oc4j_applications\applications\em\em.war [ns-20802]oracle Net configuration Assistant failed Workaround: After downloading, there are a total of 2 installation packages. After each decompression, the second package is extracted to the database under the first decompression package under the corresponding directory.

\ORADATA\AGRISK\REDO01. LOG ' to ' F:\APP\ADMINISTRATOR\ORADATA\AGRISK\REDO01. LOG '; the database has changed. sql>alterdatabaserenamefile ' D:\APP\ADMINISTRATOR\ORADATA\AGRISK\REDO02. LOG ' to ' F:\APP\ADMINISTRATOR\ORADATA\AGRISK\REDO02. LOG '; the database has changed. s

end of the installation, you will be prompted to execute two scripts: Execute the two scripts again with the root user.Note: When the second script executes, it depends on the information returned. [[emailprotected] ~]#/u01/app/11.2.0/grid/root.sh Running Oracle 11g root.sh script ... The following environment variables is set as:oracle_owner= ORACLE oracle_ho

Oracle 11g manually create a database in windows 1. Create a required directory www.2cto.com D: \ app \ Administrator \ admin \ jxg12_20104350121 2. create a database file storage directory under oradata D: \ app \ Administrator \

ORACLE 11g R2 database installation hardware environment requirements, 11gr2 Physical memory requirements: Minimum 1 GB, minimum 2 GB for windows7, windows8, and windows8.1. Virtual Memory (or paging space) capacity requirements: Available RAM Swap Space Required Between 2 GB and 16 GB Equal to the size of RAM More than 16 GB

Oracle 11g database security reinforcement considerations, oracle11g In database security configuration, security reinforcement is required. To ensure database security, however, sometimes, after improper operations or database bu

With the upgrade of the Oracle version, RMAN is also enhanced. RMAN in Oracle11g supports the use of different operating systems and different databases. For the compatibility of RMAN, refer: Oracle RMAN compatibility and FAQs between different versions and different platforms This article demonstrates an example of restoring 10 Gb to 11 GB in linux. Target end: OS: Ora