Database Administrator

In the Oracle world, only one database can be opened for one instance. If I want to run two databases simultaneously on the local machine, I need to enable two instances, and the ID of the different instances is SID. Close the existing database, set

Preparations before installation: Download the server Installation Package (rpm package) and Client installation package: I use the latest version on the official website: Server: MySQL-server-5.1.53-1.glibc23.i386.rpm Client:

See the following demo:$ Cat. bash_profile... ...# PATH = $ PATH: $ HOME/bin # Export PATH Oracle_SID = ltyORACLE_BASE =/u01ORACLE_HOME =/u01/oracle# PATH = $ ORACLE_HOME/bin: $ PATH# LD_ASSUME_KERNEL = 2.4.19LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/

The following problems are encountered in the project. A url is sent from the page. Search for records based on the url. The key is that the url address contains special characters. Such as single quotation marks, address characters, and so on. '%'

Download sqlite-3.3.6.tar.gzDecompress and copy to the directory where you want to install it. What I chose is/usr/local/sqlite-3.3.6.Then in the terminal:# Cd/usr/local/sqlite-3.3.6#./Configure# Make# Make install# Make doc An error is prompted

1. What is an elastic domain? FlexValue is a field composed of child fields or segments. It is displayed as a pop-up window containing prompts of each segment on the form. Each segment has a name and a valid value set. For example, Guangdong mobile

Oracle has three main file types: control files, data files, and log files. Log Files record all operation records on the database and provide a recovery mechanism, before writing data to a data file, oracle needs to write the modified content to

1. Statement to modify the Oracle user password Alter user edw1010 identified by edw1010; In fact, this is very simple, but because it is not commonly used, it may seem a little busy. 2. View deleted code scripts The reference statement is as

Oracle record user DDL operation script -- The current common user creates issgztCreate table TAB_DDL(LOGIN_USER VARCHAR2 (60 ),Audsid number,MACHINE VARCHAR2 (60 ),IPADDRESS VARCHAR2 (20 ),SCHEMA_USER VARCHAR2 (60 ),SCHEMA_OBJECT VARCHAR2 (60 ),DDL_

An ora-00955 error occurred when adding a field to the primary key Add an id2 field to mytable and make it one of the primary keys. The original primary key name is mytable_pk and the field is (id). follow these steps: 1. Delete the primary key:

To migrate data files using rman: 1. Run copy in the rman window.Copy datafile 1 to '+ TESTDG/rac/datafile/system. dbf ';Copy datafile 2 to '+ TESTDG/rac/datafile/sysaux. dbf ';Copy datafile 3 to '+ TESTDG/rac/datafile/undotbs1.dbf ';Copy datafile 4

Installation environment:Operating System: CentOS6.5 _ x64 DesktopHost Name: OracledbMemory: 1 GB (minimum official requirement: 1 GB)Hard Disk: 40 GB (4.29G and 1.7G data files required for Enterprise Edition installation)System preparation before

I. Windows cracking:1. Stop the mysql Service2. Enter the command window, enter the bin directory under the mysql installation directory, skip permission detection, and start mysqlMysql \ bin> mysqld-nt -- skip-grant-tables3. open a new window, go

Reconfigure OCR and vote disk (11.2.0.1.0) 1. format the disk of the disk where the original ocr and vote disk are located.[Root @ pmstest2 ~] # Dd if =/dev/zero of =/dev/sdb bs = 1024 k count = 11 + 0 records in1 + 0 records out1048576 bytes (1.0

Before installing Oracle on linux, You need to perform a series of configurations. Manual execution of each environment is slow;Two scripts are written here for automatic configuration and installation. Currently, the installation is successful on

Use yum install mysql-mmm for installation. After the mmm software is installed, the configuration is completed, but the following error is reported when the/usr/sbin/mmm_control show command is executed: ERROR: Can not connect to monitor daemon!

In March January 2014, the database needs to be moved from the original storage platform to the new storage platform due to changes in the hardware environment. That is, change the underlying storage medium of the database. The following describes

Set encoding when MySQL connects to the database The default encoding of the MySQL database used by the user is UTF8, while that of the server is GBK. There are always many data writes. Com. mysql. jdbc. DriverJdbc: mysql: // localhost: 3306/db1?

Abstract: It mainly records the knowledge about Oracle stored procedure, from definition to use. Start with the simplest example and go deeper. At the same time, the use of ref cursor is combined later. By the way, I added how to use it in java.I.

Percona is a branch of mysql. I believe many of my friends are familiar with it. percona-toolkit is a toolkit launched by percona. It contains a lot of useful and useful mysql maintenance kits, I started to learn about this tool today. The first