Database Administrator

Environment:OS: CentOS4.4Oracle: oracle10gr1(the installation software is 10201_database_linux32.zip. It has not been upgraded to R2 and does not affect the following configuration)Primary: 192.168.0.5 (host name RAC1)Standby: 192.168.0.7 (host name

1. What is MySQL?MySQL (pronounced "My Ess Que Ell") is a multi-user, multi-thread SQL database Server developed by Tcx (http://www.tcx.se. MySQL aims to be fast, stable, and easy to use.MySQL can be obtained in this http://www.mysql.net.

1. After sqlplus '/as sysdba'SQL> select username, password from dba_users where username = 'enable ';USERNAME PASSWORD------------------------------------------------------------ENCLE E5406F88BEEF81082. Change the password and log onSQL> alter user

I learned how to install mysql + php + apache2 in freebsd and linux. Version: mysql: 4.0.26 apache: 2.0.59 php: 4.4.2 Freebsd: -- MySQL Pw groupadd mysql Pw useradd mysql-g mysql ./Configure-prefix =/usr/local/mysql Make Make install Chown-R

How to start em and isqlplus of Oracle10g in Linux: Note: $ ORACLE_HOME is the installation path of oracle. 1. Use EM (enterprise Management) 1.1 start EM $ ORACLE_HOME/bin/emctl start dbconsole If the following information appears, it indicates

I. Site Information: Oracle dual-host Hot Standby using RoseHa. The database version is 11.2.0.1.0 (64-bit) and the operating system is 64-bit windows2008. In the company's test environment, you have retained the archived logs for the last month

Two years ago, I would like to sum up that there are many online articles about the causes of database locks caused by deep foreign key indexes, so I will not detail them here. 1. Slow database response. Check that a large number of enq locks exist

The two master and slave mysql database servers are upgraded to hardware. The normal server is shut down. After the hardware upgrade is completed, the server is started. It is found that the master-slave synchronization process is disabled. mysql>

Sybase Contral Center (future name: SAP Contral Center) is a unified Web-based resource management framework. Sybase ASE does not contain SCC. SCC must be downloaded and installed independently. If ASE has a valid license, SCC does not require any

Decompress and install MySQL 5.1.65 in Ubuntu 12.10. 1. Download Http://downloads.mysql.com/archives.php? P = mysql-5.1 & o = linux- Http://downloads.mysql.com/archives/mysql-5.1/mysql-5.1.65-linux-i686-glibc23.tar.gz 2. Decompress Gunzip mysql-

1) In the/etc/oratab file, the file is generated by the root. sh Command executed last when the database is installed. Pwdb:/Oracle/procduct/10.2/db_1/: Y $ ORACLE_SID: $ ORACLE_HOME:   2) Add/etc/rc. local Su-oracle-c 'dbstart' Su-oracle-c

Problem description: After Oracle 11g is installed, the following prompt is displayed when Eclipse is started: Version 1.3.1-01 of the JVM is not suitable for this product. Version 1.4.1 or greater is required. (Version 1.3.1-01 of JVM is not

Permission managementPermission management overviewIn Oracle, user permissions are divided into system permissions and object permissions. System permission: indicates the permission to perform an operation at the database level, such as create

Environment: OS: AIX Version 6.1 Oracle: 10.2.0.5 rac (node rac2) I. Problem Description At, I received a text message, and the database crashed. I immediately connected to the database and found in the log: From the log, the problem is obvious:

Fault recovery for loss of inactive log groupsIf the database loses a non-active log group, because the inactive log group has completed the checkpoint,The database does not suffer data losses. In this case, you only need to re-create the log group

Activity loss or recovery of the Current Log FileOracle ensures that data submitted successfully is not lost through the log file, but in the case of a fault, the user may lose the current log file. this can be divided into two situations: data is

Note: you must first modify the environment variables of Oracle and root users. Vi ~ /. Bash_profle Add the following content: Umask 022 Export ORACLE_BASE =/home/oracle/app Export ORACLE_HOME = $ ORACLE_BASE/oracle/product/11.2.0/dbhome_1 Export

Solemnly declare that BBED is an internal Oracle tool. If this database is not supported once you use oracle, exercise caution. 1. Create bbed (10 Gb test) [Oracle @ rac1 ~] $ Cd $ ORACLE_HOME/rdbms/lib [Oracle @ rac1 lib] $ make-f ins_rdbms.mk BBED

After Oracle 11g r2 is installed and the database is created, start em and report OC4J_DBConsole_source_ora11g not found error. em cannot start. [Oracle @ source ~] $ Emctl start dbconsole Enter the Configuration

. Use the srvctl command to configure the service   In addition to using DBCA graphics, you can also use commands to configure services. This method is especially useful for remote maintenance. Both creation and maintenance use the srvctl command.