Database Administrator

Programmers often write on their resumes to familiarize themselves with Oracle and SQL Server. So it is very likely to be asked about the difference between Oracle and SQL Server, and many people are being asked. I have never thought about this

A friend called me a few days ago and asked me to help test their servers. After scanning, I found that SQL Server SA was empty and decided to use this vulnerability for penetration testing. After testing, we found that the Stored Procedure

This article describes how to install the PostgreSQL8.3.3 database with the source code on Red Hat Enterprise Linux Server 5 and install it with the root user. 1. Download the source code package corresponding to PostgreSQL8.3.3 on the Linux

Environment:OS: Red Hat Linux As 5DB: Oracle 10.2.0.4 Today, a developer deleted all the data in a table, because it was not a long time before the undo space was overwritten, And the undo space was restored. the recovery process is simulated as

Error message: mcrypt Extensions cannot be loaded. (1) extension = php_mcrypt.dll is changed to extension = php_mcrypt.dll // remove the previous one to make it take effect. [root @ www.bkjia.com ~] # Updatedb # update a database[Root @

1. Introduction In relational databases, join operations are common when data in different tables are joined. First, let's take a look at how the join operation works. Then, let's explore the execution sequence when the join and where statements

Today, a student found a problem when building a master-slave environment. Thanks @ 80 s. Symptom: Slave_IO_Running stops on the slave database. Last_Error is shown as follows: Bin/mysqlbinlog: Character set '# 45' is not a compiled character set

Use the scan method of the new Oracle 11gR2 component (assuming that scan_vip is 192.168.100.217)String url = "jdbc: oracle: thin: @ 192.168.100.217: 1521/prod"You can also use the vip connection method before 11gr2.String url = "jdbc: oracle: thin:

In brief, writing this article is a summary of your recent work. I hope it will be helpful and a little bit of accumulation. I. Why redis? Redis is used as the cache in the project and memcache is not yet used. There are two main considerations: 1.

SQLite is organized by B-Tree in external databases. For details about B-tree, refer**** Donald E. Knuth, the art of computer programming, Volume 3:** "Sorting And Searching", pages 473-480. Addison-Wesley** Publishing Company, Reading,

First, let's give a brief introduction. [NOTE 1] installation path of MYSQL in MAC:/usr/local/mysql-5.5.28-osx10.6-x86 The database data files are stored in the data folder of the directory; The command file is in the bin folder. [NOTE 2] how to

Oracle10g manually create a database stored in ASMProject Process:0. Add two SCSI hard disks to the computer.1. Install ASM2. Create two ASM disk groups: GROUP1 and GROUP23. Create a database. First, create a parameter file and save it as $

OCR is like a Windows registry that stores all configuration information related to the cluster and RAC database. It is also a public configuration, that is, multiple nodes share the same configuration information. Therefore, this configuration

It is troublesome to optimize an SQL statement before Oracle 10 Gb. However, the SQL Tuning Advisor tool launched in Oracle 10 Gb can greatly reduce the workload of SQL optimization, however, to use SQL Tuning Advisor, make sure that your optimizer

OCR is equivalent to the Windows registry. For Windows, all software information, users, configurations, and security are stored in the registry. In the same way, all cluster-related resources, configurations, nodes, and RAC databases are stored in

Oracle RAC migration OCR For how to add and delete Oracle rac ocr, see: Oracle RAC backup and recovery OCR reference: If you want to change an existing ocr location or a faulty ocr location, you can use the following procedure to migrate the ocr. 1.

SHELL scripts have been studied in recent days. To facilitate Oracle O & M and simplify management, it is very necessary to learn some SHELL scripts. Through books and some online materials, I have compiled some excellent scripts, which are all

The username and password used for installing Oracle are not remembered. Don't worry. Open sqlplus. Follow these steps to create a login user: Step 1: Use sys to log on to sys/password as sysdba. Any character of the password can be logged

I recently read "RMAN Recipes for Oracle Database 11g". for more information about [RMAN Recipes for Oracle Database 11g pdf download] I am a foreigner, I will write down some of the important operations so that you can check them later. If it works

Stop an Application Server Use the application system administrator user to log on Cd $ INST_TOP/admin/scripts (or cd $ ADMIN_SCRIPTS_HOME) In this case, run the following command in/u01/Oracle/mc3yd213/inst/apps/mc3yd213_bej301441/admin/scripts to