Database Administrator

Oracle 11.2.0.4 alert started by db instance of a single instance Oracle 11.2.0.4 alert started by db instance of a single instance Fri Jan 09 03:11:17 2015DIAG started with pid = 19, OS id = 6031Dumping diagnostic data in directory = [cdmp_201501090

Size of SGA during Oracle 10 Gb startup The size of the SGA started in Oracle 10g Database is determined by sga_target and sga_max_size. The following three cases are discussed: Sga_target = sga_max_size Parameter file

MongoDB cluster in Linux-replica set Environment Construction MongoDB replica sets are suitable for scenarios with fewer writes and more reads. You can use message queues for write control to reduce the pressure on highly concurrent writes. The

Oracle problems with number type conversion to_char Oracle problems with number type conversion to_char Select to_char (0.1) nums from dual; It is observed that if the integer of a decimal number is 0 and the preceding 0 is not displayed after

Analysis Steps for slow OGG rep running Analysis Steps for slow OGG rep running: 1. Perform ps-ef | grep according to the rep process name to obtain the rep process PID. [Oracle @ hosta ~] $ Ps-ef | grep repfullOracle 27906 27861 0 pts/7 S + \ _

Restoration Method for Oracle 10g Clusterware Votedisk corruption Votedisk is very important for RAC (10g Clusterware, 11g GI). We call it an arbitration disk, when a node in the RAC cluster fails and the network is disconnected, it determines

Install MySQL Enterprise Monitor MySQL Enterprise Monitor is an Enterprise-level monitoring designed specifically for MySQL databases. It can be well integrated with various MySQL features, including: mySQL's key performance indicators, hosts, disks,

TNS-01251: Cannot set trace/log directory under ADR 11204 RAC environment error TNS-01251: Cannot set trace/log directory under ADR LSNRCTL> set current_listener listenerCurrent Listener is listenerLSNRCTL> set current_listener listenerCurrent

Oracle login Method 1. There are two ways to manage Oracle login authentication:1. Operating System Authentication2. Password AuthenticationIi. Overview and implementation of operating system authentication1. Warm up a small experimentSQL> -- first,

An exception is thrown when the default MySQL query time is used.The problem occurs when a mysql table is created, with a field of the Date type in the table. The default value is 0000-00-00 00:00:00. PrepareStatement is used for query, and the

Install mysql in linux and mysql in linux 1. Download mysql. Here I advocate binary installation. Use winSCP to transmit the downloaded mysql to the linux Server 2. decompress the downloaded mysql package #tar -zxvf /{MySQL5.6_path}/mysql-{version}.

Oracle date operations, oracle date1. Obtain the last day of a month. SELECT TO_CHAR(LAST_DAY(TO_DATE('20140125', 'yyyymmdd')), 'yyyymmdd') LASTDAY FROM DUAL 2. Obtain the last day of the last month: select to_char(add_months(last_day(to_date('2008-

Oracle cursor introduction, Oracle cursor IntroductionOracle cursor Introduction The PL/SQL cursor in Oracle stores the data queried in the database in the memory as a temporary table. The cursor can operate on the data stored in the memory, one or

Oracle memory problems In Oracle, the memory structure mainly includes two categories: SGA and PGA. SGA represents the system global zone, and PGA represents the program global zone. Oracle memory mainly stores the execution program code (PL/SQL,

Trigger creation traps The creation of Oracle triggers differs from the creation of stored procedures, functions, and packages. Trap 1: The current schema is inconsistent with the trigger owner. For example: The current login schema is R5_T150, and

How to start MongoDB as a windows Service, mongodbwindows Service MongoDB is used in recent projects. It is very troublesome to run commands in cmd every time you start the system. Although these commands can be written as bat scripts, this window

Oracle reported error when importing imp data: ORA-12592: TNS: Package error, ora-12592tns Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you

Modify the default encoding in MySQL Linux. The younger brother recorded the modification of the default MySQL encoding here, and changed the default encoding to utf8. I hope this article will help you. Thank you! Environment: Linux: centeros 6.6

Set up VNC Remote Desktop Connection in Linux to install Oracle11G and vncoracle11gPreface:To install oracle in linux, you need to start the swing interface of java. Therefore, the x-window is required. Therefore, it is difficult to directly go to

Common timensten maintenance operations and timensten Maintenance **************************************** ********************************* * ************ --- 1. keep it in the memory ttAdmin-ramPolicy always ttwind --- 2. load the application to