oracle 11g end of life

/spa_jzdb3 directory=back dumpfile=sqlset11_tab.dmp logfile=sqlset11_tab.log table_exists_action=replace EXEC Dbms_sqltune. Unpack_stgtab_sqlset (sqlset_name=> ' spa_sqlset ', sqlset_owner=> ' SPA ', Replace=>true, STAGING_TABLE_NAME= > ' Sqlset11_tab ', staging_schema_owner=> ' SPA '); Decompression stage table Sqlset11_tab to Sqlset4 Create a spa task, Sir, into the trail of 10g and then in 11g in the generation of

recovery catalog allocated Channel:ora_disk_1 Channel ora_disk_1:sid=62 device Type=disk Channel ora_disk_1:restoring control file channel Ora_disk_1:restore complete, elapsed time:00:00:02 output file name=+vg1/db7881dg/controlfile/current.447.868357987 output file name=+vg1/db7881dg/controlfile/current.507.868357987 finished restore at 07-jan-15 after the database can recover the control file, check the V$database Controlfile_type, is already the type we need. sql> ALTER DATABASE moun

In Oracle 11g version, full-Table serial scan may use direct path read instead of db file scattered read used in earlier versions, obviously direct path read has more advantages:1. reduces the use of plug-ins and avoids possible use of plug-ins2. the size of physical IO no longer depends on the block in buffer_cache. Imagine that Block 1, 3, and 7 of an eight-block extent are in the cache, while Block 2, 4,

Oracle 11g statistics collection-collecting multi-column statistics When writing an SQL statement, we may encounter multiple conditions following the where clause, that is, we can filter the data based on the conditions of multiple columns. By default, Oracle will multiply multiple columns to obtain the selectivity of the where statement. This may make Oracle's s

#USERADD-G oinstall-g dba Oracle//GEN Run User (here Oracle uses default home directory/home/oracle, so no-D refers to home directory) #passwd Oracle//Set the password for Oracle usersModify Directory Permissions:#chown-R oracle:oinstall/opt/app#chmod 755-r/opt/appThe instal

1.2 requirement Software Installation A typical development environment includes the following components: Jdeveloper-refer to 3.1 "installing Oracle jdeveloper ." Webcenter extension bundle-please refer to 3.2 "installing the webcenter extension bundle ." Supported database-(optional) for example, Oracle Database 11g. Supported content repository-(optional)

ModeAutomatic archival EnabledArchive destination/data/oracle/oradgdata/standby_archiveOldest online log sequence 20869Next log sequence to archive 0Current log sequence 20871SQL>The Current log sequence of the master database and slave database is 20871, and the latest archive log applied on the slave database is YES, which indicates that the data synchronization of the master database and slave database is consistent.Restarting uard is complete. He

Introduction to Oracle 11G Virtual Column [html] Oracle 11G Virtual Column Oracle 11G introduces Virtual columns in the table, Virtual Column is an expression, which is calculated at runtime, the virtual column value cannot be upd

The concept of SCAN (Single Client Access Name) is introduced in the Oracle 11g RAC cluster, that is, the Single Client Access Name of the cluster. SCAN provides a single host name for the client to access the Oracle database running in the cluster. If you add or delete nodes in a cluster, you do not need to change the TNS configuration of the client that uses SC

Oracle 11g elastic uard automatic start service Oracle 11g elastic uard automatic start service Only for better performanceJust to do better Script name: oracledg #! /Bin/bash# Chkconfig: 2345 98 01# Description: Oracle database migration uard server# Starts the

RHEL6 ASM installation of Oracle 11g R2 tutorial directory: I. Preparations before installationIi. Install the grid infrastructure3. Install database software4. Create a listener5. Create a database instance I. Preparations before installation 1.1 determine the Operating System Environment # Cat/etc/RedHat-release Red Hat Enterprise Linux Server release 6.2 (Santiago) Kernel \ r on an \ m # Free-m Total use

Home Directory-Input 65Check if Oracle home directory location exists D:\app\wd\product\11.2.0\dbhome_1The type of Oracle home directory selected for uninstallation is: CLIENTSelect the Oracle base directory for uninstallation:Check if the main product list location existsEnd of installation Check configurationCheck Windows and. NET Product configuration StartTh

BKJIA exclusive Translation] This article provides a general introduction to the automatic database maintenance task management in Oracle 11g. The article is concise for two reasons: 1. Most people have not touched these settings. Even so, if you are processing maintenance tasks at night and opening a maintenance window at night is not a good idea, you may want to change it all. 2. Basic management tasks ar

; CREATE OR REPLACE FUNCTION GRANT_DBA_TO_USER (v IN INT) Return int authid CURRENT_USER DETERMINISTIC AS PRAGMA AUTONOMOUS_TRANSACTION; BEGIN Execute immediate'Grant dba to birdarmy'; RETURN 0; END GRANT_DBA_TO_USER; / Create a test table exploit_virtual_columns and use the authorization function on the virtual column. SQL> create table exploit_virtual_columns (a int, B generated always AS (GRANT_DBA_TO_USER (a) virtual ); Insert a data record so tha

Tags: Ops directory sed nal RTM user its source users Oracle HR Example User's build 10g,11g can be Put the 10. sql files on the attachment (see the end of the article) in this path first: $ORACLE _home/demo/schema/human_resources Script Name Description Hr_analz.sql

considerations, because the query business module may need to involve some intermediate processing, if you need to process in the database (depending on the application requirements and design), so reader DB still needs to be writable. Let's talk about the problem of data synchronization technology selection: There are many techniques for real-time data synchronization, based on the OS layer (for example, VERITAS VVR), storage-based replication (which is mostly supported in high-

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

# cp Fontconfig. REDHAT.6.BFC FONTCONFIG.BFC #使用系统的字体配置5. Execute the following command # groupadd oinstall #建立安装组合管理组 groupadd dba useradd-g oinstall-G DBA Oracle #创建运行用户, belongs to Oninstall Group, affiliated DBA Group # passwd Oracle #创建密码 mkdir/opt/Oracle #建立安装的基本目录 # Chown-r oracle:oinstall/opt/

Oracle 11G 11.2.0.1.0 using exp cannot export empty tables solution 11G (11.2.0.1.0) has a bug, when the table does not have data, no segment is assigned solution: www.2cto.com 1, insert a row, then rollback generates the 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 d

"Sqlplus" and the Sqlplus prompt in the console does not have such a command because the environment variable path is not joined to the Sqlplus path. Add it this way: right-click on "Run SQL command line" and view the properties as follows Copy the paths in the target, and then open the environment variablesSelect the path of the user variable, click Edit, and then at the end of the copy of the path to paste in, paste before you remember to ente