Database Administrator

Latch indicates the locking mechanism that occurs when processing data between running processes of the Oracle database. Lock, which indicates the differential locking mechanism when concurrency occurs between specific objects in the oracle

Two days ago, when I returned to Beijing, I encountered a problem at work: the company has an Oracle project in Shenzhen, and the Oracle database cannot be connected after a system restart. The project developer asked me for help. I want to read

Speaking of this problem, I am very ashamed. It was in my previous article "Configuring IP address () in Ubuntu7.10" that solved step 2's problem, this causes the problem that mysql cannot be logged on or cannot be installed again. I apologize to

1. Modify the Oracle system configuration file/etc/oratab/Etc/oratab format: SID: ORACLE_HOME: AUTOSet the AUTO domain to Y (uppercase). Only in this way can dbstart and dbshut of oracle be used. Mine is:Ora9i:/home/oracle/ora/products/9.2.0: Y2.

To build a java web development environment on the latest Ubuntu8.04 and install myeclipse, I will not repeat the specific installation methods of the two eclipse software, because there are many online applications. For eclipse and myeclipse, it is

The source code of mysql. the serial number is mysql-5.0.20a.tar.gz. Of course, the other code can be used only for testing. Red Hat Linux as 4 is used for Linux. Installation steps: 1.decompress mysql-5.0.20a.tar.gz. Command: tar-zxvf Mysql-5.0.20a.

The following illustration describes how to install PostgreSQL8.3 In Ubuntu. First download postgresql-8.3.3-2-linux.binRoot @ bai-desktop:/home/bai/liuy # lsPostgresql-8.3.3-2-linux.binRoot @ bai-desktop:/home/bai/liuy # chmod u + x postgresql-8.3.3

The installation of Oracle-xe in Ubuntu 8.04 for the first time was quite smooth. Only the error "/etc/sysconfig/oracle-xe" does not exist at the end, but it can be used. You can also enter the WEB management interface. I downloaded the deb package

In Linux, the following error is reported when you enter MySQL: Can't connect to local MySQL server through socket '/var/lib/mysql. sock' (2) This is very simple because the MySQL service is not started, but it cannot be seen from the literal

How do I regularly back up MySQL Data? I have provided several methods for you to see. Supports regular and automatic backup of mysql Data in linux. MySQL: shell script for automatic database backup in LinuxThe programs on Linux Server Update the

On June 19, March 23, Oracle announced the release of its enterprise package for development tool Eclipse to enhance the access and use capabilities of this free development tool for Oracle Integrated middleware components. It is undoubtedly a good

When DBCA is used to create an Oracle database or delete an existing database. The following describes how to create a database. When creating a database, you are generally provided with three database templates (that is, the database type ):

For DEV and UAT environments, databases must be in archive mode, but do not need to be backed up. Therefore, the constant increase in archive archiving logs results in a large amount of disk space consumption. In this case, you can use a shell

Environment: OEL + Oracle 11.2.0.3 Change the dbstart file under $ ORACLE_HOME/bin [Oracle @ Seven bin] $ vi dbstart Find this paragraph at the frontend # First argument is used to bring up Oracle Net Listener ORACLE_HOME_LISTNER = $1 // Set

1. nvl Function The nvl function converts a null value to an actual value. The data type can be date, number, character, and must match: for example:Nvl (commision, 0) Nvl (hiredate, '01-JAN-87 ') Nvl (job_id, 'no manager ') Nvl (to_char (job_id),

The first thing to note is that a ORA-01555 error is a "secure" error that will not cause data loss or corruption, but will make the query that receives the error Unable to continue, in the daily maintenance of the database, if only one or two

When we delete a user, if the user to be deleted is currently connected to the Oracle database, an error is returned: SQL> conn/as sysdbaConnected. SQL> drop user fc cascade;Drop user fc cascade*ERROR at line 1:ORA-01940: cannot drop a user that

OracleOraDb10g_home1TNSListener:This Service corresponds to % Oracle_Hoem \ bin \ TNSLSNR. EXEIf the service is not started, Oracle errors will occur-Ora-12514: TNS: no listeners. OracleServiceORACLE:If the service is not started, it will cause

1. Environment Description OS: AIX6.1 Oracle: 11.2.0.3.0 RAC 2. Accidents The host of NODE 2 in the database has a down accident and should have been switched to NODE 1 normally. However, the switchover failed and the system was restarted to solve

Step 1: Try to delete sqlplus using the SQL command. If the deletion is successful, everything is fine! However, if you want to delete a session with a deadlock through a command line or using an Oracle management tool, oracle will only mark the