Database Administrator

Output MySQL logs to syslog In the chroot environment I have been learning nodejs and angularjs over the past few months. I am still working on front-end development. I will share some experiences later. One problem we encountered in the past two

Oracle reconstruction Enterprise Manager 1. First create a listener[Root @ primary ~] # Xhost +Access control disabled, clients can connect from any host[Root @ primary ~] # Su-Oracle[Oracle @ primary ~] $ Netca Annotation: The LISTENER name

Data synchronization between Oracle GoldenGate databases on Heterogeneous OS Oracle GoldenGate (hereinafter referred to as OGG) synchronizes data between databases of the same type on Heterogeneous OS. Functions implemented by ogg: It can be refined

Oracle 11g uses DML Error Logging to avoid bulk insert failure Use DML Error Logging to avoid bulk insert failureIf an error occurs when an insert statement with a subquery is used to load data. the system terminates the statement and rolls back the

Installing Oracle Block Browser and Editor tool (bbed), installingbbedBBED is an internal ORACLE tool. Generally, BBED is used to restore faulty databases, for example, if the data file header is inconsistent due to power failure or abnormal

How to "play" and "play"Today, I tried to share my story with you how to "play", the topic of today. Do you have any experience like this? Open your circle of friends and you will no longer hear from your friends, some personal pictures of friends

[Root @ localhost ~] # MongoMongoDB shell version: 1.8.1Connecting to: test> DbTest> Show collectionsData_testSystem. indexesSystem. users> Db. data_test.find (). skip (3). limit (4) // query by PAGE, starting from 4th records, 4 records per page.{"_

The Toad for Oracle tool was used in further projects. It was easy to use. Although there were too many things stacked on the interface, it felt a little messy, but it was actually quite helpful. After logging on to the database, you can use the

I. Environment preparation1. experiment environmentOperating System: Oracle Enterprise Linux 5.6Virtual Machine version: VMware 8.0Virtual Machine Hardware configuration: processes 1, ram 1G, disk type SICS, disk size 30G, Nic type NATWhen

Statistics of SQL Server research-discover and process expired statistics, and analyze SQL statisticsPreface: Statistical information is the main source of information about data distribution in predicates. If you do not know the specific data

[Ora10, 4] oracle background process Introduction:, ora10oracle1. SMON (System MONitor) System monitoring process: During database startup, SMON is placed after the CKPT process and in Oracle9i, it is placed at the sixth position: PMON started

Oracle batch export AWR reports, oracle export awr Work requirement: in the project, all the AWR reports in the production database must be dumped and imported to the database for testing convenience. The AWR report in the test database needs to be

Obtain the SQL Server installation time and SQL Server installation time. The latest installation of SQL Server 2014 does not have a formal License. You can only try it for three months. To know when it expires, you must know when SQL Server 2014

Deepen understanding of Oracle outer connections (left/right/full), inner connections (oracleinner), andOracle's left join, right join, and (+) Outer Join types are always confused. The experiment is used to deepen the understanding of the

Mysql remote connection is acceptable. Local Connection reports an error. mysql local connection Use the MySQLdb library of python to connect to the local mysql database. The error is as follows: File "/usr/lib/python2.7/dist-packages/MySQLdb/_

Mongo scatter -- aggregate & Query, aggregate aggregation Mongo Official Website: http://www.mongodb.org/ Mongo is used in work, but Mongo has not been systematically studied. It only records some knowledge points in the use of Mongo during work

Summary of the advantages and disadvantages of the five ORACLE tables:1. Normal table: Suitable for most design scenarios, with advantages and disadvantages.Advantages:A. The syntax is simple and convenient.B. Suitable for most

Some time ago, I helped a friend recover a damaged dmp file, which is more than 100 Gb. I recorded the recovery process and briefly summarized it.I. DescriptionThis dmp file is exp from an Oracle 9i Database. Two types of errors may occur randomly

1. installation environment: Red Hat Enterprise Linux 5.4, memory is not less than 1 GB, hard disk is greater than 8 GB, Linux address 192.168.1.80 in this environment. Oracle version: 10 GB Installation steps: 2. Modify the hosts

% T: Number of the redo thread. % S: log serial number. The ID value of % rRESETLOGS. These three matching characters must exist. If the online configuration file format is used, you must restart the database. 10.1 view the location where archive