Database Administrator

System: openSUSE 12.1 x86_64Database: Oracle 10g r2 (10.0.2.0.4) 64-bit1. Check if the operating system fails:Modify SuSE-release under/etcAll values of 12.1 are modified to 9.0. 2. decompress the cpio.gz FileDecompress the fileMethod 1:Zcat lnx_920_

Step 1: view the Oracle tablespace usage: Select dbf. tablespace_name, Dbf. totalspace "Total (M )", Dbf. Total number of totalblocks as blocks, Dfs. freespace "total remaining amount (M )", Dfs. freeblocks "remaining blocks ", (Dfs.

Oracle Import utility allows you to extract data from a database and write the data to an operating system file. The basic format used by imp: imp [username [/password [@ service]. The following describes common usage of imp. 1. Get help Imp help =

During the 11th holiday, it may not be easy. If the database reports an error and a critical business cannot be properly executed on a certain day, it must be processed immediately. Cause Analysis 1, log on to the database, view the host log, the

PrefaceEvery DBA in the Process of database management should inevitably encounter a variety of errors (ORA-1547, ORA-904, ORA-1578 ......). Some errors are often called "classic errors" by Oracle DBAs due to frequent and complex causes ". The ORA-31

1. view the current database log ModeSQL> select name, log_mode from v $ database; orSQL> archive log list; (This method requires as sysdba) To archive a non-archive database, follow these steps:1. SQL> alter system set log_archive_dest_1 =

After the active data guard is deployed, the read-only query can be handed over to the standby database for execution, and the routine database backup work can be performed on the standby database to relieve the pressure on the primary database,

When a friend encounters a problem today, the following information appears in the alarm log: ORA-1591: lockheldbyin-doubtdistributedtransaction1.92.66874 Query the dba_2pc table and no distributed transaction information is

It has been several months since reids was studied and used. I have summarized a lot of documents and related materials. In the next time, I will share some relevant materials, this article also describes how to use it in our applications. The

1. Redis IntroductionRedis is a key-value storage system. Similar to Memcached, Memcached supports more storage value types, including string, list, set, and zset ). These data types support push/pop, add/remove, Intersection Set and difference set,

1. Create a sequence -- Create sequence Createsequence SEQ_TEST_JOB Minvalue 1 Max value 9999999999999999 Start with 2 Increment by 1 Cache 20; 2. Create a Baotou Createorreplace package PKG_TEST_JOB IS -- Author: ADMINISTRATOR --

How to solve a Java error when installing Oracle 11gR2 on AIX 6.1: Sys-/tools/database>./runInstallerStarting Oracle Universal Installer... Checking Temp space: must be greater than 190 MB. Actual 7005 MB PassedChecking swap space: must be greater

Fault symptom Oracle Database 11g Database common user login prompt ORA-28002: the password will expire within 7 days [11: 01: 00oracle @ dvd db_1] $ sqlplus wang/oracle SQL * Plus: Release 11.2.0.1.0 Production on Fri Nov 16 11:01:23 2012 Copyright

The solution for forgetting the MySQL root Password in Linux is based on Ubuntu 12.04 LTS. Forget the mysql password. The solution found on the internet is recorded here. Edit the mysql configuration file/etc/mysql/my. cnf and add a line "skip-grant-

Fault symptom: In Linux, where all Chinese characters appear in Oracle? Alternative, or directly garbled. Sometimes the error message is garbled. Solution: I. temporary solution Switch to the Oracle user and run [SQL] view plaincopyprint?

Problem: when using an implicit cursor like select into from tablename, if no data is found, an error in the ora-01403 is reported. Each time an explicit cursor is used, it is very troublesome to open the value. An experienced instructor suggested

When the tablespace is expanded in the field, the environment is: solaris 10 cluster 3.2 + Oracle 10g RAC after expansion, execute sqlplus/as sysdba and then query the table space: SQL> select file_name from dba_data_files; The following error

Oracle RAC client failover (failover). When using the TFA method, the client does not need to send a connection request again when the connected instance or node fails, the previous database operations can still be continued, which is called

When the Oracle database is connected to hang, there are two listener, one is the other sub-processThe process is as follows:1. When a problem occurs, the user connects to the hang and two listener occurs. The existing connection is normal.$ Ps-ef |

How to add a node Oracle 10g RAC Add a node The current RAC environment is as follows. You must delete racdb3 first. SQL> select INSTANCE_NAME, HOST_NAME, VERSION, STARTUP_TIME, STATUS, ACTIVE_STATE, INSTANCE_ROLE, DATABASE_STATUS from gv $ INSTANCE;