Database Administrator

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

Oh, when you create a stored procedure, you can directly create it in the form of "create or replace procedure stored procedure name" without any problems, in the past two days, I tried the inventory package in the project. During the storage

1. The insert format is. /** * Write a time Method */ Public staticStringgetStringDate (){ Date d = new Date (); SimpleDateFormat sdf = new SimpleDateFormat ("yyyy-MM-dd "); Return sdf. format (d ); } Insert: Art. setArtAddTime (java. SQL. Date.

Single-instance Environment Vmware Server 1.0.6 + CentOS 5.2 + Oracle 10g 1. Stop the process 2. Install patches 3. Upgrade the database 1> stop all Oracle-related processes [Oracle @ node2 Disk1] $ emctl stop dbconsole [Oracle @ node2 Disk1] $

In Oracle databases, undo has three major functions: providing Consistent Read, Rollback Transaction, and Instance Recovery ).Consistent Read is relative to Dirty Read. Assume that a table T contains 10000 records. It takes 15 minutes to obtain all

# Oracle environment variables defined# (Write it below and hide it here) # Database User InformationUSERNAME = database USERNAME (Information Hiding)PASSWORD = Database PASSWORD (Information Hiding) # Back fileFILE_PREFIX = Oracle _ # FTP Server

Today, we need to uninstall Oracle 10.2.01 in the lab room, and then install Oracle 10.1.03. It took a long time to unmount the database because of lack of experience. At last, we had a great sense of accomplishment. Log on to the system as the

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

An exception is an exception that has been defined in pl/SQL and given the Exception name. They are all placed in the standard package that comes with pl/SQL, so that pl/SQL programmers do not need to define them again. There are 21 predefined

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

One of the daily work of the system administrator is to upgrade the service, add a patch for the service or upgrade some fancy functions. In early 2013, the latest MySQL 5.6 was released with the goal of providing better performance and scalability.

This error is different from most of the answers on the Internet. The error is not a 32-bit rpm package. It was reported that a single line was commented out when the vipca was modified and read the vipca code, ah   Do not comment out the line arch =

1. Create a table with an empty eygle 2. Create a user's eygle, which belongs to the eygle tablespace; grant the user the DBA permission 3. log on to the database as an egyle user and create the table test_egyle. 4. rman backup the egyle

Environment variable Oracle_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name. In fact, it is the problem of em to reconfigure emca. Pay attention to setting ORACLE_UNQNAME before. Summary: 1. Modify the DBSNMP password: To

The experiment is divided into two steps:1. LMT local management of tablespaces, ASSM automatic segment management when the data file structure analysis Oracle 11G: 0 operating system block, 1-2 is the file header, 3-127 is the bitmap information.

System Environment: Oracle Linux 5.5 x64 bit; Oracle version: Install Cluster and OracleSoft 10.2.0.1 (do not create instances), and upgrade Cluster and OracleSoft to 10.2.0.4; When dbca is used to create a database, the database stops at 88% and an

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)

After establishing RAC on a virtual machine a few days ago, I tried to test the two functions of Oracle TAF (transparent application failover) and Server Load balancer. 1. Server Load balancer First, edit the tnsnames. ora file on the server and

A foreground SQL statement is simplified as follows:SELECT products_name, products_viewed FROM 'products _ description'Order by products_viewed DESC, products_name LIMIT 0, 20; This statement often appears in large batches in slow logs! A

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.