Database Administrator

Oracle 11g Silent Installation Software + manual database creation Because it is a secondary jump + remote operation, the GUI cannot be used and cannot be directly installed on the GUI. Use silent software installation + manual database creation to

15 useful MySQL/MariaDB performance tuning and Optimization Techniques MySQL is a powerful open-source Relational Database Management System (RDBMS ). It was released in 1995 (20 years ago ). It uses Structured Query Language (SQL), which may be the

Troubleshooting of SQL plus logon failures caused by su switching in Oracle Problem description:The Oracle database in the production environment suddenly fails to log on, and the oracle database in the rlwrap production environment suddenly fails

Install and configure MongoDB in Linux1. MongoDB simple description A MongoDB is an open-source database system written in C ++ Based on Distributed File storage. It aims to provide scalable and high-performance data storage solutions for WEB

Mysql batch Add a new column stored procedure in the table, mysql new Generally, for websites with a large access volume, the request log table is created independently on a daily basis. The business needs to add a new column for each table. After a

Oracle cloud control 12c startup and shutdown, cloud12c The entire installation of Oracle cloud control 12c is complicated. The installation path, logon password, port number, and many other configurations are confusing. This article describes how

[Sqlite], sqliteI. Install SQLite on Windows 1. Download Visit the SQLite download page http://www.sqlite.org/download.html to download pre-compiled binary files from windows. You need to download the sqlite-shell-win32-*. zip and sqlite-dll-win32-*.

I uninstalled PL/SQL Developer and compared it with Toad for Oracle. Previously, PL/SQL Developer was used to manage Oracle, which was inconvenient to use. It is very difficult to open, and there is always an extra box in the upper left corner of

DateDiff function, datediffIn MySQL, you can use the DATEDIFF () function to calculate the number of days between two dates. Syntax: datediff(date1,date2)Note: date1 and date2 must be valid date or date/time expressions Example 1 SELECT DATEDIFF('2

How to Use ZOL one-click installer to download the Zhongguancun online source installation package, zol Zhongguancun online How to Use the ZOL one-click installer to download the Zhongguancun online source installation package Magenfeng(Guangdong

JSP uses UTF-8 link MYSQL database (UTF8) garbled and connection failure issues: Preface: the databases used by these big companies are not human-friendly... It took me a long time to get it done. Csdn does not seem to be able to transmit images

I. Backup and Recovery Overview1. Backup and Recovery Overview1.1 What is Backup and Recovery?Generally, backup and recovery references various policies and procedures to protect your database from data loss, and recreate the database after any data

TNS-12541, TNS-12560, TNS-00511, TNS-12542, TNS-12560, TNS-00512 database boot listener error, tns-12541tns-00512 Chapter 4 Database Server listener errors 1.1.1 database listening Error 1.1.1.1 problems and phenomena The server environment is

Problem description: A session has been active for more than 20 hours, waiting for the event SQL * Net more data from client One session was logged on from eleven o'clock A.M. yesterday (v $ session. login_time), which has been ACTIVE till now,

Windows 10 install oracle 12c error: [INS-30131], 12cins-30131 "[INS-30131] the Initial Setup That Is Required to Run the Installation Program Validation Was Not Successful" Error While Installing Oracle Database (Doc ID 1569962.1)

Postgres-XL: PostgreSQL-based open-source scalable Database Cluster,Postgres-XL: PostgreSQL-based open-source scalable Database ClusterIn the past year, IOE has become more and more popular in the industry. Many traditional enterprises have also

SQLite tutorial (11): temporary files, sqlite tutorial I. Introduction: Although the SQLite database is composed of a single file, some hidden temporary files exist in the SQLite runtime. These temporary files exist for different purposes,

Database Query analyzer 6.03: How to Operate Domestic DM databases flexibly and quickly, db6.03  Database Query analyzer 6.03: How to Operate Domestic DM databases flexibly and quickly Magenfeng (Guangdong Union Electronic Service Co., Ltd.,

MongoDB Practice Notes for beginners-install, create databases, save and query data, and learn mongodb MongoDB is a scalable and High-Performance Distributed Document storage database written in C. It is designed to provide scalable and

The target of PostgreSQL is very similar to that of the current MySQL database. So what are the advantages of PostgreSQL? This article will be explained to you. This article introduces the basic concepts of PostgreSQL's transaction processing