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

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

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, I upgraded MySQL from 5.1.26-rc to 5.5.15. The source code packages downloaded from the official website are compiled. MySQL 5.5.15 is provided by my colleagues. Because the existing database uses the innodb engine, mysqldump is used to

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

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: \

OracleDatabase Log status We queryV $ logThe view shows the log status. SQL> select group #, ARCHIVED, status fromv $ log;  GROUP # ARC STATUS ----------------------------- 1 NO CURRENT 2 YESINACTIVE 3 YES ACTIVE   CurrentIndicates the currently

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

Install postgresql on openSUSE and record the steps below. Read more: Install Mono on openSUSE and release ASP. Net programs Environment I tested the installation of postgresql 8.4.6 on openSUSE 11.3, and the installation of postgresql 9.0.3 on

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

In Oracle, you must query the non-repeated columns t. address and t. mermer_name in the customer table: The general idea is: Select distinct t. address, t. customer_name from customer t However, this method is incorrect in oracle. Therefore,

Some Oracle users need to be granted the query permission for the dynamic performance view. The problems encountered today are as follows: SQL> conn/as sysdbaConnected.SQL> grant select on v $ session to hr;Grant select on v $ session to hr*ERROR

On SQL server, it is easier to verify whether the data is Numeric. You can use the following methods: ISNUMERIC When it is a number type, the return value of the method is 1; otherwise, the return value is 0. Example: Select * from tablename

Error: [Oracle @ prudentwoo admin] $ sqlplussystem/oracle @ PRUDENTWOO SQL * Plus: Release 11.2.0.1.0 Production onWed Dec 12 03:23:29 2012 Copyright (c) 1982,200 9, Oracle. All rights reserved.   ERROR: ORA-12514: TNS: listenerdoes not currently

In Oracle 11g installation, the following parameter values must be specified in linux. Select three of them as an example. The rest will not be written because they are not met for the time being.# Vim/etc/sysctl. conf Fs. aio-max-nr = 1048576Fs.

Two Linux servers, one as master server A and the other as backup server B. The system is CentOS and MySQL is used for the database. After mysql settings on A are complete, B cannot connect. However, the C server can connect to. Very strange.

1. create any directory ): SQL> create user Oracle identified by oracle; The user has been created. SQL> grant dba to oracle; Authorization successful. SQL> grant create any directory to oracle; Authorization successful. SQL> conn

--******************* -- CRS-0215 error handling --*******************   When installing Clusterware, Receive the following error message: The given interface (s), "eth0" is not public. Public interfaces shoshould be used to configure virtual