Database Administrator

Two days ago, the ICBC website could not be opened, and then we saw the news, saying that the announcement of the price increase on the ICBC website was missing. It is estimated that the incident will soon be terminated. Last night, QQ suddenly fell

In project development, we often have complicated business logic. Using the stored procedures of Oracle can greatly reduce the compilation workload of java program code, and the stored procedures are executed on the database, so that the good

First, create a user. Groupadd oinstall Groupadd dba Useradd-g oinstall-G dba-s/usr/bin/csh-d/export/home/Oracle-m oracle Second, create an access point Df-k Mkdir-p/opt/app/oracle/10.2.0 Mkdir-p/opt/app/oracle/doc Chown-R oracle:

In daily database maintenance and database programming, we often hesitate to perform DML operations on large data volumes, so that Oracle's undo tablespace can be extended to dozens of GB or dozens of GB. the physical space occupied by the disk will

Environment: Linux Version: 2.6.9-22. ELsmp Data Protecter Version: A.06.00 DP Server: Installed in Windows 2003 The following is a brief introduction to the installation process. 1. Attach the installation disc to the optical drive and mount

1. view the progress of EXPDP/IMPDP1. Two views When you export a large volume of data, some people may be anxious to see the progress. You can use two views: DBA_DATAPUBMP_JOBS and DBA_DATAPUMP_SESSIONS views Col owner_name for a10 Col job_name for

Redis is an open-source, network-supported, memory-based, key-Value Pair storage database written in ansi c. Its development is hosted by VMware. Redis is the most popular key-Value Pair storage database, according to the data of the monthly ranking

RAC: Real Application Cluster (Real Application Cluster) is widely used. As an Oracle Database Cluster Environment, RAC has a complete set of management knowledge. Here I will demonstrate the restart process of rac. Recommended reading: Oracle 11g

MySQL is the most popular database management system in the world and the first choice for programming communities all over the world. It has an interesting series of features and is very good at many aspects. Thanks to its popularity, you can find

In the case of physical damage to Oracle data blocks, backup can be used directly for recovery if we have a backup. For Backup recovery, Volume El provides us with many methods, such as cold backup, user management, and RMAN. For these methods, we

Environment:Operating System: RedHat 5.3 64bitOracle version: Release 10.2.0.1.0 The following error occurs when you start a test Oracle Database today:SQL> startupORA-27125: unable to create shared memory segmentLinux-x86_64 Error: 1: Operation

After manual database creation (10.2.0.1), run the following command during EM creation: Emca-config dbcontrol db-repos create The following error occurs: ORA-06550: line 1, column 21:PLS-00302: component 'valid' must be declaredORA-06550: line 1,

Oracle 10g provides four regular expression functions: regexp function: REGEXP_LIKE, REGEXP_REPLACE, REGEXP_INSTR, REGEXP_SUBSTR. REGEXP_LIKE: (matched) checks whether a string matches a regular expression.(Srcstr, pattern [,

I. multiplexing of Control FilesA) shutdown immediate; B) in the operating system, copy the backup file to the new disk and copy the full path of the new control file; C) startup nomount; D ),Alter system set control_files ='F: \ Oracle \ PRODUCT \ 1

After listener. ora and tnsnames. ora are configured, the following error is reported after the listening command is started: [Oracle @ gc1 admin] $ lsnrctl start   LSNRCTL for Linux: Version 10.2.0.1.0-Production on 25-APR-2014 23:27:57   Copyright

1. First add three Disks 2. Installation Package [Root @ myorcl asm] # ls Oracleasm-2.6.18-348.6.1.el5-2.0.5-1.el5.i686.rpm Oracleasm-2.6.18-348.6.1.el5debug-2.0.5-1.el5.i686.rpm Oracleasm-2.6.18-348.6.1.el5PAE-2.0.5-1.el5.i686.rpm Oracleasm-2.6.18-3

I plan to take a technical note on the Oracle index topic, because today I helped a friend in Shenzhen to perform the rman test and found a ORA-XXXXX error while restoring my raw data. The test results are as follows:Run {Allocate channel category

Symptom: The test database uses the following method to create an index: Create index IDX_ANA_OFFICE on ANA (OFFICE_CITY, OFFICE_NO)Tablespace IDXPctfree 10Initrans 2Maxtrans 255Storage(Initialize 128 KNext 128 KMinextents 1Maxextents

Background: Recently, we are engaged in data migration. We have migrated data from U1 users in database A to U2 users in database B. We have used open-source kettle to work with the Data Pump. It's Okay during the test, but it's actually going

1 SQL ordered by Elapsed TimeTop SQL statements that record the total execution Time (note that the total execution Time of the SQL statement within the monitoring range, rather than the execution Time of a single SQL statement Elapsed Time = CPU