oracle 12c database new features for dba

BKJIA San Francisco site report] at the 2009 Oracle Global Conference OpenWorld, OOW, everyone is not new to Oracle new database machine Exadata V2 challenge IBM database machine pureScale. However, the current understanding of th

Install Oracle 11.2.0.4 database software and then execute root.sh, this is nothing special, slightly.After that, we need to modify the Oracle binaries permissions for Oracle RDBMS so that the Oracle database process can get the A

Tags: style blog http io ar color OS using SPOriginal: How to create a new Oracle databaseThree ways to create a new Oracle database:1. Create a configuration or delete a database by running the

DSGRealSync copies all data in the production database or some tables to the target system in real time by means of transaction replication. IT personnel can enhance the new enterprise IT system through the target system. DSG RealSync replicates all data in the production database or some tables to the target system in real time by means of transaction replicatio

1.dbms is built on the operating system, so the operating system to be familiar with the operation, especially the server UNIX system-based, the general understanding of UNIX is not as good as windows, so need to learn.Common knowledge to learn: directory structure, file and folder operations, user management, user profiles, system resources and load viewing, configuration, installation packages2.oracle Learning① First is SQL,② Second, we first unders

Oracle's sequence implementation is very flexible, so it also brings about some usability issues. How to obtain the sequence value generated by the new inserted records is significantly different from other databases, this document introduces five methods for reading the sequence Value of the newly inserted record. Database scripts used for testing: SQL> create table T1 2 ( 3 ID NUMBER 4 ); Table created

DSG RealSync database real-time replication software A new generation of real-time heterogeneous heat disaster recovery-Oracle Database IT systems have been running for a long time. On the one hand, their functions are getting greater and greater, and enterprise operations depend strictly on the normal operation of IT

Set the environment variable TNS_ADMINoracleproductapp5networkadminsamples to read the new tnsnames. ora location. You can use the client to connect to the oracle program. Set the environment variable TNS_ADMIN =/oracle/product/app5/network/admin/samples to read the location of the new tnsnames. ora, and use the client

/* divided into four steps *//* Step 1th: Create a temporary tablespace */Create temporary tablespace kmyf_tempTempfile' E:\app\pangxy\product\11.2.0\dbhome_1\kmyf_temp.dbf ' size 50m autoextend onNext 50m maxsize 20480m extent management local;/* Step 2nd: Create a data table space */Create tablespace kmyf_data LoggingDataFile ' E:\app\pangxy\product\11.2.0\dbhome_1\kmyf_data.dbf ' size 50m autoextend onNext 50m maxsize 20480m extent management local;/* 3rd step: Create user and specify Tablesp

In the graphical interface environment for Oracle_home/oui/bin, run addnode.sh, for the new node to add the process: $ cd $ORACLE _home/oui/bin $./addnode.sh Starting Oracle Universal Installer ... No pre-requisite checks found in Oraparam.ini, no system pre-requisite checks would be executed. Oracle Universal Ins