Database Administrator

FNDLOAD is a Data Synchronization tool officially provided by Oracle. Generally, we use the FNDLOAD tool to download the custom AOL Data of DEV Instance to a text file, then, use FNDLOAD to upload data to the PROD Instance. Under what circumstances

I. installation and configuration 1. Installation Download: wget-c http://fastdl.mongodb.org/linux/mongodb-linux-x86_64-2.0.6.tgz Unzip: tar zxvf mongodb-linux-x86_64-2.0.6.tgz Establish a soft connection: ln-s mongodb-linux-x86_64-2.0.6

Deploy the Rman backup plan and find the error message in alert. log after execution:Fri Jul 6 00:30:16 2012Errors in file/Oracle/admin/live/udump/***** _ ora_3652.trc:Fri Jul 6 00:30:16 2012Errors in file/oracle/admin/live/udump/***** _

1. Solve directory Problems [Ora @ rac1-21 bin] $ srvctl/U01/Oracle/product/10.2.0/db_1/jdk/jre/bin/java: error while loading shared libraries: libpthread. so.0: cannot open shared object file: No such file or directory [Ora @ rac1-21 bin] $ which

Summary:1. Primary keys and composite primary keys have the same query performance (the same index height and the appropriate use of indexes ).2. Primary keys and composite primary keys. The (update, insert) performance is different (because

VPD is used for development in the project. The creation of Database User B objects depends on user A. Because user A objects perform DDL, migration, dump, and other operations, this results in the INVALID of user B. User B is used as the data

Because the project needs to use the database, and it cannot depend on a specific platform but also requires flexibility, so I thought of SQLite and started to modify and use the source code. Here I will record it for the sake of memo, the following

The "Recycle Bin" (Recycle BIN) concept is introduced in Oracle Versions later than 10 Gb. The deleted objects are all placed in the Recycle Bin and named with the BIN $ prefix. A user can easily restore a table from the "recycle bin", but before 9i,

Deploying Spring applications to CloudFoundry.com is simple, as SpringSource says. After you register your Cloud Foundry beta account, install CloudFoundry in STS for Eclipse. Here is a blog detailing how to install it. I will not describe it

The storage of the unique index is different from that of the non-unique index. The storage of the non-unique index needs to store the ROWID as a column, and the unique index stores the ROWID in the DATA area, the following shows how to store the

During the weekend, developers used a machine for testing and installed a one-click installation package lnmp. As a result, I got rid of the mysql-server installed on the original rpm on this machine, but I don't know how they got it, the files

The following error occurs when importing impdp data: ErrorsInFile/Oracle/app/diag/rdbms/gavin/Gavin/trace/Gavin_arc0_5889.trc: ORA-19809: exceeds the limit on the number of recovery files ORA-19804: unable to reclaim 49837568 bytes of disk

The table names imported to the database are garbled due to inconsistent codes and cannot be deleted. The names of tables whose names start with numbers and whose names contain invalid characters cannot be deleted. It is said that the card cannot

CentOS, apache2.2.4, database Mysql-5.0.18. Use the mysql source package for installation, or use the mysql Binary Package or rpm package for installation. 1. Add a logon user and group: # Groupadd mysql # Useradd-g mysql 2. Decompress

The following documents are easy to translate from the official Oracle dba documents. Manage redo log files Objective:1. Explain the purpose of redoing log files2. describe the structure of the redo log file3. Learn to control log switching and

Download Software, version mongodb-linux-x86_64-2.0.2.tgz Directory after decompression: mongodb-linux-x86_64-2.0.2 Then transfer to the/usr/local/mongodb directoryCreate a data storage directory and a log directoryMkdir/usr/local/mongodb/{data,

When performing a multi-table joint query, if we view its execution plan, we will find a connection method between multiple tables. I was planningSqlplusThe execution plan is used, but the format looks

Environment: AIX6.1, Oracle10.2.0.3 Create a single instance on a node of RAC and create it using DBCA. An error is reported when the configuration is complete. Error: ORA-29702Text: error occurred in Cluster Group Service operation Cause: An

Typical Oracle recursive algorithms are used. For example, under a multi-level department, a sub-department cannot be the parent department of the parent department. For example, the father department has a son department and B son department. The

Each Block in Oracle has a part called ITL, which is used to store transaction information. The number of ITL of an object is determined by the initrans and maxtrans parameters of the object. The Oracle official documentation records that the