ORA-12520 error resolution instance

ORA-12520 error resolution instance Problem description: An error was reported when I suddenly found a connection to the database today. When I use pl/SQL dev to connect to data, sometimes I can connect to the database. Sometimes I can report the

Linux backs up MySQL Data every day

vps

Linux backs up MySQL Data every day Preface: If your MySQL database file is large, it may occupy a lot of server resources during backup. Therefore, the webmaster should try to select the minimum period of time for the visitor to execute the

B-tree index usage rules optimized by MySQL

B-tree index usage rules optimized by MySQL B-tree index usage rules optimized by MySQL Start with a question: Suppose a table has a joint index (c1, c2, c3, c4). Only c1, c2, and c3 parts of the joint index can be used.A where c1 = x and c2 = x and

Modify the size of Oracle redo log files

Modify the size of Oracle redo log files Modify the size of Oracle redo log files 1. Create 3 new log groups SQL> ALTER DATABASE ADD LOGFILE GROUP 4 ('/u01/app/oracle/oradata/orcl/redo06.log') SIZE 500 M; SQL> ALTER DATABASE ADD LOGFILE GROUP 5 ('/u0

Use cgroups to limit the resource occupation of MySQL Enterprise Backup

Use cgroups to limit the resource occupation of MySQL Enterprise Backup Today, I encountered a problem: MySQL Enterprise Backup caused a heavy load on the I/O subsystem, slow application response, and system unavailability. So I want to restrict the

An error solution for ORA-600 [13011]

An error solution for ORA-600 [13011] Sunoperating 5.10Oracle 10.2.0.2.0A ORA-600 error occurs in a database in the development environment. Error message in alert. log:Thu Nov 13 15:11:43 2014Errors in file/oracle/admin/sun/bdump/sun_j000_29589.trc:

Turn RAC off (Oracle 12C note)

Turn RAC off (Oracle 12C note) Turn RAC off (Oracle 12C note) Check RAC status [Grid @ rac01 ~] $ Crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization

The rman backup script in the Oracle database is very practical.

The rman backup script in the Oracle database is very practical. The rman backup script in the Oracle database is very practical. Query character sets SQL> select * from nls_database_parameters; NLS_CHARACTERSETAL32UTF8 Character Set is very

Oracle Database cannot be accessed using localhost and 127.0.0.1

Oracle Database cannot be accessed using localhost and 127.0.0.1 I recently learned about Oracle databases and installed Oracle 10g (Version: oracle_10g_10.2.0.20.win32) in Windows XP SP3 on a virtual machine ). After the installation is complete,

Summary of new features in Oracle 12C SQL

Summary of new features in Oracle 12C SQL Multiple indexes on the same field Before Oracle 12c R1, a field cannot have multiple indexes in any form. Some may wonder why a field usually requires multiple indexes. In fact, there are many fields or

How to migrate MySQL 5.5 database to MariaDB 10 on Ubuntu

How to migrate MySQL 5.5 database to MariaDB 10 on Ubuntu This article has been tested by ourselves. The system is Ubuntu 14.04 server, and the Mysql database is Mysql 5.5. We are preparing to migrate it to Maria DB 10.1, for details about the

Use the new Oracle RAC 11gR2 feature renamedg to change the diskgroup name

Use the new Oracle RAC 11gR2 feature renamedg to change the diskgroup name Environment Description:AIX7.1 + dual-node Oracle Rac 11.2.0.3 Because this Rac is not installed by your own department, it is installed by the Development Department and is

Why didn't Oracle RAC Opatch go to Rac database home during auto?

Why didn't Oracle RAC Opatch go to Rac database home during auto? First explain the environment:Operating System: AIX 7.1Oracle version: Oracle Rac 11.2.0.3I used the 11.2.0.3.9 patch set before and it was not officially used for Rac installation,

RedHat6.5 install Oracle 12C RAC

RedHat6.5 install Oracle 12C RAC 12c RAC Installation Process Note: The following configurations are executed on both nodes.1. Network Configuration Take rac01 as an example. Both nodes must be configured. Eth0 and eth1 are bond0 Eth2 and eth3 are

Oracle user name and password Modification

Oracle user name and password Modification After the Oracle database is copied or cloned, you often need to modify the user name and password. The following describes the modification methods and steps: 1. query the table USER $ Select name, USER

Oracle enhanced date functions

Oracle enhanced date functions -- Change the database time zone to UTC + 8 Alter database set TIME_ZONE = '+ 08:00 '; /* An error may occur during the modification: ORA-30079: the database time zone cannot be changed when the database has a

Oracle Instanc Client installation command tool

Oracle Instanc Client installation command toolPrerequisites 1. Linux RHEL 6.X X86_64 Operating System 2. Oracle-related files (same OS) can be obtained from the server where the Oracle server is installed)Software Download Download the following

Be careful when using with in Oracle -- predicate cannot be promoted

Be careful when using with in Oracle -- predicate cannot be promoted Today, we can see that a SQL statement uses with in large quantities. For logic clarity, developers cache some result sets first with, and there are many places to use this result

Oracle simple column-to-row

Oracle simple column-to-row Oracle simple column-to-row The requirement is to count the total salaries of different jobs in each department. SQL> select deptno, ename, job, sal from emp;DEPTNO ENAME JOB SAL---------------------------------------20

Oracle not exists equivalence statement

Oracle not exists equivalence statement Not exists can be changed to left join + is null. It can be seen that the execution plan is the same before and after rewriting, and the resource consumption is the same, which means it is equivalent. SQL>

Total Pages: 1013 1 .... 344 345 346 347 348 .... 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.