Database Administrator

Download patches from Metalink Log onto Metalink (https://support.Oracle.com) and Oracle users can use ARU to download it. Click the Patches & Updates tab. In the "Patch Search" area, enter your Patch number, Search, After finding your Patch, pay

Scenario 1:[Oracle @ www.bkjia.com ~] $ Sqlplus/as sysdbaSQL * Plus: Release 11.2.0.1.0 Production on Tue Jun 26 20:52:47 2012Copyright (c) 1982,200 9, Oracle. All rights reserved. Connected:Oracle Database 11g Enterprise Edition Release

When installing small patches in the RAC environment, you can use Rolling installation to provide uninterrupted business applications! When installing the patch, stop a database instance, install the patch on this node, start the instance, stop

Sometimes, users may encounter access to schema... Denied and other error messages. In Postgresql, data access permissions are divided into at least two levels. One is schema and the other is table. Therefore, for a common user test, if a Super

1. Check the original undo tablespace: Select file_name, bytes/1024/1024 as MB from dba_data_files where tablespace_name like 'undo % '; 2. Create a New undo tablespace: Create undo tablespace undotbs2 datafile

1. Shut down the databaseSQL> shutdown immediate;2. Move data files and log files to a new locationSQL> host mv/u01/olddata. dbf/u02/newdata. dbf;SQL> host mv/u01/oldredo. log/u02/newredo. log;3. Start the database in load modeSQL> startup mount;4.

I. Functions of redo log files: 1. Record all data changes 2. Provide a recovery mechanism 3. group-based Management (there are at least two groups. The default value is 3. Each group has one redo log file. Oracle officially recommends that the size

ORA-07445: exception encountered: core dump [kghalkaline () + 58] [SIGSEGV] [Address not mapped to object] [0x000000068] [] [] DUMP File * ** Service name :( orcl) 2012-07-12 14:18:55. 016 * ** Session id: (258.58198) 14:18:55. 016 Exception signal:

Using RMAN to fix the issue based on time points, the strange thing is that, after setting nls_date_format, you cannot log on to RMAN?Symptoms: C:> set NLS_DATE_FORMAT = 'yyyy-MM-DD HH24: MI: ss' C:> rman nocatalog target rman/rman @ test Recovery

BackupBackup is used as a means of redundancy to prevent errors or downtime.I. Oracle backup can be divided into two types: physical backup and logical backup.1. Physical backup: copy, copy files such as datafile and control file to other

Connection query is a frequently used query method in database query statements. The following describes how to query connections based on the official documents provided by Oracle: 1. Connection Type: 1) Unique oracle connection types: A.Equijoin

When optimizing MySQL configuration, add skip-name-resolve to check the startup log when you restart MySQL. Warning Information is found. 120726 11:57:22 [Warning] 'user' entry 'root @ localhost. localdomain 'ignored in -- skip-name-resolve mode. 1

Recently encountered a problem in the project, and the current affairs of updating expired data were not rolled back. The transaction configuration was carefully checked before and after, and the problem was not found. Finally, after one-step

First article on Restoration Based on SCN 1. Check the SCN number before deleting the data: SQL> col name format a45 SQL & gt; set line 300 SQL> select name, checkpoint_change # from v $ datafile_header;   NAME CHECKPOINT_CHANGE # -------------------

1. download the latest version of postgresql: http://www.postgresql.org/ftp/source/ 2. decompress the file:Tar zxvf postgresql-8.3.7.tar.gzCd postgresql-8.3.7 3. Configuration:./Configure -- prefix =/usr/local/pgsql 4. Compile:Make 5.

1. When the mysql client initiates a connection request, the MySql Server takes the initiative to check the client host name. 2. First, find the/etc/hosts file in the Windows System directory and search for the ing between domain names and IP

Benefits of Compression Compression is an Oracle feature that is more suitable for Data Warehouse Environments. The benefits of compression include: 1. Saving storage space makes sense for massive data volumes. 2. the query performance will be

RMAN is a required management tool for Oracle Database Backup management. There are many ways to operate it. I sorted out some common operation commands and summarized them to facilitate work. 1. database backup operation commands Simplified Version

Cause: For non-important files, it usually does not cause the instance to crash. Oracle will take these damaged data files offline and make their content inaccessible, but the rest of the database should be open. Damaged important data files can

Under normal circumstances, you can change the user password in Oracle EBS in System administrator> Define user form, but sometimes, you need to change the password more quickly during development or implementation, you can use the script below