Database Administrator

1. The insert format is. /** * Write a time Method */ Public staticStringgetStringDate (){ Date d = new Date (); SimpleDateFormat sdf = new SimpleDateFormat ("yyyy-MM-dd "); Return sdf. format (d ); } Insert: Art. setArtAddTime (java. SQL. Date.

Single-instance Environment Vmware Server 1.0.6 + CentOS 5.2 + Oracle 10g 1. Stop the process 2. Install patches 3. Upgrade the database 1> stop all Oracle-related processes [Oracle @ node2 Disk1] $ emctl stop dbconsole [Oracle @ node2 Disk1] $

The configuration file of the newly added tablespace mainly uses this parameter.Test EnvironmentInnodb_data_file_path = ibdata1: 370 M; ibdata2: 50 M; ibdata3: 50 M; ibdata4: 500 M; ibdata5: 500 M: autoextend There are several situations1. During

If the web and database are not on the same server, the MySQL server must allow remote connections to run the website properly. There are two ways to set the remote connection of MySQL: 1. Change the table. It may be that your account is not

Today, we need to uninstall Oracle 10.2.01 in the lab room, and then install Oracle 10.1.03. It took a long time to unmount the database because of lack of experience. At last, we had a great sense of accomplishment. Log on to the system as the

1) Q: the following error is reported when you telnet to a SUN machine: No utmpx entry. You must exec "login" from the lowest level "shell ". After I have done the following: Cd/var/adm Mv utmpx utmpxbak Touch utmpx Telnet returns to normal. When

The first time I met Oracle, I sorted out some simple and practical solutions. Confirm orcale Recognition-it is a annotator, not recognized # Length () is a string length function, not len () Table Dual: system table, with only one option

1. Ensure that the system users you log on to have sufficient permissions. Windows: add your users to the Oracle DBA Group. Use root to log on to UNIX. 2. Run sqlplus/nolog in command 3. Enter the conn/as sysdba after the SQL> command If the

1. First, add the scheduled task to the list. The system scans the task list every minute to check whether the task is to be executed at the current time. /etc/crontab:  # m h dom mon dow user    command    0 1  *   *  *   root    /home/fzw/

By default, after PHPMyAdmin is installed, the information_schema database is displayed no matter what account you use to log on to the database. However, you cannot perform operations on the database. You can only view the database, this database

Method 1 for Oracle to implement the fibonacci series: Select replace (MAX (SYS_CONNECT_BY_PATH (fib | ',', '/'), '/', '') | '...' fiblistFROM (SELECT n, fib, ROW_NUMBER ()OVER (order by n) rFROM (select n, round (1 + sqrt (5) * 0.5, n)-power

When installing Oracle in Linux, swap is insufficient. solution: Root User 1. Add a file system (The following is an example of adding a file system of MB) Dd if =/dev/zero of =/home/oracle/myswaps/swapfile1 bs = 1 M count = 512 Note: The path

Because a large amount of data exists in text files and needs to be imported to Oracle, we are lucky to have access to the arms SqlLoader. Run the sqlldr command on the host where Oracle is installed.Sqlldr You will see instructions on this tool:

One of the daily work of the system administrator is to upgrade the service, add a patch for the service or upgrade some fancy functions. In early 2013, the latest MySQL 5.6 was released with the goal of providing better performance and scalability.

1. Create a databaseMysql> create database if not exists tongcheng;Query OK, 1 row affected (0.01 sec)Mysql> 2. view the options when creating a databaseMysql> show create database tongcheng;+ ----------- + -------------------------------------------

1. Create a table with an empty eygle 2. Create a user's eygle, which belongs to the eygle tablespace; grant the user the DBA permission 3. log on to the database as an egyle user and create the table test_egyle. 4. rman backup the egyle

In recent times, many netizens raised questions about Listener Configuration, and the Client cannot connect to the Server ). This article briefly introduces the Listener Configuration, provides detailed configuration methods for PL/SQL Developer to

The experiment is divided into two steps:1. LMT local management of tablespaces, ASSM automatic segment management when the data file structure analysis Oracle 11G: 0 operating system block, 1-2 is the file header, 3-127 is the bitmap information.

System Environment: Oracle Linux 5.5 x64 bit; Oracle version: Install Cluster and OracleSoft 10.2.0.1 (do not create instances), and upgrade Cluster and OracleSoft to 10.2.0.4; When dbca is used to create a database, the database stops at 88% and an

A foreground SQL statement is simplified as follows:SELECT products_name, products_viewed FROM 'products _ description'Order by products_viewed DESC, products_name LIMIT 0, 20; This statement often appears in large batches in slow logs! A