Database Administrator

The management framework includes: database instance, listener, and Management Interface (database control, management proxy, which is used by Grid control)Manage database control (Oracle provides a Database control console for databases that are

Start the subscription and publish Client On the subscription Client Redis 127.0.0.1: 6379> PSUBSCRIBE shareReading messages... (press Ctrl-C to quit) 1) "psubscribe" 2) "share" 3) (integer) 1 Indicates that the client subscribes to the share

This error is the most common error in Oracle db, which is caused by many reasons. However, one of the major reasons is that the database server suddenly loses power and then restarts the database to report an error.The cause of this problem is that

-- Recode Data TypeDeclareV_deptinfo scott. dept % rowtype;Type dept_record is RECORD (V1 scott. dept. deptno % type,V2 scott. dept. dname % type,V3 scott. dept % rowtype-- The ROWTYPE can be declared.);V_deptrecord dept_record;Begin-- The following

Environment:Oracle11g + IE9 Problem:Oracle Database ControlThe browser cannot log on Solution: Open your browser and enterURL:Https: // 127.0.0.1: 1158/emOrHttps: // localhost: 1158/em IfInternet Explorer cannot display the webpage, Follow these

-- Functions and stored procedures can be defined separately. They will appear in pl/SQL-- Functions's folder and under the Procedures folder -- They can also be defined in the package. -- Functions or stored procedures defined in a package,

I. Fault symptom: SQL> conn system/OracleERROR:ORA-28000: the account is locked Warning: You are no longer connected to ORACLE.SQL> Ii. Cause Analysis:Unable to log on because the system is locked Log on to the operating system using the sys user or

There is a new feature in Oracle 11g R2. When the table has no data, no segment is allocated to save space. Oracle cannot export empty tables when executing export, but there are still solutions: Solution: 1. insert a row and then roll back to

In the Oracl RAC 10.2.0.4 environment where the operating system is Linux, the local hard disk of a node server is suddenly damaged and stops running. The remaining node still works normally and continues to provide external database services. The

The first time I installed MySQL on Linux (Ubuntu 10.10), I had to pay some twists and turns, and finally I had to figure out my ideas. Let's talk about how to install mysql in Ubuntu 10.10. The current mysql version is 5.5.20 and my system version

In Linux, mysql is often used to connect to the server every time: [Root @ localhost ~] # Mysql-hlocalhost-uroot-p11111 Every time I enter the user name, password, and more people, is there a more convenient way? We only need to simply configure

In the master-slave replication of MySQL, the transmission process is plain text transmission, which does not guarantee data security. When compiling and installing Mysql, an option such as -- with-openssl is basically added, that is, it supports

1. First, I created a user named "bkjia" and set his password to "bkjia123" (an SQL statement operated as sys) Create user bkjia identified by bkjia123; 2. assign some permissions to new users Grant create session to bkjia;Grant create table to

1Environment Introduction: This is a test library. After deleting all the parameter files, control files, and data files, we can restore the data. I restored both the control file and parameter file, but the database could not be opened.ORA-01103:

Oracle 11g backup file imported 10g, *. dmp file imported to 10g encountered a lot of problems The following error occurs when I export data from 11 GB and then import the data to 10 Gb. IMP-00010: the exported file is not valid and the header

I. mySQL Database Backup 1. create database xscj character set utf8 COLLATE utf8_general_ci; 2. create table student (Sno int (10) not null comment 'student ID ', Sname varchar (16) not null comment 'name', Ssex char (2) not null comment 'gender',

The same Oracle dll script: DeclareCInt;Begin Select Count(*)IntoCFromUser_tablesWhereTable_name =Upper('Activestarttimes'); If c = 1Then ExecuteImmediate'Drop table "ACTIVESTARTTIMES" cascade constraints'; C: = 0;EndIf;

Brief description of PostgreSQL database operations PostgreSQL database version Psql -- versionPsql (PostgreSQL) 9.1.3 I. Database Backup 1. Backup database structure Su-postgresPg_dump-Fc-s-f testdbschema. SQL testdb 2. Back up database

The Flashback Drop flash-back deletion function of Oracle provides a convenient Recovery Method for deleting tables by mistake. The principle of this function is the RecycleBin function of Oracle. Note: If the table to be deleted is originally

Today, the following error occurs when you run your own JDBC to call the stored procedure:ORA-01002 read violation orderMost of the suggestions provided on the Internet are to set Automatic SQL submission to false: cn. setAutoCommit (false );But