Database Administrator

Use awk to parse dump files Dump files are often encountered at work. Sometimes a dump is obtained, but more information is not provided, which may cause problems during import. If a user's default tablespace is user, but the table's tablespace in

Summary of Oracle rebuild table (rename) Considerations I. OverviewSome time ago, a DBA friend failed to run the business on the morning of the next day after he finished the rename operation and encountered the restriction and error that the data

Format of mysqladmin tool: Mysqladmin [option] command [command option] command ...... Option options: -C number indicates the number of automatic runs, which must be used with-I. -How long is the I number interval repeated? Check the status of the

MySql Chinese garbled problem (3), mysql Chinese garbled Problem The MySql client is on the dos interface, but the default character set encoding method on the dos interface is: GBK (1) MySql character conversion Principle (2). view all the

Dynamic SQL (Chapter Summary), dynamic SQL Chapter Summary1. You can use dynamic SQL to create a subroutine when the dependent object does not exist.2. dynamic SQL mainly uses EXECUTE IMMEDIATE statements to EXECUTE DML, DDL, DCL, and other

Single-line functions (Chapter Summary), Chapter Summary1. single-row functions can complete many independent small functions.2. The main function of a character function is to process string data, such as converting a string into uppercase,

New mysql third-party tools cannot be connected, mysql third-partyMysql cannot be connected from the client to the server. The company uses Mysql for a test and starts to build a local Mysql database and connect it to it. No connection failure has

[Translated from mos] If SCHEMATRANDATA is used in OGG (Oracle GoldenGate), additional db patches are required, When SCHEMATRANDATA is used in OGG (Oracle GoldenGate), additional db patches are required. Reference Original:Patches needed to support

Initialization error cocould not load ".../oci. dll", oci. dll When you connect to the Oracle database using PL/SQL, the following error occurs: Initialization error Cocould not load "F: \ oracle \ bin \ oci. dll"OCIDLL forced to Foracle \ bin \ oci.

Rman backup times: ORA-02396: exceeded maximum idle time, rmanora-02396 Rman backup times: ORA-02396: exceeded maximum idle time Reference Original:RMAN backup faling with ORA-02396: exceeded maximum idle time, please connect again (Doc ID 1446182.1)

GoldenGate process abend, error for OGG-00868 ORA-02396: Exceeded Maximum Idle Time, Please Connect Again, ogg00868 GoldenGate process abend, error for OGG-00868 ORA-02396: Exceeded Maximum Idle Time, Please Connect Again Reference

MySQL Regular Expression search, mysql Regular Expression The products table is as follows: 1. Basic Character matching The difference between regular expression and LIKE is that regular expression searches for the entire column, As long as prod_

Share the Memcached shell startup and stop script, memcachedshell Note: To use this shell, you must first successfully create the memcache environment 1 and create the memcached file and permission [root @ luozhonghua ~] # Touch/etc/init.

Mongodb Install mongodb I think mannual install is a little more reliable: http://docs.mongodb.org/manual/tutorial/install-mongodb-on-os-x/ Start mongodb $ Mongod Connect to mogodb $ Mongo Mongo> use monk-app Mongo> db. products. insert ({"name":

Navicat software sets the applicable scope for connecting to the mysql database and the scope of demonstration tools: All mysql series (including mysql in Linux and Windows)Demo tool: Navicat 8.0 MySQLDemo system: Windows2003 system navicat

Symptom:GG does init data load, error OGG-01192, OGG-0166810:43:44 ERROR OGG-01192 Oracle GoldenGate Capture for Oracle, ext2.prm: Trying to use RMTTASK on data types which may be written as LOB chunks (Table: 'portal. UNID_PAPER ').10:43:44 ERROR

When 64-bit Oracle 10g is installed on Oracle Linux Server Release 5.7, the following problems are encountered: Error in invoking target 'install' of makefile'/u01/app/oracle/product/dbhome_1/ctx/lib/ins_ctx.mk '. See

1. An error is reported when Oracle is started. SQL> startup Error: ORA-03113: end-of-file on communication channel View the alert. log File and find ORA-03113: end-of-file on communication channelCannot reclaim 45680128 bytes disk space from 2147483

SQL> /*SQL> SQL statementsSQL> 1. DML Statement (Data Manipulation Language): insert update delete selectSQL> 2. DDL Statement (Data Definition Language): create/alter/drop/truncate tableSQL> create/drop view, create/drop index (sequence,

This article is to translate the MongoDB Production Notes section in MongoDB Manuel. This section focuses on considerations that affect performance and reliability in the production environment, and deserves the attention of those who are deploying