Database Administrator

Turn RAC off (Oracle 12C note) Turn RAC off (Oracle 12C note) Check RAC status [Grid @ rac01 ~] $ Crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization

Migrate the Oracle database from the 32-bit platform to the 64-bit The disk of the customer's 32-bit Oracle database system is damaged. Fortunately, the Oracle database is intact. The customer requested that the database be migrated to the newly

Installation notes for Oracle 11g xe in Linux After several days, I finally installed Oracle 11G on the server and it was able to run properly. So today, we will record the brief installation steps and problems encountered during the installation,

The ADMIN password entered in INS-30011 does not comply with Oracle-recommended standards, ins-30011oracle 1. Error description 2. Error cause An error occurs because the first character of the password is a number. A. It must start with a

Check the ORACLE warning File Script and oracle warning script Check the important information within two days: Vi alter_error.sh echo "Check Alter Error:"cat $TRACE/alert_$ORACLE_SID.log | grep -E

Oracle Silent Installation and oracle Silent Installation Download the oracle installation package: : Note: To download oracle, you must register oracle. Http://download.oracle.com/otn/nt/oracle11g Download two

EBS first project learning summary, ebs first project summary EBS organizational structure: (1) Business Group (BG) (2) Legal Entity (LE) (3) Business Entity (OU) (4) Inventory Organization (INV) (5) Cost Center (Cost Center) (6) HR Organization (7

Principle and Practical Application of memcache, and actual application of memcache What is Memcache?Memcache is a danga.com project that was first used for LiveJournal. Many people around the world use this cache project to build their own websites

Database-stored procedures ., Database Stored Procedures Stored Procedure: Stored Procedures (Stored Procedure) are a set of SQL statements for specific functions in large database systems. They are compiled and Stored in the database, you can run a

Xin Xing makes mysql run faster. First, it optimizes the direction and database modeling. Xin Xing makes mysql I plan to write a set of bibliography recently, that is, about mysql optimization. First, I will write it on my blog and then sort it into

Mysql update modifies multiple data entries and mysql updatesGenerally, the following SQL statement is used to update the field value:Copy codeThe Code is as follows:UPDATE mytable SET myfield = 'value' WHERE other_field = 'other _ value ';However,

AWR report generation and simple analysis methods, awr Report Analysis MethodsHow to generate an AWR report: Step 1: When the database pressure test card starts: generate the first snapshot: SQL> exec dbms_workload_repository.create_snapshot

What is the difference between insert into, replace into, and insert ignore in MYSQL? mysqlignore The following statements are commonly used in mysql to insert data: Insert into indicates that the data is inserted. The database checks the primary

SQL table join diagram, SQL table diagram You can see through the figure below Multi-table queries are classified into internal and external connections. Outer join is divided into left join or left outer join, right join or right outer join, and

Test the impact of the stored procedure status on execution, and test the Stored Procedure status.Purpose: Test the impact of the stored procedure status on the operation of the stored procedure.Environment preparation: 1. Create a test table

Database Import and Export instance, Import and Export instance Import and Export instances: All the following commands are entered in the DOS window! User Creation reference: http://blog.csdn.net/gateway6143/article/details/41212823 　　 I. Data

Add, query, modify, and delete operations on data in basic SQL statements1. create a database: create database ;For example, create database student;2. connect to an existing database: use ;For example, use student;3. delete a database: drop

Multi-threaded SQL statements that do not repeatedly read data from SQL Server tables When sending text messages or emails, we often use a table to store the data to be sent, multiple threads in the background constantly read the data to be sent

SegmentFault! 1024 programmer game "Red shore call" task introduction the next day, segmentfault Seeing that the lab is about to close, let's take a look at the problem solving process (in fact, everyone is waiting for the third question to come

SQL Server database design specifications (1) 1. Introduction Database Design refers to constructing the optimal database mode for a given application environment, establishing a database and other application systems, so as to effectively store