Database Administrator

After the cold backup system (see Oracle EBS system overall backup (cold backup), restart the DB Listener and DB without any errors, and then run the command adstrtal. when sh apps/apps is used to start the Apps Server, an error is reported. [Oracle

This article summarizes mysql Data replication, migration, and conversion in various scenarios. 1. Import and Export Use the mysqldump command to export data files into a text file, which provides higher security in different scenarios. For example,

Requirements: When the number of data in the Oracle table is an odd number, a blank row is automatically added, and an even number of data is returned. If the number of data in the table is an even number, all rows with an even number are directly

1. Memory Dumps 1). Global Area Alter session set events 'immediate trace name global_area level n '; 1 Including PGA2 contains SGA4 include UGA8 contains indrect memory 2). Library Cache Alter session set events 'immediate trace name library_cache

Use Xshell to connect to a remote Linux database server. When you switch to the sqlplus console and enter an error character, ^ H is displayed when you use the rollback key to modify the character. Solution:$ Stty erase ^ H: erase is used to delete

First, we will give an example by PAGE: Find the records from the first row to the Tenth row! Select c. * from (select a. *, rownum rm from oper_log a) c where c. rm between 1 and 10  Note: rownum is a pseudo column, which means a column that does

Delete undo tablespace report ORA-01548 When exporting data with expdp, the following error occurs: C: \ Documents ents and Settings \ TEMP> expdp scott/tiger DUMPFILE = scott. dmp DIRECTORY = du Mp SCHEMAS = scott Export: Release

A session-level temporary table was created recently and the following error was reported when deleting: ORA-14452: an attempt to create, change, or delete an index in a temporary table in use The solution is as follows: 1. First query the

We know that scott must be unlocked before conn to scott/tiger for the first time. The steps for unlocking are as follows: 1: Start the database and run @ $ Oracle_HOME/db_1/rdbms/admin/utlsampl. SQL. 2: access the database through sqlplus again 3

The Flashback function and experiment are a little old. I will share the experiment diary from the previous two years. 1. Set flashback Parameters SQL> conn/as sysdba;Connected.SQL> archive log listDatabase Log mode non-archive ModeDisable automatic

Define such SQL in SQL MAP. in Oracle Database, if s. post = t. post and s. FLISK_ID = t. FLIGHK_ID If the two conditions are the same as the input data, the update set statement is executed. Otherwise, the INSERT statement is executed.

When ASMM is used, there are few 04031 problems, but some applications may also exhaust the memory.1. No bound variable is used, resulting in too much resource occupation for parsing.2. Open too many cursor and do not release3. bug First.Bind

On the platform after Oracle 10.2.0.4, we may encounter the following error when importing materialized views using a Data Pump: ...Ksedmp: internal or fatal errorORA-7445: exception encountered: core dump [_ intel_fast_memcpy.A () + 10][SIGSEGV]

Top-N queries are used to return a limited number of records from an ordered result set. This query is particularly useful when you need to obtain N records at the beginning or last, or you need to view data by page. This article describes several

In my previous articles, I have discussed that adding default columns to a data table is a very dangerous thing, especially in online production environments. To add a default column to a large data table, the most direct cause is: The system runs

Note: Here I want to back up the pw85 database under the/var/lib/MySql database directory to the compressed file format of/home/snapshot (2012_04_11 refers to the date on which the backup was executed ), at last, only the backups of the last 7 days

In application development, one or more selection box conditions are required. If the input value of the input box is 'sz 'or 'sz | nj | zj | nt', it will be processed in SQL. Select * from tab_1 where col_1 = 'sz '; this is a single sequence input.

Today, the Oracle Development Server suddenly fails to connect. After the sqlplus/nolog, conn/as sysdba, and startup commands are displayedSQL> startupORA-01078: failure in processing system parametersLRM-00109: cocould not open parameter file '/opt/

Cause: The reused control file is damaged and the instance is terminated immediately. The DBA tries to start the crashed instance. If it fails to start in NOMOUNT mode, an error message is displayed. The alarm log declares a copy of The Lost

A machine, the disk was found to scan, it is estimated that the shutdown encountered problems yesterday, Oracle appeared after ora-01172 ora-01151Hurry to find information to solve, and encountered a ORA-12514 error, the first solution to this error