Database Administrator

[Oracle @ bi11g bin] $./sqlplus/nolog SQL * Plus: Release 11.2.0.1.0 Production on Fri Dec 1618: 39: 36 2011   Copyright (c) 1982,200 9, Oracle. All rights reserved.   SQL> conn/as sysdba Connected. SQL> show parameter memory   NAME TYPE VALUE ------

There are two ways to store files in Mongodb in the GridFSB mode: 1. Command Line program files 2. client-side driver programming (using Java as an example) Related reading: MongoDB cluster configuration (sharding with replica set) Add a shard

Mongodb supports master-slave replication without verification, but only one configuration role is master and oplog, And the other configuration role is slave and master's ip port. If it comes with verification, it will be troublesome. Master: 1.

AIX5.3 Oracle10G RAC environment, when creating a LV because CHMOD, CHOWN is not synchronized in two nodes, resulting in nodes with no permissions set reported ORA-01186 \ ORA-01157 \ ORA-01110 error, then, the data file problem occurs during the

1. Encryption Algorithm create or replace function encrypt (in_string varchar2, shift number) return varchar2 isLv_out_string varchar2 (100 );Lv_in_string varchar2 (100 );Lv_length number (5 );Lv_count number (5 );Lv_temp varchar2 (1 );Lv_shift

Follow the steps of configuring dbstart for Oracle 10g on the Internet to enable auto-startup. the startup is successful and the record is as follows: 1. Modify the dbstart script:$ Vi $ ORACLE_HOME/bin/dbstart# ORACLE_HOME_LISTNER

1. The LONG data type stores variable-length strings with a maximum length limit of 2 GB. 2. For text that exceeds a certain length, the LONG type can only be used for storage. Many objects in the data dictionary are defined as LONG. 3. The LONG

1. Switch to the database user on the console: su-OracleIi. Input: lsnrctl start; start the listener;3. Start the database;4. operate databases, such as creating users, granting permissions, and creating tables;5. Shut down the database;6. Disable

The Spool buffer pool technology in Oracle can be used to export Oracle Data to text files. 1. Enter the buffer start command in Oracle PL/SQL and specify the output file name: Spool d:/output.txt   2, Set heading off -- remove the field name Set

1. Create an Oracle database (if any ).2. Create an OEM user and create a directoryMkidr-p/oracle/oem_12cChmod-R oem: oisntall/oracle/oem_12c3. modify Database ParametersSu-oracleSqlplus/AS SYSDBAAlter system set processses = 300 SCOPE =

First, change the lazy property to false. Type 2: Add OpenSessionInViewFilter org. springframework. orm. hibernate3.support. OpenSessionInViewFilter flushMode AUTO OpenSessionInViewFilter /* The above two methods have some problems. Third,

1. Unzip the shortcut key installation package: Root@www.bkjia.com ~ # Tar-zxvf rlwap-0.30.tar.gz Root@www.bkjia.com ~ # Cd rlwap-0.30 2. Perform the Configuration: Root@www.bkjia.com ~ #./Configure Root@www.bkjia.com ~ # Make

The error message is as follows: SQL> startup ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device Check 1. The memory size of the operating system. Make sure that the size of the configured SGA + PGA does not exceed the

Conversion between different data typesIn the value assignment statement, the data type is implicitly converted, and the implicit conversion should be avoided as much as possible, because the written SQL statements are hard to understand and are

Master Server IP Address: 1.1.1.21 Slave Server IP: 1.1.1.22 Note: This document only describes synchronization of the master node and slave node, rather than mutual backup. To achieve mutual backup, perform the following two steps after completing

First, the previous image shows the truth. Note: 1. Read a data table with more than rows, and then write data to the local table. 2. Tables of the big field type are not included. Note: 1. I recently performed data import/export operations.

Just now, another careless operation was executed on the Slave to change the database schema. The result is that the status of this server in mmm_control has changed to: REPLICATION_FAIL. First, use writer to perform the same operation to ensure the

1. Install Devadm @ devserver :~ $ Sudo apt-get install mysql-server......The following NEW packages will be installed:Libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient16Libnet-daemon-perl libplrpc-perl mysql-client-5.1

The method for starting Scott user in Oracle. In Oracle10g, (g stands for 'network') the Scott user in the database is locked during installation. When installing Oracle, you can directly unlock the user. If you forget to unlock the user, you can

1. Check the system packageRpm-q compat-libstdc ++-33 elfutils-libelf-devel glibc-common glibc-devel gcc-c ++ libaio-devel libaio libgcc libstdc ++ libstdc ++-devel make sysstat unixODBC-devel pdksh5.2.14 Note that the package pdk5.2.14 does not