Database Administrator

You can use the PKG format of the binary installation package to install MySQL in Mac OS X 10.2.x ("Jaguar") and later versions instead of the binary distribution version. Note that this software package does not support earlier versions of Mac OS X

Recently, the disk space of the Oracle server in the development environment is full, so I began to delete things everywhere and finally delete the files. I started to think about oracle data files again, due to the lack of knowledge about oracle,

It is troublesome to optimize an SQL statement before Oracle 10 Gb. However, the SQL Tuning Advisor tool launched in Oracle 10 Gb can greatly reduce the workload of SQL optimization, however, to use SQL Tuning Advisor, make sure that your optimizer

GXPT is a distributed system that temporarily includes the permission system, basic system, evaluation system, and examination system. Each system has its own oracle database. Our group is responsible for the evaluation system, and the normal

The EBS system password is divided into four types. The change of password must comply with the regulations and specifications, especially backup.1. Operating System users, such as root, ora, appl, and grid users.[Modification method] use the OS

Redis's memory storage structure is a large dictionary storage, which is also known as a hash table. Redis can store tens of thousands of records of CACHE and tens of millions or even hundreds of millions of records (depending on the memory), which

I. Environment Introduction SQL ServerPRINT @ VERSIONMicrosoftSQLServer2012-11.0.2100.60 (X64) Feb10201219: 39: 15 Copyright (c) microsoftconfigurationenterpriseedition: Core-basedLicensing (64-bit) onWindowsNT6.1 (Build7601: ServicePack1)

Introduction to Oracle Trading Community Architecture (Oracle chloroform)Introduction Oracle Trading Community Architecture (chloroform) is a data model used to manage complex Party or customer information in a business environment, including

The slow query log of mysql database is a very important auxiliary log for tuning. However, the log format recorded by mysql by default is not friendly enough to read. This is determined by the mysql Logging rules, capture one log. Although the

Restoring oracle 10g RAC [restoring OCR] ---- Query OCR status:#/Oracle/product/10g/crs/bin/ocrcheckPROT-601: Failed to initialize ocrcheck  --------- Replacing the original OCR disk, an error occurred:#/Oracle/product/10g/crs/bin/ocrconfig-replace

Install the Oracle 11g Database on RHEL 6.3, check the dependency of the package during installation, and find that the pdksh-5.2.14-1.i386.rpm package is missing, while installing the pdksh-5.2.14-1.i386.rpm package, find this package conflicts

Oracle 10g officially certified operating system version Operating system x86Red Hat Enterprise Linux AS/ES 3 (Update 4 or later)Red Hat Enterprise Linux AS/ES 4 (Update 1 or later)Oracle Enterprise Linux 4 (OEL4)Red Hat Enterprise Linux AS/ES

Github: https://github.com/ZhangzheBJUT/blog/blob/master/mgo.md MongoDB has not yet released the official support for golang driver, it is recommended to use the detailed documentation of mgo. mgo: http://godoc.org/labix.org/v2/mgoThe following is a

When using RMAN to copy a physical standby database, it is prone to errors and the error is very strange.The author summarizes the following points. 1. RMAN-04006 ORA-12528 Start the slave database to nomount SQL> startup nomount & nbsp;The Oracle

HIVE Row_Sequence achieves column auto-Growth Package org. rowsequence; Import org.apache.Hadoop.hive.ql.exe c. Description;Import org.apache.hadoop.hive.ql.exe c. UDF;Import org. apache. hadoop. hive. ql. udf. UDFType;Import org. apache. hadoop. io.

-Add a temporary Column Alter table tablename add filedname_temp number (2 ); -Leave the value of the temporary column empty. Update zyt set id_temp = null; ----- # alter table tablename modify filedname null; -The field value to be updated is

Compared with performance, DB2 import and load log records are slow, and data records are too large, which may cause full transaction logs. However, some operations have to be logged, therefore, it is not applicable to import. However, it can be

Replica Set basic Replica Set is a decentralized backup mode provided by mongodb (mongodb also provides master-slave deployment and sharding mode). Each mongod can be a master, A primary is automatically selected in the replica set, and the others

Conclusion: -- two single-instance databases are used as DG and the database version is 10.2.0.1.0.1. Configure the master database as arch async, And the slave database does not have a standby log.The log contains: RFS [4]: No standby redo logfiles

Today I encountered a strange problem: Using sqlplus on the client allows normal users to log on, but neither system nor sys users can log on, prompting ORA-12154: TNS: unable to resolve the specified connection identifier [@ More @] SQL> conn