Database Administrator

Unable to connect database ORA-01034 & ORA-27101 with connection string The operating system is linux as5 and the database is 10 Gb. After the machine is restarted, @ connecct_string cannot be used to connect to the database. You can only use the

Problems and Solutions of impdp ORA-39002, ORA-39166 and ORA-39164 During performance tests on imp and impdp, we found that if the table contains a lob field, loading is really slow, and there are about 1000 entries per second. At this speed,

The RedHat Enterprise Linux 5 installation was successful, but many errors occurred while installing Oracle. The official Oracle 10g version website is here. You do not need to register for downloading with thunder. You need to register for IE

In CentOS, how does one completely uninstall MySQL? Solve the problem that the uninstallation is not clean, centosmysql In CentOS, how does one completely uninstall MySQL? Solve the Problem of uninstallation being unclean System: CentOS 6.5, MySQL:

Pentaho Report Designer getting started tutorial (1), pentahodesigner PentahoReport Designer getting started Pentaho Report Designer5.1 is the latest version. I. Installation and introduction This section describes how to install jdk, configure java

How to uninstall the "hidden oracle" software installed after an error is reported, and the hidden oracle **************************************** ******************************** ************** Original Works are from the blog of "Deep Blue blog".

Oracle learning-literacy: oracle literacy Preface   I have been dealing with Oracle databases over the past few days. Since I have not learned much about Oracle before, I just used Oracle as a data source. I don't know much about it. For example,

Mybatis type conversion when using generator to automatically generate code, mybatisgenerator Use the generator of mybatis to automatically generate code, but in the oracle database, number (6, 2) is always automatically converted to BigDecimal, and

Sqlite Study Notes 1: Compile the database and sqlite Study Notes First, I am using a Linux environment. 1. Download source code Download from the official website: click here Second compilation 1. Decompress After the download is complete, it is

Inaccurate MySQL execution plan-Overview, mysql execution plan The execution plan for the Mao MySQL optimizer is often inaccurate, but not optimal (cpu + io )??? Too many factors :: The information of information_schema is regularly refreshed. In

9-non-connection mode of ADO. NET, DataSet in memory, DataTable --- ShinePans, DataSet is called a DataSet. It can be compared to a database in memory. DataSet is ADO. NET core, supports ADO.. NET disconnected. The core object of the distributed

How to quickly find and download the asm package on the OTN website? How to quickly find and download the asm package on the OTN website **************************************** ******************************** ****************  Original works,

Use python to batch import data to Redis, and use pythonredis to import data1. Batch import data using pipeline Class Redis_Handler (Handler): def connect (self): # print self. host, self. port, self. tableself. conn = Connection (self. host, self.

Mongodb mapreduce usage summary, mongodbmapreduce This article is from my blog: mongodb mapreduce usage Summary  As we all know, mongodb is a non-relational database. That is to say, each table in the mongodb database exists independently and

Install MySQL and Navicat, and connect to MyEclipse, navicatmyeclipse 1. Download and install MySQL 1) Go to http://dev.mysql.com/downloads/download the mysqlcommunity edition serverand the ororused for jdbc. You can install MySQL by default.

Blocking blocked and racblocked in RAC Environment The blocking in the RAC environment is different from that in a single instance, because we need to consider the session in different instances. That is to say, the corresponding strain of the

Oracle Optimization-double-edged sword and oracle optimization double-edged sword Oracle optimization is a double-edged sword. Pay special attention to the use of this sword:OLTP or OLAP Optimization 1: Index During DML operations, indexes must be

Background:On the local machine (Win7 64-bit flagship Edition) Install the Oracle 11g Client32-bit ORACLE clientIf the 64-bit ORACLE client is installed, you cannot enter the sqlplus/nolog command in the CMD command, that is, the command cannot be

Example of an external data experiment (6)Verify whether the agent startup sequence affects the capture update operation. Next to the external data experiment series: "Example of the external data experiment (5) modify the column value on the

A developer encountered an error: ORA-01795: the maximum number of expressions in the list is 1000 Statement is a select xxx from xxx where xxx in (xx, xx ,.....); Let's take a look at the error: 01795,000 00, "maximum number of expressions in a