Database Administrator

This article mainly summarizes the operation tips such as pending operations, shrinking databases, compressing databases, and transferring databases to new users with existing user permissions, checking backup sets, and restoring databases during

To view database Parameters in Oracle EBS, go to System Administration> Oracle Applications Manager> Initialization Parameters.OrPath: System Administration> Oracle Applications Manager> System Configuration Overview> Database> Init. ora

Oracle 11gR2 is installed in Oracle Linux 6.0 (also suitable for other linux versions of RedHat ).There is no major difference in the installation under. After all, the three linux releases are more different in log.This document is a review after I

1. Introduction to system environment Oracle Database Server Operating System: RHEL4.8 64-bit, IP: 192.168.12.242 Oracle Database Version: oracle 10g Mysql database server operating system: RHEL 4.8 32-bit, IP: 192.168.5.186 Mysql database version:

Build Environment: Red Hat Linux Enterprise 5.4 Oracle 10g R2 The host operating system information is 192.168.199.128. Preparation: The master database (production database) DB_NAME = mustang SID = l already exists. Start building Data Guard First,

For details, see:Oracle Database Release Notes11g Release 2 (11.2) for ibm aix on POWER Systems (64-Bit)Part Number E23560-031. Installation, Configuration, and Upgrade Issues for Release 11.2.0.3Review the following sections for information about

1. query all Oracle roles Select * from dba_roles; 2. Describes frequently used pre-defined roles, such as connect, resource, and dba. 1. connect has most of the permissions of General developers. In most cases, it is enough to assign the connect

I used to think that the full backup of SQL Server only backs up the data in the database and does not contain logs. In fact, this is an error. Using RESTOREHEADERONLY can help us verify (msdb. dbo. backupset also contains the relevant information ).

NagiosQL is a web graphical management application designed for nagios. It operates databases and configuration files, including writing configuration file information to databases, modify the monitoring configuration of Nagios in the database and

Environment: MySQL Sever 5.1 + MySQL command line tool Problem: the current time of the MySQL datetime data type is set to the default value. Solution: Method 1: Because the default value of the current MySQL field does not support functions, it is

[Oracle @ node1 pfile] $ export ORACLE_SID = MRAC1 [Oracle @ node1 pfile] $ sqlplus/as sysdba   SQL * Plus: Release 10.2.0.1.0-Production on Thu Sep 27 10:27:35 2012   Copyright (c) 1982,200 5, Oracle. All rights reserved. Oracle Database 10g

Use the scan method of the new Oracle 11gR2 component (assuming that scan_vip is 192.168.100.217)String url = "jdbc: oracle: thin: @ 192.168.100.217: 1521/prod"You can also use the vip connection method before 11gr2.String url = "jdbc: oracle: thin:

The installed mysql database is: mysql-5.6.4-m7, which is installed with the cmake tool. CMake is a cross-platform installation (Compilation) tool. You can use simple statements to describe the installation (compilation process) of all platforms ).

First, let's give a brief introduction. [NOTE 1] installation path of MYSQL in MAC:/usr/local/mysql-5.5.28-osx10.6-x86 The database data files are stored in the data folder of the directory; The command file is in the bin folder. [NOTE 2] how to

In Oracle RAC, in addition to the TFA Method Based on the client, there is also the TFA Method Based on the server. You can regard the TFA method of the server as an upgraded version of the TFA method of the client. The TFA on the server must be

The Oracle Database encountered a ORA-600 [504] error. The error message is as follows: Tue Oct 5 10:16:18 2010 Errors in file/opt/oracle/admin/eomsdb/udump/eomsdb_ora_29837.trc: ORA-00600: internal error code, arguments: [504], [0x38006C260], [1

Oracle Special Character Processing search and replacement A colleague encountered a special character matching Replacement problem a few days ago. Here is a summary. What should we do if our data contains special characters such as line breaks and

Note: Que1: Generally, When configuring kernel parameters (gedit/etc/sysctl. conf), we only need to modify kernel. shmmax. 1 is half of the physical memory: Physical memory grep MemTotal/proc/meminfo The Unit is byte. (B) 3 It is recommended that

Because MemSQL is fully compatible with MySQL, It is very straightforward to migrate data from MySQL to MemSQL. You can use standard MySQL tools for migration. In this example, we assume that both your MySQL and MemSQL run on the same machine, MySQL

How to generate WIP debug log files in ONLINE cases?For 11.5.10 and above, the WIP debug log files will be created if1. FND: Debug Log Filename = (Make sure this is null)2. FND: Debug Log Enabled = Yes3. FND: Debug Log Level = Statement4. FND: Debug