Database Administrator

Oracle bug solved: ORA-20446 Error I downloaded an Oracle 11g and want to see what new features are available. After the installation, enable EM and find that the feature is excellent. It is used to import data from another database. Set to import

Oracle error -- ORA-03113: file end solution for communication channel Origin Today as usual, login PL/SQL, indeed login failed, there is an error "ORA-01034" and "ORA-27101" Then I log on to Oracle through the command prompt, to view what is going

Oracle non-archive mode Media Recovery error-ORA-26040 System Environment: Operating System: Linux RH55 Oracle: Oracle 11gR2 Simulation case: 1. view the database mode 18:12:36 SYS @ prod> archive log list; Database log mode No Archive

SQL Server queries the remote database table data to the local database, sqldbStep 1: Sp_configure 'show advanced options', 1; RECONFIGURE; sp_configure 'ad Hoc Distributed Queries ', 1; RECONFIGURE; GO Step 2: Insert into

Oracle listener lsnrctl, listenerlsnrctl Lsnrctl (Listener Control) is an SQL * Net tool used to Control the listener database. This tool provides commands to Control the start and stop of listener and view the status of listener, changes the

Database Design-semi-structured storage and database structured storage Business scenario: the user fills in some documents, reports them, and approves them. There are several fields in the document that need statistics, and the business is not

Dbca database error: ORA-19504 ORA-12547 ORA-15001 ORA-15055, dbcaora-19504 [Problem] This error was found on Baidu, and the content of the entire TM was actually depressing. Later, I opened Google, Error time: When [asm, 1] ASM installation +

MySQL bin-log analysis method, mysqlbin-log Author: Echo Chen (Chen Bin) Email: chenb19870707@gmail.com Blog: Blog.csdn.net/chen19870707 Date: September 9th, 2014 Some time ago, when the game server was suspended, it was always slow.

Hibernate operates Blob data and hibernateblob data   First, let's look at the database. Create a New BlobTable table in the database. The table has two fields, one id (primary key) and one picture field, which is a Blob field. Then, use Hibernate

PHP operating MongoDB module linux, detailed introduction (7), mongodblinux In linux, why did I quit immediately after I got connected to mongodb? Connect failed, not connected at all, not just connected and exited.Check whether

Zend_Db_Expr, zenddbtable When using Db classes in zendframework, the Framework automatically adds quotation marks to SQL statements to prevent database attacks. This causes a problem, you cannot use the zend db class to use mysql built-in functions

2-dimensional topology-based accessibility Query1. Basic Concepts In a directed acyclic graph, r (u, v) indicates whether there is a path between u and v. When there is a path between u and v, r (u, v) returns true, that is, u to v is reachable;

Test interview that little thing (database knowledge), test interview 1> relational database standardization is introduced to solve the problems of relational databases (insertion exceptions, deletion exceptions, and data redundancy.   2> the

Table space status (2). Table space status Tablespace status-read only, READ WRITE 1. The primary purpose of the read-only tablespace is to eliminate the need for backup and recovery of most static data in the database. Oracle does not update

Common shell script running Log Module, shell logTarget Implement recording of SHELL execution start time, end time, running status, error information, etc. Use the function to encapsulate log records and use scripts to call functions.Source code

Mysql database copy, mysql databaseWe often have this requirement to copy the mysql database on a server to another machine, such as database migration. To do this, use the ready-made mysql tool mysqldump. When using mysqldump, you must specify the

Blue growth notes-Chase DBA (2): Install! Install! Long-lost memories have aroused my new awareness of DBAs.Blue growth notes-Chase DBA (2): Install! Install! Long-lost memories have aroused my new awareness of DBAs. ********************************

CentOS6.5 Oracle11G-R2 installation, uninstall, linuxoracle11gr2 CentOS6.5 Oracle11G-R2 installation, uninstallResources (including all my installation processes, system backup files): http://download.csdn.net/detail/attagain/7700437 I. Hardware

The error and solution after the sqlserver host name is changed. The sqlserver Host Name After changing the Host Name of the sqlserver server, you need to perform some operations. Otherwise, there will be problems with the maintenance plan and

An I/O error occurs in SQL Server due to cloning backup from a virtual machine. CASE Environment: Server Configuration: CPU: Intel E5-2690 RAM: 12 GB Virtual Machine Operating System: Windows Server 2008 R2 Standard Edtion x64 Database Version: SQL