Database Administrator

I am from Fedora. If it is another one, it is slightly different on the command line. 1. Install the database driver Adapter Http://sourceforge.net/projects/mysql-python/ 2. Unzip the package and install the package. problems may occur during

1. Use Database-level triggers to control the alter \ drop \ truncate permissions of non-sys and system -- control the create or replace trigger sys. TRIGGER_ALTER operationBEFORE ALTERON DATABASEBeginIf ora_login_user not in ('sys ', 'system')

OracleWe only use the server to install databases, and its clients have multiple options. The following section describesOracleThe main installation steps of the database server. 1InWin 7LowerFirst modify OracleServer program compatibility Click

When we define a very complex cursor, this cursor takes a long time to execute. During the execution of this cursor, other users modify the data of the table referenced by this cursor, does cursor get the data before or after modification? The

Oracle logs are classified into three categories: Warning logs-= Alert log files; Trace logs-Trace filesUser and process); redo log -- redo log records database changes ). Redo log file redo log files, including archive redo log files ---------

In order to cope with accidents, backing up the database is essential. How to write the backup script? Before writing the script, assume that the bin directory of mysql is/usr/local/mysql/bin/ PATH = $ PATH: $ HOME/bin # Backup Directory

I. Multi-version concurrent access control Oracle can automatically implement read consistency (read consistency) of a query, that is, the data obtained by a query comes from the same time point (single point in time) (This is also called

Opening the cmd command line is definitely not a mysql command line. The first time I was wrong in this place, I was depressed for a long time. Command for backing up MySQL database Mysqldump-hhostname-uusername-ppassword databasename> backupfile.

1. Modify the archiveCreate pfile = '/Oracle/pfile0209.ora' from spfile;Srvctl stop database-d orcl 2. Change *. cluster_database in/oracle/pfile. ora to false.Startup mount pfile = '/oracle/pfile0209.ora ';Alter database archivelog;Alter database

1Method1 [Oracle @ rhfour test] $Strings control01.ctl 2Method2 Connected: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production With the Partitioning, OLAP and Data Mining options   SQL>Alter database backup controlfile to trace as '

Recently, the company has prepared a test machine to install Oracle 11 GB to RedHat AS4, which records Oracle considerations: Oracle open file descriptor 65536 Error modification: ulimit-a first view the relevant parameters, and then modify them

Create table Image_lob (t_id varchar2 (5), t_image blob ); Create or replace directory images as 'e: \ image '; SELECT * FROM Image_lob; Create or replace procedure ima_insert (tid varchar2, filename varchar2, v_path varchar2) F_lob bfile; -- file

Public is not a role. You can understand it as a set of all database users. If a permission is granted to the public, the database user can have this permission (of course, some users may not have the connect permission ). For example, if you want

My database was suspended for no reason. The following error was reported when I started the database today: SQL> alter database open; Alterdatabase open * ERROR atline 1: The ORA-16014: log 3 sequence #99 not archived, no available destinations ORA-

Because MongoDB's memory is managed by the system's virtual memory, MongoDB does not interfere with memory management. This can simplify Mongo's work, but the memory usage of Mongo cannot be controlled at the same time. Is it really uncontrollable?

Today, a customer's database accidentally deleted the data files in the entire directory and deleted them at the operating system level. Fortunately, the database did not crash and was still in the open state, the customer found the problem and

If the primary stored procedure and primary function are composed of sub-procedure or sub-function, can the sub-function or sub-program contain exception handling? Follow these principles: 1. If the main program and subprograms are to be processed

Read/write separation while backing up Topology: Database Synchronization replication software is an important part of disaster recovery for key systems. When the production system encounters exceptions or faults, the database of the backup

Oracle Installation on Linux has become a nightmare for many engineers due to its tedious process and high error rate. Some time ago, due to work needs, we installed oracle several times on HP's PC servers and minicomputers. The process was as bad

We add User. hbm. xml to some extensions to illustrate the meanings of common attributes: Xml Version='1. 0' Encoding='Utf-8'?> PUBLIC "-// Hibernate/Hibernate Mapping DTD 3.0 // EN" Http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">