Database Administrator

CRS-0184/PRCR-1070 when Oracle 11g RAC executes root. sh Oracle 11g RAC installation, the first node to execute root. sh encountered a CRS-0184/PRCR-1070, Google a lot of posts have not found a solution. Hey, let's calm down and look at the log !!

Oracle 11g installation manual on RedHat Linux 5.8 _ x64 Platform Oracle 11g installation manual on RedHat Linux 5.8 _ x64 Platform Build Environment: VM10 + RedHat 5.8 _ x64 + Oracle 11g (grid + db) Steps: 1. Install VMware software on your

MySQL Condition Optimization example Some friends tried the following and asked questions: Merge having conditions into where conditionsAdvantages:It facilitates unified and centralized resolution of condition clauses, saving time for multiple

MySQL does not support subquery optimization. 1. Create a table Create table tt1 (id int primary key, c1 INT );Create table tt2 (id int primary key, c2 INT );Insert into tt1 values );Insert into tt2 values (1, 2), (2, 2 ); 2. Execution Plan and

Java code to import backup database files to the Oracle database Today, we will paste an Oracle database backup feature that has been implemented very early. This feature was designed at the university stage: Import java. io. IOException; /*** Java

How to enable and enable autotrace for Oracle tools Platform: Oracle 10g RHEL-5.8 The procedure is as follows: 1) sys @ ORCL> @ $ ORACLE_HOME/sqlplus/admin/plustrce. SQL 2) sys @ ORCL> grant plustrace to public; Description of several common

Use of DML (Database operating language) in SQL 1. Insert statement:INSERT [INTO] table [(column1, column2, column3,...)] VALUES (value1, value2, value3 ,...);Example: insert into user VALUES (NULL, 'test', '20140901 ');Example: insert into user

SQL advanced (2), SQLSQL advanced (2) if at least one keyword of SQL INNER JOIN exists in the table, the INNER JOIN keyword returns the row.Inner join keyword syntax SELECT column_name(s)FROM table_name1INNER JOIN table_name2 ON

C3P0 database connection pool, Use the C3P0 database connection pool 1. Copy jar package: c3p0-0.9.1.2.jar c3p0-0.9.1.2-jdk1.3.jar c3p0-oracle-thin-extras-0.9.1.2.jar (oracle required) 2. Write the preparation file under the src directory:

Multi-path and udev configuration in Suse 11 and udev configuration in suse11 Recently, we deployed Oracle 10g RAC in multiple paths Under SuSe 11 SP3. 10 Gbit/s in SuSe 11 is also a wonderful piece of cake, and even documents are hard to find. Who

Analysis of OCP questions 053-61 RMAN set command id to, ocprman 61. You frequently have multiple RMAN sessions running, and you want to be able to easily identify eachJob via the CLIENTJNFO column of the dynamic performance view V $ SESSION. What

Start Oracle11g service, oracle11g Service When running oracle, It is very resource-consuming and affects the speed of the machine. Therefore, I usually stop its services when I don't need oracle, but what services do we need to start and what do we

Install MySQL in linux source code Recently, MySQL Fabric needs to be used. This product is a utility generated after MySQL5.6.10. MySQL5.1 is installed on the machine at hand. Therefore, you need to upgrade the old MySQL version to MySQL 5.6 first.

To build a RAC-DG for the customer encountered some problems, set up rac-dgYesterday I went to a customer to build a physical standby database of the RAC-DG, here I will list the general process again, for does not involve leakage of privacy, the

Bug 7715339: a logon Failure triggers 'row cache lock' wait, 7715339row Bug 7715339-Logon failures causes "row cache lock" waits-Allow disable of logon delay(Document ID 7715339.8) to the bottomModification time: 2012-7-26 type: PATCHFor this

Oracle11 tablespace dbf File migration, oracle11dbf When the disk space of the oracle data file is insufficient or the dbf file needs to be migrated to another location in other cases, the procedure is as follows: 1. sqlplus sys/sys as sysdba 2.

Basic Database Operations, databasesI. Data Table Student (S #, Sname, Sage, Ssex) Student table S #: Student ID; Sname: Student name; Sage: Student age; Ssex: Student genderCourse (C #, Cname, T #) curriculum C #, Course No.; Cname: Course name; T #

About the _ external_scn_rejection_threshold_hours parameter and scn headroom patch in oracle db 11gR2, 11gr2headroomAbout the _ external_scn_rejection_threshold_hours parameter and scn headroom patch in oracle db 11gR2From:Installing, Executing and

Database partition: oracle database partitionDatabase partition:Concept:Take mysql as an example. The data in the mysql database isExist on disk as a fileBy default, it is placed under/mysql/data (you can use my. in cnf), a table corresponds to

Distributed Database New Thinking: Cross-Cloud Platform This is a simple solution that has a long history: using a distributed architecture in the database to quickly return request data. This solution runs database query operations on multiple