Database Administrator

Oracle Spatial Database Function usage Recently, I have been using Oracle's spatial database for some spatial data processing and analysis functions. I wrote this article mainly to take notes. After all, good memory is not as bad as writing. First,

Basic AWR knowledge Since Oracle began to support AWR for 10 Gb, in addition to more new content for reference, compared with Statspack, HTML saving format also provides a lot of convenience for viewing documents. I recently read the books of nimiek

Oracle cannot find the listener Oracle Server File app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN \ listener. ora SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = CLRExtProc)(ORACLE_HOME = D: \ app \ Administrator \ product \

MySQL database builds a series of multiple instances The so-called multi-instance is to build and run multiple MySQL instances on a server. Each instance uses different service ports and listens through different sockets. Physically, each instance

Oracle Cluster physical configuration requirements and restrictions 1. Oracle Clusterware supports up to 100 nodes in a cluster on deployments running Oracle Database 10 grelease 2 (10.2) and later releases. In Versions later than 10.2, oracle

TNS-01201: Listener cannot find executablen error resolution The TNS-01201: Listener cannot find executable... error message was recently received when the Listener was started. This error has never been encountered. I really don't know what it is.

Oracle query field details The SQL statement used to query the detailed information of a field in Oracle contains the table name, field name, type, length, whether it is null, column number, and field remarks. SELECT USER_TAB_COLS.TABLE_NAME as

Undo tablespace and redo logs Differences between undo and redo and their respective functions 1. Features of undo data: 1. It is a backup before data modification, mainly to ensure the user's read consistency 2. generated when the transaction

Hive-based file format: RCFile introduction and application Directory 1. Introduction to Hadoop file formats(1) SequenceFile(2) RCFile(3) Avro(4) Text Format(5) External format2. Why is RCFile required?3. RCFile Introduction4. What method should I

Questions about Oracle Database Development I recently attended several interviews to summarize the most common questions about competing for Oracle development jobs: 1. What is the difference between delete and truncate? 1) truncate is a DDL

Use PRM to restore table data truncated by truncate in the Oracle database Recovery scenario 1 conventional recovery of the Truncate table by mistake Company D's business maintenance personnel mistakenly TRUNCATE all the data on a table because they

Full version of MySQL5.6 cluster configuration under Redhat6.5 1. Prepare three servers 2. Install the Linux operating system for the three machines respectively (Oracle Linux/RHEL 6.5 x86_64bit) 3. Separate IP addresses Management node 192.168.1.110

[Oracle] ROWNUM and paging Rownum is a poor Oracle database, and its order increases progressively according to the order in which records are obtained from the table. Note that because records are stored unordered In the table, therefore, you

ORA-27054 error solved in two cases In Linux, mount the storage on another aix machine to nfs in linux, and then use expdp to export data stored in the disk mounted to linux. An error is reported. ORA-27054: NFS file system where the file is created

Kettle empty strings Today, Kettle is used to find some problems. The database is MySQL and you need to copy the data of a table to the local database. The table structure is as follows: Kettle is as follows: An error is reported for such a

Clever Use of xmltype to parse clob data For clob data, xml format is used in many cases, but data query and processing is always insufficient. When conditions permit, if xmltype can be cleverly used for data processing, it is accidentally a

Oracle 11.2.0.3.0 psu 11.2.0.3.9 in aix Upgrade Oracle psu to 11.2.0.3.9 on aix,Encountered: Copy failed from '/install/17540582/16902043/files/lib/libnnz11.so' to '/oraapp/oracle/product/11.2.0/dbhome_1/lib/libnnz11.so' Please verify all

Troubleshooting of abnormal shutdown of MySQL Slave The production environment has a Master-Slave replication of MySQL. A while ago, the network of the data center was upgraded, but after a general network fault is recovered, you only need to start

The Thinkphp framework supports MySQL read/write splitting. In the past, I tried to use Mysql Proxy and Ameba to solve the read/write splitting of MySQL, but the results are not very satisfactory. Now many websites and projects have been migrated

DB2 SQL20321N solution instance SQL20321N was reported during a recent DB2 database migration. Scenario: a clean environment, just installed with DB2, is expected to migrate an old DB2 database to this point. Perform cold backup at the source