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

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->

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

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 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,

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.

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

Customize a mysql STARTUP script according to the working environment --- 1. Save As/usr/local/mysql/scripts/mysql_env.ini # Set mysql init variablesMYSQL_USER = system # mysql UsernameMYSQL_PASS = 'Password' # mysql logon User password # Check

1. What is NULL?NULL indicates UNKNOW (unknown), which does not represent any value. For example, if a column in a row does not have any value, it is NULL.ORACLE allows blank fields of any data type, except for the following two cases:1) primary key

1. Download Go to the official website to download the latest PostgreSQL Studio, I downloaded pgstudio_1.2-bin. zip, because my computer does not have tomcat. If Tomcat is configured on your computer, download pgstudio_1.2.zip and decompress the

Reprinted please indicate the source: http://blog.csdn.net/guoyjoe/article/details/30839817 ######### Preparations before recovery1. Perform a Hot Backup select 'alter tablespace '||tablespace_name|| ' begin backup;' ||chr(10)|| 'host cp '|

Step 1: Use the following SQL statement to view the process list and identify the locked table SELECT dob. OBJECT_NAME Table_Name, lo. SESSION_ID | ',' | vss. SERIAL # delete number, Lo. locked_mode, lo. SESSION_ID, vss. SERIAL #, vss. action Action,

Sometimes it is necessary for Oracle to terminate the current session. For example, if you want to perform a management operation, you need to terminate all non-Administrator sessions. The following describes all aspects of session termination,

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

You can use the following methods to conveniently find the SQL statement used to monitor the Oracle tablespace usage: A test database is found to ensure that only one user is connected. Use TOAD to view the table space usage. Refresh the share pool

If you want to update the start with value of a sequence, you cannot directly change it. An error is returned: SQL> alter sequence seq_xxrs start with 1000; Alter sequence seq_xxrs start with 1000. ORA-02283: unable to change startup serial

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

Test the use of the alter database backup controlfile to trace command to back up the Oracle10g Control File And restore the control file when the control file is lost-backup control file View the default path of alter database backup controlfile to

Before installation: The minimum requirement for memory (RAM) is 1 GB. 2 GB or above is recommended. Recommended virtual memory swap: memory is 1 GB ~ We recommend that you set the swap size to 1.5 times of the memory size for 2 GB. The memory

Note: Install MySQL 5.6 On A CentOS Virtual Machine on Windows 7. 1. Download the installation packageMysql5.6: Http://dev.mysql.com/downloads/mysql/ Select the Linux version here: Use Navicat to manage MySQL databases on a remote Linux Server 2