Database Administrator

Abstract: This article describes how to install the Oracle Apex 4.0 on Oracle 10g and how to install the Language Pack. I. Environment Oracle 10g 10.2.0.4Apex 4.0.1Apex Listener 1.0.2Window 2003JDK 6 update22J2EE 6GlassfishV3 3.0.1Install the

The installation documents for a single Oracle instance are everywhere on the Internet, and there are also some good articles. In fact, the best installation documentation for oracle is the online manual, but the installation steps of the manual are

(1) srvctl status database-d dbservername Oracle @ zjgldb2 $ srvctl status database-d kms Instance kms1 is running on node zjgldb1 Instance kms2 is running on node zjgldb2 (2) crs_stat-t Oracle @ zjgldb2 $ crs_stat-t Name Type Target status host ----

This article focuses on the combination of two MySQL commands. It will create a new data table with the same structure and data based on the original data table. This helps you quickly copy tables as test data during development without having to

How to restart the MySQL Service RedHat Linux (Fedora Core/Cent OS) 1. start:/etc/init. d/mysqld start2. stop:/etc/init. d/mysqld stop3. restart:/etc/init. d/mysqld restartDebian/Ubuntu Linux1. start:/etc/init. d/mysql start2. stop:/etc/init.

By default, Oracle sqlplus cannot start the execution of analysis plans and statistics execution efficiency. To start the following functions, you only need to take a few steps: 1. log on to the system using the sysdba role of the sys user. 2:

Test an Android program that reads an sqlite database mydb. After I perform the following operations, the getWritableDatabase method of SQLiteOpenHelper has an exception.1. backed up this database in adb shell: mv mydb mydb_bak2. Restore the

Oracle 10 Gb does not support RedHat AS5 by default, but it can also be installed. The following is a simple record of the installation process: Install Linux and package GCC and other development classes to reduce the environment configuration

Required packages: Php5-mysql # php can contact the database after installation Php5-common Php5-cli # Need to execute php script Mysql-server Start installation: Download the latest mysar package Tar zxvf mysar-2.0.6.tar.gz-C/usr/local #

The Linux server uses the system crontab to regularly execute Backup files and save the backup results by date to achieve the backup purpose. 1. Create the path to save the backup file/mysqldata # Mkdir/mysqldata 2. Create the/usr/sbin/bakmysql

This example is created based on ASMLib or a bare device. 1. Install the support packages required by asmA. Download the support package from the Oracle Website: hereB. Download the corresponding asm installation package based on the Linux

The following describes how to organize scripts on the Internet and make improvements based on actual conditions. #! /Bin/sh Usage = "$0-hlocalhost-uroot-pxxxx-P3306"Dbhost = "localhost"Dbuser = ""Dbpass = ""Dbport = 3306 For varin in $ *; doIf [$

The lpad function is an Oracle database function. the lpad function fills the string with the specified characters on the left. It can be understood from its literal meaning that l is short for left, pad is the meaning of fill, so lpad is the

Every time the server administrator notifies that a file occupies too much hard disk space, it is estimated that the tablespace of the Oracle database has become larger. There is no way. You need to be aware of the number of tablespaces currently

How to handle HANG Databases 1. Generate systemstate dump:SQL> sqlplus-prelim/as sysdbaSQL> alter session set max_dump_file_size = unlimited;SQL> alter session set events 'immediate trace name systemstate level 10 ';Wait for some 30 secondsSQL>

Since Oracle9i, Oracle is no longer simply a relational database management system. It adds a series of object-oriented features based on the relational database model. Oracle9i is known as object-oriented database. Oracle's object system complies

Idle> startupThe Oracle routine has been started. Total System Global Area 3407261696 bytesFixed Size 2180504 bytesVariable Size 2348812904 bytesDatabase Buffers 1040187392 bytesRedo Buffers 16080896 bytesThe database has been loaded.ORA-03113: End

Stream is an extended application of Oracle Message Queue (also called OracleAdvanced Queue) technology. Oracle Message Queue solves event management through publishing/subscription. Stream replication is only based on its data sharing technology.

I. Oracle PL/SQL usage1. User ManagementDatabase System permission (DataBaseSystem Privilege) Database Object permission (DataBaseSystem Privilege) Oracle internal users Sys and System Create user: create user user_test identified by

Currently, LAMP and LNMP are two popular open-source Linux Web Services. Known as free and efficient, it is the preferred server architecture for many websites and Web systems. Business data is often a valuable resource. The damage and loss of