Database Administrator

I have used Personal Oracle + rj2000 to develop some programs. When I port the program to oracle for nt, I find that some functions are faulty. The study found that the user was not able to connect normally. Because you do not need an alias (alias)

After one day of download yesterday, I finally downloaded the installation disk of Hongqi 5NE. The DOSUTIL folder cannot be found during decompression. As you know, to install Hongqi 5.0, I only need to decompress the DOSUTIL file, run AUTOBOOT in

I. ProblemsWhen using the sqlcmd client tool to connect to data, the following error occurs:C: \> sqlcmdHResult 0x2, level 16, status 1Named pipeline provider: connection to SQL Server cannot be opened [2].Sqlcmd: Error: Microsoft SQL Native Client:

Q: How do I install multiple Mysql instances on Windows?A: The specific method is as follows:1. Install Mysql for Windows normally, for example, in the d: \ mysql folder;2. Configure Mysql as usual;3. Copy the folder installed in the backup, such as

1. Download Oracle Database 10g Release 2 Express Edition for Linux x86Web: http://www.oracle.com/technology/software/products/database/Xe/htdocs/102xelinsoft.htmlDownload oracle-xe-universal_10.2.0.1-1.0_i386.deb2. Run dpkg-I oracle-xe-universal _..

1. log in system as root.2. Hardware requirements: 1 GB memory or above, preferably 2 GB hard disk space or above,/tmp at least MB.3. In addition to the following packages mentioned in the installation documentation:Binutils-2.15.92.0.2-10.EL4Compat-

Decompress mysql4.0.26Root @ www:/db # tar zxvf mysql-4.0.26.tar.gzBack up the data directory of mysql5Root @ www:/db # tar czvf mysql5.data.tar.gz mysql5CompileRoot @ www:/db # cd mysql-4.0.26Root @ www:/db/mysql-4.0.26 #./configure -- prefix

How to install Rose HA in Linux. This document assumes that the environment is a Linux operating system and the Oracle database version 9.2 is used. Next, let's take a look at how to install and configure Rose HA in the Linux Oracle

It took me a morning to debug a program and finally succeeded. Although it was a few simple words, I had some gains in the process ~ I have a lot of feelings. The question is to use JDBC to connect to MYSQL. It would have been okay to use ejbs

This article answers the following question: "How stable is the MySQL server ?", And "can I rely on the MySQL server in this project "? We will try to clarify this type of questions and answer some important questions that may concern many potential

1. Problem: When using the mysql database, when a large number of tables are generated and a large number of records are inserted, the/usr/local/mysql/data directory is generated. Into some log files, such as: localhost-bin.001, localhost-bin.002 ...

This is not about using any programming language to implement this function, but using Shell and MySQL commands in Linux. Java code Echo "use test; select * from test order by id desc; "|/usr/local/mysql/bin/mysql-uXXXX-pXXXX --

RAC creates a DBlink and uses impdp to extract data from the source database. Grant permissions and create dblink [Plain] view plaincopyprint?[Oracle @ zhongwc1 ~] $ Sqlplus/as sysdbaSQL * Plus: Release 11.2.0.3.0 Production on Mon Feb 4 10:26:45 201

Oracle index file migration steps: Preparations:1) Back up GBOS User table indexes: Use plsqlDevelop to export all GBOS User table indexes for backup.  1. view the data files in the index tablespaceSelect file_id, file_name, tablespace_name, bytes/10

This article records some Oracle Table Access Operations For the stored procedure of displaying the execution plan in Oracle, see (1) TABLE ACCESS FULL Scan a table from a full table and access the table through a full table scan. Example: SQL> exec

Import the four. dmp files to the Oracle 10 Gb database. I installed the Oracle 11 GB database on my local machine. If I didn't want to, I would just export the files. Use the import table function in PLSQL Developer to export data. 1. Create a

Oracle Basic Data Structure Articles: Oracle recovery Internal principles http://www.bkjia.com/search.aspx? Where = nkey & keyword = 19824 2.1 Control File The control file contains the status information of all other files in the database. The

Query and unlock lock table records in Oralce First, query the tables that are locked. Select B. owner, B. object_name, a. session_id, a. locked_modeFrom v $ locked_object a, dba_objects BWhere B. object_id = a. object_id; Query the sid and serial

When talking about rman, we need to talk about catalog, that is, restoring the directory. I don't think this stuff is very useful. If the database does not reach the open state, the restoring directory database cannot be connected at all. I

During Oracle learning, we will find that many Oracle knowledge points are in pairs. So, in order to facilitate understanding and memory, I will make a summary of this series. The first part of this series is static or dynamic initialization