Database Administrator

1. on Linux, after logging on with an Oracle user, run:[Oracle @ h16 oracle] $ sqlplus/nologSQL * Plus: Release 9.2.0.4.0-Production on Tue Feb 19 16:42:38 2008Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.SQL> connect

MySQL transaction processing Learning Start transaction, COMMIT, and ROLLBACK syntaxStart transaction | BEGIN [WORK]COMMIT [WORK] [AND [NO] CHAIN] [[NO] RELEASE]ROLLBACK [WORK] [AND [NO] CHAIN] [[NO] RELEASE]Set autocommit = {0 | 1} The start

1. Oracle has two ways to connect to the database: local or remote. When you log on to the database server, set Oracle_SID, and no longer connect to the database specified in $ sqlplus system in the string, use a local connection. The local

Platform: Red Hat RHEL5 + VSFTPD + MySQL 1. Install MySQL Mysql-5.1.7-beta-linux-i686-glibc23.tar.gz# Tar zxvf mysql-5.1.7-beta-linux-i686-glibc23.tar.gz# Ln-s mysql-5.1.7-beta-linux-i686-glibc23/usr/local/mysql# Cd/usr/local/mysql#

1. After mysql is installed in Linux, the default value is: case-sensitive for table names, not case-sensitive for column names; 2. log on to the/etc/my. add lower_case_table_names = 1 after [mysqld] In cnf and restart the MYSQL service. The

I wrote a script to check whether the SLAVE of MySQL REPLICATION is normal in Linux, which is relatively simple.If you want to run it with CRONTAB, remove the Read part.1. Run the MYSQL Command show status to View Script 1.[Root @ localhost ~] # Cat

1. Source: http://vegan.net/tony/supersmack/ 2. installation: Note that during compilation, You can first copy the corresponding libmysqlclient. so. * To/usr/lib. 3. test: [Root @ DB_Backup smacks] # super-smack-d mysql select-key.smack 10

I. Compilation and Installation ./Configure -- prefix = installation pathMakeMake install Run the mysql Script: installation directory/bin/./mysql_install_db -- user = XX (xx is the Freebsd user name) 2. modify the configuration file: Copy my.

Learn how to use RIA Framework Flex to create a MySQL management UI The emergence of PHPMyAdmin shocked the industry, and there is no doubt. It is of course the best PHP-based application, because it changes the MySQL management interface from the

1] in Linux, how does one create a management user for the mysqld database?After the database is installed, we should create a management account for the mysql database. To set the root user as the administrator, we should run the following command;[

In Oracle, user permissions are divided into two types (this article does not involve dba or role permissions, but only describes the permissions of common users ), system Privilege System permission and User Table Privilege User data Table

When querying the Oracle database server, it is found that the disk space of the database server reaches 98%, and the total data files for analysis cannot reach this level, after query, the usage of the original temporary tablespace reaches 32 GB,

Database Version: 5.1.24. For databases of Version 4. x, go to the relevant documentation. English document address: http://dev.mysql.com/doc/refman/5.1/en/replication-howto.html 1. When the master server (master) runs normally, create a user

The postgresql installed on the server has not been used for a long time. It is actually used for redmine databases. Considering that mysql may be upgraded frequently, and the connection component of rails is a little difficult to install, it was

You need to back up both the cacti-backup. SQL and syslog. SQL databases, and the/var/www/html/folder and its overall content. Restore files and databases: 1. Restore all content in the html folder to the original location: A. decompress the

1. delete archivelog all will delete all archived logs without reservation (corresponding records are recorded in the control file) 2. the archived log information is recorded in the control file. the lifetime and total number of retainable logs

View the current License status SQL> show parameter license;NAME TYPE VALUE-----------------------------------------------------------------------------License_max_sessions integer 0License_max_users integer 0License_sessions_warning integer 0 View

The recent data import (IMP) encountered a ORA-01187 ORA-01110 error because the database was restored with hot standby, and the recovery was successful because the database was successfully open, so where are the omissions? If you have a similar

1. Differences between dba, sysdba, and sysoper A dba is a role. A role can contain system permissions, object permissions, and roles. A dba does not contain sysdba and sysoper permissions; Sysdba and sysoper are two types of system permissions. If

'Test' is a reserved word of Oracle. Therefore, you must pay attention to it in some places. Currently, I have found that oracle treats it as a reserved word during rman backup. TEST is indeed a reserved word in rman... When backing up other