Database Administrator

DML ErrorLogging  Oracle provides two types of exception tables.  This is a new feature available in Versions later than 10gR2.  DML error logging is a new feature in ORACLE10gR2. This new feature solves the following problems: assuming that you

Problem: Use pl/SQL developer to debug Oracle stored procedures. Right-click the stored procedure, select test, and press f9 (debug ). If this is normal, the buttons such as run and step into can be clicked, or click run to the breakpoint, or

To modify the Oracle10g port, you must modify two files. (Modified by Red Hat linux as4u6) Listener. ora and tnsnames. ora All files are in the/opt/oracle10g/product/10.2.0.1/db_1/network/admin directory. Modify listener. ora as follows: ------------

A cluster consists of the following three services: Shards Server: each shard is composed of one or more mongod processes used to store data.Config Server: used to store the Metadata information of a cluster, including the information of each Shard

It is a gradual process to collect my own understanding of Mongodb's advantages and disadvantages, or to reference or extract from other reliable online files, it also expands with my understanding of Mongodb. (1) Mongodb limitations 1. Uneven

After building the MongoDB cluster (SEE), you need to create a database, create a table, and set the partition primary key to initialize the data! (1) create a WLB database and set the table shards wlb_orders D:/mongodb-win32-i386-1.8.0/cmd> cd

MongoDB is a scalable, high-performance, open-source, free-mode, document-oriented database. It is not a commonly used RDBMS and belongs to the database category of the popular NoSql database. It is not the same as a general key-value-based db

In daily workDBAData transfer is often encountered. The most typical thing is to import the database running in the online system to the test environment for related upgrade tests and stress tests. The following two methods are used to clone a

The following are related records of installing PostgreSQL 5.5 On CentOS 9.1. (1) download the postgresql9. 1 RPM installation package from the http://yum.pgrpms.org/repopackages.php[Root @ server1 ~] # Wget http://yum.pgrpms.org/9.1/redhat/rhel-5-i3

The process of a Delete operation in OracleDELETE)1. Oracle reads the Block to the Buffer Cache (if the Block does not exist in the Buffer)2. record the details of the delete operation in the redo log buffer.3. Create an undo entry in the

Lab environment: CentOS5.0 + Oracle11gR2.0 Objective: To test the cold standby and complete Recovery of the Oracle database in NOACRHIVE mode. Location of the original file:/u01/oradata/denver. restore to the/u01/oradata/md directory. Tutorial

I decided to modify the name of the database when I was idle recently. I remember I learned how to modify the name of the database by recreating the control file, you can use the nid of Oracle to modify the database name. However, this method is

Change ORA Password Expiration problem: ERROR: ORA-28002: the password will expire after 7 days 1. putty Login Server 2. Perform sqlplus/as sysdba 3. Change the session garbled command: alter session set nls_language = american 4. view the user's

First, use the useradd weblogic command to create the weblogic account Run the script shown in the weblogic directory and execute weblogic installation. The welcome page for Weblogic is displayed. Click Next to continue. Create the BEA

table detection, creation, and deletion. # Include # Include # Include # Include # Include BoolDb_tableExists (sqlite3 * db,Const Char* Tbname) { IntNRet; Const Char* SzTail; Sqlite3_stmt * pvm; CharSQL [1024]; Sprintf

Integrity constraintsIntegrity constraints are used to enhance data integrity. Oracle provides five integrity constraints: CheckNOT NULLUniquePrimaryForeign key Integrity constraints are a rule that does not occupy any database space. Integrity

Structured Query LanguageThere are four types of statements:Data Query Language DQL-Data Query Language SELECTData Manipulation Language DML-Data Manipulation Language INSERT, UPDATE, DELETEData Definition Language DDL-Data Definition Language

We will focus on several SCN SCN in control file 1. System checkpoint SCN After a checkpoint is completed, Oracle stores the scn of the system checkpoint in the control file. 2. Data File checkpoint SCN After a checkpoint is completed, Oracle

Log on to the database using the following methods in Oracle in Linux: sqlplus/nolog conn/as sysdba, but it gets stuck at the conn/as sysdba step and cannot be logged on, and check whether the listening status does not respond. This is a bug in

Use mysqldump + crond for backup Create a database backup sh file such as/root/sbin/db-backup.sh DATE = 'date + % Y-% m-% d' /Usr/bin/mysqldump-uroot-p123456 mydatabase>/root/backup/mysql-backup. SQL. $ DATE Contents are all tables in the backup