Database Administrator

Scenario: The customer said that the OEM was suddenly unavailable. Because the application is linked to some OEM pages, it must be restored immediately. Symptom: Log on to the client server and execute the emctl status dbconsole. An error is

I. Site Information: Oracle dual-host Hot Standby using RoseHa. The database version is 11.2.0.1.0 (64-bit) and the operating system is 64-bit windows2008. In the company's test environment, you have retained the archived logs for the last month

Two years ago, I would like to sum up that there are many online articles about the causes of database locks caused by deep foreign key indexes, so I will not detail them here. 1. Slow database response. Check that a large number of enq locks exist

1. Oracle cannot be started because of reduced memory Last login: Sun Nov 4 15:09:06 2012 from 192.168.5.222[Oracle @ h1 ~] $ Sqlplus "/as SYSDBA" SQL * Plus: Release 11.2.0.1.0 Production on Sun Nov 4 15:26:59 2012 Copyright (c) 1982,200 9, Oracle.

This error occurs ORA-01861: literal does not match format string Statement is Between 'time1' and 'time2' The query result is: ORA-01861: Text and format strings do not match Solution To_date ('time1', 'yyyy-mm-dd hh24: mi: ss ') Or You can

The "SQL" Mark written in the implicit cursor. For example, SQL % ROWCOUNT indicates that the implicit cursor has several rows of records. The explicit cursor is customized by the developer, you can also use C1 % ROWCOUNT to indicate the number of

1. Use the create or replace view command to create a view Syntax format: Create or replace view name As select query clause Example: Create or replace view tb_user_view1 as select count (username) shuliang, username from tb_user group by username

System Environment: Database: Oracle 11.2.0.3 (64-bit linux) ArcSDE: ArcSDE9.3.1 sp2 (Build 4000) First, use dbca to create an oracle database instance (AA) Then, use ArcSDE9.3.1 sp2 post oracle 11.2.0.3 to create and configure sde user

Slave processes is the background process that represents the execution of other processes.  I/O Slave Processes I/O slave processes (Innn) simulate asynchronous I/O for systems and devices that do not support it. in asynchronous I/O, there is no

CentOS 6.2 is already installed with mysql 5.1. However, CentOS 5.1 does not support the utf8mb4 character set (For details, refer to:). You can only upgrade Mysql to 5.5. This is indeed a painful upgrade process. Complete steps: 1. First, back up

When reading some posts online. Someone found that the mechanism for organizing and managing database file storage in Sqlite is B-tree. I think this is not rigorous. So I turned out the definitive guide to sqlite SECOND EDITON. After review, I would

Decompress and install MySQL 5.1.65 in Ubuntu 12.10. 1. Download Http://downloads.mysql.com/archives.php? P = mysql-5.1 & o = linux- Http://downloads.mysql.com/archives/mysql-5.1/mysql-5.1.65-linux-i686-glibc23.tar.gz 2. Decompress Gunzip mysql-

The main problems encountered during Oracle 11gR2 installation are: 1. After the system parameters are set, the data set in the condition detection process during database installation is completely different from that detected by the installer,

I tried to install Oracle 11g R2 under CenOS s5.5 in VMware. I thought it was simple, but I found many problems. Installation steps: 1. check the corresponding rpm package It doesn't matter if the check is complete. It will check the installation of

MySQL multi-Table update can be written in several different ways. Assume that we have two tables. One Table stores Product information for the Product table, with the Product Price column Price. The other table is the ProductPrice table, update the

Problem description: After Oracle 11g is installed, the following prompt is displayed when Eclipse is started: Version 1.3.1-01 of the JVM is not suitable for this product. Version 1.4.1 or greater is required. (Version 1.3.1-01 of JVM is not

The following issues suddenly occurred when logging on to Oracle:ORA-00257: archiver error. Connect internal only, until freed. If you are confused, it may be caused by insufficient space for archiving logs.Log On As A sysdba User:Query the space

1. download the latest MongoDB version 2.2.2 from the official website. Click the mongodb download link, or open the terminal and enter a command such 2. After the download is complete, find the directory where the downloaded file is stored and

Operating system version: 64-bit Linux Database Version: Any Version Problem description An error is reported when the database is started after the database parameters are modified. SQL> startup nomount ORA-27102: out of memory Linux-x86_64

1. Create two external files in 1.txt and 2.txt with only one data. 2. Create a logical directory and perform proper authorization: SQL> create directory ztj1_dir as 'C: \ ztj1 \'; Directory created Then, manually create the actual directory in the