CentOS 6.5 system installation Oracle11.2.0.4 basic steps

CentOS 6.5 system installation Oracle11.2.0.4 basic steps CentOS 6.5 system installation Oracle11.2.0.4 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 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

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

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)

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

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

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

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

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

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 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

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

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

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

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 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

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

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

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

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,

Total Pages: 1013 1 .... 81 82 83 84 85 .... 1013 Go to: GO

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.