Configure HugePage in Linux

Configure HugePage in Linux For Oracle database servers with large memory, it is necessary to configure HugePage. The following describes how to configure Huge: My environment: OS: CentOS release 6.4 (Final) Oracle: 11.2.0.4 RAC HugePage needs to be

Detailed analysis of InnoDB indexes in MySQL

Detailed analysis of InnoDB indexes in MySQL Abstract: This article introduces the InnoDB Index-related knowledge of MySQL, from various trees to the indexing principle to the details of storage. InnoDB is the default storage engine of MySQL (MyISAM

Configure the NIC Bonding for the RAC Private Network

Configure the NIC Bonding for the RAC Private Network In the installation and deployment process of RAC, it is not just a simple installation. The possible single point of failure (spof) should be considered during the installation process. The most

How to downgrade an Oracle database from 11.2 to a previous version

How to downgrade an Oracle database from 11.2 to a previous version This document can be used to downgrade the upgraded database from Oracle 11gR2 to the following guidelines and checklists: Oracle 10gR1, Oracle 10gR2, and Oracle 11gR1. This

MySQL 5.5.40 automated installation script

MySQL 5.5.40 automated installation script After learning the Linux Shell script for two weeks, I finally wrote a MySQL automated installation script. With the full-day test today, MySQL 5.5.40 can be installed normally. Other versions have not been

Oracle BUG caused instance downtime: ORA-07445

Oracle BUG caused instance downtime: ORA-07445 Symptom:The customer's database (RAC environment: 11.1.0.6) encountered abnormal instance downtime, accompanied by a ORA-07445 error:Sun Jun 23 01:00:06 2013Exception [type: SIGSEGV, Address not mapped

Archive mode: Restores data files that are not backed up.

Archive mode: Restores data files that are not backed up. Scenario: 1. Open archiving for databases; 2. All archived logs after data files are created are online; 3. Data Files Or tablespaces have not been backed up, databases have not been backed

Database instance cannot be started after ORA-39700 Oracle 10g upgrade

Database instance cannot be started after ORA-39700 Oracle 10g upgrade Upgrade Oracle Database 10.2.0.1 to 10.2.0.5 todayAn error occurred while starting the database:ORA-01092: The ORACLE instance terminated. Disconnection forced instance is

Oracle bug solved: ORA-20446 Error

Oracle bug solved: ORA-20446 Error I downloaded an Oracle 11g and want to see what new features are available. After the installation, enable EM and find that the feature is excellent. It is used to import data from another database. Set to import

Slow MySQL subquery

Slow MySQL subquery When you use the explain tool to view the execution plan of the SQL statement, if the select_type field contains "DEPENDENT SUBQUERY", you should note that, you have fallen into the slow mysql subquery "pit ". Related books: High-

Oracle session and connection Optimization

Oracle session and connection Optimization 1. Modify the Oracle session and maximum number of connections 1. view the maximum number of connections SQL> show parameter processes; NAME TYPE VALUE--------------------------------------------------------

Enable Oracle startup in CentOS 6.4

Enable Oracle startup in CentOS 6.4 Objective: To enable Oracle to start on CentOS 6.4 Solution: First add start, close, restart Oracle services and instance services, and then add this service to the System Service running level. Set CentOS to

ORA-01031: insufficient privileges Problem Solving notes

ORA-01031: insufficient privileges Problem Solving notes About ORA-01031: insufficient privileges troubleshooting notes A) File $ Oracle_HOME/network/admin/sqlnet. oraDoes this involve oracle OS authentication or password file authentication? The

Oracle ORA-27121 troubleshooting

Oracle ORA-27121 troubleshooting ORA-27121: unable to determine size of shared memory segmentCause: shmctl () call failedAction: check permissions on segment, contact Oracle support Cause: The oracle database is migrated through the cold copy

PL/SQL Developer log on to Oracle 12c

PL/SQL Developer log on to Oracle 12c After Oracle 12c is installed, PL/SQL Developer cannot connect to Oracle 12c. Search online and follow the instructions in fcflying, so take a note: 1) install Oracle 12c 64-bit :

Incorrect upgrade leads to ORA-27468 errors and full flashback (ORA-16014)

Incorrect upgrade leads to ORA-27468 errors and full flashback (ORA-16014) ORA-27468 error in Oracle 10.2.0.5 environment Alert Log. View alert logs: Errors in file/u01/app/oracle/admin/crab/bdump/crab_j001_23669.trc:ORA-12012: Automatic job 5329

Compile and install MySQL 5.6.20 in CentOS 6.5

Compile and install MySQL 5.6.20 in CentOS 6.5 Overview:MySQL 6.5 installed through yum in CentOS 5.1 is old, so I want to install the later version 5.6.20 through the source code. Body:I. Uninstall the old versionRun the following command to check

ORA-28001: the password has expired Solution

ORA-28001: the password has expired Solution ORA-28001: the password has expiredCause: The user "s account has expired and the password needs to be changedAction: change the password or contact the DBA An error is reported when the program connects

Oracle ORA-16014 troubleshooting

Oracle ORA-16014 troubleshooting ORA-16014: log 3 sequence #9147 not archived, no available destinations ORA-00312: online log 3 thread 1: '/U01/app/Oracle/oradata/omsdb/redo03.log' Mon Apr 22 19:10:28 2013 ***************************************

Migrate Oracle databases across OS platforms

Migrate Oracle databases across OS platforms Port existing Oracle databases (non-binary executable program files/) from one operating system platform to another operating system platform (for example, from Windows to Solaris)This requirement may

Total Pages: 1013 1 .... 374 375 376 377 378 .... 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.