Database Administrator

Configure the Oracle database environment using Python 1. download and install the cx_Oracle installation package To operate the Oracle database using Python, you must first install the cx_Oracle package as

Blocking blocked in RAC Environment) The blocking in the RAC environment is different from that in a single instance, because we need to consider the session in different instances. That is to say, the corresponding strain of the previously queried

Oracle 11g Release 1 (11.1) PL/SQL Collection methodContent EXISTS Method COUNT Method LIMIT Method FIRST and LAST methods PRIOR and NEXT Methods EXTEND Method TRIM Method DELETE Method   CollectionThe method is a built-in PL/SQL

Online expansion of database UNDO tablespace Expand the database UNDO tablespace online and log on to the Oracle database server with an Oracle account Method 1: View the tablespace name and file location: Select tablespace_name, file_id, file_name,

Install the MySQL5.6 service on the CentOS Virtual Machine of Win71. Download the installation package Mysql5.6: Http://dev.mysql.com/downloads/mysql/ Select the linux version here: -------------------------------------- Split line -----------------

Simple MySQL database access using C language Unlike Oracle, MYSQL databases do not support embedded SQL languages. However, it provides powerful C and C ++ support APIs. The C language API is in part 1 of the Reference Manual, and is independent of

Oracle password files and logon methods Preface: As we all know, the Oracle database has a password file, which is used to log on to the database and perform a series of mount and open operations when the database is not started; The experiment

Common Oracle ASM commandsIn the Oracle RAC environment, run asmcmd with the grid account to enter the asm command mode, for example: [Grid @ oradb-node1 ~] $ Asmcmd ASMCMD>   ASMCMD> du // display all disk space occupied by the ASM file in the

How to solve ORA-12170 TNS connection timeout Recently, when I suddenly connected to the local Oracle database through plsql for a while, I reported that the ORA-12170 TNS connection timed out! The phenomenon is that the network is not connected

Oracle NULL values 1. What is NULL?NULL indicates UNKNOW (unknown), which does not represent any value. For example, if a column in a row does not have any value, it is NULL.Oracle allows blank fields of any data type, except for the following two

Solution to impdp exceptions and interruptions Check the database load today and find that the cpu consumption is abnormally high. There are many dw processes, but the impdp process does not exist.Check the process of datapump and find a large

How to update a table using query results in Oracle Oracle uses the results of one query to update the data of another table. The simulation experiment is as follows. Use the query results of table t2 to update data with the same id as table

11g rac rebuilding the SPFILE of the ASM instance 1. PrerequisitesYou need to know the following information:1) number of nodes2) the location of the disk included in the ASM disk group3) There are several disk groups for the instance. 2. Steps and

Oracle 11gR2 RAC installation error-clock not synchronized System Environment: Operating System: RedHat EL5 Cluster: Oracle GI (Grid Infrastructure) Oracle: Oracle 11.2.0.1.0 : RAC System Architecture For Oracle 11g RAC, the first thing to do is to

MySQL sets utf8mb4 Encoding There is a project that needs to store ios emojis)Although this type of expression is UTF-8 encoded, a single character occupies 4 bytes, while MySQL utf8 encoding can only store 3 bytes of characters.In MySQL 5.6, you

[Translated from mos] Method of rebuilding control file, mos Reconstruction Reconstruction of Control Files Reference Original:How to Recreate a Controlfile (Doc ID 735106.1) Applicable:Oracle Database-Enterprise Edition-Version 9.0.1.0 and

In the linux oracle 10g/11g x64bit environment, goldengate automatically starts with the OS, x64bitgoldengateIn linux and oracle 10g/11g x64bit environments, goldengate automatically starts with the OS.Background description:Goldengate is installed

PHP redis operations summary, phpredis class MyRedis {private $ redis; /*** @ param string $ host * @ param int $ post */public function _ construct ($ host = '10. 102.1.8 ', $ port = 6379) {$ this-> redis = new Redis (); $ this-> redis-> connect (

Oracle GoldenGate (ogg) 11.2.1.0.20 is the last ogg version that supports oracle db 10 Gb, oracle11.2.0.4 Reference Original: Oracle GoldenGate 11.2.1.0.22 Patch Set Availability (Doc ID 1669160.1) This article does not translate and only

Key and constraint in SQLSEVER, and SQLSEVER Constraint SQL Server has five types of constraints: PRIMARY KEY constraint, FOREIGN KEY constraint, UNIQUE constraint, DEFAULT constraint, and CHECK constraint. To view or create constraints, you must