Database Administrator

MONGODB Data ArchitectureUpgrade SolutionProblem DiscoveryThe number of users that application servers suddenly flood into, resulting in slow server responseCheck the server and find that the response speed is extremely slow, which is 30ops.Check

System Environment: Operating System: RedHat EL6 Oracle: Oracle 10g and Oracle 11g Manual database creation is relatively easy to implement. In this case, we will make a simple comparison from 10g and 11g. We can see a simple difference between 11g

System Environment: Operating System: RedHat EL55 Oracle: Oracle 11.2.0.1.0 Cluster software: Oracle GI 11.2.0.1.0 Error: [Oracle @ node1 ~] $ Srvctl add database-d stddb-o/u01/app/oracle/product/11.2.0/db_1/-n cuug [Oracle @ node1 ~] $ Srvctl add

When Oracle is started after modifying the parameters, the following error occurs: SYS @ PROD> startupORA-00119: invalid specification for system parameter DISPATCHERSORA-00111: invalid attribute DISPPATCHERS Solution 1. Create pfile SYS @ PROD>

SQL> create table aa (a number, B number );Table created.SQL> create table bb (B number, c number );Table created.SQL> insert into aa values (1, 2 );1 row created.SQL> insert into aa values (2, 3 );1 row created.SQL> insert into bb values (2, 4 );1

Start: net start mySql;Enter: mysql-u root-p/mysql-h localhost-u root-p databaseName;List databases: show databases;Select Database: use databaseName;List tables: show tables;Show columns from tableName;Create a database: source

1. experiment environment ConfigurationThis experiment is carried out in the vmware9.0 environment, the installation of the operating system CentOS-6.4-x86_64, database version is Oracle10g10.2.0.1, the source database and the target database are

I accidentally found that my DB2 test environment could not be used. I always reported an error when I opened it. I always thought it was db2audit and reported an error. DB2 database performance adjustment and optimization (1st and 2) PDF DB2

Serial number Task Command combination 1 Delete 0-byte files Find.-type f-size 0-exec rm-rf {}\;Find. type f-size 0-delete 2 View processes in a descending order of memory Ps-e-o "% C: % p: % z: % a" |

In Oracle, if you want to delete a user's table data in multiple ways, we recommend a fast method to delete all the table data under the user, you can use plsql to quickly delete a file. The Code is as follows: DeclareCursor c_t is (select

We recommend that you deploy this tool under root or non-Oracle users. 1. Software preparation, go to the https://support.oracle.com according to the corresponding version of oracle download 2. Install and uninstall osw Copy the downloaded osw.tar

1. OverviewThere are two ways to import a MySQL database:1) Export the database SQL script first and then import it;2) directly copy database directories and files. In different operating systems or MySQL versions, the method of directly copying

If you have encountered a problem before, you need to retrieve all the file names in a folder and store them in the database. Using a php script to test, read a file name and store it in the database immediately. It took me more than 230 seconds to

Exp/Imp is a commonly used logical backup method.   Use of Exp/Imp tools 1. data transmission between two databases. Different database versions and operating systems are supported. 2. database backup and recovery 3. transfer data from one database

1. Install CentOS2. Install the library required by ora3. Modify the centos Kernel4. create user groups and directory structures5. Install ora11g2r6. Install the SQL plus paging program and help patch7. self-starting script8. Common commands 1.

Determine the data file, log file, and tempfile information of the original database. Select group #, status, type, member from v $ logfile;Col name format a65Select file #, name, bytes/1024/1024 MB from v $ datafile;Select name from v $ controlfile;

1. Download mysql monitoring Script: gmetric-mysql.sh Free in http://linux.bkjia.com/ The username and password are both www.bkjia.com The specific download directory is in/July 6, 2014,/July 25, April,/Ganglia, which monitors MySQL. For the

Accidental data deletion is a "low-level error" that is often encountered by junior O & M personnel. Some experienced veterans sometimes get lost when they are tired and calm ". Once a data file is deleted by mistake, restoring the database with the

Temporary tablespace is a special structure in the Oracle architecture. In general, the database user only needs to set the corresponding Temporary tablespace (to the user), and the assignment of temporary segments is automatically completed by the

1. Environment Description and precautions Operating System: Oracle Linux 5.4 (32-bit) Object: Install Grid Infrastructure on an independent server and install Oracle Database (data files are stored in the ASM disk group) Completion Time: 1 H