Database Administrator

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

If I have multiple MySQL versions, how can I make them work together and get along with each other? In WIN environment A) Start the cmd window and run the MySQLd-nt command in the/bin directory to install the service. For example: MySQL-nt-install

1. Create, configure, or delete a Database by running Oracle Database Configuration Assistant (you can also enter dbca in the command line );2. Create a database using command line3. Create, configure, or delete a database by running a custom batch

In Ubuntu, MySQL only allows local access by default. If you want other machines to remotely access the MySQL database, you need to set something Modify/etc/mysql/my. cnf Comment out this sentence bind-address = 127.0.0.1 Grant database access

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

After umVPS is used, many times you have to deal with the virtual host without doing anything on your own, such as upgrading PHP and MySQL. Because you don't need to do it yourself, you cannot do it. Therefore, binggu is not sure whether the PHP and

From Oracle9i, oracle Installation includes XDB by default. After the database, the http service of Oracle XDB automatically occupies port 8080, which makes it a lot of trouble to use java web development or JBoss or Tomcat. Here we will introduce

It's just a simple configuration. Weblogic configures the data source in Linux, which is the same as that in windows. It may be a problem only for those who have just switched from windows to Linux. Step 1: copy the database connection file (My

It took half a day to install Oracle 11G on Ubuntu 8.04 LTS. The following describes the steps. 1. Make sure the following programs are installed: Sudo apt-get install build-essential libaio1 gawk ksh libmotif3 alien libtool lsb-rpm 2. Cd/binLn-sf

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

Rails2.2.2 has good support for Chinese characters. Of course, not only Chinese characters are supported, but all multi-byte texts are well supported.For a website with high requirements for l10n localization and i18n internationalization, multiple

As shown in, the entire data layer consists of three clusters: Group1, Group2, and group3. these three clusters are the results of horizontal data splitting, of course, these three clusters form a DB containing complete data. Each Group includes one

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 ):

Note: To install MySQL using yum in CentOS Linux, you must install MySQL in a network environment. For more information about how to connect to the network in Linux, see the previous article! Article 1: install and configure MySQL Step 1: Install

Yesterday at the customer site a RAC in the start of listening when the TNS-12545 TNS-12560 TNS-00515 error, after processing back to normal, Today, I restored this problem on my own virtual machine, recording: OS: Linux DB: 10.2.0.4 RAC 1. Simulate

Version: mysql-5.1 [Root @ localhost mysql-5.1.55] # useradd-M-s/sbin/nologin mysql[Root @ localhost media] # tar zxf mysql-5.1.55.tar.gz-C/usr/src[Root @ localhost media] # cd/usr/src/mysql-5.1.55/ The next step is to compile and install [Root @

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

I did an experiment today to delete all the data in the primary table and associated sub-tables that meet a certain condition. In fact, this requirement is very simple, if the on delete cascade is specified when the sub-Table creates a foreign key,

1. Configure ORALCEHOME in the set connection Toll-> preference-> Oracle-> connection OracleHome: configure the path of the oracle client OCI LIb configuration E: \ oracleDatabse \ instantclient_11_2 \ oci. dll 2. Configure the oracle client

'Test' is a reserved word of Oracle. Therefore, you must pay attention to it in some places. Currently, I have found that oracle treats it as a reserved word during rman backup. TEST is indeed a reserved word in rman... When backing up other