Database Administrator

Oracle 11gR2 RAC node crash Fault Analysis Environment: AIX 7100Oracle 11gR2 RACDetailed version: 11.2.0.4 Symptom:Node 2 crs hang is down. The CRSCTL command does not respond at all. After the CRS process host is restarted, the VIP is not migrated

Use occi to connect to Oracle in Linux without installing a client1. Assume that you have successfully installed the oracle10g and Eclipse C ++ environments.2. Replace libocci. so.10.1 and libocci10.a in the "opt/.../db_1/lib" path. (First download

Installation environment: Ubuntu 10.04-desktop-i386 and PostgreSQL 8.4 Installation steps: 1. Install PostgreSQL Enter the following command Sudo apt-get install postgresql The system prompts you to install the required disk space. Enter "y". The

It took a long time to connect the Oracle 10g database to the Tomcat server after one night and one morning, but it was actually quite simple.I am using Java. There are two methods. Related reading: Notes for using spfile and pfile in Oracle (1) //

The two highly lethal commands compiled today can instantly kill Oracle. Next I will give a simple comment and demonstrate its power.$ Ps-ef | grep $ ORACLE_SID | grep-v grep | awk '{print $2}' | xargskill-9$ Ipcs-m | grep oracle | awk '{print $2}' |

For example, update table1 t1 set t1.name= (Select t2.name from table2 t2 where t2.age = 20) Cause of error: the subquery contains more than one record. If you want to update data in batches, You can nest the data, for example, the following SQL

1. OracleThe role of Package:   It can simplify application design, improve application performance, hide information, and overload subprograms. 2. Functions in ORACLE, Package, packageThe differences between bodies and procedure are the

Build an Oracle10G (6) dbca database for RAC under AIX, and oracle10gdbca Establish a series of RAC instances under AIX Build an Oracle10G (6) dbca database with RAC under AIX Environment Node Node 1 Node 2 Small Machine

Detailed process of restarting the Oracle 11G worker uard production environment, 11 gworker uardScenario: restart the database, do not restart the linux system, so you do not need to consider listening programs,# Linux input lsnrctl start1. Close

 Add and Update price list lines-- Purpose: to add row information based on the existing price list Header-- Restriction: this api has some problems. If the header information is forcibly added, there will be many problems. Therefore, this example

In databases, we often use SQL statements to perform simple statistical sorting on tables. For date fields, we can simply order them. For complex operations, you can perform group and order by year, month, and day of the date. Group by year,

MySQL backup methods I have been wanting to write some blogs recently, but I don't know what to write. I feel that my recent knowledge has not increased. Today I think of a blog that can be written. I used to back up MySQL based on the data folder,

11. View the Exhibit and examine the structure of the PRODUCTS table.All products have a list price.You issue the following command to display the total price of each product after a discount of 25% and atax of 15% are applied on it. freight charges

View background When I first started charging the data center, the master said that they should use the view, storage process, and trigger. I didn't feel much at the time, I don't know when to use it, and where to use it. Just a few days ago, when I

DataGridViewControls are highly configurable and scalable. It provides a large number of attributes, methods, and events that can be used to customize the appearance and behavior of the control. The following example shows how to add, delete, modify,

1. Tomcat startup error: Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'memcachedClient' defined in file [/usr/local/apache-tomcat-6.0.37_6500/webapps/trade_service/WEB-INF/classes/META-INF/spring/

Reprinted please indicate the source http://blog.csdn.net/guoyjoe/article/details/30965303 The experiment steps are as follows: 1. Use rman to back up the entire database Recovery Manager: Release 11.2.0.3.0 - Production on Sun Jun 8 15:30:35

In such a scenario, after multiple agent Systems (each with their own database) perform their own operations, complex operations will be triggered for the stored procedures of their respective databases, after each operation is complete, you need to

We have published three articles in the first, second, and third articles in one of the basic questions and answers for Linux interviews, which are well received by readers. At the same time, we have received feedback. Some readers hope that this

In 11g, Oracle introduced a new feature: adaptive cursor sharing. This feature is mainly used to improve the execution plan of SQL statements with variable binding. It also causes SQL statements with variable binding to generate multiple cursors. In