Database Administrator

Recent field feedback: a messaging program accessing the Oracle database records some error logs about "ORA-00060: deadlock detected while waiting for resources. However, after the communication program record is abnormal, it does not crash and can

Install MySQL in Ubuntu Sudo apt-get install mysql-server This should be very simple, and I don't think there is much problem with the installation, so I will not talk about it much. Let's talk about the configuration below. Configure MySQL Note: In

1. Upload the executable file IF_FIN_BOSS_IMP_V2.prog to the $ IT_TOP/bin path of the server through FalshFXP: 2. Define the executable program (for example, executable program, request-call-> executable) Access path: application

The name of the table generated by PowerDesigner is enclosed in quotation marks as follows: /* ===================================================== ======================================= *//* Table: "EPPD_ B _BILL_INTERCALATE "*//* ================

Oracle pseudo columns and pseudo tables   To implement the complete functions of relational databases, the oracle system provides a database column that is composed of pseudo columns. These columns are not completed by us when an object is created,

1) SQL * Plus login. SQL FileWhen you use SQL * PLUS to log on, SQL * PLUS reads and executes the script in the following order:· $ Oracle_home/sqlplus/admin/glogin. SQL· Login. SQL in the current directory, or set an environment variable SQLPATH

1, ERROR: ORA-12560: TNS: protocol adapter error Listener is not started. start listener: lsnrctl start on the server where the database is located. 2, ERROR: ORA-01033: Oracle initialization or shutdown in progress Oracle is not in the open

-- Create a databaseCreate database Etp; -- Connect to the databaseConnect to Etp; -- DisconnectDisconnect Etp; -- View tables in the current databaseList tables; -- Create a tableCreate table studentInfo (Stuno char (5) not null,Stuname varchar (8 )

1--Create temporary tablespace2 Create TemporaryTablespace data_temp3Tempfile'D: \ Oracle \ oraudata \ data_temp.dbf'4Size 2000 m5AutoextendOn6 Next500 m7Extent management local;8 9 --Create a data package Space10 CreateTablespace data_data11Logging1

There are three methods to restore controlfile by restoring controlfile. The functions are the same and you only need to know one of them.Method 1: Restore from autobackupBy default, controlfile is automatically backed up when the database is backed

I. Master-slave SynchronizationRefer Ii. Incremental Backup:Perform full backup at PM and PM every day, and back up binlog every one hour, that is, Incremental backup. The specific operations are as follows:Enable binlog in LinuxAdd the mysqld

Checkpoint not complete information found in the alter log recentlyCause analysis:First, what is checkpoint?A chkpoint is an internal mechanism of a database. It has two purposes: 1. ensure data consistencyWhen the system checks, the DBWR process

Scenario: Synchronize tables from Oracle A to Oracle B 1. Create a database link (client B)SQL code Create Public DatabaseLink dblink_name  Connect ToA_user_name identifiedByA_user_password Using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS =

Em for configuring non-default listening PORT (1521) (※parameter name-SID and-PORT must be in uppercase)Emca-config dbcontrol db-repos recreate-SID t11g-PORT 1715Dynamic listening must be configured:(You need to manually register listener for

Install Oracle 10.2.0 in a 64-bit Linux operating system, 1. install an xmamanger software locally to start xmanager-passive. 2. Create an oracle user and dba group on the server. useradd oracle-g dba 3. Modify the. bash_profile of the oracle

There are four functions that support regular expressions in Oracle: 1. REGEXP_LIKE: similar to LIKE 2. REGEXP_INSTR: similar to INSTR 3, REGEXP_SUBSTR: similar to SUBSTR 4. REGEXP_REPLACE: similar to REPLACE They are used in the same way as Oracle

RedHat linux as 5 and Oracle10g are used in oracle10g installation in linux. 1. Install System Patches first[Root @ oracle rpm] # rpm-ivh libXp -* Warning: libXp-1.0.0-8.i386.rpm: Header V3DSA signature: NOKEY, key ID 82fd17b2 Preparing... ##########

Environment: RHEL6 + MySQL-server-5.5.18-1.el6.i686 + MySQL-client-5.5.18-1.el6.i686 Problem: Directly download the package and use RPM for installation. An error is displayed. Run rpm = pa | grep mysql * to check whether MYSQL has been installed.

MySQL description: An article library contains two tables: category and article. There are 10 classified data entries in category. There are 0.2 million articles in articles. In article, there is a "article_category" field that corresponds to the

Operating Environment MASTER:192.168.1.124 From:192.168.1.125 Mysql- 5.0.56 .Tar.gz,CentOS5.2 Database1:/Data/3306/Database2:/Data/3307/ 1Modify master databaseMy. cnf ====================================== # Vi/etc/my.