CentOS 6.5 system installation Oracle188.8.131.52 basic steps CentOS 6.5 system installation Oracle184.108.40.206 basic steps 1. Modify the hosts file (simple, not described in detail)Vim/etc/hosts 2. Modify the sysctl. conf file. Vim/etc/sysctl. conf Kernel.
Oracle Data Pump example Oracle Data Pump example: 1. Export the specified tablespace: Expdp system/xxx DIRECTORY = dump_dir tableapace = xxx dumpfile = xxx _ % DATE :~ 0, 4% % DATE :~ 5, 2% % DATE :~ 8, 2% ". dmp logfile = xxx. log It seems
MySQL Security optimization using aliases to prevent misoperation Background: When a newbie experiences misoperations, he deletes my entire test table (test, no backup) Operation Command: Mysql> update test set name = 'Tom '; Result: All name
Summary of Oracle archive logs 1. Open archive logs Sqlplus/as sysdbaSQL> shutdown immediate;SQL> startup mount; # Open the control file instead of the data fileSQL> alter database archivelog; # Switch the database to archive ModeSQL> alter database
Zabbix uses the Orabbix plug-in to monitor Oracle databases (enhanced version) According to some information on the Internet, the installation finally found many problems, so I fixed some problems and recorded them. 1. Install jdk (Orabbix Server) 1.
Install MySQL in CentOS 7 The mysql-sever file for mysql installation does not appear to be in the yum source of CentOS 7. You need to download it from the official website. # Wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
Summary of various MySQL logs Log Type: Error log) General log) Binary log) Relay log) Slow log) Redo log of InnoDB Engine Error Log Log-error = error. log Save the storage path to datadir without specifying the hostname. err Record mysql
Create external table in Oracle Oracle db allows you to query External tables in read-only mode. External tables can be stored on any storage device that can be read by oracle databases. The content of external tables is not saved in the database.
Oracle adump file goes viral The Oracle adump file is too long, causing the oracle database to crash and re-build the adump directory. The error is: no space left on device, df-TH space is still available, but the directory cannot be created, the
Oracle Reports ORA-01691 error, single data file size limit problem 1. Problem: an error occurs when the Oracle database synchronizes a large table from another database. ERROR at line 3: ORA-24801: illegal parameter value in OCI lob function ORA-020
MySQL configuration file my. cnf added log parameter file Error MySQL configuration file my. cnf added log parameter file Error Add a line after [mysqld]Log =/tmp/mysql. logThen restart mysql,Shell> service mysql restartThen an error is
MySQL 5.7 cannot be logged on First, MySQL version 5.7 was released. The manager asked me to build LNMP with the latest version. Many problems were encountered during the setup process. Today, I will briefly discuss a problem with MySQL: After the
Compile and install MariaDB-10.0.20 under CentOS 6.6 System Environment: CentOS6.6 (Final)MariaDB port: 3309 (because MySQL is already installed on the local machine and you do not want to delete MySQL) # Wget http://mariadb.nethub.com.hk//mariadb-10
Process Monitoring Tool Supervisor starts MongoDB 1. What is a supervisor? Superviosr is a process monitoring tool on a UNIX-like system. Supervisor is a Python-developed client/server system that can manage and monitor processes on * nix. However,
Considerations when enabling full log query in MySQL 5.6 Today, because I want to query the call of an SQL statement, I started the full query log in production and thought that I only need to write it like this in my. cnf: Log =/home/logs/mysql.
The MySQL restart process cannot be underestimated. The restart of the database seems to be very simple and has no technical skills. This is what I said before. This sentence is simply a pain point of mine. This kind of activity is so technical that
Connect SQL plus to Oracle There are three methods for SQLPlus connection. 1. sqlplus/as sysdba Operating system authentication does not require the database server to start listener or the database server to be available. For example, if you
Install MySQL Binary Package for RedHat Linux Enterprise 6.4 Download MySQL and upload it to the server 1. Download the mysql binary installation package from the Mysql official website. Https://edelivery.Oracle.com/osdc/faces/SearchSoftware? _
Restoration Methods for deleting online redo logs of Oracle databases The online redo log of the Oracle database contains Operation Records of all data in the database. We can use the redo log to perform many operations, such as log
Oracle 11g RAC two-node root. sh execution error: one case Only record the Oracle 11g rac installation process once 1. The installation of multi-path software using RHEL6.5 multipath using udev to configure the ASM shared disk failed. At that time,