Database Administrator

Developed and used TOMCAT version 5.0.28MYSQL database mysql-5.0.22 for Development and UseMYSQL database development tool Navicat_MySQLJDK1.4 Basic work: 1. Configure the environment variable JDK environment variable: JAVA_HOMETOMCAT environment

Installation package required for CentOS * GNOME Desktop Environment * Editors * Graphical Internet * Text-based Internet * Development Libraries * Development Tools * Legacy Software Development * Server Configuration Tools * Administration Tools *

Install mysql5.1 using rpm in CentOS/Linux First, we need to download the 64-bit Linux, so the 64-bit version is downloaded, and the following three files are required: 64bit

When using the SQL statement generated by powerdesigner to create a table, I do not know how to add a space in the table name. I did not care to directly run it in PL/SQL, it is difficult to use the statement or right-click to delete the file. When

1. maintain_mode Parameter Golbal or transportable tablepsaces is recommended. When this parameter is set to global, streams is used for full-database replication; otherwise, streams is used for table space replication, you must specify one or more

To install MySQL in Ubuntu, run the following command at a terminal prompt: Sudo apt-get install mysql-server Sudo apt-get install mysql-client Sudo apt-get install php5-mysql // The installation php5-mysql is to connect php to mysql Once the

MySQL service basics: MySQL is an open-source relational database server software. It is currently developed and maintained by Oracle. MySQL features multiple threads and users. It is based on the C/S (Client/Server) architecture. It is easy to

After receiving the phone number from the O & M personnel, the number of connections to the mysql server is full. log on to the server and check that it is full. Well, first increase the number of connections to 2500 to provide external services

Recently, Oracle data migration was conducted. There was an article about migration ideas. Here we will continue the specific test. The topic is about table space transmission. Oracle transfer tablespace Upgrade Oracle 9i to 10 Gb using a writable

(I) HugePages Introduction HugePages is introduced by kernel 2.6 to adapt to the increasing physical memory size. In Linux, the default page size is 4 K. If HugePages is used, the default page size is 2 M. Let's look at two more terms: Page table

This article uses the migration method to migrate and upgrade the database from 10 Gb to 11 GB. Recommended reading: Clone an Oracle EBS Database User-managed database clone RMAN-based database cloning on the same machine RMAN duplicate Database I.

PHP is recommended to operate Oracle databases by using the OCI8 extension. The method for enabling PHP OCI8 extension on the internet is roughly as follows: (1) Remove the comments of extension = php_oci8.dll in php. ini (first use phpinfo to check

I. Logical Standby preparation 1. Check whether the operation objects and statements are supported by logical Standby. Because logical Standby maintains synchronization with the Primary database through SQL applications. There is a big difference

Step 1: query the table id from the data dictionary View Select object_id from all_objects where owner = 'sunard' and object_name = 'tbl _ WDC_INF '; Step 2: Identify the order of all fields in the table by id Select obj #, col #, name from sys.

1. Basic data type Character TypeChar can be up to 2000 characters in lengthExample: char (10) 'database' stores 'database' with the first six characters, followed by 4 spaces.Varchar2 () is a string of up to 4000 characters.Char queries are fast

Oracle 10g connection error: ORA-12514: TNS: The Listener currently cannot recognize requests in the connection Descriptor Solution:1. Open the /network/admin/listener. ora file and find:SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME =

There are four types of Oracle index scans based on different index types and where restrictions: 3, 4, which can be normalized.(1) unique index scan (index uniquescan)(2) index range scan)(3) full index scan)(4) index fast full scan)(5) index skip

1. Mysql Database Installation Introduction: Mysql is a platform-independent open-source database that can be built on Windows, Linux, Unix, and other platforms. This article mainly explains how to install Mysql databases on the Linux platform,

The following problem occurs during spfile creation or nomount: SQL> create spfile from pfile;Create spfile from pfile*ERROR at line 1:ORA-01078: failure in processing system parametersLRM-00123: invalid character 158 found in the input file

I recently used LogMiner to mine logs on Oracle 10 Gb. I did not intend to create table test as select * from v $ logmnr_contents. I found that there are actually records, but the recorded content cannot be parsed, the info field reports In Memory