oim 11g

Oracle 11g column-to-row listparts It is a little difficult to switch between the first 11g of Oracle, and it is very simple after 11g. Currently, a test table records the approval information of a document. The id is the primary key of the Approval Information, the sheet_id is the foreign key, and the id of the document, remark indicates the approval content. On

Oracle 11g Silent Installation Software + manual database creation Because it is a secondary jump + remote operation, the GUI cannot be used and cannot be directly installed on the GUI. Use silent software installation + manual database creation to complete the requirement. 1. Install the Oracle software in silent mode and configure the listener 2. manual database creation 3. check whether all components meet the requirements. 1. Install the Oracle so

New Features of Oracle 11g: User rename Oracle Data is constantly changing during project development. Therefore, we need to regularly import the development database to the test database. The common practice is "trilogy :" 1. Export data from exp in the Development Library 2. Delete the Test Database User 3. Use imp to import exported data to the Test Database Today, my colleague asked me if I could keep my previous users, for example, changing the u

Oracle 11g replica uard creation in ORA-01665 resolution, dataguardora-01665Oracle 11g fails to restore the standby control file when creating data guard. When I mount standby database, tell me that the control file is not a standby control file and the information is ORA-01665: control file is not a standby control file ".The control file is generated using rman in the master database.Backup current contro

From Oracle 12c Backup (EXPDP) package, restore to 11g, think all know there will be compatibility issues. Sure enough, the error: ORA-39142: Version number 4.1 (in the dump file "fork. EXPDP") incompatible Like Later learned that in the 12C backup, you should specify version information, such as I want to guide the 11g library (specific version of 11.1.0.6.0, open Sqlplus can see), then version=11.1.0.

The example in this article describes Java's approach to Oracle 11g RELEASE2 based on JDBC. Share to everyone for your reference. Specifically as follows: The JDBC connection for Oracle 11g Release 2 appears to be different if you receive the following exception:Listener refused the connection with the following error:ora-12505, Tns:listener does no currently know of SID given in C Onnect Descriptor.Then y

Tags: Session set EPO BSP Ongl important tips title IDTJob required, installed Oracle 11g, an error occurred while importing the backup data on other machines:IMP-00019: Deny row due to ORACLE error 12899IMP-00003: Encountering ORACLE error 12899ORA-12899: Column "ZHENG". " D_dic "." Dicexplain "value is too large (actual value: 140, Maximum: 100)This data sheet structure is injected directly, not at all. Later on the Internet to know the original is

Nothing's going on today. Installed Oracle database, but in this process encountered a lot of problems, here want to share with you.At first I installed the Oracle 12c, but this installation does not matter, Ann me a full half a day is not well, in the configuration of Security window there is no time, the current user does not have access to the temporary folder permissions, at that time, Baidu has a lot of online tutorials also has not been resolved, including online said the sharing of C-disk

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

New Features of Oracle 11g (36 in total) I. Database Management ·1. Database Replay) This feature can capture the load of the entire data and pass it to a test database created from the backup or standby database, and then repeat the load to test the system tuning effect. ·2. SQL replay (sqlreplay) Similar to the previous feature. However, it only captures the SQL load, rather than all the load. ·3. Plan Management) This feature allows y

Tags: rhel, rhel 5.8, Oracle, Oracle 11gFirst, prefaceRecently to prepare for the exam, ready to review the knowledge of Oracle database, then the premise of learning Oracle is definitely deployed, the current mainstream Oracle version is 11g, then we will first look at the next, How to deploy Oracle has opened and started databases for monitoring database operationsIi. Considerations for installing the Red Hat Enterprise Linux 5.8 Operating systemIns

information, this feature can package information related to an event. You can also send the packaging information to the Oracle Support Team.· Feature-based Patching)During patching, this feature makes it easy for you to differentiate the features in the patch package that you are using and must play. Enterprise Manager (EM) enables you to subscribe to a feature-based patch service, so Enterprise Manager can automatically scan for the features you are using with patches.· Auto SQL Tuning)The 1

used and that the different invocations of the statement use the same execution plan. A bound peek is no longer useful for generating a valid execution plan if different invocations of the statement derive significant benefits from different execution plans. A schedule does not always apply to all bound values, and in order to resolve this problem as much as possible, Oracle Database 11g introduces adaptive cursor sharing. This feature is a more com

Fault symptom Oracle Database 11g Database common user login prompt ORA-28002: the password will expire within 7 days[11: 01: 00oracle @ dvd db_1] $ sqlplus wang/oracleSQL * Plus: Release 11.2.0.1.0 Production on Fri Nov 16 11:01:23 2012Copyright (c) 1982,200 9, Oracle. All rights reserved.ERROR:ORA-28002: the password will expire within 7 daysConnected:Oracle Database 11g Enterprise Edition Release 11.2.0.