Database Administrator

BUG 3028673 -- Oracle on aix does not share your const structs-PER PROCESS MEMORY OVERHEAD Oracle on ibm aix platforms (AIX 5L and 4.3.3) use a large amount of memory per dedicated connection. for Oracle 9.2 on AIX 5L the memory required per idle

1. Download The Oracle_database_10.2.0.1.0 for linux Installer:: Oracle official website (pay attention to the version number of the Installation File) 2. query the kernel version and required software packages to prepare the software environment

To install Oracle 11g in Ubuntu 10.04, follow these steps:1. Install JDK. For the installation method, see setting up a sun java Development Environment under Ubuntu 10.04.To solve Chinese garbled characters, create the "fallback" directory in the

The MySoft_Data test of ORM is successful. It should be very useful. Model. e_cate c = new Model. e_cate ();C. fid = 1;C. name = "1 ";C. tmpid = "2222 "; DbSession session = new DbSession (new MySoft. data. mySql. mySqlProvider ("Server =

In the case of php5.3, The dblib driver of pdo cannot connect to mssql. According to the official description, 5.2 has modified this bug, but 5.3 does not. You can use the mssql function that comes with php. Compile freetds, php_mssql, and pdo_dblib

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

One thing that should have been simple and smooth, but encountered a lot of trouble in the actual process. For a new linux user, it is very easy to get stuck, so simply write it down, in this way, we can make progress every day! There is a

The ROWID (also called restricted Rowid) below Oracle 8 is: FFFF. BBBBBBBB. RRRR occupies 6 bytes (10bit file # + 22bit + 16bit). However, to expand the data file, change the Rowid to OOOOOOFFFBBBBBBRRR, occupies 10 bytes (32bit + 10bit rfile # +

I. Log transmission problems 1. Generally, use the following statement to check whether the sequence of the archive logs of the primary database and standby database is the same. Run the following command in the primary database: SQL> alter system

Due to a problem with the stability of Fedora 14 in my current version, I decided to change it to Ubuntu 10.10, just because I had used this version for a while and felt that it was superior in performance, stability is also good (for Linux, you can

Create a virtual service cluster for the user. Install liunx RedHat 4.3 32-bit + Oracle 10G in the vmware 5.3 bar virtual machine. Unfortunately, a client address conflicts with linux, and the database cannot be accessed after running for a while

After sorting out "Oracle database provides several different database startup and shutdown methods", I wrote an example when I went back. One problem occurs: ORA-12528: TNS: listener: all appropriate instances are blocking new connections So I went

ORA-600 [6947]/ORA-600 [kdsgrp1] Processing SQL> select * from v $ version; BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64biPL/SQL Release 10.2.0.1.0-ProductionCORE 1

Sequence: sequence creation method and use when inserting data; -- Sequence CreationCreate sequence sqIncrement by 1Start with 1Maxvalue 10Minvalue 1CycleCache 5 -- General (a sequence can be used in multiple tables, but generally, a table

Error 1: [INS-06101] IP address of localhost cocould not be determinedFigure: Solution: Because your host name and IP address are different, you can match the host name in the/etc/hosts file.Vim/etc/hostsIP address Host NameError 2: at Oracle.

Authorize scott to enable the execution plan. The script is as follows:[Oracle @ rac1 admin] $ sqlplus/as sysdbaSQL * Plus: Release 10.2.0.5.0-Production on Sat Oct 12 02:02:28 2013Copyright (c) 1982,201 0, Oracle. All Rights

Follow Finally, the Oracle installation is complete: Check the dependency package before installation: Rpm-q gcc make binutils setarch compat-db compat-gcc-c ++ compat-libstdc ++-devel unixODBC-devel libaio-devel sysstat There are missing yum

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

When you look at the histogram of a field, you cannot see the values of high and low values. You need to convert the values as follows. SQL> SELECT column_name,Num_distinct n_d,Low_value o_low_value,Display_raw (low_value, data_type)

Purpose: control whether the log Transmission Service asynchronously or synchronously writes log data to the disk. Affrem: Before the log writing process is in progress, the archive log and the slave database log must be synchronized and written.