PHP

Error Caused by ORA-09925: Unabletocreateaudittrailfile Error Caused by ORA-09925: Unable to create audit trail file When I practiced manual Oracle database creation today, I set the path in the parameter file audit_file_dest incorrectly and

The user tells a RAC environment database to generate a large number of ORA-21799 error messages in the log, the alert Log part is truncated as follows: The user tells a RAC environment database to generate a large number of ORA-21799 error messages

Unless you have sysdba permissions, you can only view your own objects. Therefore, for users, it seems that everyone has their own recycle bin. Even if the user deletes other Unless you have sysdba permissions, you can only view your own objects.

Recently, I have been using Oracle's spatial database for some spatial data processing and analysis functions. I wrote this article mainly to take notes. After all, good memory is not as bad as writing. Recently, I have been using Oracle's spatial

1.1.ORA-01722 Date: 2014-06-0514: 09 environment: test environment [scenario description] Run SQLgt during Database Upgrade ;@? Rdbmsadmincat 1.1. ORA-01722 Date: Environment: test environment [scenario description] in the Database Upgrade process,

As we all know, the Oracle database has a password file, which is used to log on to the database and perform a series of password verification when the database is not started. As we all know, the Oracle database has a password file, which is used

Today is very strange, import a single table to report the error of ORA-01401, also searched a circle online, and my situation is different. This error is caused by the storage of characters when the dmp file is exported. Today is very strange,

To_date ( To_date ( When writing an SQL statement into a database To_date ('20140901', 'yyyymmddhhmms ') Reporting ORA-01810: The format code appears twice The reason is that the year, month, and day expressions in java are different from

PostgreSQL is a very complex object-relational database management system (ORDBMS). It is also currently the most powerful, feature-rich and complex free software database system. PostgreSQL is a very complex object-relational database management

I recently tested MySQL master-slave Database Synchronization and found some problems. Among them, the master-slave synchronization latency is one of them. The following content is some explanations found on the Internet and is recorded. I recently

Building Database Clone objects is a common daily O & M requirement. During actual development and testing, you often need to quickly copy a database environment containing business data. Before Building Database Clone objects is a common daily O &

I have never understood the usage of rman crosschcek and obsolete clearly, and it is a bit confusing. This has a great impact on the management of rman backup sets and even backups. I have never understood the usage of rman crosschcek and obsolete

In the DataGuard environment, StandbyRedoLog is a special log type. From the latest guidance on installation of DG, we recommend that you configure St on Primary and Standby. In the Data Guard environment, Standby Redo Log is a special Log type.

1. Enable the flash back database feature: 1. Ensure that the database is in archive mode. If it is not in archive mode, convert the database to archive mode SQLgt; archiveloglist; Data 1. Enable the flash back database feature: 1. Ensure that the

Another aspect of OracleUpdate is the Undo, Redo, and process workload. Oracle users know that Undo and Another aspect of Oracle Update is the Undo, Redo, and process workload. Oracle users know that Undo and SQL statements are a convenient and

Linux: Use root to log on to CentOS1, download postgresql9.3, decompress the package, and go to the decompressed postgresql directory 2. Compile and install # pwd #. configu. Linux: Use root to log on to CentOS 1, download postgresql9.3, decompress

Oracle's nologging attribute is very vulnerable to misuse. In our previous article, we discussed the impact of append + nologging on RedoLog. The conclusion of this article is as follows: Oracle's nologging attribute is very vulnerable to misuse. In

For the RESETLOGS and NORESETLOGS options of ALTTERDATABASEOPEN, this statement determines whether Oracle resets the current log serial number to 1 and archives any Unarchived logs ( For the RESETLOGS and NORESETLOGS options of altter database open,

With the continuous development and increase of the technical environment, the O & M department is facing two trends: large-scale and complex. One or two O & M personnel manage hundreds of servers in the company With the continuous development and

There are many ways to recover data, such as hot and cold backup and flash back to the database. If you delete data files directly from the operating system OS, there are some preferred methods in the LinuxUnix environment. There are many ways to