Database Administrator

Oracle Database startup and shutdown Methods I. Several startup methods: 1. startup nomount is not installed and started. In this mode, execute the following commands: re-build the control file and re-build the database. Start the instance, that is,

Informix was previously installed in RHAS4, but the idea is vague. Today, we have to install it again. The installation process is listed below to be noted. 1. Create an informix user.Groupadd informixUseradd-g informix 2. Log On As the root user

This article describes how to use ulogd to save iptables logs to MySQL In debian. There are many benefits to doing so. The main benefit is that the log statistics in the future will be very convenient. Install ulogd and ulogd-mysql First, run the

1. The simplest is to read data that requires consistency from the master database. However, this method is obviously not feasible for applications with large data volumes. 2. the synchronous replication model is used. MYSQL provides a synchronous

Solution to port 80 occupation after Oracle installation: Modify two files in the oracle \ Apache \ conf directory: httpd. conf, httpd. conf. default: Change the port in the file from 80 to 18001 to change the application port of Apache to port 1800

OS: Oracle-Enterprise-R5-U2-Server-i386Oracle: linux_x86_11gR1_database ERROR:Sqlplus: error while loading shared libraries:/u01/app/oracle/product/11.1.0/db_1/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied I. Simple

Installation environment: Ubuntu Linux 1. Install JDK first 2. Install MySQL JDBC driver Connector/J (1) Search for Connector/J in the new software management package of Ubuntu (2) Find and install (3) Find the mysql-connector-java-n.n.n file

Introduction to Oracle listeners The Oracle listener is a component of the Oracle server software. It manages the communication between the Oracle database and the client. It listens for connection requests on a specific Nic port (TCP port 1521 by

Generally, you can determine whether a database is designed with a comparative specification from two aspects. First, check whether there are a large number of narrow tables, and second, whether the number of wide tables is small enough. If the two

When configuring the SDF server in Linux, sometimes the graphical interface for installing MySQ cannot be installed. You need to download and install the server again: Select software tools: MySQL Control Center MySQLCC is a fully functional,

Environment: UbuntuMYSQL 5.0.38JDK 1.6Ecplise 3.2.2Hibernate 3.2Mysql query browser 1.2.5bateDuring java project development, it was found that the Insert data was garbled and no solution was found for searching various cool people. Try the

--- Create a packageCreate or replace package test_pkg isG_public_flag varchar2 (1 );Function test_function (p_param1 varchar2,P_param2 varchar2) return varchar2;Function hello_function (p_param3 varchar2) return varchar2;Procedure ff (p1 varchar2 );

Next to the previous article... see: Group For convenience, I still paste the structure of my table: Similar to databases, group is often used for statistics. The MongoDB group has many restrictions. For example, if the returned result set

Use shell scripts for log analysis. to store the analysis results directly to the mysql database, execute mysql statements in the shell script. Method 1 Save the statements to be executed in each step to tmp. SQL. Mysql-u uname-p pwd Method

Apsaradb for MongoDB Preface I have always wanted to get started with the development of large data volumes. Recently I found NoSQL databases have significant advantages in relational databases, especially for processing massive data volumes. There

OS: SUSE10DBMS: Oracle11.1.0.7When querying a table, the system reports an error related to the temp tablespace, and the log reports that the tempfile cannot be expanded. Current log #2 seq #644 mem #0:/oradata/test02/test02/redo02.logTue May 14 14:2

Scenario Description: There are two tables in the Oracle database, one being tm_bus_realtime_log. The current table only contains data from the previous day. The data volume has millions of data records. There is also a table where the History Table

1. Create the path to save the backup file/mysqldata # Mkdir/bak/mysqlbak 2. Create the/usr/sbin/bakmysql file. # Vi/usr/sbin/bakmysql. sh 3. Write the following script: NOTE: If your mysql password contains special characters, such! @ #, You need

1. First fill in the database connection string in Webconfig 2. Step 2: Create a page and add the following code Public partial class WebForm1: System. Web. UI. Page{ /// // Connect to the database /////////////////////// ////////String oraclestr =

In mysql, when the delete operation drops tens of millions of data records, the table may be locked, and the mysql server may be under great pressure. This is an unavoidable problem in mysql. It can be said that it is insufficient in dealing with