Database Administrator

SQL code Select decode (INSTR ('initateaaaa FLOOR ', 'aaa'), 1) FROM DUAL The format of the INSTR method is INSTR (source string, target string, start position, matching serial number) For example, in INSTR ('upgrade FLOOR ', 'or', 3, 2), the

1. ORA-01102: cannot mount database in EXCLUSIVE mode Symptom: SQL> startupOracle instance started.Total System Global Area 1224736768 bytesFixed Size 2020384 bytesVariable Size 318770144 bytesDatabase Buffers 889192448 bytesRedo Buffers 14753792

Instance Design 1. Function DesignA graduate Enrollment System developed by a university requires the design of PL/SQL programs to process the examinee's Score data, the processing logic is to automatically classify the candidates into admission,

Oracle provides an interesting connect by clause, which can sort the branches with a family tree structure. It applies to the structure of organizations or companies, financial account code, and so on. To use query traversal, you need to store data

Perform SQL tracking in Oracle. It is estimated that most of them will use autotrace in sqlplus or set 10046 tracking. However, if you are debugging an application system, especially the system that opens the connection pool, the above two methods

Kingdee EAS7.0 is deployed in the latest LINUX and Oracle 64-bit environments. The configuration is complex: RedHat ENTERPRISE 5.4X64 configure Oracle 11gR2 step overview: 1. decompress the oracle_installation package. Zip. Copy the second

SQL> create tablespace test datafile 'y: \ test. dbf' size 20 M; The name of the actually created tablespace is TEST. Execute the following three commands to delete the tablespace: SQL> drop tablespace test; The tablespace has been deleted. SQL>

I. How to expand the linux swap spaceA) Login as the root user B) Type following command to create 512 MB swap file (1024*512 MB = 524288 block size ):# Dd if =/dev/zero of =/swapfile1 bs = 1024 count = 524288 C) Set up a Linux swap area:#

Operating System: CentOS 5.5 (1) install MySQL The most convenient way to install MySQL on this operating system is to use yum for installation: [Root @ localhost yum. repos. d] # yum install mysql-server (sometimes the network is slow, it will take

Problem:Org. postgresql. util. PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.Solution: Edit/var/lib/pgsql/data/postgresql. conf fileChange# Listen_addresses = '

RMAN retention policies are related to data integrity. Therefore, they are important and set based on user-defined data recovery tolerance. That is to say, based on the recovery needs, the user needs to retain data for several days, or the user

System Environment: Linux CentOS-6.4-64bit During the MySQL setup process, the default Root account can only be accessed from the local machine. If you want to access the MySQL database on Linux through other machines, you must make some

Because apache of this project is only used to download the function and install phpAdmin to find the database, and Mysql 5.6 has been installed before, it is directly installed using the yum command method during deployment. However, when using

Today, the leader asked me to install mysql in the production environment using a compilation-free method, so I had the following content. The directory involved in it has been processed. Please modify it as needed! 1. Download the mysql compilation-

Oracle encountered a problem: after entering the user name and password in PL/SQL, a title error occurred. I have not backed up all the database databases in a project, and there is still a lot of data, this won't let me reload the database. Think

You can use sqlplus to connect to an Oracle database and then use the database interactively. Another non-interactive method is to directly execute SQL commands through shell, which can be directly executed on the shell CLI port or through shell

A problem occurred on the contact marketing platform a few days ago. Ask a colleague to help solve the problem. The result is two days later and the problem is still not located.We still need to solve the problem near the Spring Festival. We have

1. Upgrade Grid Infrastructure1.1 prepare 1.1.1 software before Upgrade   Needless to say: Download, upload to server, decompress  1.1.2 create a new HOME for GI Mkdir-p/u01/app/11.2.0.4/grid Chown-R grid: oinstall/u01/app/11.2.0.4 Chmod-R

1. Full backup database, and the Backup Type is specified as backupset RMAN> backup as backupset database; Starting backup at 13-FEB-14Using channel ORA_DISK_1..... 2. Back up the users tablespace again and specify the Backup Type as backupset. RMAN>

Environment:Platform: RedHat EnterPrise 5.8 X86_X64Database: Oracle EnterPrise 11.2.0.3Cluster software: Oracle grid 11.2.0.3 Fault symptom:An archive failure occurs in the database, and an instance of one node is HANG dead. The log information is