Database Administrator

Oracle shared service connects to static registration service, oracle static Oracle shared service connection static registration service By default, the oracle shared service is registered to the dynamic registration service.Sys @ PROD3> select *

(13) Process Control in mysql and 13mysql Process Control Overview In mysql, you can use the if/case/loop/leave/iterate/repeat/while statement to control the process. If statement If statement,Similar to if statements in advanced languages (c/c

About the OGG stats process name reset command, the oggstatsreset command Oracle GoldenGate Command Interpreter for OracleVersion 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100 Linux, x86, 32bit (optimized), Oracle 10g on Oct 4 2011 23: 54: 04

The transaction log for database 'xx' is full, Error: 9002, Severity: 17, State: severity Check database logs with the following error message: Error: 9002, Severity: 17, State: 4.The transaction log for database 'SharedServices1_Search_DB' is full.

Excel uses ADO to call SQL Server Stored Procedures and ado stored procedures Test environment: SQL Server 2014, Excel 2013 Excel example File Download: http://download.csdn.net/detail/zhanghongju/8533555 In the early stage, I made a small software

Use nodejs mongodb to connect to mongodb's shard distribution service, nodejsmongodb 1. For more information about connecting to a single mongodb instance, see the node mongodb documentation. Https://github.com/mongodb/node-mongodb-native 2.

Navicat connection oracle error: ORA-12737 Instant Client Light: unsupported server character set ZHS16GBK, navicatora-12737 Today I used Navicat to connect to the Oracle database and reported the following error: "ORA-12737 Instant Client Light:

Path to mathematics-sas memo (10), path to mathematics-sas memo Merge combines two or more data sets. Libname saslib "k: \ sas "; DataSaslib. goodsprice; Input id name $ price6.2; Datalines; 1 mouse 35.6 2 Keyboard 28.95 3 mouse pad 8.2 4 headsets 29

SQL -- Process Multi-condition query and SQL page query on the page Two methods are used to process multi-condition queries in the past. The first method is to determine the fields to be filled in the condition, and then determine whether the

Spring dynamic multi-data source instance Demo and spring dynamic instance demo Recently, many people have consulted Spring on how to configure multiple data sources. It is troublesome to answer the questions one by one, and the configuration in

Sybase ase xa distributed transaction support, sybaseasexa By default, Sybase ASE installation does not support XA.You must obtain the DTM License from Sybase. The SYSAM service is not started by default. SYSAM is a service that manages various

Mysql HA-Install Keepalived + LVS + Mysql (dual master) On Redhat 6.3, keepalivedlvs Host information: Scheduling node: Name: lvsOS: Redhat 6.3IP: rule: 192.168.56.236 data node 1: Name: rule: Redhat 6.3IP: 192.168.56.230 data node 2: Name:

Shang Silicon Valley-mybatis Quick Start,-mybatis Quick Start1. Introduction to Mybatis (ibatis) MyBatis is an excellent persistent layer framework that supports common SQL queries, stored procedures, and advanced mappings. MyBatis eliminates the

MySQL query cache settings improve MySQL query performance and cache mysql First, let's take a look at the MSYQL logical framework: The image comes from high-performance mysql   If QueryCache is used, the server will retrieve the results from

[Synchronous replication common error handling 3] The Stored Procedure sp_MSins_tablename cannot be found, and the stored procedure cannot be found An error occurred while synchronizing the environment to SQL2008 R2 The error message is that the

SQL Server setup media does not support the language of the OS or does not have ENU localized files., setupfilesWhen you click setup.exe to install sqlserver2008of win7 64, SQL Server setup media does not support the language of the OS or does not

Oracle table data recovery and oracle Data Recovery When you accidentally delete data in a table for table data recovery, you generally do not need to operate on the table any more. You can recover the data in the table as follows. Scenario: If

Oracle FGA fine-grained audit and oraclefga fine-grained Audit If you want to audit the table, it is a good choice to use FGA for a certain period of time, persons and DML statements. SQL> select * from v $ version;Oracle Database 11g Enterprise

The obsolete maintenance command crs _ *, 12ccrs _ in Oracle 12c RAC _   Crs_stat is commonly used in Oracle 10g and 11g RAC to monitor the running status of RAC. However, the crs_stat display is incomplete, so we will perform a secondary

The error message "pldeveloper" appears when PL/SQL Developer connects to a 64-bit database. Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you