Database Administrator

Type is a database object structure that we often use. In practice, we can define the type separately and then use it in PL/SQL code or data tables. In an accidental opportunity, I found that the use of the Type is troublesome in data exp/imp. When

In windows, proc does not support access through the parameter list, but in Linux, it does! Void insert_sale_to_db (float tm){Exec SQL WHENEVER SQLERROR GOTO ERROR;Exec SQL INSERT INTO SALE VALUES (: tm );Exec SQL COMMIT WORK;Return; ERROR:Makelog

1. Oracle client Configuration 1. find the oracle installation directory → db_1 → NETWORK → ADMIN → modify the listener. ora file and tnsnames. open ora notepad and check whether the host is the host name of the current computer. If not, change it

This error occurs. IMP-00003: encountered Oracle error 1659 ORA-01659: cannot allocate MINEXTENTS more than 6 (in tablespace DATA) IMP-00017: The following statement failed due to ORACLE error 1659: After checking the information, it turns out that

/Etc/my. cnf Configuration [Mysqld]Datadir =/var/lib/mysqlSocket =/var/lib/mysql. sockUser = mysql# Default to using old password format for compatibility with mysql 3.x# Clients (those using the mysqlclient10 compatibility package ).Old_passwords =

Environment: OS: Red Hat Linux As 5DB: 11.2.0.1 11G has greatly improved the volume uard, the slave database can still apply the archive logs uploaded from the master database. Remember to open the slave database to check whether the data has been

1. Reduce the control file. If a control file is corrupted, we need to remove the corrupt control file. Steps:1. Modify the parameter file and verify2. Stop the database3. Start the database4. Verify and view v $ controlfile The following is the

Summary of Oracle listener problems: 1) Oracle listeners cannot be started normally after the system is shut down and restarted abnormally. You can manually modify the settings and use static registration listening:For example:# Listener. ora

Recently, we have used arcplan for reports. When we need to display data at different date granularities, it is easier to use SQL statements to directly query data from the database. It is highly reusable and recorded. Annual granularity: displays

Install EBS All are modified using the root user. 1. Create the user's specified Oracle user directory/export/home/oracle 2. Create a user group dba; 3. Add oracle to the dba group; 4. Modify the host file backup hosts. bak Cd etc/inet Increase in

Today I encountered a problem: Oracle's OracleOraHome90TNSListener service cannot be started now, It can be started normally before, but now it is an error: OracleOraHome90TNSListener service cannot be started on the local computer. The message

1. Fault Cause Use ruby to permanently delete all tables under the ql user, and the recycle bin does not exist. Therefore, the use of "flashback table" is invalid; Flashback database is disabled; Only recovery through media is supported. 2. Use RMAN

(1) Multiple Oralce databases can be installed on one computer. (Instance), their SID cannot be the same (2) You can install multiple identical SID Oracle Database (Instance) (3) In the same network The global database name must not be the same

1. Environment Introduction Site Unique_db_name Primary 192.168.1.102 Stydb Physical standby 192.168.1.101 Ql SQL> select protection_level from v $

Here we mainly verify the storage of null values of the number and varchar2 data types. First, we will introduce the structure of row piece. Reference A structure chart of the official document Generally, a rowpiece excluding (cluster table and

MySQL remote Incremental Backup: #! /Bin/sh    # MySQL Info Sqluser = root Sqlpsw = root /Usr/bin/mysqladmin-u $ sqluser-p $ sqlpsw flush-logs --Default-Character-set = GBK DATADIR =/data/mysql BAKDIR =/home/backup/mysql/daily TEMPDIR =

Mysql database read/write splittingI. Mysql database installation (skipped here)2. Mysql master-slave replication. The master server is A: 192.168.5.31, And the slave server is B: 192.168.5.32.1. Operations on master serverLog on to mysqlMysql-u

1. Write an SQL script Compile the SQL Execution script that DB2 needs to execute and place it on the AIX server. The following is an example of crontest. SQL: Connect ToTemUserDb2admin using db2admin; Call P_TEST (); 2. Write the sh execution

1. Modify the/etc/oratab FileDb1:/home/Oracle/product/11.2.0/db_1: Y$ ORACLE_SID: $ ORACLE_HOME: Y2. Modify the Startup File $ ORACLE_HOME/bin/dbstart.Change ORACLE_HOME_LISTNER = $1 to ORACLE_HOME_LISTNER =/home/oracle/product/11.2.0/db_1.3. Modify

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