Oracle

As we all know, in a RAC environment, the kill Ocssd.bin process can cause the host to reboot.But sometimes the system has been abnormal, and CRS can not shut down normally, and the host may be a few years without restarting the old system, no one

Today is going to review Oracle, Oracle was previously installed, reinstall the system, probably reinstall the system to its impact on it, in the service table found no Lister the item. Oracle was then reinstalled for insurance purposes. Configure

TRANSLATE is a superset of the functionality provided by REPLACE.  Syntax: TRANSLATE (STRING,FROM_STR,TO_STR) parameter 1:string, original string parameter 2:from_str, string parameter  3:to_str that needs to be replaced, used to replace

SQL turning is a tool in the Quest Central software produced by Quest Corporation. Quest is an integrated, graphical, Cross-platform database management solution that can manage Oracle, DB2, and SQL Server databases simultaneously. Introduction to

First, the problem appearance:Java.sql.SQLException:Io exception: Got minus one from a read callAt Oracle.jdbc.driver.DatabaseError.throwSqlException (databaseerror.java:112)At Oracle.jdbc.driver.DatabaseError.throwSqlException (databaseerror.java:14

In the banking, financial and other sensitive to the digital requirements of the system, the digital display generally have strict requirements.This is a requirement, title, which requires numbers to be displayed in two decimal places, and if there

Oracle NTP check Error./runcluvfy.sh Stage-pre Crsinst-n Oracle57,oracle58-verbose[10:06:58] Verifying Network time Protocol (NTP) ... FAILED[10:06:58] prvg-1063:configuration files for more than one time synchronization service[10:06:58]were found

12C Oracle Data Guard Repository Today exception2018-07-05t21:31:32.291970+08:00GEN0 (ospid:75371): Terminating the instance due to error 4722018-07-05t21:31:32.293376+08:00System State Dump requested by (Instance=1, osid=75371 (GEN0)),

Milliseconds converted to dateSELECT To_char (1406538765000/(+ *) + to_date (' 1970-01-01 08:00:00 ', ' yyyy-mm-dd HH:MI:SS '), ' Yyyy-mm-dd HH24:MI:SS ') as CDATE from DUAL;Date conversion millisecondsSELECT To_number (to_date ('

I do not know if everyone in the Win7 64-bit system with PB to connect to the Oracle database, have encountered "Oracle library Oci.dll could not be loaded" issue.Consulted a lot of people, (they are said to be my PB and Oracle did not install well,

Oracle defines string types VARCHAR2 and char specify the length of the usage as follows:VARCHAR2 ( ) is a number between 1~4000 that represents up to 4000 bytes of storage space.char ( ) is a number between 1~2000 that represents up to 2000 bytes

declare type t_indexby is table of number index by binary_integer; type t_nested is table of number; type t_varray is varray(10) of number; v_indexby t_indexby; v_nested t_nested; v_varray

This article explains how to create a database silently and how to install the OEM 13C silently.First, OEM database creation1, Oracle official download oem13c, the file list is as follows:12.1.0.2.0_database_template_for_em13_1_0_0_0_linux_x64.zipem1

Original source http://bijian1013.iteye.com/blog/1895412 the difference between the for update and for update nowait First of all, if only select, Oracle will not add any locks, that is, Oracle to select There is no limit to the data read,

Transferred from: http://blog.itpub.net/628922/viewspace-759245/Do not need to register, directly copied to thunderbolt or other download software can be downloaded.Oracle 11.2.0.3:Linux x64:https://updates.oracle.com/orion/services/download/p1040453

For years and Days "Day" is a single-digit case, the processing is not the same, ' YYYYMMDD ' format is not a problem, and the format ' yyyy-mm-dd ' form is not, please see:Sql> alter session Set Nls_date_format = ' Yyyy-mm-dd hh24:mi:ss ';Session

The CHR function returns: A String that contains the characters associated with the specified character code.Chr ("0") is a 0 characterCHR ("1")CHR ("2")CHR ("3")CHR ("4")CHR ("5")CHR ("6")CHR ("7") bellsCHR ("8") back latticeCHR ("9") tab

Recently took over a project where the server-side database is Oracle 11g 64-bit. Because the main job is not development, and do not want to install a large Oracle database on their own computers, it is thought that only through the database

 1. RAC global wait Event Description In the RAC environment, the most common wait events related to global cache adjustment are global cache Cr request, global cache busy, and equeue.   When a process needs to access one or more blocks, Oracle