Database Administrator

Recently, the disk space of the Oracle server in the development environment is full, so I began to delete things everywhere and finally delete the files. I started to think about oracle data files again, due to the lack of knowledge about oracle,

Once the database is restored, open reports an error ORA-00349, as shown below. Finally, delete the log group. SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-00349: failure obtaining block size for '+ fra_kg0

With the release of ArcGIS10.1, more users gradually accept the use of ArcSDE for direct connection, not only because direct connection is a trend (service connections will be discarded later ), more importantly, the direct connection performance is

Using Oracle PL/SQL code encryption to protect the business logic is very useful in some scenarios. The following is a simple arrangement: 1. Use the Wrap command to encrypt 2. Use the dbms_ddl package for encryption Iii. Oracle encryption

Restoring oracle 10g RAC [restoring OCR] ---- Query OCR status:#/Oracle/product/10g/crs/bin/ocrcheckPROT-601: Failed to initialize ocrcheck  --------- Replacing the original OCR disk, an error occurred:#/Oracle/product/10g/crs/bin/ocrconfig-replace

Environment Oracle 11.2.0 + SQL Plus Problem Write a function as required: add 200 of the employees whose salaries are lower than the average wage in the scott. emp table, and return the total number of employees who have changed their salaries. An

Starting from 10 Gb, Oracle provides more efficient Data Pump (expdp/impdp) for Data import and export. The old exp/imp can also be used, but it is not recommended. Note: expdp/impdp AND exp/imp are incompatible. In other words, exp exported files

The crs_stat command in Oracle 11g RAC has many new resource types compared with the previous version. By default, crs_stat-t is used to check that resources are a large piece of data, it looks really laborious. The author Paul Elbow and Enkitec

-- ======================================-- Oracle listener log configuration and management-- ====================================== The Oracle listener is a server program used to listen to all requests from the client and provide database

CKPTQ: The data block in the Checkpoint Queue records the LRBA address of each data block. RBA: Redo Block Address (Address of the Redo log Block, which is equivalent to the rowid in the data file. You can use this Address to locate the Redo log

Materialized views are a feature built in Oracle for a long time, while PostgreSQL also developed functional code very early in the way similar to create table ...., it's just that it hasn't been built in. Version 9.3 Finally uses this as a built-in

1. MYSQL login Error[Oracle @ bys2 mysqlogg] $ mysql-u root-pEnter password:ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: YES)In this case, use mysql-u root to log on without a password.Password re-change: Use the

ASM concepts 1. what is Automatic Storage Management (ASM, it is a disk management tool that can implement strip, image data files, recovery files, and other files among multiple physical devices. The distribution unit is AUs (allocation units) the

System Environment: OS: Linux EL5 CRS: CRS 10.2.0.1 Oracle: Oracle 10.2.0.1 1. crs startup failed [Root @ node2 ~] # Crsctl check crsFailure 1 contacting CSS daemonCannot communicate with CRSCannot communicate with EVM 2. view system logs [Root @

Compared with performance, DB2 import and load log records are slow, and data records are too large, which may cause full transaction logs. However, some operations have to be logged, therefore, it is not applicable to import. However, it can be

Oracle provides the scott user's re-creation script, and the 11G uses the script to create scott. The simple operation is as follows: SQL> select * from dba_users where username = 'Scott '; ------ SCOTT has been manually deleted. No rows selectedSQL>

Replica Set basic Replica Set is a decentralized backup mode provided by mongodb (mongodb also provides master-slave deployment and sharding mode). Each mongod can be a master, A primary is automatically selected in the replica set, and the others

Index, which allows you to quickly access specific information in a database table. An index is a structure that sorts the values of one or more columns in a database table, such as the name column of the employee table. If you want to search for a

Oracle Vault is an important part of the three security technologies. Compared with the other two types, Label Security and Virtual Private Database (VPD), Oracle Vault better reflects the O & M system management and Security rule configuration.

Use of encrypted tablespace under Oracle 11 GB Oracle Undo image data exploration Oracle ROLLBACK and Undo) The Undo tablespace cannot be opened because it is damaged. How to handle Undo tablespace failures Oracle Undo tablespace reconstruction and