Database Administrator

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

Oracle 11gR2 RAC environment DBCA create database error ORA-15055 ORA-15001 Symptom: After installing the Oracle 11gR2 GridInfrastructure and Database software, run DBCA to create a Database to 30% and report the following error. Click OK to ignore

Relationship between MySQL mysqld file generation permission and UMASK Today, because of the binlog File Permission issue, the final tracking is that the MySQL installation initialization specifies the permission for the MySQL user to generate the

Oracle ORA-01555 (snapshot old) I. Introduction: [Oracle@www.bkjia.com] $ oerr ora 0155501555,000 00, "snapshot too old: rollback segment number % s with name \" % s \ "too small"// * Cause: rollback records needed by a reader for consistent read

Oracle 11g R2 (GI) Startup Process 11gR2 cluster management software (GI) startup sequence and diagnostic methods In this article, we will introduce the Starting sequence of 11gR2GI and introduce common problems and corresponding solutions during GI

MySQL multi-instance configuration (2), mysql instance Configuration For centralized O & M of MySQL databases, you can deploy multiple MySQL instances on one MySQL database server. This function is implemented through mysqld_multi. Mysqld_multi is

RAC background process introduction, rac background processThere are more processes on the RAC database than on a single instance database. These processes are unique to RAC and are set to implement cluster database functions. This article will

Common Methods for Solving oracle deadlocks (tried and tested) and oracle deadlocks -- 1. query the locked status Select object_name, machine, s. sid, s. serial # From v $ locked_object l, dba_objects o, v $ session s Where l. object_id = o.

Wang Liping-simple application of SQLite, SQLiteOpenHelper, and sqliteopenhelper The Android platform provides a database helper class to create or open a database. This helper class inherits from the SQLiteOpenHelper class. In the constructor of

11gR2RAC environment DBCA create database error ORA-15055 ORA-15001, 11gr2racdbca 11gR2RAC environment DBCA create database error ORA-15055 ORA-15001   Symptom: After 11gR2 GridInfrastructure and Database software are installed, the following error

MySQL database can be accessed using any ip address. Use the CMD command line to modify the value of a field in the database table for connection and access. Step 1. Find the bin directory where the MYSQL software is installed; (1) cd \ Current

Oracle installation and configuration process I had to install oracle myself for the first time. I had no idea about oracle installation and configuration before, and finally finished it. 1. Install the oracle10g Server 2. Install the oracle10g

Rejected-tragic ORA-01017: invalid username/password; logon denied error, ora-01017denied Oracle is not installed locally. oracle client and PL/SQL Developer are installed. To visualize the oracle database. Failed to log on when using PL/SQL login,

Oracle PL/SQL Composite data type, oraclepl Composite data types can be roughly divided into two types. The first type is record type, which is suitable for processing single row and multiple columns of data, a bit similar to VO in java; the first

A simple cursor deletes an SQL SERVER table. Use databaseNameDeclare @ tblname char (100)Declare @ SQL char (5000)Declare table_cursor cursor for select name from sysobjects where name like 'tb _ card [_] % 'and name <> 'tb _ card_regist' and name <>

Which of the following is the most common number in 2 billion ?, About 2 billion Baidu, an asshole, swallowed several answers. So I sent it here: 1536 Here I will post some evaluation data. Why? Because I ran on many computers, I lost some of them,

The alert log shows the Private Strand Flush Not Complete processing method, strandflushAlert. log also reports the following error in the database of the customer in Nanjing:Fri Oct 17 19:59:51 2014 Thread 1 cannot allocate new log, sequence 4722

Error: ActiveRecord: IrreversibleMigration exception, exceptionalRecently, the field of the database table was modified in rails3.2 and you want to roll back and cancel the operation. However, when you run the rake db: rollback command, an error

[MongoDB] set up a Mongo Master/slave database for synchronization in windows, mongodbmongo In the previous series of articles, we talked about the basic operations, advanced queries, and index usage of mongodb. This blog mainly describes how to

MongoDB operation manual CRUD query pointer, mongodbcrudEnumeration traversal pointer Overview As mentioned earlier, if db. collection. find () is not specified to a variable declared by var, the first 20 records will be automatically