Database Administrator

Microsoft Excel is a frequently used tabulation tool. It can use ODBC to conveniently obtain DB2 data on AS/400. The procedure is as follows: (the procedure is described in the WIN2000 + Office2000 environment. you have configured the ODBC Data

Developing Internet applications is complicated: You must not only define the behavior and logic of applications, but also combine multiple products, technical layers, and standards in a distributed environment. The sample code shows a variety of

In Ubuntu 7.04, the following error will occur when using mysql-gui in the following version, which is my reference on mysql official, with the address of the following http://bugs.mysql.com/bug.php? Id = 28959. Here we provide a solution, that is,

Today, a 32-bit Linux is installed on a server with a blade failure, and a 32-bit Oracle is installed on it, the physical data guard of a 64-bit Oracle instance is successfully configured. The same-digit data guard configurations of the same version

During this period of time, data needs to be migrated from the database of the 10g ZHS16GBK character set to the database of the 11g UTF8 character set, and the value of the NLS_LENGTH_SEMANTICS parameter of the source database is Byte, the value of

Backup of control files can be performed in two formats: Text backup and binary backup. Backup text format SQL> alterdatabase backup controlfile to trace as '/bk/con. SQL ';   Databasealtered. Backup binary format SQL> alterdatabase backup

This article describes the process of installing Oracle 11g on RHEL 6.3. You can download RHEL from many image sites, such as Oracle 11g, note that the version 11.2.0.3 is used in this article. Currently, this version is not available for download

Many data conversion and processing operations may encounter the need to convert 0.007007040000 to 0.70%. We can use the Oracle SQL function to_char to achieve this conversion. This function is used to convert the DATE or NUMBER data type to a

1. Download A performance problem occurs in the customer system. The database version is 9.2.0.4 32-bit. Because the 32-bit database has a maximum memory limit of GB, physical memory cannot be fully used even if a new machine is used, we plan to use

I. Environment Description Source database: Operating System: LINUX 32-bit Database: Oracle 10.2.0.4.0 32-bit   Target database: Operating System: LINUX 64-bit Database: ORACLE 10.2.0.4.0 64-bit   Ii. operation instructions Cross-platform

I. Preface Logical backup and physical backup have their own advantages and disadvantages. Generally, physical Backup recovery is fast, occupies a large amount of space, and logical backup is slow and occupies a small amount of space. The recovery

In MySQL, the user's permission to EXECUTE stored procedures is EXECUTE.For example, you have created the following stored procedure in a database named configdb. The stored procedure is defined as user_admin.Use configdb;Drop procedure if exists sp_

The leader said that after oracle was upgraded to 11 GB, it connected to the oracle database, but opened it through plsql. Click the jobs column, and the created jobs list is not displayed, I asked him about his plsql version. He said it was plsql7.1

Manually back up archived logs 1. database01 [Oraprod @ db01 scripts] $ pwd/Usr/tivoli/scripts[Oraprod @ db01 scripts] $ ls1. txt nohup. out oraicr0.sh scheoraicr0.shBKlog null oraicr1.sh scheoraicr0.sh. testBKlog.tar oraarch. sh oraicr1.sh. orig

We have the honor to have a few RMAN full-database recovery experiments today. Here is a brief version, which can be found in an instant if you forget it. 1. Full recovery1. Full database [full recovery]$ Rman target/log on to the rman tool. If

Applies to: Oracle Database-Enterprise Edition-Version 8.0.3.0 and laterOracle Net Services-Version 9.2.0.1 and laterInformation in this document applies to any platform.Goal Discuss what can be expected when implementing Dead Connection Detection

8.3.3 Using Transportable Tablespaces with a Physical Standby Database 8.3.3 use of the transmitted tablespace in the physical standby Database You can use the Oracle transportable tablespaces feature to move a subset of an Oracle database and plug

This problem was encountered by a friend who made an SSIS program to import data to txt. Then, use Oracle tools to import data to Oracle. However, when executing the variable step in SSIS, it is found that the output column name is completely

For Oracle network configuration, we usually use negmgr or netca to connect the client to the database instance. You can also connect to the ASM instance from a client. However, Oracle does not provide a tool for us to complete the configuration. We

Please note that Oracle explicitly does not Support running Oracle database with VMWare on the official Support website.But what should I do in a virtual environment? My suggestions:If you are an enterprise user and all the infrastructure uses