Database Administrator

Common Oracle ebs dba SQL-installation/patch Common Oracle ebs dba SQL-installation/patch Check whether the application patch is installed:Select bug_number, last_update_date from ad_bugs where bug_number = '& bug_num '; Check which languages are

Whether the path change of the bare device in ASM affects the operation of the database Use asm to store database files. In linux, you can use asmlib to manage Block devices, or use bare devices to create an asm disk. In asmlib mode, changing the

Blob field value for accessing the Oracle Data Link Access photo table Select * from zp @ dblink1 where a1 = '201312 '; Error: The ora-22992 cannot use the LOB locator selected from the remote table Change to the following method: Method 1:Drop

ORA-01861: Text and format strings do not match error handling An error is returned when the following materialized view is created.Create materialized view BBBRefresh complete on demandAsSelect a. vbillcode,B. invname,Del. exchdateFrom AA @ AAInner

Oracle's use of null in not in In the past, I also summarized some Oracle NULL problems. It happened that I saw another point that I didn't find before when I was reading the book, that is the question of using null in not in. SQL> select * from

Three methods for creating a user in MySQL There are three methods for creating a USER in mysql: The insert user table method, the create user method, and the GRANT method. I. Account Name Composition Account composition: User Name + host (So

Linux MongoDB configuration + RockMongo management and monitoring 1. Download mongodb-linux-x86_64-2.0.5.tgz 2. Extract 3. mkdir-p/data/monogodbdata 4. start the bin directory: nohup. /mongod -- dbpath =/data/monogodbdata/-- logpath

Set MySQL database to allow remote connection in Linux If the following error occurs when you use a client tool to connect to a MySQL database in Linux: Host '192. 168.1.3 'is not allowed to connect to this MySQL server solution: 1. Access the

ORA-27102: out of memory error handling Problem description: Originally, SGA 4G and PGA 2G. Alter system set sga_max_size = 30G scope = spfile; Alter system set sga_target = 30G scope = spfile; After, SQL> shutdown immediateDatabase closed.Database

PowerDesigner 15 Overview1. Introduction to PowerDesigner PowerDesigner 15 is a CASE (Computer-Aided Software Engineering) tool integrated with Enterprise Architecture Analysis, UML (Unified Modeling Language), and data modeling launched by Sybase.

WAS cluster series (1): unmount, was Cluster Note: The "arrow indicates" trajectory is "Click order", which is the effect after clicking Environment Project point Metrics WAS version 7.0 Operating System Windows 2

WAS cluster series (6): cluster creation: Step 4: Install WAS upgrade software, cluster was Click "Next" step by step and pay attention to one process, as listed below: We recommend that you set the path for "upgrade software" installation, which

Hibernate uses the c3p0 data source,After configuring hibernate to connect to the database environment, we can perform the following operations to build the environment for using the c3p0 data source in hibernate. 1). Import the jar

In rac, the vip address of a node cannot be started on this node, but can be started on other nodes ., Racvip This experiment is in a virtual machine! The same problem with the experiment: http://blog.csdn.net/wanghui5767260/article/details/38850335

When a human is working on a smart phone, a huge data center is dead. On June 23, Paul Brody, vice president of IBM and head of the Global Business Services electronics industry, wrote on the technology website Venture Beat, in the IOT era, the use

Oracle flexibly inserts data through query insert into... select..., oracle... select. Insert into reg_user (id, name, password, area_code, reg_time, first_pswd, record_type) select l. reg_user_id, l. entry_person, '4qrcoum6wau + VuBX8g + IPg =

Data Source and connection pool, data source connection pool The data source is used to connect to the database and obtain the Connection object, which is expressed in java using the javax. SQL. DataSource interface. With the data source, we do not

Understanding MySql transaction isolation mechanism, locks, and various lock protocols, mysql transactions The understanding of the transaction isolation mechanism of the database is always on the surface, and its content is also forgotten. In the

Solving ora-00054 Oracle lock table problems, ora-00054oracle 1. run SQL: select session_id from v $ locked_object; check the Sessions of the lock table. There may be many sessions, but they are not normal. 2. SELECT sid, serial #, username, osuser

Mysql optimization, mysql Mysql optimization (in linux) Method 1: Add SQL logs to locate slow queries 1. First, add timeout control in the mysql configuration file, and add 2 S timeout under mysqld: Vi/etc/my. cnf 2. Restart mysql, set log to on,