Database Administrator

TNS-03505 name cannot be resolved TNS-03505 name cannot be resolved Symptom: [Oracle @ db01 admin] $ tnsping pri  TNS Ping Utility for Linux: Version 11.2.0.4.0-Production on 15-JUN-2015 21:57:52Copyright (c) 1997,201 3, Oracle. All rights reserved.

ORA-12170: TNS: Connection timeout problem solved The virtual machine can access the database normally, but the physical machine connection to the database appeared "ORA-12170: TNS: Connection timeout", you can solve the problem with the following

Default MySQL test Database Permissions By default, the mysql. db table contains rows that allow any user to access databases starting with "test" and "test. The value of the User field in these rows is null, indicating matching any User. This means

Online Slave reports 1062 Cases Recently, the online Slave often reported a 1062 error. It broke the ground. Fortunately, Slave has not been used in the business for the time being. That is to say, there is no read/write splitting, so Slave has

Introduction to Kingshard MySQL Middleware Functions: MySQL table sharding and a series of MySQL operations such as adding, deleting, modifying, and querying tables. The master-slave architecture of MySQL can be expanded to facilitate distributed

Oracle Database basics-Installation I. Basic Database knowledge 1. Concept The Database Management System (DBMS) is a technology used in computers to manage, store, and share data. 2. Category Database development can be divided into the following

A simple test of orion Orion is a small I/O testing tool that can test random read/write and simulate mixed loads. This tool is already included in Oracle 11g, and does not need to be installed any more. It has brought a lot of convenience for I/O

Solution for installing Percona Xtrabackup in CentOS 6.5 Solution for installing Percona Xtrabackup in CentOS 6.5 1. download the latest version of Xtracbackup 2. Installation Yum install perl-DBIYum install perl-DBD-MySQLYum install

Password maintenance in DataGuard Environment The motivation of this article is a friend's question. He asked me if the password file of the slave database can be directly re-built. I said it is best to copy it. If re-built, there may be some

MySQL Internal-InnoDB Storage engine (row structure) Three parts of InnoDB Row Storage (Description: Number of columns in the F branch table) Name) Size) Field Start Offsets (F * 1) or (F * 2) bytes Extra Bytes 6

Oracle lag () and lead () Functions I. Introduction The lag and lead functions are two offset-related analysis functions. These two functions can be used to retrieve the data of the first N rows of the same field in a query (lag) and the next N rows

Description of PostgreSQL lock query and killing Process Query the locks in the table. Select a. locktype, a. database, a. pid, a. mode, a. relation, B. relname From pg_locks Join pg_class B on a. relation = B. oid Where upper (B. relname) = 'table _

An example of ORA-00600 troubleshooting Executing a query in the database throws a ORA-00600 error exception ORA-00600: internal error code, arguments: [kcbzibmlt_lobds_1], [], [], [], [], [], [], [], [] [], [] View related trace files DDE: Problem

Mongodb installation and basic search operations: Learning and organizing (1), mongodb search **Install and configure MongoDB in windows: **Installation references: http://www.cnblogs.com/jiaxuekai/p/7204716.htmlHttps://jingyan.baidu.com/article/ed1

[C3p0] Article 1: a simple introduction to c3p0,Preface According to the c3p0-0.9.5.1 version of the official documents, coupled with their own understanding, compiled into the translation. Limited capabilities. If the translation content is

Error code: 1066 Not unique table/alias: 'C', 1066 unique 1. Error description 1 queries executed, 0 success, 1 errors, 0 warnings query: SELECT (select concat (s. name, '/', sr. reame, '[', DATE_FORMAT (. startTime, '% Y-% m-% D'),'] ') FROM

• Description of DML and restored data generation • Monitoring and Management of restored data • Description of differences between restored data and redone data • Configuration of restoration retention time • guaranteed restoration retention time •

Oracle Database is a very popular database system. Many large websites use Oracle. It is favored by users because it has the following outstanding features: 1. Supports high-performance transaction processing for large databases and multiple users.

Connect to the application Each application needs to identify the database server to which it connects to for data retrieval. You can use a connection string to connect an application to a database server. The typical connection string is as follows:

After installing Oracle 10 Gb, I want to enable SQL * plus for learning, and then follow the steps in the book to connect to the database with scott user. After the installation, an error is prompted several times. Error: the account is locked Then