Database Administrator

Oracle 9i provides powerful migration functions to migrate data from multiple databases to Oracle. The new Oracle migration tool provides a simple solution for migrating data from Access 2000 to Oracle 92010. This solution overcomes Chinese garbled

Because the company's ERP system platform is RedHat Linux ES4 + Oracle10g, it is temporarily handed over to me for maintenance. So I would like to take this opportunity to learn about Linux, which is not very demanding on myself, oracle can be

Oracle has set up a dedicated apt source server for Ubuntu users. You only need to add a line in/etc/apt/source. list:Deb http://oss.oracle.com/debian unstable main non-freeYou can. Before running the apt-get update command, you must add the public

Oracle 10g UPDATE 11g Training Project 1. Project Process:1. Install 11.2.0.3 database software on the server where the Oracle 10.2.0.5 database is located2. Execute dbua in the environment variable 11.2.0.3 and upgrade the Graphical Database.3.

OCR is equivalent to the Windows registry. For Windows, all software information, users, configurations, and security are stored in the registry. In the same way, all cluster-related resources, configurations, nodes, and RAC databases are stored in

To build a WebCenter, you need to build an environment. I plan to write several articles for sharing and recording: database, RCU, Weblogic, WebCenter Portal, WebCenter Content (UCM), and environment configuration. 1. First, you need to install the

The solutions to the four most common errors in SQL Server connection are as follows:1. "SQL Server does not exist or access is denied"This is the most complex. There are many causes of errors and there are many aspects to check.Generally, there are

SYS @ orcl # shutdown abort;The Oracle routine has been disabled.SYS @ orcl #Oracle @ oracle :~ /Product/10.2/db_1/dbs> rman target/ Recovery MANAGER: Release 11.1.0.6.0-Production on Wednesday June 5 23:13:10 2013 Copyright (c) 1982,200 7, Oracle.

The recent customer email description failed to connect to the database from the client with the error code ORA-12537: TNS: connection closed, and the connection was closed. Directly through tnsping, there is no problem. The TNS-12518: TNS: listener

The crs_stat command in Oracle 11g RAC has many new resource types compared with the previous version. By default, crs_stat-t is used to check that resources are a large piece of data, it looks really laborious. The author Paul Elbow and Enkitec

When the angel used Oracle, he found that the use of single and double quotation marks was different. Then he checked some information online and made some summary: Double quotation marks: when an object is created, the object name and field name

Various objects (including tables, columns, and indexes) in Oracle databases are case-insensitive by default. All objects in the data dictionary are in uppercase. If you enclose the column name or table name in double quotation marks when creating a

CKPTQ: The data block in the Checkpoint Queue records the LRBA address of each data block. RBA: Redo Block Address (Address of the Redo log Block, which is equivalent to the rowid in the data file. You can use this Address to locate the Redo log

As data increases and the innodb Storage engine is compatible with the future, The mysqldump full backup + incremental log backup policy is considered. Using mysqldump provides good support for most mysql storage engines such as myisam and

Materialized views are a feature built in Oracle for a long time, while PostgreSQL also developed functional code very early in the way similar to create table ...., it's just that it hasn't been built in. Version 9.3 Finally uses this as a built-in

Problem description: Use pl/SQL developer 9.0.6 on Windows 7 (32-bit) to remotely connect to the Oracle 10.2.0 database in Linux (64-bit. The oracle client used on Windows is a instantclient-basic-win32-10.2.0.3-20061115 and

Oracle 12c R1 physical standby uard physical standby database enable real-time apply The physical standby database is always in the mount state, which is inconvenient for Data Synchronization verification. Enabling real-time apply enables real-time

Oracle Vault is an important part of the three security technologies. Compared with the other two types, Label Security and Virtual Private Database (VPD), Oracle Vault better reflects the O & M system management and Security rule configuration.

Use of encrypted tablespace under Oracle 11 GB Oracle Undo image data exploration Oracle ROLLBACK and Undo) The Undo tablespace cannot be opened because it is damaged. How to handle Undo tablespace failures Oracle Undo tablespace reconstruction and

Someone asked me how to differentiate whether RAC is Admin or Policy managed after it is created.First, we should look at the definition: Administrator-managed: Database administrators define the servers on which databases resource run, and place