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.

I. Mount the optical drive in Linux: Mount-t iso9660/dev/cdrom/mnt/cdrom Unmount the optical drive umount/dev/cdrom The drive eject is displayed. Push drive eject-t 2. Install MySQL

When using MySQL for database restoration, The following Error occurs due to The large data size: The MySQL Server returned this Error: MySQL Error Nr.2006-MySQL server has gone away. This error occurs when I restore a MB backup. The solution is to

Troubleshooting ORA-01090: shutdown in progress,ORA-01081 Phenomenon:SQL> shutdown immediateORA-01090: shutdown in progress-connection is not permittedSQL> startupORA-01081: cannot start already-running Oracle-shut it down firstSolution:Oracle>

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

Format: grant select on database. * to username @ login host identified by "password" Example 1: Add a user user_britepic whose password is bkjia so that he can log on to any host and have the permission to query, insert, modify, and delete all

The absence of an index on a foreign key column can cause two problems: Limiting concurrency and affecting performance. Either of these two problems may cause serious performance problems. Both the official Oracle documents and Tom's books indicate

Import and Export Oracle 10 Gb in Ubuntu: Add the following code to/etc/profile:Export ORACLE_HOME =/usr/lib/oracle/xe/app/oracle/product/10.2.0/serverExport PATH = $ PATH: $ ORACLE_HOME/binExport NLS_LANG = AMERICAN_AMERICA.AL32UTF8Export

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

In Linux, view the MySQL storage engine: Server version: 5.0.45 Source distributionMysql> show engines;+ ------------ + --------- + ---------------------------------------------------------------- +| Engine | Support | Comment |+ ------------ + -----

When using MySQL, we often encounter table names that do not comply with the specifications or standards, but there is already a large amount of data in the table. How can we keep the data and only change the table name? You can create a table with

Problem 1: An error occurred while logging on to mysql.ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql. sock' (2)Solution:1) The default mysql. sock file is in the/tmp directory.2) Establish a soft connection,

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

Common scripts:----- Level 1. 0 backupBatch file:Set Oracle_SID = orclRman target sys/test @ orcl prepare file ='s:/backup/scripts/0/db_fullbakup_orcl.rman 'Log ='s:/backup/LOG/rman_backup _ % DATE :~ 0, 4% % DATE :~ 5, 2% % DATE :~ 8, 2%. Log' Rman

When I inserted data into the experiment environment, I finally broke up with ASM.In ASMCA, the available space is-0.04 GB.At this time, shutdown abort, and then start, it can only be in the mount state, as long as one open, WillORA-03113:

1. What is Alibaba uard? DataGuard is a high-availability technology specifically designed for Oracle databases launched by oracle. It was called Standby Dtabase before 8i and officially changed its name from 9i to DataGuard. Generally, there are at

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

In Oracle databases, you can use the wm_concat (column) function to merge fields. However, this method is not recommended by Oracle because WMSYS is used for Workspace Manager, the function objects may vary with versions, and such changes are

Common Data Backup Types and toolsMysqldump Backup ToolUse LVM logical volume Snapshot Backup#####################################Common Data Backup Types and tools I won't say much about the importance of data ......, Common Data Backup types are

1. Preface Recently, I have been studying MongoDB. I have learned a lot about data modification and complicated commands. So I will summarize some frequently used modification commands in this blog to facilitate future study. 2. Command Summary 1).