Database Administrator

130: the file format is incorrect. (The error is not clear yet)145: the file cannot be opened.1005: An error occurred while creating the table.1006: An error occurred while creating the database.1007: the database already exists and creation failed.1

This document uses Oracle8i as an example:First install an oracle client,Retain the bin, network, and ocommon directories in the oracle directory, and delete all the other directories,Export HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE in the

I. SummaryThe preceding section briefly introduces ProC configuration and Development in Windows. This time, we use the Linux platform to configure the Oracle ProC Development Environment (RedHat Linux 9 + Oracle 92) again ). ORACLE Database

If you use Oracle, you may use PL/SQL Developer.When PL/SQL Developer is used, a confirmation dialog box is displayed when you right-click the Table list or other object lists and select the Drop operation.There will be a check box for Don't show

Postgresql has many built-in practical functions. The following describes the grouping and cutting functions.Environment: PostgreSQL 9.1.2CentOS 5.7 finalI. Composite Functions1. concatA. Introduction concat(str "any" [, str "any" [,

PostgreSQL has a very useful built-in function, generate_series, which can be used to generate a series of filled data according to different rules.I. Syntax generate_series(start,stop) --int or bigintgenerate_series(start,stop,step)

1. scenario description;Catalog database 192.168.1.206: 1521 gridTarget database 192.168.1.201: 1521 ql2. Create the rman tablespace on the catalog database SQL> create tablespace rman datafile '/u01/app/Oracle/oradata/gird/rman. dbf' size 500 m

Previously, the OEM was able to open the webpage, but it was not possible to open it at work today. Enter http: // localhost: 1158/em to prompt that the webpage could not be opened.Check that: Cmd command line C: \ Documents ents and Settings \

1, database log error ORA-00327, pay attention to the garbled here Errors in file/Oracle/app/oracle/diag/rdbms/tyolap/tyolap3/trace/tyolap3_lgwr_22388.trc: ORA-00327: Too Many I 31 (too M too 3 ): WTI malong 102400 yundun 1048576 ORA-00312:

The sys password of the Oracle 10g ASM instance sometimes needs to be modified. The modification method is to directly modify the password file of the ASM instance, which is different from that of the user in the database instance. We cannot use the

The Oracle Database encountered a ORA-600 [504] error. The error message is as follows: Tue Oct 5 10:16:18 2010 Errors in file/opt/oracle/admin/eomsdb/udump/eomsdb_ora_29837.trc: ORA-00600: internal error code, arguments: [504], [0x38006C260], [1

When the mysql database is installed in Ubuntu and cannot be linked with the Navicat client, the following error ERROR is reported: error 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061) 1) you can log on to mysql-uroot-p123456 on

I encountered a lot of trouble when I recently used Oracle to import and export data! Then I carefully studied the oracle database and summarized several command methods for import and export for future reference. Data export: 1. Export the database

The project process is as follows:1. RAC Installation1. Experimental Platform: Oracle 10gR2 RAC + RHEL 5.4 + VMware-server-1.0.92. installation steps:(1) system requirements:Operating System: Red Hat 5.0 or 5.4Memory: 800 mbSwap space: 2048 MHard

-- ====================================== -- Create an ASM instance and an ASM Database -- ====================================== 1. concepts related to ASM 1. What is ASM (Auto Storage Management) Automatic Storage Management is a tool used to

How Does Oracle query the complete definition statement of an object? Syntax: DBMS_METADATA.GET_DDL (Object_type IN VARCHAR2,Name IN VARCHAR2,Schema IN VARCHAR2 default null,Version IN VARCHAR2 DEFAULT 'compuble ',Model IN VARCHAR2 DEFAULT 'oracle ',

Oracle Hot Backup refers to copying data files when they are in use. DBWR is also in progress during the replication process. Therefore, the backup may result in "inconsistent" backup: Articles: Oracle recovery Internal principles

Oracle RAC backup and recovery OCR For how to add and delete Oracle rac ocr, see: Voting disks Backup Recovery reference: 1. OCR supports two backup methods: automatic backup and manual backup. Automatic Backup: Oracle Clusterware automatically

Oracledata database objects are ineffective, through plsqldev.exe program for package compilation; Reported ORA-03114: database connection failure error. Oracle DB version: 9.2.0.1 Cause of failure: the PLSQLDev.exe program conflicts with the CDC

Configuration instructions:1. Use Openfiler to implement iscsi shared storage2. Implement the fence Function Through VMware ESXi5 virtual fence.3. Use RedHat 5.8 vmware-fence-soap to implement the RHCS fence device function.4. In this article, we