Database Administrator

Oracle JOB exception and interruption Cause Analysis Note: Today, my R & D colleague asked me to check whether the job stored in PKG_WMS.proc_TaskMain is still running. After all, I found that dba_jobs.NEXT_DATE = 4000/1/1. See the following for the

Batch operation records of moving table and rebuild index Batch move tables in the oldtablespace tablespace to newtablespace. query and execute the query results. Select 'alter table' | table_name | 'move tablespace newtablespace' From

Summary of physical DG Master/Slave switchover Environment check Check parameter file configuration of two RAC SQL> show parameter spfile; SQL> show parameter fal; Lsnrctl status Tnsping view the connectivity of TNS To use RAC as the slave database,

Create a MySQL table cyclically and update the two tables. Create tables cyclically Using Stored Procedures DELIMITER // Create procedure test. create_channel_avail () BEGIN DECLARE '@ I' INT (11 ); DECLARE '@ sqlstr' VARCHAR (2800 ); SET '@ I' = 1;

MySQL Master/Slave database switch records Old Master database: Lock the table of the master database before switching to prevent data from being written to the master database during switching. Mysql> flush tables with read lock; Old slave database:

MySQL Operation Specifications (Summary) User permission management Create user Command: create user 'username' @ 'host' identified by 'Password '; Note: Username Host specifies the host on which the user can log on. If the local user can use

MySQL common error analysis and solution Summary 1. Can't connect to MySQL server on 'localhost' (10061)Translation: cannot connect to mysql on localhostAnalysis: This indicates that the "localhost" computer exists, but the MySQL service is not

455th questions, 053455 455. When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?(Choose all that apply .)A. The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE. B.

Difference between mysql int (m) and int (m), and mysqlint It is estimated that most of my friends who are getting started with mysql will have this question: what does the value in int (M) mean? According to the relevant information, we summarized

Analysis of High cpu overhead of smon processes, smoncpuToday, I suddenly found that the cpu of an online oracle database server was running very high and it was not very normal. I checked it carefully and found that the smon process had eaten a cpu.

MySQL query ERROR: No query specified, mysqlspecified Today, one netizen reported the ERROR "ERROR: No query specified" in the query and sent it later; Root case: query syntax error \ G cannot be followed by a semicolon; because \ G is

Mysql strange connection error, mysql strange Error Today, I encountered a database connection problem:Unlike the mysql connection problem on linux, It is permission settings, and the origin of this problem is: I want to import a csv file to

SQL Sever -- cannot connect to (local ). Sqlsever Solved the "remote process call failed (0x800706be)" mentioned in the previous blog. New problems are coming soon... I, Solution: In the SQLSever Configuration Manager, find "SQL Sever service" and

561st questions, 053561 questions561. If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode,What will be the result when you issue the command alter database archivelog?A. The alter database archivelog

Learn to read MySql slow query logs and mysql query logsWhen and how to enable MySql logs in the blog at the front end We learned how to enable MySql slow query logs. Today, let's take a look at how to read these slow query logs.Before tracking slow

Some important knowledge points about rman duplicate-Series 3, rmanduplicateFYI: Http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#RCMRF126 Rman duplicate database must be on the same platform, but 32bit \ 64bit replication is

After hadoop namenode is reformatted, The hmaster process of hbase disappears immediately after it is started. hbasehmaster After the hadoop namenode is re-formatted, restart hbase and find that its hmaster process disappears immediately after it

Oracle official doc_view initialization parameters (example), oracle Initialization Original works, from the blog of "Deep Blue,Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/46864217 Record the steps for viewing initialization

[Oracle] restores all redo logs physically when the database is running. oracleredo Lab environment: OEL5.6 Oracle11.2.0.1 Lab started: Database running status, delete all logs: [Oracle @ itaa test] $ ls Control01.ctl redo01.log sysaux01.dbf undotbs0

MySQL command line login, mysql Command LineEnvironment IntroductionOS: CentOS6.X & Win2003 & Win2008MySQL version: 5.5.xIn addition to common MySQL management tools, MySQL client command line tools are often used.1. Install the command line tool in