Database Administrator

This article describes how to use PHP4 to connect Oracle8i in a Linux environment. 1. Download and install Oracle 8i for linux. Complete installation. Do not only install the client. 2. Download The PHP3 or PHP4 source code. 3. Configure PHP

After one day of download yesterday, I finally downloaded the installation disk of Hongqi 5NE. The DOSUTIL folder cannot be found during decompression. As you know, to install Hongqi 5.0, I only need to decompress the DOSUTIL file, run AUTOBOOT in

The default capacity of the mysql table is 4 GB. When loaddata is used, an error occurs when the file load 2 GB. However, if the myd file is 4 GB, I don't know what is going on. Expand the table capacity first. First check the table status: show

(1) Start-> Settings-> Control Panel-> management tools-> servicesStop all Oracle services.(2) Start-> Program-> Oracle-OraHome81-> Oracle Installation Products-> Universal InstallerUninstall all Oracle Products(3) Run regedit, select

Mysql can be connected to the web through PHP in two ways, one is mysql-related functions through php, and the other is ODBC-related functions through php. The related functions are as follows: MYSQL Functions Mysql_affected_rows: obtain the number

This is not about using any programming language to implement this function, but using Shell and MySQL commands in Linux. Java code Echo "use test; select * from test order by id desc; "|/usr/local/mysql/bin/mysql-uXXXX-pXXXX --

Write down some important knowledge about Oracle databases for future reference! I. file systems and functionsExecution file: the Core of the Oracle system. data files can only be identified by Oracle processing programs. it is meaningless to leave

A Linux server needs to start multiple data instances, such as DB1 and DB2. Method:Export Oracle_SID = DB1Sqlplus '/as sysdba' Exit! Export ORACLE_SID = DB2Sqlplus '/as sysdba' Exit! For different listening ports, the method for starting the

Oracle closes and enables archiving logs 1. Archive Mode 1 SQL> archive log list; # Check whether the archive mode is used2 SQL> alter system set log_archive_start = true scope = spfile; # enable active ArchivingSQL> alter system set

Error: ORA-12537: TNS: connection closed. Environment: Oracle: 11.2.0.2 OS: LINUX 5.6 Environment: RAC NODE1: 10.20.31.36 NODE2: 10.20.31.38   [Oracle @ ract1 ~] $ Sqlplussys/oracle@10.20.31.36: 1521/racdbas sysdba SQL * Plus: Release 11.2.0.2.0

1. User Management 1.1 create a user (Database verification) Create user dave identified by pwd Default tablespace users Temporary tablespace temp QUOTA 5 m ON users;   1.2 modify a user Alter user dave quota 0 on system;   1.3 Delete a user Drop

This morning, the middleware service was congested in the production service, and the query results of a history table were found to be very slow. Further, the hash partition index of the table was invalid, it is in the "UNUSABLE" status and the

In Oracle, sequence is the so-called serial number, which is automatically increased every time it is obtained. It is generally used in places where the sequence numbers need to be sorted. 1. create sequenceFirst, you must have the create sequence

In the past few days, I have encountered this problem in Oracle several times. The scenario is not the same (note: the unit of Y on the title is KB ): 1. insert into table1 values (...) select (...) from table2 :( it will occupy temp tablespace. If

This article mainly verifies the maximum available space size of the lvm + raw device tablespace. -- 1. Prepare the tablespace before it is created. The size of/dev/raw/raw14 is 8 Mb.[Oracle @ master ~] $ Ln-s/dev/raw/raw14/oracle/oradata/rawt/test01

Version description Hadoop 1.0.3HBase 0.94.1Hive 0.9.0 Perform operations Hive> select count (*) from tablename; Exception prompt Exception in thread "Thread-54" java. lang. RuntimeException: Error while reading from task log url At

This error occurs when the insert statement is executed. Insert into Table 1 values (123,2423, 12 ); The structure of Table 1 has four columns. Obviously, only three columns are inserted, so this problem occurs. After the value of another column is

Starting from 9i, Oracle also provides a new Undo Data Management method, that is, using the Automatic Oracle Undo tablespace Management, usually abbreviated as AUM ). (1) check whether the empno = 7788 record exists in the Buffer Cache. If it does

The Oracle Database software provides the following two scripts to configure automatic Database startup and shutdown with the server:[Oracle @ prod bin] $ pwd/U01/app/oracle/product/11.2.0/db_1/bin[Oracle @ prod bin] $ ls-l dbs *-Rwxr-x --- 1 oracle

When talking about rman, we need to talk about catalog, that is, restoring the directory. I don't think this stuff is very useful. If the database does not reach the open state, the restoring directory database cannot be connected at all. I