Database Administrator

11g ASM Single Instance dbca error prcr-1006 crs-0259 prcr-1071 11g ASM dbca error prcr-1006 crs-0259 prcr-1071 When creating a single instance DB Using ASM, it appears when running DBCAPRCR-1006: Failed to add resource ora. orcl. db for orclPRCR-107

How to insert special characters in Oracle: & and '(Multiple Solutions) When importing a batch of data to Oracle today, I encountered a problem: Toad prompts me to assign a value to a custom variable AMP. At first I was wondering that data is a

MySQL performance profiling tool (pt-query-digest) This tool is also from percona-toolkitOther tools in this tool setTroubleshooting of abnormal shutdown of MySQL Slave (pt-slave-restart) Verify MySQL master-slave consistency (pt-table-checksum & pt-

Install MySQL Sudo apt-get install mysql-server This should be very simple, and I don't think there is much problem with the installation, so I will not talk about it much. Let's talk about the configuration below. Configure MySQL Note: In Ubuntu,

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.

This article introduces how to diagnose node restart problems in the RAC environment. Applicable to 10gR2 and 11gR1.First, we will introduce the CRS process that can cause node restart.1. ocssd: its main functions are Node Monitoring and Group

Mysql Command rename table syntax Rename table tbl_name TO new_tbl_name [, tbl_name2New_tbl_name2,...]Renaming is performed in atomic mode (atomically), which means that the table cannot be modified by any other thread when the renaming is running.

Installing the Oracle client in Linux to connect to a remote oracle host to complete data operations is a problem I will solve this time. Search for the Linux oracle keyword on google and find some articles, but it seems that the installation of

Today, a vendor asked me a question. If you want to change the data type of a field in a table, whether it is a field type in View also responds to automatic changes. At that time, I thought it would be changed automatically. However, the vendors

************* ************* I. Role of master and slave: 1. It can be used as a backup method. 2. read/write splitting to relieve the pressure on a database II. Environment: OS CentOS5.5 DB MySQL5.5.3-m3 To install CentOS5.5, see Install

Restrictions on Oracle eXpress Edition data filesRestrictions on oracle XE are described as follows:1. Express Edition is limited to a single instance on any server;2. Express Edition may be installed on a multiple CPU server, but may only be

I just got started with DB2, but I am not very familiar with the Backup recovery mechanism of DB2, and I am not familiar with the relevant information, so I have to explore it myself. Requirement Online compression and backup of the production

1. NLS Parameter Oracle called globalization support National Language Support (NLS ),You can set the NLS parameter at the Session, Instance, and Database levels.Session-level settings overwrite Instance-level settings, and Instance-level settings

The original version of a testing database of the company is Oracle 11gR2. Some of the 10g syntax is somewhat different. The boss said to re-build the test database and use the 10G version. Although it can be shut down, the data volume is not big,

Commands for Dump files include exp/imp and expdp/impdp. These four commands have been compiled in related articles. Oracle EXP/IMP description Comparison between exp/imp and expdp/impdp and some optimization items in use Oracle expdp/impdp

Common Data Types of DB2 include: 1. Digital type. 1. SMALLINT --- short integer, range:-32768 ~ + 32767, less than once 2. INT/INTEGER --- INTEGER, 4 bytes in the range of-2147483648 ~ + 2147483647, multiple times for auto-generated sequence or

Modified the Oracle 10g inside the SPFILE ***. ORA file, the database can not get up, hold the wrong ORA-27046: file size is not a multiple of logical block size. The reason is that the dynamic server parameter file (SPFILE) is a binary file and

I. The following error is reported when 10gRAC uses DBCA to reconstruct asm:The ASM instance configured on the local node is a single-instance ASM. to create a single-instance database using this ASM instance, restart DBCA and select the

ORA-01000 is a common exception in development. This exception indicates the number of opened cursors in the program> the maximum number of opened cursors set in the database. This exception is usually caused by two reasons. 1. The maximum open

Record a problem. Shutdown immediate appears SQL> shutdown immediate ORA-00600: internal error code, arguments: [2032], [12587038], [12587038], [8192], [2], [255], [0], [767], [], [], [], []   And when the data is inserted ORA-01110: data file 3: