Database Administrator

Note: Do not use the "create pfile from spfile;" command to create a PFILE when maintaining the RAC environment. The reason is that in the RAC environment, SPFILE is stored in shared storage by default (on bare devices or ASM disk groups ), each

Some resources in the Oracle 11gR2 grid cluster are not automatically started and need to be manually started, such as srvctl and crs_start. The cause of this problem is that when the cluster is running, some resources are manually stopped. View

1. Create an External table using datapump. The data comes from an internal entity table. -- First create the scott. countries entity table for experiment SQL> create table scott. countries ( 2 country_id number, 3 country_name varchar2 (30 ), 4

I found that Oracle's service and listener services started normally today, but the sqlplus logon prompt is as follows: ERROR: A ORA-01034: ORACLE not available ORA-27101: shared memory realm does notexist Most of the solutions to this problem

Oracle sometimes requires a large amount of test data. It is very slow and difficult to use a stored procedure. For example, assume that table A is associated with table B, and B _id is a_id. The table fields are as follows, Table: A_id

ORA-14300: partition keywords map to partitions that exceed the maximum number of partitions allowed Environment: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0-64bit Production The object table is an automatic partition table by day:

Essential for installing MySQL with yum in CentOS 6.5 Step 2. Install mysql in yum[Root @ stonex ~] # Yum-y install mysql-serverInstallation result:Installed:Mysql-server.x86_64. 1.73-3. el6_5Dependency Installed:Mysql. x86_64. 1.73-3. el6_5

Today, a single point library of 11.2.0.2 on CentOS5.8 x86-64 has a problem. The specific phenomenon is that every time the alter database is opened, the alert Log will be automatically crash (crashed) within 10 seconds, as shown in the following

I. Experiment 1 A) lab requirements: I. move the table under the vip user to the DATA tablespace to partition the table fragments. -- I think it should be to check the usage of one or some tablespaces, to fragment the table in the tablespace,

-- Test environment:OS: RedHat linux (64)Primary:IP: 192.168.94.198SID: dgdb1Hostname: dg1DB_UNIQUE_NAME: dgdb1Database: 10.2.0.1 (64)Standby:IP: 192.168.94.199SID: dgdb1Hostname: dg2DB_UNIQUE_NAME: dgdb1_sDatabase: 10.2.0.1 (64)  -- Preparations

Oracle data export: Create a path file: create_dir. SQL Create or replace directory dmpdir as 'e: \ app \ tmp ';Grant read, write on directory dmpdir to test;Exit Write and execute export Bat file: export. bat Sqlplus system/root123 @ MYTEST @

ORA-15041: the direct and indirect impact of diskgroup space exhausted on your database environment? Disk Space Problems and ORA-15041 errors related to the ASM disk group can have a serious impact on the database environment, as shown in Database

Have you ever handled the problem of data corruption or data loss on the hard disk? As a result, even though you are still in the process of diagnosing and analyzing the problem, the end user and manager have already contacted you and want to know

-- Instance demo--- System user ExportC: \ Users \ ZML> exp system/zml file = 'd: \ zml. dmp 'Log = 'd: \ zml. log' tables = (zml) Export: Release 11.2.0.1.0-Production on Monday April 21 21:39:12 2014 Copyright (c) 1982,200 9, Oracle and/or its

$ LsvgRootvgVg_oradata $ Lsvg-l vg_oradata......DBF_5G_031 raw 20 20 1 open/syncd N/DBF_5G_032 raw 20 20 1 open/syncd N/DBF_5G_033 raw 20 20 1 open/syncd N/DBF_5G_034 raw 20 20 1 open/syncd N/DBF_5G_035 raw 20 20 1 open/syncd N/DBF_5G_036 raw 20 20 1

In many scenarios, developers prefer to use 00:00:00. the NUMBER of milliseconds since indicates the specific time. In this way, data can be stored in the database as NUMBER, which is convenient for comparison in some cases. Similarly, sometimes we

1. Read-Only tablespace recoveryBy default, even if a read-only data file is lost, RMAN does not restore the read-only data file during full database restoration. To restore a read-only data file during full recovery, you must use the check readonly

The tablespace data file capacity is related to the DB_BLOCK_SIZE setting. this parameter is specified when you create a database instance. The DB_BLOCK_SIZE parameter can be set to 4 K, 8 K, 16 K, 32 K, 64 K, etc, A maximum of 4194304 data blocks

When migrating an Oracle stored procedure to the HIVE platform, you will inevitably encounter Syntax problems related to table Association. This article compares various table Association syntaxes of ORALCE and HIVE in detail, including internal

Database locking Contention is a common problem in practice. Serious Contention may cause overall database performance degradation, or even connection failure. In actual production, Contention is usually an urgent situation. It is a challenge for O &