Database Administrator

Solution to Oracle dbstart failure Solution to Oracle dbstart failure [Oracle @ CentOS-1 ~] $ DbstartORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net ListenerUsage:/u01/app/oracle/product/12.1.0/dbhome_1/bin/dbstart ORACLE_HOMEModify

Dataguard primary database reported ORA-16146 error Solution Product Version 10.2.0.4Operating System Oracle Solaris on iSCSI (64-bit) 5.10 1. the alert Log is as follows:Master Database alert log---------------------Tue Mar 11 14:30:47 2014LNS:

Configure the sid_name case for the static listener to cause logon failure. Remote logon fails due to the Case sensitivity of SID_NAME during static listening configuration. For Oracle databases, the same name is case-insensitive, indicating

Redis password management 1. How to initialize the redis password? A total of 2 steps: A. There is a parameter in the configuration file: requirepass, which is the parameter for configuring the redis access password. For example, requirepass test123 

Automated installation and deployment of MySQL Anyone who has been using MySQL O & M should be clear that online MySQL usually uses source code compilation, because this allows you to select the function to be compiled based on your own needs,

Oracle OS verification Logon Username and password are our most common security authentication policies and the most common security protection policies we use in various application system software. It is a natural responsibility for Oracle to

Recently a Oracle11g-1_64 has been deployed on a DELL T710_x64 machine in the unit, a lot of information from the Internet, comprehensive installation was successful, the following is the installation steps summary, my machine configuration is as

Installation environment: Ubuntu 10.04-desktop-i386 and PostgreSQL 8.4 Installation steps: 1. Install PostgreSQL Enter the following command Sudo apt-get install postgresql The system prompts you to install the required disk space. Enter "y". The

The two highly lethal commands compiled today can instantly kill Oracle. Next I will give a simple comment and demonstrate its power.$ Ps-ef | grep $ ORACLE_SID | grep-v grep | awk '{print $2}' | xargskill-9$ Ipcs-m | grep oracle | awk '{print $2}' |

Build an Oracle10G (6) dbca database for RAC under AIX, and oracle10gdbca Establish a series of RAC instances under AIX Build an Oracle10G (6) dbca database with RAC under AIX Environment Node Node 1 Node 2 Small Machine

MySQL: on duplicate key update usage, mysqlduplicateYou can use this syntax to determine whether a record exists when inserting a record. If the record does not exist, insert the record. Otherwise, the record is updated, which is convenient and

Detailed process of restarting the Oracle 11G worker uard production environment, 11 gworker uardScenario: restart the database, do not restart the linux system, so you do not need to consider listening programs,# Linux input lsnrctl start1. Close

 Add and Update price list lines-- Purpose: to add row information based on the existing price list Header-- Restriction: this api has some problems. If the header information is forcibly added, there will be many problems. Therefore, this example

8. View the Exhibit and examine the structure of the MERs table.Which two tasks wowould require subqueries or joins to be executed in a single statement? (Choose two .) (Question: A MERs table is provided for the question, asking which two tasks

View background When I first started charging the data center, the master said that they should use the view, storage process, and trigger. I didn't feel much at the time, I don't know when to use it, and where to use it. Just a few days ago, when I

DataGridViewControls are highly configurable and scalable. It provides a large number of attributes, methods, and events that can be used to customize the appearance and behavior of the control. The following example shows how to add, delete, modify,

1. Tomcat startup error: Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'memcachedClient' defined in file [/usr/local/apache-tomcat-6.0.37_6500/webapps/trade_service/WEB-INF/classes/META-INF/spring/

Reprinted please indicate the source http://blog.csdn.net/guoyjoe/article/details/30965303 The experiment steps are as follows: 1. Use rman to back up the entire database Recovery Manager: Release 11.2.0.3.0 - Production on Sun Jun 8 15:30:35

In such a scenario, after multiple agent Systems (each with their own database) perform their own operations, complex operations will be triggered for the stored procedures of their respective databases, after each operation is complete, you need to

Write the master-slave monitoring plug-in:#! /Bin/bashMYSQL = "/usr/local/mysql/bin/mysql-uslave-pslave12345-h127.0.0.1-P"VAR_LOG =/tmp/check_mysql_status.log. $2 &> $ VAR_LOGFunction usage (){Cat 'Basename $ 0' need at least value: 'basename $