Database Administrator

Oracle Streams has been configured for a long time. For some reasons it is not officially used, you need to completely clear its configuration information. Streams consists of three parts: capture, progapation, and apply, and some basic

Oracle Net Services configuration files are typically, but not always, located in the $ ORACLE_HOME/network/admindirectory. depending on the type of file, Oracle Net uses a different search order to locate the file. The search order for thesqlnet.

Restore the database if the archive log is lost and the data file is damaged. Restore with rman, archive loss, recovery to the specified sequence1. When the database is open, perform some operations to determine the archive log file of these

Analysis process:1. tjcw database background alert alarm a large number of the following ora-00600 error alarmFri Jul 06 15:59:13 2012Errors in file f: \ Oracle \ admin \ tjcw \ udump \ tjcw_ora_3200.trc:ORA-00600: Internal error code, parameter: [61

1. Define BOM BOM is the basis of WIP. BOM defines the structure of a product and the parts and quantity required to produce specific materials. Each part may also have its BOM structure, resulting in a multi-layer product structure tree. For

1. Modify the hosts record of the Client Server192.168.1.240 Rac01194251.241 Rac02192.168.1.242 Rac01-vip192.168.1.243 Rac02-vip108.88.3.240 Rac01-priv108.88.3.241 Rac02-priv2. Create a New Tnsname record editing client: tnsnames. ora file, which is

The data in the Top Ten List is stored in the table fnd_user_shorttop_objects. The data is read from the table during login and displayed. When the user exits, the following APIs are used: FND_SIGNON.UPDATE_NAVIGATOR updates the new TOP Ten List to

Since MySQL 5.5, the INNODB engine can also be compressed like the MYISAM engine. Of course, the compressed table is okay. You should not INSERT or UPDATE it. DELETE doesn't matter. It's just MARK, and then batch DELETE it. This is the same as the

Create index "DATACORE". "ZZB_1104_INDEX" ON "DATACORE". "ZZB_1104"("DATA_DATE ","KMDH ","JGDH ","HB")PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 3145728 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0

Today with PL/SQL 9 (the latest version) of the green Chinese cracked version, found in the execution of the query: select user_no account from lack_charge statement in the user_no error reported, the error is ORA-00911: invalid character (invalid

The following error occurs in the database of the latest User:Ioctl ASYNC_CONFIG error, errno = 11 The environment is as follows:HP-UX 11.31, Oracle 10.2.0.5.7 Metalink:Applies:Oracle Server-Enterprise Edition-Version: 9.2.0.1 and later [Release: 9.2

Slave_IO_State: Wait for the master to have an event Master_Host: current master server host Master_User: the current user used to connect to the master server Master_Port: current master server interface Connect_Retry: current value of the

Share a small case: Today, a cache buffers chain appears in a database, and the application has not changed recently. How can this happen suddenly? Of course, latch: the function of the cache buffers chain is to Find data in the database cache.

Recently, when a product is installed and deployed for the first time, the background throws the following exception: Caused by: java. SQL. SQLException: Schema 'root' does not existAt org. apache. derby. impl. jdbc. SQLExceptionFactory.

Mysql function GROUP_CONCAT GROUP_CONCAT () is a function provided BY the MySQL database, usually used with group by, For details, refer to the MySQL official documentation:

Oracle is not a good bowl of rice. There are many risks and suggestions.1. Incomplete recovery based on time points requires brainwashing of the control file, tearing up the account book (redo the log), and re-printing the account book. This is a

Back up data from host A to host B Mysqldump-uroot-p vw> vw. SQL Back up the database file and restore it to the target machine B. The database version of B is 5.5.23, And the mysql version of machine A is 5.0.22. Mysql> source/root/vw. SQL; .....

Oracle spatial creates a spatial field index, creates a field index, and completes an SQL statement instance. // Create a spatial field index for oracle spatial table// ================================================Drop index index_sp_v_gbjj;Drop

Content Demo level Query Hierarchical Queries) Reference Demo level Query The purpose of hierarchical query is to save the recursive code of the program. Writing recursion is always annoying. Assume thatScottUnder the user, useEMPTable-level

Learning Oracle is a complex and tedious process. In front of the vast array of official Oracle data, new features, MOS data, and a variety of Internal knowledge, we always feel powerless and overwhelmed. However, this is often the pleasure of our