Database Administrator

Operating software environment: CentOS 4.4, TSM5.3.2, Oracle 10G Environment: One broken PC, P3 900 Mhz, M memory, 40 Gb hard drive One obsolete hp dat 40 tape drive N DDS3 and DDS4 tapes that do not know many teenagers Reference books: IBM Tivoli

I. Introduction I have been using Linux for a long time. I have never studied hard tasks and system learning. Recently, I have to use MySQL in Linux for my work. I thought that I had experience using SQL Server in Windows and thought it would be

[Mysqld]Port = 3306Serverid = 1Socket =/tmp/mysql. sockSkip-locking # Avoid external locks of MySQL to reduce the chance of errors and enhance stability. Skip-name-resolve Prohibit MySQL from performing DNS resolution on external connections. This

Restore the MySQL administrator password in Linux 1. Send the kill command to the mysqld server to disable the mysqld server (not kill-9). files storing process IDs are usually stored in the directory/var/lib/MYSQL of the mysql database. # Killall-

According to a recent user survey by Oracle, open-source software is occupying the installation share of Oracle Database software, and about 60% of IT facilities are using some form of open-source software. The survey conducted by the Independent

1. Install the required MySQL software package in Ubuntu Sudo apt-get install binutils cpp fetchmail flex gcc libarchive-zip-perl libc6-dev libcompress-zlib-perl libdb4.3-dev libpcre3 libpopt-dev lynx m4 make ncftp nmap perl-modules unzip zip zlib1g-

I have installed the Oracle 10 Gb database on a Linux Virtual Machine. How can I access the remote plsql? I have created an orcl instance. How can I connect the remote plsql to my instance? Use TCP to configure the TNSNAMES. ORA file to support

Outline 1. configuration file description My-small.cnf My-medium.cnf My-large.cnf My-huge.cnf My-innodb-heavy-4G.cnf 2. Detailed explanation my-innodb-heavy-4G.cnfIii. configuration file OptimizationNote: Environment Description, CentO5.

MySQL initial Account Management The initial MySQL account is as follows: [Root @ lx16 ~] # Mysql-u rootMysql> select host, user, password from mysql. user;+ ----------- + ------ + ---------- +| Host | user | password |+ ----------- + ------ + ------

Solution: (1) Track and execute the inserted SQL/stored procedure, find the row that causes the culprit, and insert the row again after modification. (2) The simplest way is to increase the precision of the target field.   Because the specific table

Installation and introductionImplementation of backup and RestorationFull + incremental + binary log backup and Restoration#####################################I. Installation and introduction 1. IntroductionXtrabackup is a mysql database backup

Oracle Net tool (command) tnsping is an OSI Session Layer tool used: 1) Verify the name resolution (name resolution, which is the name of the oracle Network Service) 2) whether the remote listener is enabled 1. Remote tnsping 2. Disable

Tutorial start:1. Install MySQL Note: perform the following operations on the two MySQL servers 192.168.21.169 and 192.168.21.168 respectively to install MySQL 5.5.22. 2. Configure the MySQL master server (192.168.21.169)Mysql-uroot-p # enter the

Today, a test database is down. After the Oracle database is restarted, the listener cannot be started. The lsnrctl start or lsnrctl status Command is stuck in this step: Lsnrctl status LSNRCTL for Linux: Version 10.2.0.5.0-Production on 09-APR-2013

Most people will first check whether the disk space in the archive directory is full and determine whether the archive space is full based on the free space of the archive directory, however, I think this method does not necessarily represent the

Introduction: The use of MyBatis in the project, a more annoying problem is unable to see the specific execution of the SQL, So, find the Log4jdbc-log4j2. This is a jdbc-level listening tool that can listen for the main operations on the database,

Today is. Due to the analysis of deadlock, writing RAC was delayed. Today, I will write an article about the disk management log voting in RAC. Record it here.Votedisk is created because of split-brain caused by network. The voting disk is stored in

DB2 10 introduces a more management method for tablespaces that manage data storage based on temperature, but requires the database to enable automatic storage management. The specific storage path is in a directory, it takes two steps to convert a

In the actual O & M environment, operating system OS maintenance is required. The application system is a whole, not only the application itself and the database server running on the application server, but also the operating system, network,

With the development of Oracle, a complete solution system has been built in the Backup recovery field. In most cases, our backup and restoration requirements can be achieved using the mature Oracle solution. Table space Point In Time Recover