Oracle

The scenario is to use the Oracle Instant Client:Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.htmlStep One:Download the corresponding instant client version to the official Oracle website and download the basic

Execute on Node 1 (CRYDB01):[[email protected] app]# chown -R oracle:oinstall /u01/app/oracle80 MB. 985 MB 150 MB. 1905 MB 256 colors. 16777216 PassedPreparing to launch Oracle Universal Installer from /tmp/OraInstall2015-02-13_01-49.

Two different ways:Thin is a thin client connection that does not require an Oracle client to be installed, and only requires a JDBC-driven jar package in the classpath. Thin is a purely Java-written Oracle database provider.OCI is a way for a rich

Decode function usage in OracleMeaning explanation:Decode (condition, value 1, return value 1, value 2, return value 2,... Value N, return value N, default value)The function has the following meanings:IF condition = value 1 ThenRETURN (translation

Sql> SetAutotraceusage:SETAutot[RACE]{OFF | on |TRACE[ only]}[Exp[lain]][Stat[istics]]sql> SetAutotrace onSP2-0618: Cannot find the Session Identifier.CheckPlustrace role isenabledSP2-0611: Error EnablingSTATISTICSReportsql>Conn/

How to connect to Oracle remotely with Plsql on a computer that does not have Oracle installedDownload Instantclient, my is WIN7, download is Instantclient-basiclite-nt-12.1.0.1.0.zipUnzip to a fixed directory such as C:\instantclient_plsqlCreate a

Use of packages in OracleThe use of packages is primarily to implement the modularity of the program, the package can be related to the stored procedures, functions, variables, constants and cursors and other PL/SQL programs together, in this way

Recently encountered a case:Status: HP-UX operating system, Oracle 10.2.0.4 RAC, MCSG mode, 2 OCR and 3 voting disk each correspond to one LV in the same concurrent volume groupPurpose: To mirror shared storage, the technology used is HP's own HP

First, background:The specific scenario is that the database is not an ordinary OLTP system, more like an OLAP system, the data update frequency is very low, operating in the Noarchivelog mode, real-time requirements are low, but only one copy of

Today, the customer gave me a table from the ORACLE11G database to export a data file to me, the file suffix is dmp file, I put DMP file into our business database error, and later on-line check is due to the Oracle database version inconsistency

@echo off Echo ================================================ Echo automatic backup script for Oracle database in Windows echo 1. Use the current date to name the backup file. Echo 2. Automatically delete backups up to 30 days ago. echo ===========

Oracle Database user manages Oracle permissions settingsFirst, the Classification of rights:System permissions: The system specifies the user's permission to use the database. (System permissions are for users). Entity permissions: A permission user'

Oracle SQLLDR Use (fast import, but weak handling of the data itself)Blog Category: Db. Oracle Oraclesql Sqlload.cmdSQL code Pause Sqlldr user/[email protected] control.ctl skip=1 rows=2000 bindsize=8192000 Pause

Crontab-eNo crontab for root-using an empty oneCrontab:installing New Crontab"/tmp/crontab. Jkmaak ": 1:bad minuteErrors in crontab file, can ' t install.Want to retry the same edit?Enter Y or NWant to retry the same edit? YCrontab:installing New

Add Standby LogMain Library parameter file:crm.__db_cache_size=8254390272crm.__java_pool_size=33554432crm.__large_pool_size=33554432Crm.__oracle_base= '/u01/app/oracle ' #ORACLE_BASE set from environmentcrm.__pga_aggregate_target=3288334336crm.__sga_

Get all the hours in a whileSELECT to_date (' 2013-07-01 ', ' yyyy-mm-dd hh24 ') + (ROWNUM-1)/sdate from dualCONNECT by ROWNUM Get all the days in a whileSELECT to_date (' 2013-07-01 ', ' yyyy-mm-dd ') + ROWNUM-1 sdate from dualCONNECT by ROWNUM Get

There has been no contact with Oracle database before, and recently the company has a project that needs to be used, so start tossing Oracle. Just started to go a lot of detours, in order to help more and I just started to contact Oracle's small

OracleRAC rebuilding OCR and Votedisk   Environment:OS: redhat 5.8DB: Oracle 10.2.0.5 raw device We need to develop the habit of backing up ocr and votedisk frequently. However, ocr and votedisk can be rebuilt without backup. It is like a control

[ORACLE] Methods for adding and deleting disk members in an ASM disk Step 1: Disable the database shutdown immediate Step 2: Check the mounting diskgroup status of the dg. SQL> show parameter diskgroup Alter diskgroup dgdata mount; Step 3: view the

Automatic backup script for Oracle databases in Windows @ Echo off echo ============================================ ================= echo in Windows environment, the Oracle database's automatic backup script echo 1. use the current date to name