oca 11g

Tags: 11g hand-built library Oracle 11gFirst step: Catalog-- Database Files directory$ cd $ORACLE _base/oradata$ ls-- When you see a library that already exists SIDPROD$ pwd-- Take a look at the absolute path/u01/app/oracle/oradata$ mkdir HYL$ ls-l-- production look at the directory and permissions-- plan the different disk directories where the data files are stored, depending on the situation$ CD HYL$ mkdir Dump Disk1 disk2 disk3 disk4 disk5--disk r

Oracle 11g Recovery of standby control files was unsuccessful when creating data guard. At Mount Standby database, I was told that the control file was not a standby control file, and that the specific information was "Ora-01665:control file is not a standby-control". control files I generated in the main library using Rman. Backup current controlfile for standby format ' xxxxxx/ctl.stdy '; Copy to the standby for recovery. Follow the 10g operating ha

Before Oracle 11g, when there is a transaction on a table, you cannot perform DDL operations on the table at this time, or you will get an error immediately. In the 11g introduced the Ddl_lock_timeout this parameter, can wait for a period of time has not obtained the lock, will be error. I personally think that this new feature is not very useful, just know it.Session1:sql> select * from V$version; BANNER

Tags: WinForm style blog http tar extBecause like new things, so basically computer development tools are the latest, Oracle also installed 11g R2, but colleague classmate is not 11g R1 is 10G, from here I exported the DMP file in their direction in, all show:IMP-00010: Not a valid export file, header validation failedFor this problem has been distressed, almost want to unload

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 click "Next" to install, it is not installed, will jump out of the error prompt, so only af

Label:Oracle 11g under the function of automatic expansion of the partition, it is very convenient, but also brings a problem, that is, after the export, import, the build Table statement changed, the following to do an experiment: Sql> select * from V$version;BANNER------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit P

Label:Selection:32-bit memory is a bottleneck, already 64-bit era. Use 64-bit CentOS6 and 64-bit Oracle 11g R2In virtual machine installation, the network is set up by hostonly modeNote: Network adapter to set up ICS (Internet Connection Sharing) to the VMware network Adapter VMnet1So for virtual machines, the gateway is 192.168.137.1,IP address please also set in 192.168.137.0/24 segmentHDD 40G, Memory 2G1. Download software1.1. CentOS 6 (x86_64)http

Oracle 11g slave uard Duplicate physical standby database configuration (1) physical standby database creation Configuration# Ver: 1.5 fifth Modification# Modify: 2013.8.16# Author: koumm Read more: Configure Oracle 11g replicuard test and create a Physical Standby Database) Oracle 11g slave uard physical standby Database Configuration and Active slave uard Test

After installing the OEM grid control 11g, reinstall the agent on a monitoring server and the agent will not be able to work. The error "EMD upload error: uploadXMLFiles skipped" will be reported during the emctl upload check ". As follows: [Oracle @ codb2 ~] $ Emctl upload Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0 Copyright (c) 1996,201 0 Oracle Corporation. All rights reserved. -----

Oracle 11G R2 replicuard construction in CentOS 5.11 Datagard is a disaster tolerance solution for Oracle Enterprise Edition. It is widely used in enterprises and I will record the setup process for backup.Host Name database version Instance name IPDb1 Oracle 11G R2 member 172.16.1.250Db2 Oracle 11G R2 member 172.16.1.20.By default, the Oracle database has been i

configure different storage attributes for different files in the same disk group to implement different storage methods. Ii. What new features does ASM have in 11G? 1. Fast Re-Sync ASM Fast Mirror Resync) When a short DISK path problem occurs, it takes a lot of time to restore the disk group of the asm disk group. In particular, this recovery operation requires you to relay the entire disk group. The new feature of ASM fast disk re-synchronization

Oracle Database 10g Release 2 (10.2.0.4.0) Enterprise/Standard Edition for Microsoft Windows Vista x64 and Microsoft Windows Server 2008x64 Http://download.oracle.com/otn/nt/oracle10g/10204/10204_vista_w2k8_x64_production_db.zip Http://download.oracle.com/otn/nt/oracle10g/10204/10204_vista_w2k8_x64_production_client.zip Http://download.oracle.com/otn/nt/oracle10g/10204/10204_vista_w2k8_x64_production_crs.zip Oracle Database 11g Release 2 (11

Installation and configuration of EM in Oracle 10g and 11g I set up an Oracle environment locally. I first installed the database with EM. After the installation, I wanted to modify the listener port and replace the port 15521 with another one, as a result, several parameter files are modified in the directory, and EM cannot be started directly. Finally, I analyzed it myself. In fact, there are several ways to change the password. One is to directly D

When Oracle 11g is exported using EXP, empty tables cannot be exported, and 11 gexp I. cause:There is a new feature in 11G. When the table has no data, no segment is allocated to save space.1. insert a row and then roll back to generate a segment.This method inserts data into an empty table and then deletes it, resulting in a segment. An empty table can be exported.2. Set the deferred_segment_creation param

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 load in an Oracle

Oracle upgrades from 10g to 11g detailed steps database old version: 10.2.0.4 Database new version: 11.2.0.2 OS Version: Solaris 10 Reference Documentation: Complete checklist for Manual upgrades to 11GR2 [ID 837570.1] Part I-Installing 11GR2 software The installation of the software here is not explained in detail, you can refer to the appropriate documentation. Here is to note: If you want to 11gr2 on the latest PSU or CPU, you can first in th

Now there is a need to use Exp/imp to import 11g of database data into 9i, to solve this problem generally think of three ways of thinking, try (in fact, from the high version of the server to support the low version of the client principle, you can probably guess the use of 9i client to handle the problem) Method 1: Export imports all use 11g clients --11G Cli

One, Oracle 11g installationBefore installing to determine your own computer configuration, Windows as an example, if it is Win7 the following systems such as XP, you can select Oracle 10g. Because the program file of 10g only more than 200 trillion, and 11g and reached 2G, the specific file official download path has not been found, can only go to some software download platform download. If it is Win7 bes

Tags: Hot Download Center database system will be user installation complete album prerequisite Check sel Oracle database system is one of the most popular client/server (client/server) or B/s architectures in the United States Oracle Corporation (Oracle) provides a distributed database-centric set of software products. Oracle 11g R2 is the second version of Oracle 11g, with higher performance and better se

in the 11g encountered many problems using the same method.First, we can see the following errors in the log.Apr 6, 2015 9:33:45 oracle. sysman. emcp. util. GeneralUtil initSQLEngineLoaclyCONFIG: ORA-28000: the account is locked CONFIG: ORA-20001: SYSMAN already exists ..ORA-06512: at line 17 Further Check the log. It is found that DBSNMP is locked and sysman is created by default. Unlock DBSNMP, delete sysman, and then use the clean-up method of 10