Database Administrator

The db_recovery_file_dest_size parameter is used to limit the total size of files that can be stored in the Flash recovery area. Once the db_recovery_file_dest_size parameter is set to a non-zero value, it is "difficult" to restore to the default

-- The location where exceptions and exceptions are captured in Oracle can be used to debug stored procedures, especially for a long time.DECLAREV_RATE NUMBER; -- RatioV_RETINFO VARCHAR2 (2000); -- exception informationBEGINSELECT 120/0 INTO V_RATE

This note is taken in the previous article . During the learning process, we tested the downloaded DB2 database on the official website (free version). Since DB2 is used in projects, it is also a paid database, so I only use it in project

1: When installing Linux, install X Window System, GNOME Desktop Enviroment, Development Tools, Legacy Software Development 2: After installation, run the rpm-q command to ensure that the following packages are successfully installed:Binutils-2.15.92

Oracle Database Security is often overlooked by SA or DBA. In fact, you still need to be vigilant. Here are some configurations and parameters to improve the security of the Oracle database. 0. Restrict sysdba users from using remote logon.Alter

Source code download wget http://admin.ooopic.com/soft/linux/cmake-2.8.3.tar.gz  wget http://www.wapm.cn/uploads/csft/4.0/coreseek-4.0.1-beta.tar.gz  wget http://ftp.jaist.ac.jp/pub/mysql/Downloads/MySQL-5.5/mysql-5.5.9.tar.gz  Tip: the

In many cases, DBAs need to perform operations that cannot be performed online. This statement is quite difficult. For example, if you add a column to a core-level table or perform a modification operation, not only will the master database lock the

You must use the TO_DATE function.SQL codeTO_DATE ('2017-08-24 00:00:00 ', 'yyyy-MM-DD HH: mm: ss ') The results reported two errors in the ORA-01810 format code. after an online query, it was found that there was a problem with formatting the

Today, we tested the restoration method for Oracle after deleting table data. There is a table in the maintenance test of the oracle production system. The data in the table is deleted and commit. The service cannot be interrupted (the database

The CASE expression can implement the if-then-else logic in SQL without using PL/SQL. The CASE method is similar to DECODE (), but CASE should be used because it is ANSI compatible.Note: 1. Start with CASE and END with END 2. WHEN followed by a

0. Preparations-- Create the transferred tablespaceSQL> create tablespace tbs_singleDatafile 'C: \ Oracle \ oradata \ ora9i \ tbs_single01.dbf' size 100 MExtent management local;-- Create a user and use the tablespace as the default tablespaceSQL>

1. Check whether the Oracle database master service and listener service are enabled2. Check whether the listener. ora file is correctly configured. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = G: \

Problem: After enabling SQL Server 2008, you do not need to manually add the local administrator group because it is added by default during installation. You only need to manually add the current user to the local administrator user. This means

I1. Start: the fields in the SQL code exported through powderDesiger are all in lower case and then directly imported to Oracle. 2. bug: The table structure cannot be modified (in PL/SQL Developer) --- including adding deletion and modification... 3.

Using MySQL dual master + keepalived is a very good solution. In the MySQL-HA environment, MySQL is mutually master-slave, which ensures data consistency between the two MySQL databases, then, use keepalived to implement virtual IP addresses, and

1. The data type in Oracle is number (), and the large data type is clob. 2. Create a primary key auto-Increment Introduction to ORACLE SEQUENCE In Oracle, sequence is the so-called serial number, which is automatically increased every time it is

Backup Control File Alter database backup controlfileto '/bk/ctl. bk ';  SQL>Alter system switch logfile; Alter system switch logfile * ERROR at line 1: ORA-03113: end-of-file on communication channel  SQL> conn/as sysdba Connected to an idle

ASMCMD> pwd+ Data/myrac/onlinelog ASMCMD> ls-ls Type Redund Striped Time Sys Block_Size Blocks Bytes Space NameOnlinelog unprot fine sep 25 18:00:00 Y 512 102401 52429312 group_1.257.772910379Onlinelog unprot fine sep 25 18:00:00 Y 512 102401 5242931

It is easier to add a disk image to ASM using DBCA on node 1. Two new directories are created: ARCHLOG and BACKUP. Node 2 cannot be loaded! [Oracle @ node2bdump] $ export ORACLE_SID = + ASM2 [Oracle @ node2bdump] $ asmcmd ASMCMD> ll Commands: -------

I encountered a problem when I learned how to add Foreign keys to the database today. I first created two tables, orders and order_items. The storage engine is InnoDB and all of them have the orderid attribute (the same type), but I use the command