Database Administrator

Symptom: After Oracle10gR2.0.0.1 is upgraded, A ORA-12520 error is reported for client connection now 12520,000 00, "TNS: listener cocould not find available handler for requested type of server"// * Cause: None of the known and available service

I. Prerequisites for installation and configuration1. Install the Oracleasm support packageDriver: http://www.oracle.com/technology/software/tech/linux/asmlib/rhel5.htmlTo create an asm database, you first need the ASMLib driver package, which can

1. Copy the cold backup data files, log files, and control files to the target folder. 2. Create a pfile of init: $ Oracle_SID.ora, which can be copied from the template in the samples folder. 3. Modify the control_files parameter of the pfile and

1. Install mysql1. sudo apt-get install mysql-server mysql-client (A window pops up asking for the mysql root User Password during the installation process) 2. Once the installation is complete, the MySQL server should be started automatically. You

Recently a Oracle11g-1_64 has been deployed on a DELL T710_x64 machine in the unit, a lot of information from the Internet, comprehensive installation was successful, the following is the installation steps summary, my machine configuration is as

Platform: RHEL4.5, Oracle10.2.0.1Plan: db_name = ORCLDB, db_unique_name/ORACLE_SID = WENDINGThe above two parameters can also be set to the same, here is the main difference. 1. Set Environment Variables$ Export ORACLE_BASE =/u01/app/oracle$ Export

Function: Read the data in the database to the java cube class and calculate the cube size. 1. Use PL/SQL Developor to design a table named first;Table-> new Table: design the tablespace, the size of the field, and the primary key;Table-> first->

Software environment: Ubuntu 10.10, Java1.6u22 Hardware configuration: Core-core CPU, 2 GB memory, 4 GB swap partition, GB hard disk 1. Installation preparation Before the installation starts, it is best to install java first. Do not use the jdk

In the morning to connect to Oracle, oracle can not work normally, can not shutdown immediate Mode to close, shutdown abort mode to close and then start, the error message "ORA-03113 end-of-file on communication channel" appears"The alter log

Install mysql in Linux (5.0, rpm server and client) I. Introduction I have been using Linux for a long time. I have never studied hard tasks and system learning. Recently, I have to use MySQL in Linux for my work. I thought that I had experience

This script was found online in and used in the official system after modification. The database name was changed to LinuxIDC.com. 1. Create a sh file and create a script file named mysqlscript. sh in/usr/bin/. For details, see mysqlscript. sh. 2.

-- ====================================== -- OracleHot Backup -- ======================================   OracleHot Backup means that the database is inOpenTo back up database data files, control files, parameter files, and password files. Hot

Since its birth, Oracle's AUM (Auto Undo Management) has often experienced scaling-only, not shrinking (shrink) (usually we can set enough UNDO tablespace size, and then cancel the auto-scaling attribute). In the actual environment, when the undo

Today, I wrote a program for multi-threaded database access, which has been running well and suddenly encountered the following problems: ORA-24550: signal inclued: [si_signo = 11] [si_errno = 0] [si_code = 1] [si_int = 0] [si_ptr = (nil)] [si_addr =

In PL/SQL, The UTL_FILE package provides the interaction between input and output of text files. That is to say, we can use this package to read or write files from the operating system level to the operating system file. This package can also load

Redis is a single-process service. It is mainly used for memory, CPU, and disk I/O (mainly for persistence, you can consider using multiple redis instances. Before using multiple instances, we should first consider the use of CPU and memory. During

Error message: ORA-20211: Active job record exists, cannot create new job record When this error occurs, it is difficult to find a proper solution on the Internet. Therefore, you must solve this problem by yourself. Environment in case of an error:

Batch insert operations on the List Object List in MyBatis: First, you must define the Then: InsertOrdersdish (id, ordersId, dishId)ValuesSeparator = ",">(# {Item. id, jdbcType = VARCHAR}, # {item. orderId, jdbcType = BIGINT}, # {item. dishId,

Summary: due to frequent data updates and fast data volume growth, the machine disk cannot keep up with the pace. The database shard and migration history database are used. Currently, data is optimized to reduce disk space occupied by data and save

1. What is a NoSQL database? What is the difference between NoSQL and RDBMS? Under what circumstances do I use and do not use NoSQL databases? NoSQL is a non-relational database, NoSQL = Not Only SQL. Relational databases use structured data, while