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.

Imp/exp Oracle Database Import and Export command

Imp/exp Oracle Database Import and Export command Oracle Data Import and Export: imp/expFunction: Oracle Data Import/Export imp/exp is equivalent to oracle data restoration and backup. In most cases, you can use Oracle data import and export to back

Use Toad for remote Oracle 12C data connection

Use Toad for remote Oracle 12C data connection 1. Install Oracle12c on the local machine. If you want to install a database on the local machine, select to install data. If you only need to connect remotely, skip this step without installing a

Oracle 11G uses DG Broker to create a consumer uard

Oracle 11G uses DG Broker to create a consumer uard Oracle 11G uses DG Broker to create a consumer uard 1. Environment: A. host environment: CentOS6.5 B. software environment: oracle 11.2.0.4 C. host information: DG1: 192.168.100.51 (Database sid:

How to handle insufficient SWAP space when installing Oracle

How to handle insufficient SWAP space when installing Oracle When installing Oracle, the installation may fail due to insufficient swap space allocated. The procedure is as follows: The SWAP space is 2 GB. [Root @ linux01 oracle] # freeTotal used

MySQL Master/Slave Database Configuration Guide and error handling

MySQL Master/Slave Database Configuration Guide and error handling MySQL master-slave replication Configuration 1. Requirements 1.1 System Platform consistency 1.2 consistent database versions 2. Modify the my. cnf file. The master server and slave

Install MySQL 6.4 Binary Package in 64-bit CentOS 5.6

Install MySQL 6.4 Binary Package in 64-bit CentOS 5.6 I do not like it because I want to install MySQL in Linux and it is very complicated to use the source code package: 1. You need to install the GCC compiler. While I installed linux with minimal

MongoDB upgraded from 3.0.7 to MongoDB3.2

MongoDB upgraded from 3.0.7 to MongoDB3.2 Mongodb3.2 version was just released on the day before yesterday, for: https://www.mongodb.org/downloads#production Starting in 3.2, MongoDB uses the WiredTiger as the default storageengine. Mongodb uses

Differences between statement and preparedStatement [in jdbc]

Differences between statement and preparedStatement [in jdbc] ① Syntax difference: · Statement is the parent class of PreparedStatement [developer generally uses the latter]· Different SQL statement locations:The usage of statement is as

How does MySQL export files with date format?

How does MySQL export files with date format? A netizen asked how to use only SQL statements in MySQL to export files with date format. I thought it was a bit interesting, so I tried it. The exported file uses select into outfile, but the values

Manually generate an AWR report

Manually generate an AWR report Sometimes the AWR report cannot be graphically generated for installing EM in the database. In this case, you need to manually generate an AWR report. Oracle provides an SQL statement to manually generate an AWR

Error dirname in shell script: Invalid option -- B

Error dirname in shell script: Invalid option -- B When writing a Shell script today, an error is reported during debugging. [Oracle @ smidb11 autoawrrpt] $. a. sh dirname: Invalid option -- B please try to execute "dirname -- help" for more

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

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.

Use pg_basebackup to build a PostgreSQL stream replication Environment

Use pg_basebackup to build a PostgreSQL stream replication Environment This article introduces the high availability of PostgreSQL. Here we will first conduct a stream replication experiment. Environment:OS: [Ha @ node0 ~] $ Uname-Linux node0 2.6.32-

Summary of restoring MySQL master-slave Data Consistency

Summary of restoring MySQL master-slave Data Consistency This morning, my colleague told me that the data in the MySQL master-slave database was inconsistent and he guessed that the slave database encountered a problem during synchronization. So he

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

Only enable 10046 trace for a specific SQL statement

Only enable 10046 trace for a specific SQL statement Recently, I encountered an interesting problem: there is an SQL statement that runs for dozens of milliseconds most of the time, but sometimes the execution time of a certain time is longer than 2

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,

Oracle 11g R2 rac rman backup script example

Oracle 11g R2 rac rman backup script example 1. Switch RAC to archive Mode 1. Modify the archive mode of the database. Generally, archive is configured and the flash back area is used when RAC is installed. you can skip the steps below if you have

Total Pages: 1013 1 .... 80 81 82 83 84 .... 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.