Database Administrator

Currently, php_oci8.dll is generally used for PHP and Oracle connections. However, when I wrote the PHP code debugging, I encountered a strange problem, that is, only the data can be successfully obtained for the first time after each boot, but I

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

1. Installing mysql in Linux is simple.# Apt-get install mysql-server-5.0After installation, set the password. If the password is 'sa' 2. After the installation is complete, log on to the Local Machine# Mysql-u root-pEnter the passwordThis is

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

1. view the table space name and size. Select t. tablespace_name, round (sum (bytes/(1024*1024), 0) ts_size From dba_tablespaces t, dba_data_files d Where t. tablespace_name = d. tablespace_name Group by t. tablespace_name;　　 2. view the name and

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

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,

Value Type MySQL includes strict data types (INTEGER, SAMLLINT, DECIMAL, NUMERIC), and approximate data types (FLOAT, REAL, DOUBLE). After extension, TINYINT is added, MEDIUMINT and BIGINT types have different lengths, and BIT types are added to

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,

Oracle version: 10.2.0.2 with data guardOperating System: linux rhat 5.6x64 Recently, the oracle alert Log of the master database found that the ora 600 error occurs almost every day in the last half month, as shown below:Errors in file/oracle/admin/

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

It is easy to create a database manually in DB2. Create an example database:1. Generate database storage directories and archive DirectoriesMkdir-p/demo/sampleMkdir-p/demo/samplearc2. Generate a sample databaseDb2sampl-dbpath/demo/sample3. Specify

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

Mysql5.6.15 forget the root password of the database:[Root @ oraserver139 ~] # Mysql-uroot-pEnter password:ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: NO)View the currently installed mysql version:Root @

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

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

Indexing null values Install relational database theory. null indicates unknown. Oracle B-tree index does not contain null. Consider the following table: Create table tt (t_id number, t_name varchar2 (10 ));Create index tt_idx on tt (t_name