Oracle

Problem: Dataguard cannot apply redo Log,alert without any error message.Symptom: Oracle RAC node alert has no error message and the other section reports the following errors.Thu Mar 15 15:26:22 2018Error 1017 received logging on to the

Learn from:http://blog.csdn.net/condywl/article/details/571296961. Modify the configuration file under root user/etc/oratabvim/etc/oratab Content: # This file isUsed by ORACLE utilities. It iscreated by root.sh# and updated by either Database

An Oracle database server includes:1. A physical database that stores Oracle data, which is a series of physical files that hold Oracle database data, including control files, data files, log files, and other files.2. Oracle instance: This is a

(1) Oracle Extract () function introduced from Oracle 9i to intercept a specific part from a date or interval type, syntax: Extract ({year | month | day | hour | minute | seco nd} | {timezone_hour | timezone_minute} | {timezone_region |

1. Create userYou need to log on to the database with the system user first because the system user has permissions to create other users.syntax [Create users]: Create user username identified by password [i.e. password];Example: Create user dhjw

Today after modifying the database parameters, shut down the database and CRS, and then restart the server, after the server started, the discovery database can not start, the process is as follows:Step1: Restarting the database Su--su-/grid/11.2.

1. In idea, the JSTL library is imported into web-inf/lib and can be directly on the JSP page via thetaglib uri= "http://java.sun.com/jsp/jstl/core" prefix= "c"% >taglib uri= "http://java.sun.com/jsp/jstl/sql" prefix= "sql"% >Import, you do not

Import data exported from an Oracle database into a MySQL database1. Import to the MySQL database using the default closing symbol:LOAD DATA LOCAL INFILE ' d:/oracle.txt ' IGNORE into TABLE alarmlogThe Terminator in fields now defaults to the '/t '

--------------------------------------------------------------------------------xqp 20180209 begin --find related records about this delivery order, traverse --A shipping number may consist of multiple Kanbans,

从事数据库相关工作已经十几年了，是因为自己内心的执着，一直执着于从事的oracle数据库的相关工作。我是从erp起步的，从技术难度上来说erp的开发不是特别难，数据库的数据量也不是很大，可以作为刚步职场的一个过渡阶段。如果从事erp开发，核心要掌握的就是存储过程的编写，因为大部分公司写后台都是用的存储过程，同时做erp开发的话如果感兴趣的话可以多学习些数据库设计发面的内容，比如表的设计，表与表关系的设计，可以画e-r图，也可以画系统流程图来梳理系统业务。目前感觉大的erp公司对开发者需求不多，比

In the modern multi-user multitasking system, there will inevitably be multiple users accessing a shared object at the same time, this object may be a table, row, or memory structure, in order to solve the data security, integrity and consistency of

Oracle Log Full system disk is full, causing the database to hang up and the Archivelog log is full, but the database is not open, unable to login, fortunately, can also go to Mount state. Workaround:1. According to the error View appearance: CRS

Introduction to Oracle Stored Procedure instances and oracle Stored Procedure instances This document introduces the stored procedure through the imported table. The difference between stored procedures and functions is that functions can only be

How to change the user password in oracle ORACLE Database System is a group of software products with distributed databases as the core provided by ORACLE. It is currently the most popular CLIENT/SERVER) or one of the databases in the B/S

Explain Oracle subqueries, set operations, data processing, transactions, RowNum instances, and rownum instancesSubquery Explanation: A subquery is a nested query statement in a query statement. The condition for a primary query is subquery.Case

Oracle Stored Procedure syntax and compilation process explanation, oracle Stored ProcedureSyntax CREATE [ORReplace] PROCEDURE [schema.] procedure_name [(argument [{IN | OUT | INOUT}] datatype ,... argument [{IN | OUT | INOUT}] datatype)] {IS | AS} [

Data Pump expdp and impdp backup and restoration/restoration of Oracle Database (detailed process), expdpimpdp Note: There are many ways to back up and restore the oracle database. This article only describes how to back up and restore the database

Oracle Study Notes-NVL () function usage skills, learning notes-nvl 1. Rules for alias columns: special characters (except # $), numbers, and spaces must be added with double quotation marks; Chinese characters can be added with double quotation

After Oracle OAM enables single-point logon, you can view the number of currently logged-on users. oracleoam Background: After a project is launched, especially portal projects, it is often required to count the number of online users. How can we

Create a tablespace in oracle Four steps: describes how to create a tablespace. Note:1. If you open it in PL/SQL or other tools, directly modify the [italic bold part] in the following code to execute2. Make sure that the path exists, for example,