Setting Oracle instance and listener services from the start 1. Increase startup script touch / etc / init.d / orcl vi orcl #! / Bin / bash # Whoami # Root # Chkconfig: 345 51 49 # / Etc / init.d / orcl # Description: starts the oracle dabase deamons ...
Is due to: db_16k_cache_size caused the initial set is too small. Through the command: SQL> show parameter db_16k_cache_size; view. Modify db_16k_cache_size set by the command: SQL> alter system set db_16k_cache_size = 34603008; Then re-create ...
2008-12-04 | sqlplus little secret Dbms_output.put_line will have to "eat up" the top of the box and distress? (I previously had a very troubled to preserve the space, try add ".", Plus invisible characters and so on, but eventual ...
1: First of all, switch to the system administrator sqlplus 2: query the database name, creation date and other information NOARCHIVELOG that the database is running in non archive mode, the status is read-write (normal state). ARCHIVELOG and non-arc ...
ORACLE directory catalog Transfer: http://hi.baidu.com/tuozhuai/blog/item/ddc6a3d47c58b504a08bb764.html Create directory for Oracle database can be flexible in the file read and write operations, Oracle greatly improves the ease of use and scalabilit ...
DDL (Data Definition Language): ddl statements are used to define the database structure or schema. Some examples: CREATE - to create objects in the database ALTER - alters the structure of the database DROP - delete objects from the database TRUNCAT ...
1, the simplest shell in call sqlplus. $ Vi test1.sh #! / Bin / bash sqlplus-S / nolog> result.log <set heading off feedback off pagesize 0 verify off echo off conn u_test / iamwangnc select * from tab; exit EOF $ Chmod + x test1.sh $ ./test1.sh Sec
SQL> create tablespace sdf datafile '/ nfstest / adsf.dbf' size 10m extent management local; create tablespace sdf datafile '/ nfstest / adsf.dbf' size 10m extent management local * ERROR at line 1: ORA-01119: error in creating dat ...
alter database open read only;
Oracle's a bug need to modify the hidden parameter ALTER SYSTEM SET "_cursor_features_enabled" = 10 scope = spfile; In this machine (version 10.2.0.1 of the) test, the prompt * Error Line 1: ORA-02065: illegal ALTER SYSTEM option In a 1 ...
ORACLE replace and translate function Xiangjie A brief comparison: replace: string class instead of like: SELECT REPLACE ('acdd', 'cd', 'ef') FROM dual; → aefd translate: instead of character level, such as: SELECT TRANSLATE ( ...
The Oracle RMAN backup Study Notes The Oracle RMAN backup Study Notes (Transfer from: http://lanmh.javaeye.com/blog/288830) 1. In linux. Find /-name rman displayed: / Home/oracle/product/10.20/sysman/admin/scripts/db/rman / Home/oracle/product/10.20/bin/r
Oracle instance and Oracle database Xiangjie 1, ORACLE instance 1, ORACLE instance - including the memory structure and background processes System Global Area (SGA) and the Background Process as a database instance. 2, ORACLE database - a collection ...
When we log on the database, suggesting that the current user logged in, but we do not know who is logged, and we have to board the Record, we can move out of the user in order to facilitate our login Steps: 1. Su - oralce input passpd 2. Sqlplus / a ...
select last_day (to_date ('2008-02-01 ',' yyyy-mm-dd ')) from dual The result is :2008-2-29
Oracle face questions Highlights - Technical articles 1. Explain the cold backup and hot backup of the differences and advantages of each Answer: hot backup mode for the archiving database, the database is still in working condition when the backup. ...
When you need to maintain the structure of the database or to import and export database when you can to limit the mode to start the database, so that only restricted session privileges of the user (usually the system administrator) can only log data ...
Process: 1, the installation depends package 2, configure the kernel parameters / etc / sysctl.conf 3, edit the user constraints file / etc / security / limits.conf 4, edit, login authentication pam file / etc / pam.d / login 5, turn off selinux: / e ...
1, Oracle trace file rn Oracle trace file is divided into three types. rn One is the background alarm log file: Record database at startup, shutdown and run the activities during the background processes, such as table space to create, create rollbac ...
In many cases the data a table has been unable to meet our demands inquiry and statistics, this time on the needs from different tables, view, select the data, then we need to select data from multiple tables. Multi-table select data can be two table ...
Building table: Construction sequence: Create a trigger:
Oracle 11g alert file changes (background alarm log) 1. First introduced two new term Automatic Diagnostic Repository (ADR) - A diagnostic log storage database, tracking files, known as ADR base, the corresponding initialization parameter DIAGNOSTIC_DEST,
This thing is I see EYGLE the "DBA daily work responsibilities - my DBA's seven-point proposal" (http://www.eygle.com/archives/2009/02/suggest_dba_job.html) after some ideas. Zai I understand, when the system is its implementation line, the
How to change the status of Prepayment invoice from 'Fully Applied' to 'Available', In fact the prepayment invoice has been applied. Pls refer to the attachement. File: How to change the status of Prepayment invoice from 'Fully Ap ...
Issue: Error: This action cannot be performed on all selected records. Error: The action can not be performed because the selected records are not eligible. File: The action can not be performed because the selected records are not eligible.rar Size: ...
http://www.boobooke.com/bbs/thread-7630-1-1.html rn rn rn turn a good learning post for his ride and then slowly learning environment: rn rn rn
How to enable user not to update sales order line information once a hold has been released? pls refer to the attachement. File: How to enable user not to update sales order line information once a hold has been released.rar Size: 80KB Download: Down ...
SELECT OHA.ORDER_NUMBER, HS.HOLD_ENTITY_CODE CREDIT_CHECK_CRITERIA_CODE, FLV.MEANING CREDIT_CHECK_CRITERIA, HD.NAME HOLD_NAME, HD.TYPE_CODE HOLD_TYPE, HR.RELEASE_REASON_CODE, FLV1.MEANING RELEASE_REASON, HS.RELEASED_FLAG, HS.HOLD_ENTITY_ID, OH.HOLD_R ...
How Often Should Initialize Credit Summaries be run? Solution Assumption: Use Pre-Calculated Exposure is checked on the Exposure tab of the Credit Check Rules form. The frequency with which you run Initialize Credit Summaries is business dependent. H ...
http://localhost:5560/isqlplus/dba solution can not login? Oracle database management tools are: http://localhost:1158/em http://localhost:5560/isqlplus must first start isqlplus services,> isqlplusctl start But when I enter http://localhost:5560/ ...
Service queue waiting (Tx Enqueue) in-depth analysis - ITL contention rn Author: fuyuncat rn Source: www.HelloDBA.com rn rn rnrnrnrn rn We know that matters in the locking block in the record, you need to first record in the data block header informa ...
http://localhost:5560/isqlplus/dba solution can not login? Oracle database management tools are: http://localhost:1158/em http://localhost:5560/isqlplus should first start isqlplus service,> isqlplusctl start But when I enter http://localhost:5560 ...
Bug 7637113: ERROR RECEIVED WHEN ATTEMPTING TO SHIP CONFIRM Hdr: 7637113 9.2.0.6 CONTROL 11.5.10.2 HOLDS PRODID-497 PORTID-46 Abstract: ERROR RECEIVED WHEN ATTEMPTING TO SHIP CONFIRM *** 12/11/08 06:28 am *** BUG TYPE CHOSEN --------------- Code Prod ...
File: Oracle 10g rac windows server 2003 ee in vmware server 1.0.10.rar Size: 14KB Download: Download vmware install oracle 10.2 rac window server 2003 installation steps which points out the attention to solve the online experience for all known err ...
Credit Checking Limits Hierarchy In Oracle Receivables, you can setup Credit limit (which is nothing but the overall credit limit) and order credit limit at the following levels: 1. Item category level 2. Site level 3. Customer level 4. Party level ( ...
Credit Check Hold Not Applied When Order is Over Credit Limit [ID 731369.1] Applies to: Oracle Order Management - Version: 11.5.10.2 This problem can occur on any platform. Symptoms On 11.5.10.2 in Production: Find Credit checking is not occurring fo ...
select text from all_source where type = 'PROCEDURE' and name = 'PROCEDURENAME'
DBMonitor Oracle database monitoring tools, this software can run on a machine, monitoring multiple Oracle database server status, easy to query the database status information, such as instance name, host name, current Hui Hua, total session number, ...
DBMonitor Oracle database monitoring tools, this software offer in a single machine operation, monitoring multiple Oracle database server conditions, enabling query the database status information, such as instance name, host name, the current Hui Hu ...
How to delete an existing Fixed Asset if it has been created during current period? Pls refer to the attachement. File: How to delete an existing Fixed Asset if it has been created during current period.rar Size: 46KB Download: Download
See attached document File: GL in the currency lending uneven approach. Rar Size: 5KB Download: Download
See attached document File: Multiple payment schedule lines. Rar Size: 183KB Download: Download
See attached document File: Multiple payment schedule lines. Rar Size: 183KB Download: Download
Today AIX ORACLE 4K to test the offset found in SCALABLE VG Shang's LV LVCB even without the preceding data block, but is still without Jiang LV all the space for the data file: 1. Check whether the SCALABLE VG VG # Lsvg vg1 VOLUME GROUP: vg1 VG ...
When manually delete the archive logs after, Rman backup will detect deletion log, and thus can not further continue. So now need to manually crosscheck the implementation process can return to normal after the Rman backup. 1.Crosscheck log $ Rman ta ...
Common SQL query: 1, see table space name and size select t.tablespace_name, round (sum (bytes / (1024 * 1024)), 0) ts_size from dba_tablespaces t, dba_data_files d where t.tablespace_name = d.tablespace_name group by t.tablespace_name; 2, see table ...
SQL> startup; ORACLE instance started. Total System Global Area 1207959552 bytes Fixed Size 2083528 bytes Variable Size 369100088 bytes Database Buffers 822083584 bytes Redo Buffers 14692352 bytes Completion of the loading database. ORA-16004: bac ...
[Oracle @ dg1 ~] $ sqlplus sys/atyu30 as sysdba SQL * Plus: Release 10.2.0.4.0 - Production on Saturday, May 8 19:13:05 2010 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 ...
SQL> select database_role from v $ database; DATABASE_ROLE ------------------------------------------------ PHYSICAL STANDBY SQL> select open_mode from v $ database; OPEN_MODE ------------------------------ MOUNTED SQL> select status from v ...
redhat AS 5 installation ORACLE 10g client Mainly come from the Internet, where his pass was amended. My system is Redhat Enterprise Linux AS5.3 [Redhat @ redhat ~] $ cat / etc / issue Red Hat Enterprise Linux Server release 5.3 (Tikanga) Kernel \ r ...
