oracle 11g end of support

* from dual; D-X Store @ TEST> alter system set SQL _trace = false; The system has been changed. Store @ TEST>! Cat/opt/oracle/db/diag/rdbms/test/TEST/trace/TEST_ora_5555.trcTrace file/opt/oracle/db/diag/rdbms/test/TEST/trace/TEST_ora_5555.trcOracle Database 11g Enterprise Edition Release 11.2.0.1.0-ProductionWith the Partitioning, OLAP, Data Mining and Real App

Tags: Oracle 11g grid InstallationOracle 11g Grid Installation1. Create Oracle users and user groupsGroupadd OinstallGroupadd dbaUSERADD-G oinstall-g dba-m OracleTo set the password for an Oracle User:passwd OracleI'm set up here for Oracle2. Create related catalogueMkdir-p/

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

--------------------------------------------------------------------------------------------------------------- ---------------------------Rman> Show snapshot controlfile name;Rman> Configure snapshot Controlfile name to '/STORAGE/SNAP_CONTROL/SNAPCF_%D_%I_%S_%P_%T.F ';Rman> Configure snapshot Controlfile name to ' +DATA/ORCL/SNAPCF_ORCL.F '; --can also be specified to the corresponding ASM disk group (disk group does not support wildcard naming)After

,sysdate-1);Commit 2. Exporting and importing data Exp cannot be used because this is a new feature and EXP does not support Exp Test/[email protected] file=d:/call_log.dmp Tables=soa_call_logC:\users\administrator>exp Test/[email protected] file=d:/call_log.dmp Tables=soa_call_logExport:release 11.2.0.1.0-production on Tuesday June 16 16:49:27 2015Copyright (c) 1982, the Oracle and/or its affiliates. All r

storage management is a common practice for many sites.ASM can be managed through Sql*plus, Enterprise Manager (Dbconsole), or DBCA. In Oracle 11g Release 2, ASM is now part of the grid infrastructure, whether in a single-instance or RAC environment. A new configuration Assistant ASMCA accepts and expands the functionality provided in the 11.1 dbca. ASM can no longer be launched from outside the RDBMS

The methods for uninstalling the Oracle 11g server and client and installing the Oracle 11g server and client have changed with those of the previous versions: 1. Preparations before uninstalling: choose "start"> "Settings"> "Control Panel"> "Administrative Tools"> "services" to stop all

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 sim

I. Overview Performance risks may occur when the SQL Execution Plan of an SQL statement is changed. There are many reasons for changing the SQL plan, such as the Optimized Program version, optimized program statistics, optimized program parameters, solution definition, system design, and SQL profile creation. In earlier versions of Oracle DB, various plan control technologies (such as storedoutline (9i) and SQL profile (SQLprofile (10g) were introduce

July 2014, wrote an article about EF5 with Visual Studio, Oracle 11g, the original address: http://www.cnblogs.com/HouZhiHouJueBlogs/p/ 3844028.html, Oracle is now supported to EF6. Technical update fast, some details such as not recorded, it is easy to be forgotten, so there is this blog post.　　Some basic knowledge of. NET s