Database Administrator

Install the Oracle 10gR2 database on the text interface of Fedora 14 (32-bit i686: 1. Create users and user groups[Root @ xinchang ~] # Groupadd-g 502 dba[Root @ xinchang ~] # Groupadd-g 503 running[Root @ xinchang ~] # Groupadd-g 504 asmadmin[Root @

Multiple Oracle databases physically stored in the network can be logically considered as a single large database. Users can access the data in the remote database through the network, the collaborative processing between servers is completely

In Linux, openSUSE 10.0 is used. It is intended to install MySQL and PHP and Apache servers. Follow the prompts on the network to install Mysql first. But after a long time, it just doesn't work. Today, we finally made a breakthrough. After finding

Sys_context 1. terminal: The identifier of the terminal corresponding to the current session customer 2. language: language 3. db_name: Current Database Name 4. nls_date_format: Date Format corresponding to the current session customer 5.

Auto start/stop Oracle Database Under AIX 1: Modify/etc/oratab and change "N" to "Y" to enable auto start. $ Vi/etc/oratab# This file is used by ORACLE utilities. It is created by root. sh# And updated by the Database Configuration Assistant when

1. Install JDKHttp://java.sun.com(1) The downloaded binfile can be directly executed.# Chmod 755 jdk-1.6.0_23-linux-i586.rpm.bin #./Jdk-1.6.0_23-linux-i586.rpm.bin After this step is complete, a file for the jdk-1.6.0_23-linux-i586.rpm is

The CentOS Oracle Installation process has been widely used but is constantly being updated. Here we will introduce how to install and install CentOS oracle to help you install and install CentOS oracle Process Systems. Here we will introduce how to

1. When to consider performance issues. Performance considerations should run through all stages of System Construction: system design, database design, code development, and system O & M. 1. system design phase: System Architecture: Layer 2, Layer 3

MySQL installed in the rpm package in Linux does not install the/etc/my. cnf file, As to why MySQL can be started and used normally without this file, there are two points, The first statement is that my. cnf is only a parameter file during MySQL

The strace in Linux can help us track program system calls. LGWR is an important process in Oracle and is responsible for writing redo logs into online redo logs. Let's try to use strace to peat LGWR behavior. First, find the LGWR process Number:

During Oracle development, various forms of report presentation are often encountered. Some reports cannot be directly written using SQL statements, and must be implemented in concert with SQL, however, the report query speed is slow and is not

Windows 7 flagship edition 64-bit VMware 7 Oracle Linux Release 5 E-Business R12.1.1 Linux x8   In the linux graphic interface, add the dba group and the oracle and applmgr users. These two users are automatically selected during EBS

User Managed Backup & Recovery Diagnostic Collection Note: Log on to SQL * PLUS with SYSDBA permission for executionThe instance must be mounted or OPEN mode.Generate the result file: recovery_diagnostics.out (default location is/tmp) ---------------

When I updated a view, I encountered this error: ORA-01779: could not modify the column corresponding to the non-key save table 01779,000 00, "cannot modify a column which maps to a non key-preserved table"// * Cause: An attempt was made to insert

The current status is dg1 as the master database, and the slave database is dg2.First check the status of the Master/Slave database:Dg1 SQL> select name, database_role, OPEN_MODE, SWITCHOVER_STATUS from v $ database;DATABASE_ROLE OPEN_MODE

Today, when I drop a user, it's time for hang to stop and don't care. After an hour, the result has not been deleted. There are not many objects in this user, and they are not big either, so I checked the alert Log and found the following

Mysql binlog3 formats: row, mixed, and statement. Parsing Mysqlbinlog -- base64-output = DECODE-ROWS-v mysql-bin.000144 | more   -- Base64-output = DECODE-ROWS: displays the SQL changes brought about by row mode. -V: displays SQL statements in

A few days ago, it was accidentally discovered that any OS user could obtain the PG database administrator privilege without a password. This is also a BUG. If DBA is improperly configured, it is not easy to disclose data. You can configure

Lock table read lock If a thread acquires a read lock on a table, the thread and all other threads can only read data from the table and cannot perform any write operations. Lock tables user read; // read the locked table Unlock tables; //

11.1 view fra location SQL> show parameters db_recovery_file_dest NAME TYPE VALUE ----------------------------------------------------------------------------- Db_recovery_file_dest string Db_recovery_file_dest_size big integer 0 Select * from v $