Database Administrator

When tomcat is started, the system prompts that port 8080 is occupied. After searching, the following conclusions are found: If you install other servers that use port 8080, such as Oracle, tomcat, and jboss, on one machine, the port 8080 is

Mysql of the binary version has been compiled. You do not need to perform configure, make install, or other steps. You only need to configure the mysql version and delete it directly;Now we will introduce mysql-5.1.47-linux-i686-glibc23.tar.gz:1. #

The java journey finally arrived at JDBC. Before learning JDBC, I had to review the database. I downloaded the textbooks of Shang xuexiang Oracle on the Internet, and I could only install mysql on my local machine, so I want to create an oracle

Install Oracle 10 Gb in Linux and create a database. After installation, create it manually. Follow these steps to create a database manually: 1: create a directory:/oracle/ora_data/xldb 2: Create a parameter

--. SQL script-- The only note is that f: \ dropobj. SQL is the operated. SQL;-- Your computer does not have a drive F. Replace it with drive D or E.-- Used to delete all objects of the current user-- Use for drop all objects in current user;Set

The Oracle OEM manager displays visualized logs. After we manually clear the files in the archive directory, these records are not cleared from the controlfile, that is, oracle does not know that these files no longer exist! In this case, if we want

Jcq0> show userUSER is "SYS"Jcq0> create tablespace dictionary_t2 datafile 'd: \ Oracle \ ORADATA \ DB_NAMEX \ dict. dbf' size 50 M3 extent management dictionary4 default storage (initial 100 k next 100 k );Create tablespace dictionary_t*ERROR is

There are two methods 1. The installation port is 3306 mysql Tar-zxvf mysql-5.1.44.tar.gz Cd mysql-5.1.44 Create a mysql user group Groupadd mysql Create a user named mysql3306 Useradd-g mysql mysql3306 Compile and install . /Configure -- prefix

Create or replace procedure PD_GENERATE_HELP_LAST_TABLES IS-- Generate a local data table for the view vw_last_xxx generated from sqlserverTabNocount NUMBER;V_ SQL VARCHAR2 (200 ); BEGIN-- Judge the table dat_help_last_scqy1)SELECT count (*) INTO

The Oracle 11g database is installed on RHEL6, and several problems occur on the way. The record is as follows: 1. the kernel settings provided in many documents are based on their memory. You should first know the role of these kernel settings

It's a bit empty. Let's summarize it with the new occi packages. This article is actually very useful, and it is a difficult topic for newcomers, for example, Oracle, unix, c ++, occi, shell, and makefile. Just pick out a noun and you will be able

View all user partition tables and partition policies (level 1 and level 2 partition tables are included ): SELECT p. table_name AS table name, decode (p. partitioning_key_count, 1, 'Primary partition') AS partition type,P. partitioning_type AS

MySQL always reports an error, saying that the sock file does not exist. There are several methods on the Internet to change the permissions and change the configuration file. The. sock file still cannot be generated normally. No way. Delete and

---- Query table space usage --- SELECT UPPER(F. TABLESPACE_NAME)"Tablespace name", D. TOT_GROOTTE_MB"Tablespace size (MB )", D. TOT_GROOTTE_MB-F. TOTAL_BYTES"Used space (M )", TO_CHAR (ROUND (D. TOT_GROOTTE_MB-F. TOTAL_BYTES)/D.

MySQL supports Partitioned Tables from version 5.1.x to the latest version 5.1.56, which is also a stable MySQL version. In addition, MySQL 5.5 supports range columns and list columns partitions. That is to say, non-integer COLUMNS no longer need to

Many people think that it is not practical to view the terminal IP address connected to the Oracle server. If it is only a data server, it is useless. If there is a central server and a distributed server, it will reflect its role. Specific

Phenomenon: Customer GG do extract report error OGG-00053OGG-00053: No extraction maps specifiedCause: There are no TABLE parameters in the Extract parameter file to specifySource tables for which to capture data.Action: Add one or more TABLE

Execute the following configuration process on all nodes in the cluster! Oracle 9.0.1 and 9.2.0.1 use a user space named watchdogd to monitor the background program to monitor the cluster status and restart the RAC node when a fault occurs. Starting

1. Prepare the environment1.1. Software InformationVirtual Machine: VirtualBox 4.2Operating System: Oracle Linux Server release 5.9OCFS2: ocfs2-2.6.18-348.el5-1.4.10-1.el5.x86_64.rpm 1.2. Host Configuration1.2.1. Hosts file[Root @ skynode1 ~] # More/

ORA-03113 error occurs when Oracle database is shut down: SQL> shutdown immediateORA-03113: end-of-file on communication channelProcess ID: 3437The Session ID is 125 Serial number: 5. SQL> startupThe ORA-24324: service handle not initialized.ORA-0104