Database Administrator

When installing Oracle 11g RAC, We need to configure the ntp service. There are many ways to configure the clock synchronization mode when using virtual machines. You can use the clock synchronization feature provided by vmware or directly use a

In addition to using DBCA to delete the Oracle 12C database, we can also use the drop database Command to delete it.This deletion method is very simple, but must meet the following two requirements:1. The database must be in the mount State and

GoldenGate software has been used by many large enterprises for Data Disaster Tolerance. For remote backup and disaster tolerance, many of these data needs to be transmitted through leased lines of the public network. Many of these data are

When using mysql, when I want to use desc to view the table structure, the following error message is displayed: ERROR 1 (HY000): Can't create/write to file '/tmp/#sql_1737_0.MYI' (Errcode: 13) I have never met anyone. I searched the internet. The

This is a real oracleORA-19815 solution) case, hope to help everyone.Today, the platform of a friend company encountered slow login and slow data query, and the failure to log on to oracle monitored through spotlight. No problems were found by

An SQL example that causes a deadlock is provided.Deadlock definition: in a broad sense, it includes the operating system application database. If two Process sessions hold each other's resources, they always wait for the other to release. This

In the forum, I encountered a problem where I could not Attach the database. The error message is:   Msg 5171, Level 16, State 1, Line2 "path \ allen_log.ldfcm not a primary database file.   Obviously, this error indicates that the file selected by

1. Configure the database to run in ARCHIVELOG Mode Before ORACLE 10 Gb, you must start the arch process after placing the database in Archivelog mode. Set LOG_ARCHIVE_START to true, or start the arch process. In This method is not required after 10

  The blocking mechanism is mainly used to control concurrent operations, block interference, and ensure data consistency and accuracy. There are three ways to block Oracle databases: Shared blocking, exclusive blocking, and shared update

SQL Server 2000 provides some XML functions, which are used to convert the XML documents in the component layer of the relational row set through XML, read XML documents, and load data in batches. For example, you can pass an XML document to a

The new 10g ASM production database is coming soon. The following is a simple Backup recovery test before the release:1. perform backup first $ Rman target/@ full_bak. SQL Recovery Manager: Release 10.1.0.3.0-64bit Production Copyright (c) 1995,200 4

Oracle Enterprise Manager is a management framework that enables you to manage a Complete Oracle environment, including databases, iAS servers, applications, and services.Diagnose, modify, and optimize multiple databases. Tasks are scheduled at

Oracle databases are favored by more and more enterprises for their high reliability, security, and compatibility. Many database administrators are concerned about how to maintain excellent performance of Oracle databases. Based on my experience, we

Full backup SH file: exp_comp.sh Rq = 'date + "% m % d "' Su-oracle-c "exp system/manager full = y inctype = complete file =/oracle/export/db_comp $ rq. dmp" Cumulative backup SH file: exp_cumu.sh Rq = 'date + "% m % d "' Su-oracle-c "exp

We all know that informix requires logs. However, we will discuss the usage and significance of each log as follows: The first thing to note is that there are two types of informix logs: Physical logs used to store the front image of data, and

The core architecture of Informix Dynamic servers is designed to provide built-in multi-clue and parallel processing capabilities.Multi-clue On the database server, the Informix dynamic server uses an adjustable database server process pool called a

#! /Bin/cshIf ($ # argv! = 1 thenEcho "Usage: csh deltmp. sh [dbname]";Exit (0 );Else if ($ # argv = 1 thenSet dbname = "$ argv [1]";EndifRm deltmp *. SQLEcho "now load tmp table to deltmp. SQL"Dbaccess $ dbname Unload to "deltmp. SQL" Select

With the development of banking business, its database is also growing rapidly. Therefore, effectively controlling the database size and reasonably organizing tables can improve computer operation efficiency and reduce financial risks. As we all

ORA-00903 invalid table name ORA-00903:Invalid table name Cause A table or cluster name is invalid or does not exist. This message is also issued if an invalid cluster name or no cluster name is specified in an alter cluster or drop cluster

How can I clear the Sybase master database logs when they are full? You can manage the master database by using the following methods. If you do not have enough space, you can consider resizing the master database. 1. In simple cases, dump trans