Database Administrator

Oracle static listener registration details There are a lot of articles on Oracle listening for static registration on the Internet, but most of them are just a simple introduction. There are no detailed examples. Here, we will combine Oracle 10gR2

Signalled during ORA-1031 Error message: ORA-1031 signalled during: create tablespace name datafile '+ data' size 10 M autoextend on next 5 M maxsize unlimited... Problem description In the newly deployed Oracle environment, a designer user needs

ORA-28001: the password has expired Oracle prompt error message ORA-28001: the password has expired, due to new features of Oracle11G, the default password expiration limit for Oracle11G User Creation is 180 days (6 months ), if the user password

Oracle uses regular expressions for four main functions Oracle Regular Expression functions: regexp_like, regexp_substr, regexp_instr, regexp_replace Oracle uses regular expressions for four main functions: 1. regexp_like can only be used for

Install MySQL WorkBench in CentOS 7 Install MySQL WorkBench in CentOS 7 Install MySQL Community Yum Source Wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm Rpm-Uvh mysql-community-release-el7-5.noarch.rpm 2. Install

ORA-12519 error process error After the system runs normally for one month, the following error occurs on the first day of the launch. After a long time, you have no idea. Later find the database listening exception, found that ORA-12519 rejection

Oracle configuration file Introduction Profile file or. bash_profile file (system-level environment variable file:/home/Oracle ); Oratab file (oracle self-run file:/etc/oratab ); InitSID. ora or spfileSID. ora file (database instance initialization

Introduction to Oracle instance recovery and flashback Instance recovery phase:1. data files are not synchronized 2. Roll Forward (redo)3. submitted and unsubmitted data in the file 4. Open the database 5. Roll Back (Restore undo) 6. submit data in

Oracle control file multiplexing 1. Oracle control file multiplexing 1. show parameter control-- View Control File InformationShow parameter spfile-- Check whether spfile exists.Create pfile from spfile;-- Generate pfileShutdown immediate-- Close

Create a tablespace in Oracle and test it with the user The Oracle tablespace is described as follows: Temporary tablespace: used for grouping operations when sorting large data volumes. Normally, these operations are completed in the memory, but

HP-UX install MySQL 1. Environment Introduction HP-UX B .11.31 ia64 Operating System Installation medium: mysql-5.1.48-hpux11.31-ia64-64bit.depot.gz 2. Installation Process (1) Create mysql users and user groups # Groupadd mysql # Useradd-g

Oracle Character Set Analysis There are many types of character sets. The first character set was ASCII. Since the number of characters supported by ASCII is very limited, many encoding schemes, such as Unicode, were introduced later. Unicode is a

Database Design-EAV (entity, attribute, value), eav entity There is such a business that is used by customers to record what they do every day. Because it is very professional, professional record books are required. There are more than 20 such

Chapter 3 Protecting the Data (2): Assign the column-level permission, chapterprotectingSource: Workshop Without the consent of the author, no one shall be published in the form of "original" or used for commercial purposes. I am not responsible

IT Ninja Turtles date review, it Ninja Turtles dateCalendar cal = Calendar. getInstance ();Cal. get (Calendar. DAY_OF_MONTH );Cal. get (Calendar. MONTH ); Cal. get (Calendar. YEAR ); SimpleDateFormat simpleDateFormat = new SimpleDateFormat

[DB] paradigm, db paradigm In my previous blog [DB] function dependency, I mainly explained what is function dependency and local and transfer dependency (FD ). When there is no FD, data redundancy is not possible in the Link. However, when the FD

[Oracle] The oraclepsu upgrade processThe following is the content in the PSU's readme file: 3.2 Patch Installation Instructions Follow these steps: If you are using a Data Guard Physical Standby database, you must install this patch on both the

Oracle NLS_DATE_FORMAT, nls_date_format Nls_date_format is used to modify the date format. Modify the session level: alter session set nls_date_format = 'yyyy-mm-dd hh24: mi: ss' Modify the Registry in windows: HKEY_LOCAL_MACHINE.SOFTWARE.ORACLE.

In linux, oracle10g lsnrctl does not respond to sqlplus normal bug4518443, oracle10glsnrctlSymptom Description: The oracle version used is 10.2.0.1.0 in linux. If lsnrctl status is entered on the command line interface, no response is returned. If

Oracle Performance Analysis 9: Re-indexing and oracle performance re-Indexing When an index is faulty, it may cause serious performance problems. index problems include index unavailability and index fragmentation leading to performance degradation.