Database Administrator

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

Below is a MySQL backup instance, which is tested and passed in Ubuntu. The task is a local backup. It can be used on the server side.#! /Bin/bash Echo "backupmysql V1.0" ### Date stamp ###Datestamp = $ (date + % Y-% m-% d) ### Path ###Startdir

Operating System: RedHat linux 5 (Enterprise Edition) Software: Oracle 10g R1 Preparations: Download the official oracle 10g install for linux documentation Software to be installed in Linux: GNOME Desktop Environment/KDE X Window

PL/SQL itself cannot access the 64-bit Oracle client on 64 systems, but there are two solutions. One is to install a 32-bit ORACLE client, however, I felt too big. I found the second method on the Internet and it was feasible after experiment.

I.Introduction Problems Help me install a 10 Gb Oracle on CentOS. As a result, my friend's CentOS version is 6.2, the latest version, but it is basically the same on Linux, so follow the previous steps, quick operations result in N errors that have

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

Google maps are queried based on Oracle. How does Google store maps in Oracle? Here we use the dbms_lob package to briefly understand the process. 1) create a t table: 00:32:04 hr @ ORCL (^ ω ^)Create TableT (a varchar2 (20), B blob ); The

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

MySQL Replication We know that the binary log of the MySQL database records every clear or potentially changing SQL statement of the database. Therefore, we can achieve the master-slave consistency of mysql based on the binary log. The simple mysql

Oracle RAC Load Balancing allows connections initiated from clients to be effectively allocated to instances with low listener load. There are two methods to achieve load balancing on the client. One is to configure the load_balance of the client,

Detailed installation and testing of pgwatch An error occurred during installation, but no documentation was found online. I decided to write a detailed installation document myself. 1. Download pgwatch. Here I use Version 1.0, as shown below: Wget

SQL statement to create job scheduling under SQL Server 2000 -- Define job creationDECLARE @ jobid uniqueidentifierEXEC msdb. dbo. sp_add_job@ Job_name = n' job name ',@ Job_id = @ jobid OUTPUT-- Define job stepsDECLARE @ SQL nvarchar (400), @

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

I. Implementation Environment Oracle Database Server 172.16.4.165 Windows Server 2008-64bit Oracle11g R2 DB2 database Server 172.16.4.165 Windows Server 2008-64bit DB2 V9.7 Oracle gateways11g R2 transparent gateway Server 172.16.4.20.windows Server 2

For production purposes, install the DB2 database on an IBM X3850 server. The following describes the procedure. Software and Hardware System Configuration: Operating System: SUSE enterprise 10 linux (64bit) Hardware configuration: 32 GB

Case: a data file in rename cannot be completely restored.SQL> startup mount; // starts to mount.SQL> show parameter control_files // view the location information of the Control FileNAME TYPE VALUE----------------------------------------------------

1 mysq error log error: 11:29:54 22977 [ERROR] Slave SQL: The incident LOST_EVENTS occured on the master. Message: error writing to the binary log, Error_code: 159011:29:54 22977 [ERROR] Error running query, slave SQL thread aborted. fix the problem,

MySQL Semisynchronous Replication In addition to the built-in asynchronous replication mechanism, MySQL5.5 also provides interfaces to support semi-synchronous replication. Disadvantages of asynchronous replication: MySQL replication is asynchronous

Summary To implement a mysql proxy, you must first understand and implement the mysql communication protocol. In this way, the proxy can be used to build a bridge between the client and the server. Mixer mysql protocol implementation mainly refer to

Image-level backup (image copies) is equivalent to copying copies of data files and archive logs. It is exactly the same as the original file in the storage space. If you need to perform partial recovery (such as a data file) when using image backup,