Database Administrator

Oracle Database Remote Access through DBLINK What is DBLINK? A Database Link is a Database Link, just like a telephone line. It is a channel. When we want to access data in another Database table across local databases, you must create a dblink for

1. Install Firebird in the new IDE of Ubuntu 2. Install Firebird Management Tool FlameRobin in Add/delete 3. change the password of firebird: sudo passwd firebird 4. change the password of the database administrator SYSDBA in firebird: sudo

CentOS 7.0 use yum to install simple configuration of MariaDB and MariaDB I forgot about the environment configuration of the space that has been idle for a long time. I have to leave it empty today and reset the disk to re-build the environment.

Cross-platform database migration using Oracle Data Guard The customer was originally a single-host Oracle 11.2.0.3.0 Database for Windows Database system. The customer's requirement is to migrate the single-host Oracle Database to the three-node

Quick install of MongoDB in Linux MongoDB is a non-relational database (NoSql) that is very popular in the IT industry. Its flexible data storage method is favored by current IT practitioners. MongoDB implements the object-oriented idea (OO idea),

Practical tutorial for importing data from sqlite3 to mysql, sqlite3mysql Preface Sqlite3 is small and lightweight, but does not support concurrent access. When the website concurrency is large, the database Request queue is long, which may cause

In the first two articles, we described the backup and recovery solutions for Small and Medium databases using RMAN catalog, all related scripts are provided to simulate Oracle Data Guard to a certain extent in a car to reduce database losses on the

Database review 7 -- recovery, database review 7Database review CH14 recovery 13.1 recovery concept Database SystemRestoreIt refers to the behavior that restores the database from an inconsistent state after a certain "failure" to a normal

Redis sentinel cluster construction and Jedis test graphic tutorial [3], redisjedis In the first two articles, the sentinel cluster construction and Jedis test graphic tutorials [1] and the sentinel cluster construction in Redis and the Jedis test

Symantec NetBackup 7.6 (NBU) FAQ, netbackupnbuSymantec NetBackup 7.6 Product Licensing Overview Product Name: Symantec NetBackup Product Version: 7.6 Release Date: 2013-12-18 Product OverviewProduct OverviewNetBackup with V-Ray technology is the

The data pump is a server tool, and the exported files are stored on the server where the database is located. Of course, we know that the files can be controlled through directory objects. The directory object has four levels by default. Of course,

Currently, popular database software include DB2, Access, Sybase, SQL server, ORACLE, and Foxpro. Among them, IBM's DB2 database is the leader in large databases, and DB2 is an important product of IBM, providing services on different operating

Shard change tracking: MV logs are not required To understand this enhancement function, you must first understand the partition trimming concept during the materialized view (MV) Refresh process. Assume that the table ACCOUNTS is partitioned Based

1. view the local node directory In the command window, enter db2 list node directory. 2. cataloguing a TCP/IP Node Command window: db2 catalog tcpip node Remote Server Ostype 3. Cancel node

Microsoft is evil, not 2 P, 3 P, huh, Office BI is 4 P. As a member of 4 P, Power Map is a half product.   The latest update is a bit bright. Mp4 can be generated. However, maps still do not support Chinese characters, including English,

Before creating an SQL Server 2000 failover cluster, you must Configure Microsoft cluster service (MSC) and use the Cluster Administrator in Microsoft Windows NT4.0 or Windows 2000 to create at least one cluster disk resource. Before running the SQL

1. simplify complicated operations by encapsulating processing in easy-to-adapt units. 2. Since a series of processing steps are not required, data consistency is ensured. If all developers and applications use the same stored procedure, the code

ORA-12545 Errors often occur when a remote client connects to the RAC database over a uniform service name. SQL> CONN NDMAIN @ nuagerac enter the password ***** connected.SQL> CONN NDMAIN @ nuagerac :******ERROR: ORA-12545: connection

Oracle recovery Manager (RMAN) has many features that can be used to help back up and recover processes. The tool has command line and GUI versions. Generally, RMAN executes and standardizes the backup and recovery processes, and reduces DBA errors

1 Preface In the recent project development process, I encountered Database Design Problems and referred to multiple databases, summary of some of the relevant database entities and relationships. During the month, I also wrote a MySQL database