oracle database 11g certification

from the master database to the Standby DB:SQL> alter system set log_archive_dest_state_2 = defer;Re-enable log transmission after flashing back:SQL> alter system set log_archive_dest_state_2 = enable; Oracle 11g environment:The steps are simpler. The new features of Snapshot Standby Database are added to the

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

Programs-->oracle Database 11g Express edition--> run the SQL command line to start the Sqlplus program.Because the Sqlplus program does not support directly in the program window right-click, copy, paste and other operations, so the blogger is to run the command line to start the Sqlplus program.Start Menu--run--input cmd, and return--open cmd command line.Micr

After the CentOS system is installed, you can start the installation of Oracle 11g. First, you must make some preparations. Use commands to create an Oracle account and corresponding user groups Create a folder and grant the Oracle user permissions, as shown in the commandUse the root account to make a series of chan

Bkjia.com exclusive Article]Oracle Database 11gR1 new database replay DBR) function allows Oracle DBA to capture load from an Oracle 10gR2 environment, and then replay this load in Oracle 11gR1 environment, this section analyzes h

Tags: des style blog http os io ar file data1. Install Oracle ClinetFirst download an Oracle 11g Client to the Oracle website, but you will need to apply for an Oracle account before you can download it.Current: http://www.oracle.com/technetwork/

use RedHat Enterprise Edition as the Oracle operating system. The latest version isRedHat6.1. You can choose 32-bit or 64-bit Linux based on the CPU architecture. Generally, the 64-bit version can manage larger memory and hard disk space, which should be the first choice for enterprise applications.Oracle 11g R2 database installation hardware configuration requi

Tags: database service Oracle Server1, the installation media download:Official website: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6B/F7/wKioL1U8buXRJLgaAAEtGZXBVVw407.jpg "title=" Oracle

to the Tnsnames.ora file. For example, my machine is: d:/instantclient_11_2/network/admin4. Set the language of Oracle, add the environment variable Nls_lang, and the value is simplified Chinese_china. Zhs16gbkAssuming that the Oracle language of the remote database is unclear, SSH or telnet to the remote machine, enter in the command interface, and connect to t

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

then press ENTER. As soon as the installation is complete, you will be prompted to execute 2 shell scripts with root privileges. Perform/home/oracle/app/oracle/product/11.2.0/dbhome_1/root.sh and/home/oracle/orainventory/as indicated by their pathOrainstroot.sh, there will be a message when the installation is complete. Execute command: CD /home/

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 administrator, nothing is more important than the data itself. like it o

Operating system: Red Hat Enterprise Linux Server Release 6.2 x86_64Oracle version: Oracle Database 11g Release 2 Oracle Official Download Address:File1:http://download.oracle.com/otn/linux/oracle11g/r2/linux.x64_11gr2_database_1of2.zipFile2:http://download.oracle.com/otn/linux/oracle11g/r2/linux.x64_11gr2_database_2o

The following error occurred while starting the Oracle 11g RAC database, only one of the nodes could be started, and the other node could not start, possibly due to a previous modification of the Cluster_database parameter. This parameter must be set to true in the Oralc RAC schema. Error message: ora-01102:cannot Mount