Database Administrator

1. administrator permissions:SYSDBA: the default schema is SYS.SYSOPER: the default schema is PUBLIC.These two permissions allow users to log on to the database when the database is not opened, so the permissions are beyond the database. This type

1. Install the cross compiler on a PC with a Linux operating system. I use Moxa tool chain for DA66x (the same is true for other embedded Linux systems ), you can download it from the Moxa Website:2. Download the ACE package to a Linux PC and

How many times have you been embarrassed to consider how to set up a database? In fact, if you use MySQL on Linux, this will not happen. Using the Webmin GUI on Linux to create a MySQL database is quite simple.In this article, we will take a look at

You can take the following steps:Query the latest service packageMake sure that you always have the latest service package. For SQL Server2000, this is SQL/downloads/2000/SP3.asp "> SP3a. Remember that there are multiple service packages. If you use

1. Install mysql, 2. Install MyODBC-standard-3.51.07-win.msi 3: The vb connection statement is: Public strcnn As StringPublic SQL As String Public conn As New ADODB. Connection Public rs As New ADODB. Recordset Sub link () Strcnn = "driver = {

In most businesses, the main business requirement for true Oracle Application cluster (RAC) configuration based on the Linux platform is the scalability of the database layer in the entire system-in this way, when the number of users increases, you

Using shell scripts to monitor and manage Oracle databases will greatly simplify DBA workload, such as common instance monitoring, monitoring, and daily alert monitoring, and database backup, AWR report automatic mail, etc. This section describes

1: Create a tablespace on the catalog Database:Export Oracle_SID = ORCL Create tablespace rmants datafile '/home/oracle/rman/rmants. ora' size 20 M; Note: The tablespace name must not be rman. If it is rman, an error will be reported in the next

CentOS 6.3 32-bit Operating System Default mysql5.6 configuration file # For advice on how to change settings please see # Http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html # *** Do not edit this file. It's a template which

Large data tables in the Oracle database are partitioned to improve data reading efficiency: In PLSQL, directly add the Code: -- Purpose: to partition and convert large table data. In this example, only 5000 pieces of data are used;-- Create Table

Some netizens recently mentioned why the historical execution plan of SQL statements cannot be viewed in dba_hist_ SQL _plan. This problem is due to the fact that the threshold value set by Oracle does not capture all SQL statements by default,

My system is Ubuntu 12.10 First, add the key: Apt-key adv -- keyserver keyserver.ubuntu.com -- recv 7F0CEB10 An error occurs as soon as it comes up: Executing: gpg -- ignore-time-conflict -- no-options -- no-default-keyring -- secret-keyring/tmp. PJ6

Simple setup of master-slave MySQL 192.168.190.128 "====" 192.168.190.129Master ---- slaveSlave ---- master 1. Configure the my. cnf file on the master 128 and add the following parameters:Server-id = 1Log-bin = mysql-binLog-salve-updatesSync_binlog

Edit the SQL statement in the current SQLPLUS Buffer For example, ed is short for editing the SQL statements in the buffer zone using the editor specified by our environment variables. Of course, it is the buffer zone of SQLPLUS. We can prove that,

In the absence of visual tools to monitor database performance, common scripts come in handy. Below are a few scripts related to Oracle performance for your reference. The following scripts are successfully tested in Oracle 10 Gb, and Oracle 11 GB

Platform solaris, Oracle10202Error Information: Terminate output from the derivative process.Information :----------------------------------Information: An exception occurs during the operation: makeException error name: MakefileExceptionException

DRBD is the block-level synchronous replication technology implemented by the kernel module. The synchronization level here can be adjusted.Because DRBD uses the network card for block replication. If Infiniband is used for transmission, high

1. Back up data on the Management node.Ndb_mgm> start backupNdb_mgm> shutdownNdb_mgm> exit2. Delete SQL node data.Drop database TEST_CLUSTER;3. Disable the MYSQLD server.[Root @ localhost bin] # service mysqld stopShutting down MySQL... SUCCESS!4.

Lab environment: OEL + Oracle11.2.0.3 + physical standby As we all know, Data Guard is already the mainstream disaster tolerance solution of today's standards. Due to its strong adaptability to the network, it can adopt synchronous real-time

Almost all internal changes that occur in Oracle are recorded in the online redo log file. oracle uses these redo log groups to restore the database, so they are very important. The main tasks of online redo log files are: Back up data, 1: record