Database Administrator

1. administrator permissions:SYSDBA: the default schema is SYS.SYSOPER: the default schema is PUBLIC.These two permissions allow users to log on to the database when the database is not opened, so the permissions are beyond the database. This type

Q: I have locked myself out of SQL Server and cannot Log On As sysadmin. Is there any solution? Do I need to reinstall SQL Server? A: you do not have to reinstall SQL Server. To re-access SQL Server, you must modify the registry key value of SQL

This article describes how to install the PostgreSQL8.3.3 database with the source code on Red Hat Enterprise Linux Server 5 and install it with the root user. 1. Download the source code package corresponding to PostgreSQL8.3.3 on the Linux

The following is a simple process Lighttpd + php5 + mysql + Debian etch Lighttpd is the fastest static web server, and mysql is the most common database server. Let's take a look at lighttpd. After debian is installed, everything is easy. Log on to

In most businesses, the main business requirement for true Oracle Application cluster (RAC) configuration based on the Linux platform is the scalability of the database layer in the entire system-in this way, when the number of users increases, you

Oracle announced the release of the complete data integrity (data integrity) Test of open source code, so that users in the Linux community can obtain more comprehensive protection during data transfer. At present, 2.6.27.Oracle, the core of Linux

For the installation process of Oracle 9i in Ubuntu, refer to this article. This article is mainly based on kubuntu to install Oracle 10g. Refer to this article to easily install 10g, however, oracle 9204 has encountered many obstacles and the

1. Required Software The command line email tool in mutt Linux, which can be used to receive and send emails. Sendmail/postfix on the mail server in Linux, all emails are sent from the Local Machine MySQL database backup program 2. mutt parameter

Download sakai-demo-2.6.2 from the official website, the default is the memory database hsqldb, want to use mysql. So ...... 1. How do tables, fields, and data in mysql come from? I found it on the official website. I didn't find mysql backup files,

You can add data to a table as follows:1. insert into table values (...)Write data according to the specified column in the table. If only the table name is given, the data is added in the column order.Insert into table (col1, col2) values (value1,

Analysis and Processing of Oracle jobs not executed Steps: 1) Check the last date, next date/failure times, broken, and check whether the job fails to run multiple times because of the exception or deadlock in the Stored Procedure executed by the

Extract Process recovery Principle BR Applicable to Extract processes (for Oracle databases only) You can use the BR parameter to control the Bounded Recovery (BR) function of GoldenGate. The Bounded Recovery function only supports Oracle databases.

I received a development email last night, saying that the following error was prompted when I used PL/SQL DEV to log on to the database: I am also depressed when I see this error. I have never encountered this situation. So we created a test user

1. When Hive creates a table, the regular expression is the same as that in java code. \ is used in RegexSerDe to represent the anti-transcoding.Create table inst_cn_3 (Ip string,Time string,Mac string,Lan string,Ver string,Lc string,Pn string,Reg

DRBD is the block-level synchronous replication technology implemented by the kernel module. The synchronization level here can be adjusted.Because DRBD uses the network card for block replication. If Infiniband is used for transmission, high

1. Back up data on the Management node.Ndb_mgm> start backupNdb_mgm> shutdownNdb_mgm> exit2. Delete SQL node data.Drop database TEST_CLUSTER;3. Disable the MYSQLD server.[Root @ localhost bin] # service mysqld stopShutting down MySQL... SUCCESS!4.

I recently read "RMAN Recipes for Oracle Database 11g". for more information about [RMAN Recipes for Oracle Database 11g pdf download] I am a foreigner, I will write down some of the important operations so that you can check them later. If it works

Oracle Data Guard provides one or more slave databases for the production database (a copy of the database ), to ensure that data is not lost when the master database is unavailable or when exceptions occur, and continue to provide services through

In non-relational database MongoDB, there is no ready-made framework that can easily implement database grouping through Group By like SQL. If we want to implement the MongoDB Group function, we must write the original NO-SQL query statement to

Today, in the log file of a server, the following information is found: It seems to be an error, but it does not affect the operation of the database. However, after all, the error is reported. If you look uncomfortable, study it. Fatal NI connect