Database Administrator

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 =

1. Modify the dbstart script:$ Vi $ Oracle_HOME/bin/dbstart# ORACLE_HOME_LISTNER =/ade/vikrkuma_new/oracleORACLE_HOME_LISTNER = $ ORACLE_HOME 2. Modify/etc/oratab in the following format:$ Vi/etc/oratabSID: $ ORACLE_HOME: Y3. Modify/etc/rc. local to

1. Copy the cold backup data files, log files, and control files to the target folder. 2. Create a pfile of init: $ Oracle_SID.ora, which can be copied from the template in the samples folder. 3. Modify the control_files parameter of the pfile and

1. Install mysql1. sudo apt-get install mysql-server mysql-client (A window pops up asking for the mysql root User Password during the installation process) 2. Once the installation is complete, the MySQL server should be started automatically. You

To install Oracle in a virtual machine Linux: Step 1: copy the oracle Installation Software to the Linux environment. The specific steps are as follows: in/etc/samba/sam. configure the shared directory in conf. First, you need to create a new folder

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

A system suddenly loses power, and Oracle cannot be started after the system is started. The following error is reported during startup: ORA-01102 cannot mount database in EXCLUSIVE modeError 1102 may be caused by the following possibilities: 1. In

PL/SQL is a block structure language. The block consists of the definition part, execution part, and Exception Handling part. Syntax structure: Declare /* * Definition: used to define variables */ Variable name variable type V1 varchar2 (10 )

In Oracle databases, varchar2 (4000), a large amount of content, is often helpless. In this regard, we often use large objects for storage (clob), but because the jdbc driver does not support CLOB well, it is often very troublesome to use hibernate

Because there is no description of the software package in rh5 in Oracle10.2 official documentation, the installation is based on the AS4 package, but the following error is returned today to help you get an error when downloading 10 Gb in RH5: /tmp/

In the previous article, we mentioned hot standby (), which is to back up data when MySQL or other database services are running. This article shares another backup method, that is, hot copy. Hot copy is similar to hot backup, but hot backup uses

How to access the Oracle database using the ADO engine: Define the database header file as CDBOperation. h # Pragma once# Import "C: \ Program Files \ Common Files \ System \ ADO \ msado15.dll" no_namespace rename ("EOF", "adoEOF"), rename

According to the morgo suggestion suggested by morgo, I did some small tests on the queries and datasets mentioned in Impact of column types on MySQL JOIN performance, but I found another problem: response time (aka MySQL versions ).The answer To

Oracle 11g linux 32-bit client Configuration First, attach your own integrated client download link: Oracle 11g client Linux-32bit Download from FTP No. 1 of the customer's home: ------------------------------------------ Split line -----------------

Oracle 11gR2 Single Instance database boot self-start 1. Change the N at the bottom of/etc/oratab to Y. 2. Modify $ ORACLE_HOME/bin/dbstart and $ ORACLE_HOME/bin/dbshut. ORACLE_HOME_LISNER = $ absolute path of ORACLE_HOME 3. added as a linux service:

1. Copy the table structure and data: Create table table_name_new as select * from table_name_old 2. copy only the table structure: Create table table_name_new as select * from table_name_old where 1 = 2; Or: Create table table_name_new like

The following error occurs when rman is used for restore: Channel c1: ORA-19870: error while restoring backup piece/u01/dbfull_03orat5q_1_1.bakORA-19502: write error on file "/u01/app/Oracle/oradata/aux/system01.dbf", block number 34304 (block size =

CURDATE () or CURRENT_DATE () Returns the current date, in YYYY-MM-DD or YYYYMMDD format. Contains only the year, month, and day Select curdate () + 0; Result: 20140214 Select curdate () + 1; Result: 20140215 CURTIME () or CURRENT_TIME ()Returns the

1. What is a NoSQL database? What is the difference between NoSQL and RDBMS? Under what circumstances do I use and do not use NoSQL databases? NoSQL is a non-relational database, NoSQL = Not Only SQL. Relational databases use structured data, while

When a DBA logs on to a local or remote database, it is common to log on to the database using the "sqlplus username/password @ Connection Service name" method to save time, if we replace Oracle SQLPlus with our own implementation, and record its