Database Administrator

In Linux, although you can create databases through dbca, you cannot use a graphical environment in some environments, for example, the database server is in the data center and the open ports are limited, you can also create databases in batches.

(1) log on with the system root permission (2) Stop the MYSQL server: Mysqladmin shutdown (3) skip the authorization table and execute the MYSQL server: Mysqld_safe -- skip-grant-tables -- skip-networking & (Note: The parameter --

Today, a friend asked me to install MySQL for him. I was surprised to say that I had installed MySQL N times and never had such a situation, however, when I install the service, the service cannot be started. When the installation is complete and

This is the operation procedure in Ubuntu. It will be different in other Linux systems, and the principle is similar in general. Preparation 1 download ruby-oci8's latest stable version ruby-oci8-1.0.2.tar.gz2 install Oracle-xe-client first3

Installation environment: Linux : Http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-gui-tools-5.0r12.tar.gz/from/pick After decompression, there are five parts. We want to install the workbench. First, download and compile the required

The new project was launched. It was a hosted call center and analyzed the business processes of competitors. It was probably developed based on asterisk. A while ago, we saw an open-source project asterCRM, some Call Center and CRM functions, so

1. query user informationSQL> select username, default_tablespace, temporary_tablespace, created, account_status from dba_users; 2. Add users1.% su-Oracle, or log in with an oracle software installation user2. Change the ORACLE_SID environment

After installing phpMyAdmin 3.0, change the name of the config. sample. inc. php file to config. inc. php and edit it in text. Modify the following three parts: $ Cfg ['blowfish _ secret'] = '';/* you must fill in this for cookie auth! */ Just

Test environment: MySQL 5.0.45 [Note: You can use MySQL> select version (); in mysql to view the database VERSION] 1. Connect to MySQL. Format: mysql-h host address-u user name-p User Password 1. Connect to MySQL on the local machine. First open the

Synonym CREATE [PUBLIC] SYNONYM synonym For schema. object Hide the Object Name and owner: Select count (*) from hr. employees; Create synonym emp for hr. employees; -- by default, it belongs to the donny user and is the private object of

Today, I plan to enable the Database Control for Oracle Database 11 GB and find that the Database is not installed initially: [Oracle @ test126 ~] $ Emctl startEM Configuration issue./opt/Oracle/product/11.1.0/test126.hurray.com.cn _ dodd not

An error occurred in the alter log of the backup database on site.ORA-1688: unable to extend table SYS. WRH $ _ SQLSTAT partition WRH $ _ SQLSTA_3344221469_3956 by 128 in tablespace SYSAUXORA-1688: unable to extend table SYS. WRH $ _ SQLSTAT

Oracle has two storage structures: Logical Storage Structure and logical storage structure. The logical storage structure is the core of the Oracle database storage structure. The logical storage structure of Oracle is a hierarchical structure

"//" Is followed by a comment. "#" indicates the operation under the root user, and "$" indicates the operation under the Oracle user. # Chkconfig iptables off // permanently disable the firewall or # Service iptabels stop // temporarily disable the

Just getting started with mongoDB, everything starts from scratch. After an afternoon, I completed the installation and sorted it out. I. I installed mongoDB in Linux. The steps are as follows: 1. to download the installation package, be sure to

Extent indicates the range. In Oracle databases, extent management provides extent management local (local management) and extent management dictionary (data dictionary management) The default value is local. There are two ways to increase the size

References (1) official SUSE installation documentation: Oracle database on SLES11 SP2 (PDF) (2) Oracle Online Book: Database Quick Installation Guide for Linux x86-64 Free in http://linux.bkjia.com/(Note: This address is not FTP, directly click to

Small and Medium databases are characterized by low database concurrency, low database capacity, limited version functions, and N multiple single instances. Even so, there will be zero loss of the database. Enterprises do not want to spend too much

1. Oracle multi-Table query Multi-Table query refers to queries based on two or more tables or views. Question: Display employee name, employee salary, and department name [Cartesian set ]? Select t. ename, t. sal, t1.dnamefrom emp t, dept t1where t.

Oracle provides three standard roles (role) for compatibility with earlier versions: connect, resource, and dba. 1. connect role (connection role) Temporary users, especially those who do not need to create tables, usually only connect them. Connect