Database Administrator

Oracle 11.2.0.2 solve INS-35354 when RAC is installed When installing an Oracle 11.2.0.2 RAC database today, the INS-35354 problem occurs: Because the GI of 11.2.0.2 has been successfully installed, and all the status of the Cluster is normal, this

Oracle 11G R2 replicuard construction in CentOS 5.11 Datagard is a disaster tolerance solution for Oracle Enterprise Edition. It is widely used in enterprises and I will record the setup process for backup.Host Name database version Instance name

Phpmyadmin creates database users (local, any host) and phpmyadmin DatabasesPhpmyadmin User Creation You can use phpmyadmin to create a database user and Set permissions. Both User Creation and permission configuration are simple. Root User It

Database Link of IT Ninja Turtles: database of Ninja Turtles -CREATE public database link test_link connect to scott identified by tiger using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521) (CONNECT_DATA

Oracle Performance Analysis 5: Index Structure and scan mode of data access methods, oracle Index The previous article describes full scan. This article describes the index structure and scan methods, and describes each scan method later.When Oracle

WAS cluster series (3): Build a cluster: Step 1: prepare files, was Cluster Note: "pointing track" is "Click order", which is the effect after clicking Environment Project point Metrics WAS version 7.0 Operating

CentOS installation mysql *. rpm prompt conflicts with file from package solution, centos. rpm Install MySql 6.5 in CentOS 5.6 Decompress file: tar xvf MySQL-5.6.19-1.linux_glibc2.5.x86_64.rpm-bundle.tar Release the following files: MySQL-embedded-5.

Oracele Timesten connects to DSN to create a user, oraceletimesten 1. Enable startup [Tt @ host2 info] $ ttDaemonAdmin-start-force /Home/tt/TimesTen/tt1122/info/timestend. pid file exists, attempt start due to-force option. TimesTen Daemon startup

Full process of installing MySQL 11.04 through apt in Ubuntu 5.1: Read: MySQL 5.5.11 compiling and Installation notes in Linux (complete installation tutorial) compile and install MySQL dual-instance in Ubuntu and configure master-slave replication

Today is, in the database recovery when a long-time violation of the ora-600 [2662] error, the special sorting is as follows: Problem description: The system tablespace is deleted by mistake. The database is restored to the starting state by

Problem description In the production database, the data of one table is 1 billion level, and that of the other table is 10 billion level. The data of other tables is also quite large. I didn't know that these tables had such a large amount of data

Redhat 6.2 installation of the Oracle 11g client and Analysis of problems encountered, oracle11gOracle 11.2.0.1.0 client (32 bit) was installed on Redhat6.2 (64 bit) yesterday. The following are some problems encountered during installation and the

When you build a Postgresql test environment and encounter a problem during installation, execute configure The following error is reported during the process: configure: error: readline library not found. The colleague said that the system has been

Why percona-xtrabackup We have discussed MySQL Cold Standby, Hot Standby, mysqldump, and hot copy to ensure data consistency. Because mysql cold backup, mysqldump, and mysql hot copy cannot achieve Incremental backup, Incremental backup is used in a

Environment Introduction: Dual-host operating system: solaris 10 database version: oracle 11g R1 64bit current host name and IP: fly-db2 192.168.20.21 current slave host name and IP: fly-db1 192.168.20.20 Background: The physical memory of the

Oracle 11g RMAN: Interpretation of the command for creating dg in Active Database Duplication for standby database, rmanduplicationIf the production-based duplicate replication is not manually configured with pfile (set memory, process, dg-related

Atitit. Software dashboard (4) -- db database subsystem-monitoring, atitit -- db Atitit. Software dashboard (4) -- db database subsystem-Monitoring Connections ::: Deadlock table list: Basic deadlock list (recent records, time, SQL, etc) 3. Monitor

The advantage of parallel query is that it can process query jobs through multiple threads, thus improving the query efficiency. The SQL Server database provides the parallel query function for database servers with multiple CPUs to optimize the

When the system fails, data logs can be used to restore data to solve database faults. As an SQL Server database administrator, it is important to understand the role of data log files and how to use them to solve common database faults. Since the

Transaction processing is a key issue for all large database products. database vendors have spent a lot of energy in this aspect, different transaction processing methods may cause huge differences in database performance and functions. Transaction