Database Administrator

In the application, the system prompts you to provide reference information to help you use the system correctly. However, when running Oracle form, the prompt information of the information line at the bottom of the screen is in English. When more

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

Installation environment: VMware Workstation 5.5.3 Host hardware environment: AthlonXP 2000 +, 256*2/DDR400, ST80G, GeForce4 MX440 Select Other Linux 2.6.x for Linux created using VM After installation, the virtual machine environment is as

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

After installing the Oracle database in Linux, I tried to use dbstart to start the database but did not respond. In this case, I need to change the oracle configuration. Su rootVi/etc/oratab*:/Opt/oracle/product/9.2.0.4: NEgo:/opt/oracle/product/9.2.

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

I am a beginner in Linux and have trouble installing PostgreSQL today. I need to install PostgreSQL8.2 now, but enter the command in the console: emerge PostgreSQL-pv to search for only PostgreSQL8.0. However, I need to install version 8.2, what

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

INSTALL the MySQL BINARY package according to the INSTALL-BINARY instructions. problems may occur in RedHat Linux. Other releases are not tested. Many people on the Forum are looking for a solution, I have an incorrect answer before, and I want to

1. Configuration:./Configure \-- Prefix =/home/zengyf/local/mysql-5.1.30 \-- Enable-local-infile \-- With-unix-socket-path =/home/zengyf/local/mysql-5.1.30/var/mysql. sock \-- With-tcp-port = 5506 \-- Enable-thread-safe-client \-- With-mysqld-user =

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

How to configure HOST1 and HOST2 to log on without a password based on Oracle user ssh 1. login HOST1 as oracle, in ~ /. Ssh/Public id_rsa.pub and private key id_rsa Ssh-keygen-t rsa 2. login HOST2 as oracle, in ~ /. Ssh/Public id_rsa.pub and

Problem description: The operating system of the server is CentOS 5.5. Many systems have been running on the server and PHP5.2.10 is installed. The stable yum installation source version of Centos5.X is 5.1.6 and does not comply with the latest

(1) lower_case_table_names ● Recommendation reason The GNU/Linux platform is case sensitive to names of databases, tables, stored procedures, and other objects. To reduce developer development costs, we recommend that you set this parameter so that

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

Debian7 install Oracle 11g notes. Install Debian 7.0 Wheezy on a USB flash drive Debian 7.0 Wheezy released! Debian 7.0 Wheezy test experience 1. Installation Package is requiredApt-get install gcc g ++ make binutils libc6 libc6-dev libstdc ++ 6

About setting the table to read only in Oracle Alter table test3 read only; This feature should be added from 11 GB, because an error is reported when it is executed in 10 GB: ORA-01735: Invalid alter table Option After the value is set to read

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

When to use B + tree indexes Not all columns that appear under all query conditions need to be indexed. When to add B + tree indexes, my experience is that it makes sense to use B + tree indexes to access a small part of a table. For gender fields,

Encountered a ORA-01172, ORA-01151 error, asked about the storage failure caused the database to fail to start. Database Version: 10.2.0.1.0 [Oracle @ hhserverfs ~] $ Sqlplus/nolog SQL * Plus: Release 10.2.0.1.0-Production on Sat Jun 8 11:46:38 2013