oracle 11g certification

the command:Su–rootCd/home/oracle/app/oracle/product/11.2.0/dbhome_1SH root.shCd/home/oracle/app/orainventorySH orainstroot.sh Iv. Creating a DatabaseSwitch to the Oracle account, enter DBCA in the terminal, and start the graphical creation.Select a custom databaseEnter the instance name and global database name

, change back to db_name = 'symp3 ', the same db_name should be set for the same DG -- The following is the configured backup database parameter file, which only lists the modified parts. If the original pfile file contains the same entries, you can comment on it or delete [Oracle @ linux3 ~]. $ Tail-20 $ ORACLE_HOME/dbs/initsybo5.oradb _ unique_name = sybo5log_archive_config = 'dg _ Config = (sybo3, sybo5) 'Log _ archive_dest_1 = 'location =/u01/data

Before Oracle 11g, adding a column to a large table and setting the default value would be a tragedy. sometimes you have to select the online redefinition function to achieve this requirement. adding new columns and setting the default values in 11 GB only allows you to modify the data dictionary to achieve this function, greatly improving the efficiency.Add 10g columns (default) SQL> select * from

1. DB_BLOCK_CHECKSUM parameter description Before Oracle 10.2.0.3: DB_BLOCK_CHECKSUM has two options: TRUE and FALSE. The default value is TRUE. In Oracle 10.2.0.3: DB_BLOCK_CHECKSUM has three options: OFF | TYPICAL | FULL. The default value is TYPICAL. In Oracle 11g: DB_BLOCK_CHECKSUM has five options: OFF | FALSE | T

Welcome to the Oracle community forum and interact with 2 million technical staff. On Monday, Oracle announced the beta version of OracleDatabase11g at its user conference. during a keynote speech at the OracleOpenWorld conference, ChuckRozwat, executive vice president of Oracle server technology, said that the beta OracleDatabase11g contains a solution package

Oracle 11g, oracle11g General requirements for software environments RHEL 5. x System and RHEL 6. x System Graphical desktop environment + development tools + Chinese Java support -- When installing in RHEL 6. x, ksh needs to use the 5. x software package instead. Preparations: Yum install yum * Yum groupinstall "X Window System" "desktop platform" "Chinese support" "development tools" [Root @ dbserver ~]

Installing Oracle 11g R2 silently in CentOS I,Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.htmlOracle 11g online documentation:Http://www.oracle.com/pls/db112/homepage Ii. System RequirementsMemory: 1 GB (minimum official requirement: 1 GB)Hard Disk: 40 GB (4.29G and 1.7G data files required for Enterprise Edition installation) Ch

necessary to modify the Yum source, you can useHttp://mirrors.163.com/http://mirrors.sohu.com of these 2 domestic sources.Execute the following command. Cd/etc/yum.repos.dMV Centos-base.repo Centos-base.repo.bakwget Http://mirrors.163.com/.help/CentOS-Base-163.repo or wget Http://mirrors.sohu.com/help/CentOS-Base-sohu.repoRun the Yum Makecache build cache4 Console page Some of the text on the button is garbled solution (such as login screen: Login button)Workaround:EM garbled is caused by Java,

Oracle provides the scott user's re-creation script, and the 11G uses the script to create scott. The simple operation is as follows: SQL> select * from dba_users where username = 'Scott '; ------ SCOTT has been manually deleted. No rows selectedSQL> exitDisconnected from Oracle Database 11g Enterprise Edition Release

Oracle 11g Data Loading Methods Data Loading: SQL * LOADER External table Import/Export SQL * LOADER: SQL * LOADER is an Oracle tool that can load data from external data files to databases. The command for running SQL * LOADER is sqlldr. Two Sqlldr usage methods: 1. Use only one control file, which contains data 2. Use a control file (as a template) and a

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

Selection:32-bit memory is a bottleneck, it is already 64-digit era. Use 64-bit CentOS6 and 64-bit Oracle 11g R2In the virtual machine installation, use the Hostonly way to set up the networkNote: The Internet adapter will be able to set up ICS (Internet Connection Sharing) to VMware network Adapter VMnet1So for the virtual machine, the gateway is 192.168.137.1,IP address please also set in 192.168.137.0/24

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 $

Label:1. Environmental information:System:Oracle-linux 5.7 Database version:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionPL/SQL Release 11.2.0.3.0-productionCORE 11.2.0.3.0 ProductionTNS for Linux:version 11.2.0.3.0-productionNlsrtl Version 11.2.0.3.0-production Main Library: 192.168.12.31 Sid:yoon Db_unique_name:yoonLibrary: 192.168.12.231 Sid:yoon DB_UNIQUE_NAME:YOONDG 2. Check if DG is installed:Sql> SELECT * from v$op

Install ORACLE 11g R2 on CentOS 5.5. Tutorial 1: prerequisites 1. Prepare CentOS. First, what is the most important: partition is the most important. Obviously, the larger the partition, the better, especially the larger the SWAP space, at least 2 GB. Second, for beginners, there are two points to note. First, it is best to install the software in full compliance; second, remove the firewall, SElinux, and s

Background:The physical memory of the master and slave machines is doubled. After the memory is expanded, You need to modify the memory parameters related to the database, including the database and operating system. After doubling the memory size of the backup machine, modify the relevant memory parameters and start the database to the backup machine for two days. If no problem exists, then, double the physical memory of the previous host to switch the database to the slave host. The reason for