oim 11g

Oracle upgrades from 10g to 11g detailed stepsold Database 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 Here to Software 'sinstallationIt is not explained in detail, you can refer to the appropriate documentation. Here is the note: If you want to 11gr2 on the latest PSU or CPU, you can first at the software

This article mainly introduces the installation of Oracle 11g RAC and the creation and migration of 10g databases in the 11g RAC environment, and how to upgrade the database to the 11g version. The architecture of the 11g RAC and some new features of the 11g RAC are also ana

Many DBAs are still at Oracle 9i or 10g, possibly because of the Oracle 11g price issue. This article will explain the installation of Oracle 11g under Windows 7, and I hope you can see some of the new features of 11g. Recently unloaded their own Windows Vista system, installed on the Windows7 flagship version, in the installation process also encountered a lot

Many DBAs are still at Oracle 9i or 10g, possibly because of the Oracle 11g price issue. This article will explain the installation of Oracle 11g under Windows 7, and I hope you can see some of the new features of 11g. Recently unloaded their own Windows Vista system, installed on the Windows7 flagship version, in the installation process also encountered a lot o

In addition to the simple backup and recovery functions, RMAN has been given more and more responsibilities, such as creating Standby databases, such as cross-platform transfer of table space conversion. Oracle 11G's RMAN does not have many sudden updates. 1. Customize the archivelog deletion policy We know that before 11 GB, only the deletion policy of backupset can be defined, such as how long the backup is retained or how many valid backups are retained, however, to delete an archive log, you

Oracle announced the launch of a new database partner, network (OPN), at the time of Oracle Enterprise Manager 11g) resources and partners-oriented plug-ins and connectors for Oracle enterprise managers. To better develop, implement, and sell solutions based on the Oracle Enterprise Manager 11g. The new Ops Center Knowledge Area of the Oracle Enterprise Manager for Apsara stack Oracle helps partners quickly

In Oracle 10g, we can use the Asmlib library to create ASM instances, and Oracle has a lot more to offer than a separate download for the Enterprise Linux server image after Rhel 6. So we manage the device mappings used by Udev for ease of administration. In Oracle 11g, it is recommended to use Clusterware to manage resource conditions, and if we install a single instance of a grid, the configuration process is the same.Software Environment:1, check t

Modify the running time attribute of a job automatically calculated by the Oracle10g and 11g Systems Oracle 10g and 11g both have tasks for automatically collecting database statistics (10g and 11g job names are different), but the task execution time may be different from what we expected, such: the system will run on two full-day weekends, which will affect the

Delete Oracle 11g R2 in Linux 6.4 Close DatabaseSQL> shutdown [immediate] Stop Listener[Oracle @ ora920 oracle] $ lsnrctl stop If an application service exists, stop the application service first.[Oracle @ ora920 oracle] $ ORACLE_HOME/Apache/bin/apachectl stop Delete the installation directory[Root @ ora920/root] # rm-rf/opt/oracle/ Delete files under/usr/local/bin[Root @ OracleTest/root] # rm/usr/local/bin/dbhome[Root @ OracleTest/root] # rm/usr/loca

A small problem with the auto-scaling feature of Oracle 11g partitions, oracle11g It is very convenient to use the automatic partition Extension function in Oracle 11g, but it also brings about a problem, that is, after the export and import, the table creation statement is changed. Here is an experiment: SQL> select * from v $ version;BANNER------------------------------------------------------------------

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 wait is related to oracle's asynchronous io. T

Using rman for cross-database and cross-server migration10g server: 192.168.182.20.oracle 10.2.0.1.0 RHEL 4 32bit 11g Server:Server 192.168.182.131 OEL5.8 _ 32 Oracle 11.2.0.1.0 32bit[Oracle @ oelr5u8-1 admin] $ uname-Linux oelr5u8-1.localdomain 2.6.32-300.10.1.el5uek #1 SMP Wed Feb 22 17:22:40 EST 2012 i686 i686 i386 GNU/LinuxSYS @ PROD> select * from v $ version; BANNER--------------------------------------------------------------------------------O

Why cannot I enable ADG for Oracle 11g slave database? Today, we have encountered a strange problem, but there is an essential cause and effect behind the strange phenomenon.During an Environment check in the afternoon, it was found that the standby database was in the mount stage. This was a 11gR2 database, and it was a waste of time without ADG. I felt too much to do this.So I tried to start the open stage and found that the status was always read o

In Oracle 11g, use sysdba to connect to ASM.SQL> conn/as sysdbaSQL> alter diskgroup DATA mount;Alter diskgroup DATA mount*ERROR at line 1:ORA-15032: not all alterations saved medORA-15260: permission denied on ASM disk groupORA-15260: permission denied on ASM disk groupInform the permission to be rejected.[Root @ rac1 ~] # Su-grid> $ Sqlplus/as sysdbaSQL * Plus: Release 11.2.0.1.0 Production on Thu May 3 15:28:20 2012Copyright (c) 1982,200 9, Oracle.

Oracle 11g PL/SQL function result cache, oracle11g Two experiments have been conducted to simulate the Oracle Performance Diagnosis art. The book says that if you don't need RELIES_ON, then the changes to the objects on which the function depends will not result in the invalid result cache operation (result_cache RELIES_ON (test1, test2). The test proves that this operation is incorrect. The function f1 () does not use RELIES_ON, however, changes in t

In Oracle 11g, the lock mechanism is further enhanced, mainly reflected in the following three aspects: Serializing Locks Locking Tables Explicitly Sharing Locks Serializing Locks Some people also generalize this feature into DDL Wait options. In a Prod Database, DBA tries to change the table named SALES and add a column of TAX_CODE to it. This is a common task. When you execute an SQL statement similar to the following: 　 SQL> alter table sal

Solution for Oracle 11g forgetting SYS and SYSTEM passwords Oracle 11g forgets the SYS and SYSTEM passwords. The answer is simple: change the password! 1. First, log on to the SYS account using the operating SYSTEM authentication method and change the SYSTEM account password. $ Sqlplus/as sysdba SQL * Plus: Release 11.2.0.4.0 Production ction on Fri Mar 20 14:23:41 2015 Copyright (c) 1982,201 3, Oracle. All

Error Caused by Oracle 11g import to 10g Environment Introduction Old Environment New Environment Operating System: RedHat5.8 64-bit Redhat6.4 64-bit Database Version: Oracle 10.2.0.4 64-bit Oracle 11.2.0.4 64-bit Background: The old database rac was built based on oracle10g and has been running for several years. Now, the front-end application is ready to be upgraded. Considerin

New Features of Oracle 11g-HM (Hang Manager) In this article, we will introduce the new features of Oracle 11g-hang Manager. We need to note that HM only exists in the RAC database. When we diagnose database problems, we often encounter database/process hang problems. For hang problems, there are two common causes. Deadlock (cycle ). For such hang, the problem will always exist unless the loop is broken. A

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 database. The login user isSysdba* Enter the following command to different file paths: Sele