Database Administrator

I have sorted out some solutions to the Mysql problem in the FreeBSD environment for your reference! 1. An error occurred while modifying the root user password: # Mysqladmin-uroot-p password 'newpassword' Enter password: Mysqladmin: connect to

1. Composition of the NLS_LANG ParameterThe NLS_LANG parameter consists of the following parts:NLS_LANG = _. The meanings of NLS_LANG are as follows:LANGUAGE:-Oracle message language-Display month and day in dateSpecified by TERRITORY-Currency and

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

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

A. show tables or show tables from database_name;-displays the names of all tables in the current MySQL database. B. show databases;-displays the names of all databases in MySQL. C. show columns from table_name from database_name; or show columns

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

Because of the pre-research needs of the project, I want to find a solution that can meet the requirements of the internal and external Network Database Synchronization. I first tested the Advanced Replication function of Oracle, but did not succeed.

Oracle uses a variety of different mechanisms to manage database security, including two mechanisms: mode and user. The mode is a set of mode objects, such as tables, views, processes, and packages. The first database has a set of modes. Each Oracle

Step 1: Shut down the database. When the database is shut down, the database system mainly completes three tasks. First, the system will write the content in the redo log cache to the redo log file. Second, write the modified data in the high-speed

Now, the company replicates data from a single server. Now we know that you need to install multiple mysql services. Now, under the existing single-instance database, different ports are divided into the red section below;[Root @ mysql ~] #

Test environment: DB: 11.2.0.3, 10.2.0.4 OS: RHEL 4.8 Migrate the stored outline data in Oracle 10 Gb to 11 GB 1. Export the data in the test table [Oracle10g @ rhel4 SQL] $ expdp scott/oracle tables = test1directory = testdumpfile = test1.dmp;

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

Oracle 10g rac standby automatic deletion script for archiving logs #! /Bin/bashExport ORACLE_HOME =/opt/oracle/product/10.2.0/db_1Export ORACLE_SID = standby1Export ARCHIVE_DIR =/log/archivelogExport LOG_FILE =/home/oracle/logs/del_archive.log If [!

I sent a SR on MOS and asked how v $ segment_statistics was updated? Oracle: v $ segment_statisitcs has been used for internal research since 9IR2 was introduced] (I) first look at the table structure: Sys @ ORCL> desc v $ segment_statisticsName

In Linux, it is best to install the Oracle System with 1 GB memory and 2 GB swap space. The hard disk requires at least 4 GB space. At least the environment is Linux Server release 5.3 or above For Linux Server release 5.1, modify oracle10.2 G. 1.

Disable innodb_fast_shutdown =0. Complete all full purge and merge insert buffer operations (for example, during InnoDB plugin upgrade)1 By default, the above operations are not required, but the dirty pages in the buffer pool are refreshed.2. logs

Recently, when debugging a function with DML operations, it has never been successful. It is okay to test in PL/SQL. It will not work when calling a function through SQL statements, at the beginning has not found the cause, then inadvertently caught