Database Administrator

Query the connection information in the database. SQL _COMMAND is an SQL statement that can release a process: Select. SID, B. SPID,. SERIAL #,. lockwait,. USERNAME,. OSUSER,. logon_time,. last_call_et/3600 LAST_HOUR,. STATUS,'Orakill' | sid | ''|

When the Oracle archive log is full, you cannot log on to Oracle normally. You must delete some archived logs to log on to Oracle normally. 1. Delete physical files of archived logs. archive logs are generally stored in the archive directory. The

Backup To ensure that the memory settings do not affect the database startup failure settingsTherefore, you need to back up the spfile/pfile file.[Oracle @ ur65dbs] $ cd/u01/app/oracle/oraInventory/db_1/dbs[Oracle @ ur65dbs] $ cp spfile1_db. ora

In the following articles, we will first describe how to set the actual solution for automatically clearing MySQL binlog diaries and manually deleting data. We all know how to replicate MySQL Data libraries (replication) after accepting the RBR mode,

Zookeeper manages voting disks 1. Some things that must be known about voting disk:We can use the dd command to back up voting disk before 11g, But oracle no longer supports using dd to back up voting disk after 11g.If the dd or cp command is used,

Oracle11g RAC construction in linux (5) 4. Establish trust relationships between hosts (node1 and node2)   Establish trust between oracle and grid users between nodes (create a public key and private key through ssh) Create in node1 and node2

Possible causes and solutions for ORA-27302: failure occurred at: skgpspawn3 Symptom: Mon May 26 07:08:58 GMT + 08:00 2014 Process startup failed, error stack:Mon May 26 07:08:58 GMT + 08:00 2014 Errors in

ZookeeperChange the oracle cluster NIC (Changing a Network Interface) If the NIC name, ip address, gateway, and subnet mask remain unchanged before and after the NIC, no additional operations are required at the cluster level! Next, use the new

No matter what materials you want to learn, or when you first get to know a system, what you want to learn is to understand the requirements. If the requirements are different, then your system will be completely invisible. Software Requirement

This error occurs because the host name and/etc/hosts file are inconsistent. You only need to write the host name and its IP address to the/etc/hosts file and then OK. Note that the name cannot contain underscores. In addition to modifying the

Database E-R graph correlation June 15, 2014 17: 39    Three main concepts used in E-R data model are: entity set, link set and attribute. Entity set: entity set with the same type and the same nature (or attribute) Attributes: simple attributes

-- Backup 1. Back up data to the default folder. D: \ mongodb \ bin is the installation directory of mongodb Mongodump-d is the backup database command Testdb Database Name The backed up database is in the dump folder under the mongodb

SQL dialect configuration for oracle, mysql, and sqlserver databases in hibernate4 (SQL Dialects)  Database Type Hibernate SQL Dialect DB2 Org. hibernate. dialect. DB2Dialect DB2 AS/400 Org. hibernate. dialect. DB2

/** Normal paging * 10 records at 1000000 offset on the data file */select * from zol1__92game_net_ecms_bjwhere classid = 303 order by id ASCLIMIT limit, 10; /** efficient paging * 1. Search for the starting Index * 2. Search for 10 results from the

MySQL database Master/Slave server in Linux 1. Network ConfigurationServer:[Root @ CentOS mysql-5.0.40] # ifconfig eth0Eth0 Link encap: Ethernet HWaddr 08: 00: 27: 56: AAInet addr: 2.2.2.135 Bcast: 2.20.255.255 Mask: 255.0.0.0Inet6 addr: fe80: a00: 2

Because you do not want to use the background code, you want to use the Oracle trigger for Operation updates. But because the trigger updates the base table, deadlock occurs. Therefore, you can use global variables on the Internet to solve this

I. Hardware requirements 1. Memory & swap Minimum: 1 GB of RAMRecommended: 2 GB of RAM or more Check memory # grep MemTotal/proc/meminfo # grep SwapTotal/proc/meminfo 2. Hard Disk Since CentOS is installed almost 4 ~ 5 GB, plus Oracle and so on, so

Oracle 10g has introduced the Data pump technology. What are the advantages of this technology and the previous exp/imp technology? In simple terms, the recovery and backup speed are very fast; Before explaining how to use the data pump, let's

The OCI package is required for PHP to remotely connect to Oracle. This package is provided by oracle. You can directly install the Oracle InstantClient to obtain this

A ORA-01659 error occurs when an insert operation is performed on a table in the database.ERROR at line 1:ORA-01659: unable to allocate MINEXTENTS beyond 56 in tablespace USER01At the same time, the background alert Log appearsORA-1652: unable to