Database Administrator

1. Three types of Oralce logon authentication refer Operating system verification-my computer-management-local users and groups-group ora_dba Password File to verify that _ PWDorcl. ora under the installation directory of oralce is the

EBS patching steps in Oracle On Demand (OOD) projects # Check if patch applied & count of invalid objects, create invalids table & replace 7777777 with patch numberSelect name, user from v $ database;Select BUG_NUMBER, LAST_UPDATE_DATE, success_flag

Add a script to monitor the slave database running status in the MYSQL master-slave synchronization configuration. The Code is as follows: #! /Bin/bash # Check MySQL Slave's Runnning Status # Crontab time00:10 MYSQLPORT = 'netstat-na |

-- 1. Check the Software Installation/*Binutils-2.15.92.0.2-13.EL4Compat-db-4.1.25-9Compat-libstdc ++-296-2.96-132.7.2Control-center-2.8.0-12Gcc-3.4.3-22.1.EL4Gcc-c ++-3.4.3-22.1.EL44Glibc-2.3.4-2.9Glibc-common-2.3.4-2.9-- Gnome-libs-1.4.1.2.90-44.1

When I started the test database in the morning, I found the following problems:The database version is 11.2.0.3.SQL> startupOracle instance started. Total System Global Area 1653518336 bytesFixed Size 2228904 bytesVariable Size 1140854104

I. Hardware Detection1. Memory detection Oracle11g requires a minimum of 1 GB memoryCommand: grep MemTotal/proc/meninfo2. swap space detection usually has 1.5 times of swap spaceCommand: grep SwapTotal/proc/meninfo3. temporary directory/temp

Environment Description: LINUX Virtual Machine RedHat5.5 + Oracle10.2.0.1 Single Instance Library Fault description: When startup starts the database, a ORA-00600 error is reported as follows, and cannot start ORA-00600: internal error code,

An error is reported when you use expdp today:ORA-39002: invalid operation.ORA-39070: Unable to open the log file.ORA-29283: invalid file operationORA-06512: at "SYS. UTL_FILE", line 475ORA-29283: invalid file operation The cause is as follows:SQL>

Requirement: increased from 50 M in each group to 100 M 1. Check the script with log group information:SELECT v $ logfile. member, v $ logfile. group #, v $ log. status, v $ log. ARCHIVED, v $ log. bytes/1024/1024, v $ log. thread #FROM v $ log, v $

@ SequenceGenerator (name = "SQECagegory", sequenceName = "categoryDB", allocationSize = 1) ImportJavax. persistence. Entity; ImportJavax. persistence. GeneratedValue; ImportJavax. persistence. GenerationType; ImportJavax. persistence. Id;

This test does not compare data from the time dimension, but simply compares data from the bucket dimension.-- Operating System Environment[Oracle @ 11grac1 ~] $ Uname-Linux 11grac1 2.6.32-300.10.1.el5uek #1 SMP Wed Feb 22 17:22:40 EST 2012 i686 i686

Check System Environment Grep MemTotal/proc/meminfo# Check physical memory Grep SwapTotal/proc/meninfo # Check the swap space Df-k# Checking Disks Environment required for installing OracleYum install-y binutils compat-db compat-libstdc ++

Some people have discussed whether Transfer can support the dual-master structure. The answer is yes. Here is a brief description. Background Transfer can be used as a tool other than the Master/slave database or act as a server Load balancer. This

When asked about the implementation of group by, I found that there may be misunderstandings. Example Create table 'tb '('C' int (11) default null,'D' int (4) default null,'E' varchar (1000) DEFAULT NULL) ENGINE = InnoDB default charset =

From MySQL5.6, a new parameter innodb_page_size can be set to 8 K and 4 K for Innodb data pages. The default value is 16 K. This parameter must be added to my. cnf at the beginning of initialization. If a table has been created and modified, an

After reading the mongodb authoritative guide, it is more appropriate to use the replica set for read/write splitting, and the general system is enough to use it. It is easy to find. If you do not describe it, you can only describe the key

Execution Plan An execution plan is an action performed by an SQL statement running in Oracle in a certain order. You can use the explain plan for statement to view the execution plan. In the plsql developer tool, you can directly use the explain

1 Definition An executable tool used to analyze Oracle tracking files and generate clearer and more reasonable output results as needed 2 preferences F: \> tkprof Usage: tkprof tracefile outputfile [explain =] [Table=] [Print =] [Insert=] [Sys =]

1. view the Linux host system Character Set echo $ LANG En_US.UTF-8 The second ssh client character encoding is set to default by default, as long as you change to the specified UTF-8 to display Chinese on the terminal. SecureCRT settings: (After

Converts a string to an array in Oracle and returns the array members at the specified position as needed. Create or replace function GetElementFromArrayByIndex (Liststr in varchar2, sPlitVal in varchar2, iPos integer) return varchar2 is/*Liststr --