Database Administrator

An error is reported when dbca is executed after Oracle is installed; Sh:/bin/ksh: Nosuch file or directory We suspect that the ksh package is not installed, and yum installksh Done! File "/etc/oratab" is not accessible It turns out that the root.

Class op_log (models. Model ): Op_date = models. DateTimeField (auto_now = True) Op_log = models. CharField (max_length = 2000) Class op_log1 (models. Model ): Op_date = models. DateTimeField (auto_now_add = True) Op_log = models. CharField

System Environment: CentOS release 5.10 Application Environment: Oracle 10.2.0.5 + php5.2.17 Hard parts: DELL R720, 1 T * 3 7200r, raid5 Business Environment: sqlload is written into the database every five minutes for effective data within five

When logging on to the Oracle Management Server according to the document, the first login is successful. If you log on again after shutdown, the following error may occur: domain name resolution error or login denied error. The error is because the

Symptom: Oracle GridInfrastructure 11gR2 is installed on a single instance database for creating ASM for the standby database. However, the Create asm gui is displayed after you log on to the grid user to execute the ASMCA command, an error occurs

MongoDB has been widely used as a NoSQL Database in recent years. More and more enterprises are trying to use MongoDB instead of the original Database. MongoDB also performs well in clusters, sharding, and replication. I will introduce various

Let's take a look at a problem today.Environment Introduction:Gi version: 11.2.0.4.0Database version: 11.2.0.4.0Oracle linux: Linux Server release 6.4RAC dual-node ASM + restart-alone ASMProblem description:When you start the standby database

Redis is very easy to use, but it is still troublesome for people who are used to relational databases. Especially for a hash key, they want to obtain all the feild domains, there is no direct interface officially, but it can be implemented through

Oracle databases have many objects, such as tables, views, indexes, functions, triggers, and stored procedures. Table, the most important object in the database If the data size of a table is large, you can consider the Oracle partition table to

It is found that there are many problems if the character is poor and the fstab is written incorrectly at night. As a result, the system cannot get up. Because the fault was not handled at the time, I found several images online, general

Oracle clears table data during storage 1. Specify the table name for data clearing Create or replace procedure storage nameAsBeginExecute immediate 'truncate table name ';Execute immediate 'truncate table name ';Commit;End; 2. The following is the

In the first quarter of 2014, the PSU update mainly includes three versions: 12.1, 11.2.0.4, 11.2.0.3, and 11.1.0.7. In the 2nd quarter, Oracle will release version 12.1.0.2, and version 11.2.0.4 will also be the ultimate version of version 11.2,

There is a name field in nearly 10 million data tables that stores Chinese names. Currently, You need to perform fuzzy search for data based on the name field. The general practice is to create a B * tree index for the name field, the query uses

Today, I used PL/SQL to connect to the server without any response. I can log on to the server and connect to sqlplus directly. Then I found that the lsnrctl status is always connect. Try shutdown immediate and stop there. You can only use shutdown

Problem description: This prompt appears after Mysql is installed in Ubuntu. Setting mysql-server-5.5 (5.5.27-0ubuntu2)... start: Job failed to startinvoke-rc.d: initscript mysql, Action "start" failed. dpkg: error processing mysql-server-5.5 (--

Start an Oracle database instance in Linux: Step 1: Start the listener; Step 2: Start the database instance.I. How to start a database instance1. Go to sqlplus to start the instanceSu-oracle -- "switch to oracle user"Lsnrctl start -- "enable

Recently, developers are creating data for the company. The DBMS_RANDOM function is used for random data ranges. This function can not only create random numbers, but also randomly create dates and characters. DBMS_RANDOM is in the position of

In actual development, connect by can replace the cyclical code in plsql or java to improve development efficiency. The following is a problem I encountered during my work Usage of Oracle CONNECT Oracle recursive start with... connect by prior

Full recovery: only the corrupted data file is restored, and the file is restored independently. The log Sequence starting from the backup to the current log sequence cannot be reduced. Passive Incomplete recovery: one or more log sequences

My operating environment: Oracle database rdbms 11g rac on OEL5.5View the voting disk and ocr information:[Root @ rac1 bin] # pwd/U01/app/11.2.0/grid/bin[Root @ rac1 bin] #./crsctl query css votedisk# STATE File Universal Id File Name Disk group-----