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

Requirements: 1. Create chinache_0726 (chinacache _ date) in the test database every day ); 2. process the log file 13039_20100722_w3c according to the table structure and insert the result to the created table; The awk function is not just a simple

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

The installation of python-mysqldb in CentOS took three hours. The strange problem was that python setup. py build had a lot of garbled characters. If you see a friend on the Internet who has encountered the same problem, post it and share it with

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

Installation environment: RedHat es 5.5 64-bit, 8 GB system memory, 10 Gb swap, Oracle 11G R2 Standard Edition 1. Preparations before Oracle InstallationCheck the packages and install them all:Binutils-2.17.50.0.6Compat-libstdc

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 #

I. Preparations Note: because it is installed on a server that already exists and has been used by multiple parties, you must first confirm whether Mysql has been installed on this Linux server. 1. When groupadd mysql, the system prompts that mysql

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

First of all, this is the default MySQL character set () In Ubuntu. It is garbled question mark when entering Chinese Characters in Java to the database. MySQL does not recognize it because the default Character Set of MySQL is latin1 (ISO_8859_1)

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

Error message: ORA-06531: Reference to uninitialized collection Error SQL code: DeclareTYPE t_student_var is table of VARCHAR2 (100 );V_tbl_name t_student_var;BeginSelect name into v_tbl_name (1) from t_student where gid = 1;Select name into

RROR:A ORA-01034: Oracle not availableORA-27101: shared memory realm does not existLinux-x86_64 Error: 2: No such file or directoryProcess ID: 0Session ID: 0 Serial number: 0 I encountered a problem. I have been tossing for more than half an hour

If the data is too large, we cannot directly assign values to the clob variable. In this case, we can use the dbms_lob.read and dbms_lob.write methods to read and write clob variables in stages. However, we should set up a cache for the clob

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

Host OS: Win7 Virtual Machine: Virtual Box 4.3.6 Virtual Machine OS: Oracle Linux 5.1 _ x86_64 Database software: Oracle 10G 10.2.0.1 _ x86_64 Cluster software: 10201_clusterware_linux_x86_64.cpio.gz Database Upgrade Patch Set: 10.2.0.5.0 Linux x86-6

The undo segment is in the manual management mode because the undo segment management mode is modified during the experiment. 1. view the undo segment statusSQL> col segment_name for a20SQL> col owner for a10SQL> col tablespace_name for a20SQL> col

Install Oracle 10g technical documents in CentOS Step 1: run the following command as the root user to create a user, group, and set the password. /Usr/sbin/groupadd oinstall /Usr/sbin/groupadd dba /Usr/sbin/useradd-m-g oinstall-G dba oracle Id

Clear Shared pool: Alter system flush shared_pool; However, to clear the entire memory, we had to shut down the instances and databases in the entire Oracle RAC environment and restart them. You can clear the buffer cache: Alter system flush