Database Administrator

1. tar + openssl file encryption: There is a folder named test in the current directory: 1. Use tar to encrypt the file: # Tar-zcvf-pma | openssl des3-Salt-K password | dd of = test. des3 After the installation is complete, a package file named

The system reports an SQL exception. The content is as follows: Java. SQL. SQLException: ORA-01795: maximum number of expressions in a list is 1000 The SQL statement executed when an exception is thrown is not surprising. It is a common SQL

Problem 1: the shared disk allocated on node 1 can only be seen on node 2. Solution: Disable Node 1. This step does not verify whether it is required ). You can re-allocate Node 2 once and open Node 1. Problem 2: Installing Oracle changes the size

Project Introduction: The Amoeba for Mysql software is designed for the MySQL Distributed Database Front-end proxy layer. It acts as an SQLRouting function, focusing on Database Proxy at the distributed Database Proxy layer) development. It is

4.2 system service process 4.2.1 Start and Stop of oBus Start: Enter "Please Input ==> start" on the main interface of sotaCC, and go to the "start service process" menu, as shown in Figure ‑ obus_start. Stop: Enter "Please Input ==> stop" on the

For example, there is a Chinese table as follows: Example 40: Create table Test table Id number, Name VARCHAR230 ), FLAG CHAR1 ), CONSTRAINT PK_TESTD primary key id) using index ); -- Create the mv log and MV at the source end: Drop materialized

Iii. Network Transmission Encryption GoldenGate is not encrypted by default during data transmission. Data can be encrypted before GoldenGate transfers data over the network. After being transferred to the target end, data can be decrypted before

Logdump is a trail file analysis tool provided by GoldenGate. It is worth the time to study the working principle of GoldenGate. By default, the Logdump component is in the installation directory, which is an executable file, as shown in figure 6. 65

4. Use Alibaba sec for permission Control GoldenGate can restrict the use of commands by some users. For example, some monitoring users can only use the INFO and STAT commands, rather than the start and stop commands. This is the purpose of limiting

When a database is deleted by mistake, data recovery becomes very important, like oracle databases. Our common method is to flash back to flashback or use logmnr to restore Data in log analysis. However, in mysql, data Recovery becomes a very

ORACLE session count and connection count Configuration ORACLE session count and connection count Configuration ORACLE session count and connection count parameter configuration Log On As sysdba Sqlplus sys/xxxx as sysdba; View the

A ssis Package was created two days ago to loop through Excel and then import it to the database. It works normally in the development environment, but after being deployed to the SQLAgent, it is found that the Job has failed. Open JobHistory to

1. Checkpoints Checkpoints checkpoint is the system powered on CMOS initialization program initial program load, IPL) after running, a series of information is displayed on the display panel of the I/O cabinet. After the AC power supply is

Lock: Controls concurrent access to shared resources to prevent conflicts.Ensures data consistency, integrity, and sharing.-- Lock classification:1) Row-Level Lock exclusive lock)In oracle databases, when insert, update, delete, select... for update

-- ====================================== -- Oracle instance recovery -- ====================================== I. Oracle instance failure Oracle instance failures are mostly caused by instance non-consistent shutdown, which is usually called a

[Oracle @ localhost ~] $ Asmcmd help = y Commands: -------- Cd Du Find Help Ls Lsct Lsdg Mkalias Mkdir Pwd Rm Rmalias ① List Directory Information ASMCMD> ls DATA/ ASMCMD> ls-al State Type Rebal Unbal Name Mounted normal n data/ ② Alias ASMCMD>

Idle> startup ASM instance started Total System Global Area 83886080 bytes Fixed Size 1217836 bytes Variable Size 57502420 bytes ASM Cache 25165824 bytes ORA-15032: not all alterations saved med ORA-15063: ASM discovered an insufficient number of

1) view log files sys@CISCOSYS> col member format a60sys@CISCOSYS> select group#,member,type from v$logfile;GROUP# MEMBER TYPE---------- -----------------------------------------------------------

The actual size of the Instance contains fragments)SELECTROUND (SUM (data_length)/1024/1024/1024), 5) ASDATA, ROUND (SUM (index_length)/1024/1024/1024), 5) ASidx, ROUND (SUM (data_length + index_length)/1024/1024/1024), 5)

If you use INFOBRIGHT, you will not be familiar with this word.There are currently four formats. 1. binary.2. txt_variable3. mysql4. infobright What does it mean? Let me explain it in detail.BINARY represents BINARY data. That is to say, raw data