Database Administrator

I set up an nginx and mysql platform. I just created it and it was inconvenient for mysql not to use phpmyadmin. I took the previous source code and thought it would be okay to modify the database user and password. The phpMyAdmin page displays:

Two types of Oracle Database initialization parameter files:File: initsid. ora spfilesid. oraPath: $ ORACLE_HOME/dbs Differences between plain text parameter files and binary parameter files:1. Modify parameters in different ways: When initsid. ora

Oracle DBLink script -- Drop existing database linkDrop database link DBLink name; -- Create database linkCreate database link DBLink nameConnect to remote database username identified by passwordUsing '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =

A database trigger is a storage subroutine associated with a data table, view, or event in a database. For example, we can enable the Oracle database to automatically activate a trigger before or after an INSERT, UPDATE, or DELETE expression affects

Linux Oracle 9i The maintenance personnel reported that the database could not be connected. The phenomenon was: tnsping could be connected, but sqlplus could not be connected. If no error was reported, it was always there. The foreground

Platform: CentOS 5.3, Oracle 10.2.0.1Plan: db_name = risotest. You can also use risotest for the global database name. The directory structure is roughly divided into the following structure: You can do whatever you like: You need to have a concept

RunSelect NUM_ROWS, table_name from user_tables where NUM_ROWS> 0, Can achieve the effect.However:Sometimes the data is inaccurate because the table must be analyzed before the query is executed.The analysis table syntax is: analyze table table_name

Environment: Oracle 10g In the first place, we came into contact with the pascal Language. Therefore, sometimes we do not like the C language syntax very much.There is a lazy way of writing in C Language (also exists in java), probably like this:

-- The output parameters cannot be modified. There are two solutions:-- 1. Change the parameter to the input parameter.-- 2 is to change the parameter to an input/output parameter;Three methods of calling Process1 is to use callWhen you use the call

The mysqlreport tool is a perl script. To run the script properly, you must install databases such as DBI and DBD-mysql. The current version is 3.5. The following describes the application of the options: -- User USER: user name used to connect to

MySQL's Table xxxx is read only error often occurs on a Linux host. After checking a lot of information on the Internet, I finally found that it is essentially a permission problem. To solve this problem, you must first add the writable permission

The following are examples of Oracle knowledge points. User Logon (switch the user name and password to log on ): Sqlplus/nolog Connect/as sysdba 1. Users 1. Create a user (example) Create user olay identified by 123; 2. delete a user (delete

Java calls Oracle functions. A function is essentially a stored procedure that returns a result. This example shows how to call functions with in, out, and in/out parameters. Similar methods. CallableStatement cs;Try {// Call a function without

Before leaving work today, I suddenly received a call from the Bureau asking for a detailed call record for June October. Then, the entire table is started and the extracted records are inserted into the detail table. Now, we can delete tens of

Hash Join Process An example is provided to illustrate SQL _ID gtmmr9gaxqhfr, child number 0-------------------------------------SELECT/* + USE_HASH (d e) */e. ename, d. dname FROM emp e, dept d whereE. deptno = d. deptno Plan hash value: 1123238657

In fact, it is very simple to create an Oracle password file, but to prevent you from forgetting it, record it. Orapwd file =/u01/app/oracle/product/10.2.0/db_1/dbs/orapworacledb password = oracle entries = 10 [Oracle @ oracle10g dbs] $

When a latch free problem occurs, kill the session at that time, report that the session sid does not exist, and kill it at the OS layer, however, the session Status shown in v $ session is still active! This is a silent problem, but it is a test

Explanation of Incomplete recovery In the previous article (loss of the UNDO tablespace caused by RMAN backup and recovery), we talked about how to deal with the loss of the UNDO tablespace. The UNDO tablespace cannot be taken offline. Similarly,

Installing MySQL on Ubuntu is very simple. You only need to open the terminal and run several commands. 1. sudo apt-get install mysql-server 2. apt-get isntall mysql-client 3. sudo apt-get install libmysqlclient-dev During the installation process,

Oracle's verify_function_11G function only makes the password look difficult to guess through some password rules, but some users' habits make the password complex, but it is not difficult to guess, in this case, you can use the program I wrote to