Database Administrator

The default selinux configuration of RHEL5.1 only allows the MySQL Server to listen on port 3306. To enable MySQL to listen on other ports, you need to use the semanage command to set the listening permission for the MySQL Server. The following

Search for mssql. so or dll in Win first, failed! It may be possible to compile the. so file, but how to compile it is the same, so it is not a simple php. ini configuration. Find the information. You must install the freetds plug-in. The

This morning, the production sybase Database suddenly went down. I used [root @ d1 install] #./startserver-f RUN_mcsdb to disable other startup tasks. The following error is also reported. [Root @ d1 install] # Incorrectly built binary which

Sun has confirmed that all major vulnerabilities in the latest version of MySQL 5.1 have been fixed and everything is ready. Open-source users looking forward to seeing it available in the coming weeks. zack Urlocker, vice chairman of Sun's database

In Oracle databases, we may encounter a lot of data damages. In these cases, it is very important to recover data.In many cases, recovery is extremely complex and requires caution. Rash operations and attempts may cause permanent damage to the

After installing Oracle10g, I want to enable SQL * plus for learning, and then follow the steps in the book to connect to the database with scott user. After the installation, an error is prompted several times. Error: the account is locked Then I

Yesterday, a friend company's Oracle Database crashed. This once again confirms a proposition I have repeatedly mentioned: the database also needs to rest. On holidays, databases often choose their own holidays. In the past, I said: at the end of

PhpMyAdmin is a PHP-based MySQL database management tool based on the Web-Base architecture on the website host. You can manage the entire MySQL Server (requires a Super User) or a single database. To implement the latter, You need to properly set

Jboss 4.0 is an open-source application server that uses HypersonicDB as its default database. However, developers may also need to use other types of databases except HypersonicDB. In this article, we will see how to configure other databases on

Web development involves two aspects: layout and content. On the layout, the CGI Module of PERL is powerful and easy to use. In just a few lines, HTML webpages can be dynamically generated. To be fair, you must use a database to manage the content.

After receiving a new task today, You need to import MySQL database data to the local machine from the remote server. This is really a bit of a duck on the shelf. Because I have almost never touched mysql before, and MySQL is deployed on a Linux

Recently, tomcat was developed for database migration. to access the database with other users, you must enable the remote access permission; In addition, we know that there are two ways to remotely access Mysql: Authorization and table

A task is scheduled to install a sybase ASE 1252 for rhel5 environment, which requires 32-bit I have scratched my head and never installed it! Later, I found the media on the Internet, but it was quite difficult to find the installation

Hang has recently been used to export schema-level data and has to stop the current export job. If you have similar problems, please continue to read it.1. Problem DescriptionThe database is hang when the entire schema is exported, as shown

Oracle RAC normal restart sequence:Oracle 10g rac:Generally, the 10g RAC (ASM) Switch sequence is as follows:1) Stop Oracle RAC 10g environmentStop the Oracle instance first. When this instance (and related services) is closed, the ASM instance is

Understanding of Oracle architecture ------- preliminary understanding First of all, the Oracle architecture has a system diagram, which I also understand. In fact, the architecture is the figure. To understand the architecture, you must understand

Summarize and organize yourself: 1. Check the registry, Oracle_Home under HKey_LocalMachineSoftwareOracle. If not, change it to correct; 2. uninstall ODP. net (or uninstall ODT. net, ODT contains ODP, ODT is. net is an integrated plug-in for

I. Runtime Environment Note: The SWAP installed on Oracle11 must be above 2.57G. Therefore, when installing CentOS, make sure that the swap is larger than 2.57G. System Environment: centos 5.6 32-bit (graphical installation)Hard Disk Partition:/Boot

Almost all internal changes that occur in Oracle are recorded in the online redo log file. oracle uses these redo log groups to restore the database, so they are very important. The main tasks of online redo log files are: Back up data, 1: record

Recently, the system has to "scale down" because I don't want to say much about it. It is a very troublesome thing because we need to compress and store data. It has nothing to do with the operating system. It mainly refers to Oracle Data. Oracle