Database Administrator

It is inconvenient to use SQL * Plus on Linux, that is, there is no historical callback function. For SQL * Plus on Windows, you can use the "Up and down" arrow to call commands that have been used before. It is quite convenient to modify, edit, and

Follow the steps in the Oracle official documentation to install the system. First, check the system requirements on Solaris10: #/Usr/sbin/prtconf | grep "Memory size"Memory size: 16384 Megabytes#/Usr/sbin/swap-lSwapfile dev swaplo blocks

Install MySQL5.0.37 in Linux using the following three packages:MySQL-client-community-5.0.37-0.rhel3.i386.rpmMySQL-server-community-5.0.37-0.rhel3.i386.rpmPerl-DBI-1.53-2.fc7.i386.rpm(The following steps require root permissions)1. Verify that

The following information is displayed: Got an error: Connection error: Can't connect to local MySQL server through Socket '/var/lib/mysql. sock' The sudden disappearance of mysql. sock is a common problem. If it occurs after MySQL is installed

If you want to import EXCEL or CSV data to MySQL, MySQL's CSV engine is no longer suitable. MySQL CSV engine is provided after 5.0, but does not support WINDOWS. It is only supported by 5.1. The version I tested today is 5.0.45. I. Notes:1. No index.

1. Open a terminal in the graphic interface of the Linux server and enter the following command; Xhost + 2. Switch to an Oracle user and run the following command:Su-oracle 3. Specify the variables and values of the database instance. Assume that

The following is in Windows, not in Linux. When querying data using the MySQL command line, screenshots are often used to send posts, such: In this way, the display is not convenient, and the display speed is slow. How to extract data into text:

Recently, when I learned how to install a database, I used a variety of methods to create it, such as dbca, manual creation, and template creation. When I used dbca to create a database, if you do not select "Use Enterprise Manager to configure

Basically, mysql has two major problems.1. There is no problem starting mysql for the first time. After you perform some operations on mysql, especially after deleting some accounts in mysql, you will encounter such problems when you restart mysql.#/

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

ORA-12514 and ORA-28547 troubleshooting Oracle 10 Gb is installed on the local machine. The website is dynamically obtained by the company. It is normal to log on to the database with SQL plus. When you open the database with pl/SQL, the error "ORA-1

The Community recently launched ipvs 9.2.4, which aims to install a security patch and requires an upgrade. The upgrade procedure documentation is also detailed (Part 17 ), generally, there are two methods: pg_upgrade and dump/restore. For 9.2.0 and

Install Oracle 11G notes in Ubuntu 12.04. 1. First, update the system to the latest version. Sudo apt-get updateSudo apt-get dist-upgrade 2. Install the dependency packageSudo apt-get install alien binutils build-essential cpp-4.4 debhelper g + +-4.4

Backup recovery is an important technology in Oracle. Of course, it is recommended that you do not need this technology, just as you do not need to go to the hospital. When you open the database, oracle compares the control file with the data file

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

Starting from Oracle Database 10 Gb, columns SQL _TEXT and SQL _BIND in DBA_AUDIT_TRAIL are filled only when the initial parameter AUDIT_TRAIL is set to DB_EXTENDED. Oracle uses a large number of different audit methods to monitor which permissions

V $ database. CHECKPOINT_CHANGE # (last scn checkpointed)V $ database. CONTROLFILE_SEQUENCE # (control file sequence number incremented by control file transactions)V $ database. CONTROLFILE_CHANGE # (last scn in backup control file; null if the

To access MySQL on CentOS from a Windows client, you need to disable the firewall on CentOS, grant the database user remote access permission, and clear the permission cache. The specific configuration is as follows: [Root @ mysql ~] # Service

Today, I encountered a problem when I used RMAN for backup, and then I suddenly realized it. I used the client RMAN for backup. The client was windows and the server was installed with Oracle linux. I want to output the RMAN backup information to a

Check System Environment uname Hostname Vi/etc/hosts and IP host name Disable Firewall [Root @ linux-6-64 Desktop] # vi/etc/selinux/config SELINUX = disabled [Root @ linux-6-64 Desktop] # service iptablesstop Iptables: Flushing firewall rules: