Database Administrator

[Preface]Objective: To install 64-bIT Oracle10gEnvironment: RHEL 5.2 64-bit Operating System [STEP ]:1. Install the RHEL operating system, download and upload the media2. Create a software installation environment3. Install the dependency package4.

1. Download phpMyAdmin, copy it to/var/www/html, decompress it, and start using it. Http: // IP/phpMyAdmin Test Cp config. sample. inc. php config/config. inc. php Chmod o + w config/config. inc. php 2. Problem 1: phpMyAdmin cannot load MySql

How to display all current user tables in OracleShow all tables of a user (for example, SCOTT, uppercase is required) Select TABLE_NAME from all_tables where owner = 'Scott '; Show all current user tables Select * from user_tables Display All

Oracle Data Import Imp user/passwd file = abc. dmp tables = abc indexes = n Oracle Data Import (dmp file) The data volume is large and the compressed dmp file is 15 GB. You need to export the data to the company's test database. I thought it was

After debugging a program, if the problem occurs, you can check the information and find that Oracle does not allow you to change the NULL field to the NULL field. I had to make a judgment before the modification.Open PL/SQL and write the following

System Environment:[Root @ nich4 cx_Oracle-py] # uname-Linux nich4 2.6.18-164. el5 #1 SMP Tue Aug 18 15:51:54 EDT 2009 i686 i686 i386 GNU/Linux Python version:[Root @ nich4 cx_Oracle-py] # python-VPython 2.4.3 Oracle version:Oracle database 10.2.0.5

1. You need to modify the $ CRS_HOME/bin/racgvip script before running the root. sh script in the last step of crs installation. Otherwise, the vip cannot be started. The modification method is as follows: # Cd $ CRS_HOME/bin# Cp racgvip. old# Vi

Notes 1. find/-name uuid-ossp.so search to see if there is If not. Click here to download and install uid-1.6.1.tar.gz. Note .. /Configure. The uuid-ossp.so file will exist in/usr/local/lib at this time 2. If an error is reported during postgresql

Preparations: Create user and user group Groupadd mysql Useradd-g mysql 1: Download: Bison-2.4.2.tar.bz2 Cmake-2.8.3.tar.gz Make-3.82.tar.gz Bzr-2.3b5.tar.gz Mysql-5.5.8.tar.gz 2: decompress and install the first three packages Tar zxvf

Suddenly one day, good system error: ORA-01722 invalid number Environment: Oracle9 + JDBC access to the database. It was okay before. This error was suddenly found. Later I learned why 1. The following SQL statement is executed in the Code:

Rownum is an ending field appended to each table by Oracle. It records the row number of each row. One drawback of Oracle is that rownum can only be used with ' Top 5 with the highest salary Select ename, salFrom (select ename, salFrom empOrder by

Oracle How does one use free space in the database? Below is Oracle Structure of data blocks in: Data block is Oracle The smallest storage unit in the storage system. However, you can set the storage parameters to be clear. Oracle How to use the

To migrate data files using rman: 1. Run copy in the rman window.Copy datafile 1 to '+ TESTDG/rac/datafile/system. dbf ';Copy datafile 2 to '+ TESTDG/rac/datafile/sysaux. dbf ';Copy datafile 3 to '+ TESTDG/rac/datafile/undotbs1.dbf ';Copy datafile 4

Installation environment:Operating System: CentOS6.5 _ x64 DesktopHost Name: OracledbMemory: 1 GB (minimum official requirement: 1 GB)Hard Disk: 40 GB (4.29G and 1.7G data files required for Enterprise Edition installation)System preparation before

In archive mode, you may need to migrate some data from one disk group to another. In this case, we can use the "backup as copy" command to move the data file to the new disk group. Then, run the "set newname" and "SWITCH" commands to change the

Note:1. The runInstall commands of different versions may be different. The same commands may not be common among different versions. 2. because the Oracle software is installed and the Enterprise Edition, all preparations for early installation are

Several important parameters in Oracle 11g RAC Par num describ ------------------------------------------------------------------------- _ Lm_lms 2Number of background gcs server processes to start _ Lm_lms_waittime 3Default wait time for lms in

For the restoration of accidentally deleted tablespaces, this article discusses the restoration of database-based time points and the recovery of tablespace-based time points respectively. 1. Restore accidentally deleted tablespaces through database-

Recently, a large BI Project was implemented. The KPI indicator data was stored on a monthly basis, but the user requested to perform a daily calculation and replace the calculation results of the previous day until the end of the month. The Oracle

DBMS_ERRLOG provides a stored procedure CREATE_ERROR_LOG, which creates an error log table. When a DML error occurs, the operation will not terminate or roll back, but related errors will be written to the error log table. CREATE_ERROR_LOG does not