Database Administrator

16.3 MySQL Cluster configuration details (config. ini)Config. in ini, each type of node has two (or more) corresponding configuration item groups. The configuration items of each type of node are mainly composed of two parts, and one part is the

A few days ago, when the database space was full, it had increased to a maximum of 32 GB for a single storage file. However, a lot of methods are used to release the tablespace. The main reason is that the system uses a large number of partition

Scott is my first user name to contact Oracle. Regardless of the version of the database, 9i, 10g, I like to use scott for some testing. But after installing oracle 11g, scott users cannot use it, which makes me feel awkward. When you log on with

Oracle Database-based data synchronization technology can be divided into two types: data synchronization technology provided by Oracle itself and data synchronization technology provided by third-party vendors. Oracle's own synchronization

Before the article, the archive mode is enabled and the archive log format is set to the front for easy reading and clarification. Each part will be described in detail later. SQL> archive log list // view the current archive ModeDatabase log mode

After VNC remotely connects to CentOS 5.5 to run the installation file, the following error is reported: Checking installer requirements... Checking operating system version: must be RedHat-3, SUSE-9, redhat-4, UnitedLinux-1.0, asianux-1,

MySQL is successfully installed at the beginning, but it is the most original startup method. /Usr/local/mysql/bin/mysqld_safe -- user = mysql & Today, I suddenly remembered that I could start using service and init. d, so I searched for it, but it

1. Matlab establishes a connection to the Oracle database through ODBC 1. In Windows, choose Start> Control Panel> performance and maintenance> Administrative Tools and click data source (ODBC )" 2. Select "system DSN"> "add"> select "Oracle in your

SQL> conn/as sysdba ERROR: ORA-28056: Writing audit records to Windows Event Log failed OSD-1627319533: Message 1627319533 not found; product = RDBMS; facility = SOSD O/S-Error: (OS 1502 )?????????????????? ORA-28056: Writing audit records to

Today, a friend asked me how to delete archive logs in Oracle10g and answered the following question: Archiving logs in Oracle cannot be directly deleted by operating system (OS) commands, because some information of archiving logs is recorded in

First, log on to Oracle as a super AdministratorSqlplus sys/bjsxt as sysdbaThen, unlock the scott user.Alter user scott account unlock;Then the user name can be used.(Default Global Database Name orcl)1. select ename, sal * 12 from emp; // calculate

Following are the steps to remove DB2 from Unix/Linux: 1. Remove DB [delete database first](1) su-db2inst1(2) db2 list db directory(3) db2 drop db 2. Remove Instance [Delete Instance](1) su-root(2) cd /instance(3)./db2ilist(4)./db2idrop-f 3. Remove

1. Go to the listener and check the corresponding log_file and log_status [Oracle @ bys3 log] $ lsnrctl.LSNRCTL for Linux: Version 11.2.0.4.0-Production on 06-DEC-2013 10:27:11Copyright (c) 1991,201 3, Oracle. All rights reserved.Welcome to LSNRCTL,

Oracle PLSQL Packaging -- Package-- Create a package-- Step:-- 1. Statement (create a Baotou)-- 2. Create a Data Object (create a package) -- 1,Create or replace package myPackAsV_bookCount integer;Procedure p_back(V_stuid borrow. stuid % type,

MySQL-5.6.10 and MySQL-5.5.34 for source code compilation and installation on CentOS 6.2 1. Install Mysql5.6.10 1. necessary software:Yum-y install gcc-c ++ autoconf automake bison ncurses-devel libtool-ltdl-devel * cmake makeIi. Compilation and

To back up the data, you need to export the complete data of 11 GB users on the server. The client on the machine is Oracle10g. Run the command: exp ***/*** @ *** file = ***. dmp full = y After the command is executed, the system prompts: EXP-00008

A long time ago, I gave a lecture and used the command ipcs to find that the Oracle Sharing Section is small, as shown below: Oracle @ mydb ~] $ Ipcs- ------ Shared Memory Segments --------Key shmid owner perms bytes nattch status0x00000000 32768

The following error occurs when calling the Oracle stored procedure using SHELL today: PLS-00306: The number or type of parameters is incorrect when the stored procedure name is called. Summary: when the number or type of parameters is incorrect

We know that MongoDB is a non-relational database, so its query method is very different from the standard Structured Query Language SQL. But no matter how complicated it is, when it passes through the developer's hands, it can only become the

ORA-01438: The value is greater than the allowed precision specified by this columnFor example, if the value is defined as number (200.12) but is inserted, an error occurs because of number (p, s. Number (p, s), where p indicates the total length