Database Administrator

Note: Cold backup-you can back up a database in ARCHIVELOG mode or a database in NOARCHIVELOG mode. Hot Backup-only ARCHIVELOG databases can be backed up. In other words: ARCHIVELOG mode-cold backup or hot backup. NOARCHIVELOG mode-only cold backup

Finally solved the Mysql garbled problem! The system is Fedora 15. After using sudo yum install mysql-server mysql-client, modify/etc/my. cnf Add default-character-set = utf8 under [mysqld], restart mysql, and report an error. view the log, I

For the development environment, install Oracle 10g on Windows Server 2008 R2 performanise64-bit system. Downloaded from the official Oracle websiteOracle Database 10GRelease 2 (10.2.0.4) for Microsoft Windows Vista x64, Microsoft Windows Server 2008

1. log on to and unlock the account with the dba role. First, set the specific time format to view the specific time.SQL> alter session set nls_date_format = 'yyyy-mm-dd hh24: mi: ss ';Session altered. 2. view the lock timeSQL> select username, lock_

OCCI(Oracle C ++ Call Interface):C ++Program andOracleThe database implements interactive application interfaces, which are provided to users in the form of dynamic connection libraries.OCCIPairOCIImplements object-level encapsulation, and its

Oracle beginners, start oracle service on Windows: net start OracleServiceOrcl, and then open pl/SQL to connect to oracle, but an error is displayed, cannot connect. Later I found that the listening service was not started, so I started the

Grid plug-and-play (GPnP) Grid plug-and-play is used to help administrators maintain clusters. Some manual operation steps required to add or delete nodes can now be automatically implemented by GPnP. GPnP is not a separate concept. It relies on the

System installation: Select as many development software as possible. X Windows is required. 1. create necessary users, groups, and directories # Mkdir-p/u01/Oracle # Groupadd dba # Groupadd oinstall # Useradd-g oinstall-G dba/u01/oracleOracle #

Date typeDate includes year, month, day, hour, minute, and secondTimestamp this is an extended (timestamp) timestamp of the date data type of Oracle9i. Image Type Blob binary data can store pictures and sounds for 4 GB Oracle table management Create

For Oracle, Java-class functions can be used because Java JVM is built in. Usage Use pl/SQL developer: (1) Go to pl/SQL developer and select java sources: Create Enter the following code: (import can not, here to point out that the import package

1: The cursor instance displays the name and Department DECLARE Name VARCHAR2 (50 ); Department_name varchar (20); -- defines two variables to store the content in the employees table and the departments table. CURSOR emp_cur IS -- defines the

In other words, download mysql-python-1.2.3.win32-py2.7.exe Is: Free in http://linux.bkjia.com/ The username and password are both www.bkjia.com The specific download directory is/pub/2011/12/07/access the MySQL 2.7 database on the Python 5.0

In our actual application, we often need to deploy configurations between data and source code. So I am writing this blog for you to exchange and learn. The connection to Oracle databases is cumbersome. At the beginning, you cannot afford to suffer

I. Blocking Solution 1. Find out which users are blocking Select sid, serial #, username from v $ session where sidIn(Select blocking_session from v $ session );  2. Kill the process in which the user is located Alter system kill session'& Sid,

IN Operator SQL statements written IN are easy to write and understand, which is suitable for modern software development. However, SQL statements using IN always have low performance. The following differences exist between SQL statements using IN

Simple Steps for installing Oracle 11g R2 (11.2.0) on RHEL5.5 1) required rpm for installation:# Rpm-UvhBinutils-2.17.50.0.6Compat-libstdc ++-33-3.2.3Elfutils-libelf-0.125Elfutils-libelf-devel-0.125Elfutils-libelf-devel-static-0.125Gcc-4.1.2Gcc-c ++-

Technical aspects 1. Data Structure MongoDB uses document-based storage. Its data structure is similar to the BSON structure of JSON. Cassandra supports key-value storage, and each key-value stores a period of time, this time period actually plays

For example, the data format is substring-substring. -- Obtain the substring Select substr (source string or field name, INSTR (source string or field name, '-') + 1, INSTR (source string or field name '-', 1, 2) -INSTR (source string or field

The following describes the sequence and trigger used to create a table using the Oracle Client. We will record their usage: The sequence is created and the trigger is used to implement auto-increment of the table's primary key. First, create a

If developers use tables or views of other databases, they must create a View in the current database to perform cross-database operations. It is best not to directly use "databse. dbo. table_name ", because sp_depends cannot display the