Oracle Database
+ Hand-built database + oracle 9i ================================================== ================================= + + Set the environment variable + + View. Profile of the configuration is correct: export ORACLE_BASE = / opt / oracle export ORAC ...
The steps switch the database: 1. This state of the main library select switchover_status from v $ database; The main library collection on the situation of temporary table space, because temporary files prepared library may be missing after activati ...
Source: Redhat communities of: Oracle editor Directory I. Introduction Second, build the hardware platform 3, RedHat As4 update2 Installation and Configuration 4, Oracle 10g Installation and Configuration 5, Red Hat Cluster Suite Installation and Con ...
If you do a custom form or do database management software, you must be able to automatically obtain a user of some information under the database. More useful are: Table name, field English name, Chinese name field, field type, field length. Among t ...
Oracle's package is really a very good thing; PL / SQL procedures to meet the needs of modularity, in addition to block (block) and the subroutine structure, but also introduced a package structure. (1) package is a database object, logically rel ...
Still view technology UOA-Database Cluster Architect (V6) View 50,000 annual salary employment yet signed the guarantee agreement, but are not working 100% refund of all tuition (Not recommended by the so-called employment agreement or employment agr ...
1.OS authentication After Oracle installation is enabled by default, OS authentication, certification mentioned here refers to the server os os authentication. OS certification means the database user login and password checking on the operating syst ...
http://blog.sina.com.cn/s/blog_405bdbdd0100d771.html
Fault 1: accidentally deleted data files Treatment: 1, the system administrator login Oracle user to implement sqlplus sys / oracle as sysdba; 2, export control file backup alter database backup controlfile to trace as '/ oracle / a.ctl' Exec ...
package exam; import java.sql.DriverManager; / / drive the management to select the drive to create connections import java.sql.Connection; / / on behalf of a database with links to support the creation of sql statement import java.sql.Statement; / / ...
Error as follows: [Oracle @ node1 admin] $ lsnrctl start LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 26-JUL-2010 05:42:32 Copyright (c) 1991, 2005, Oracle. All rights reserved. Starting / oracle/product/10.2.0/db_1/bin/tnslsnr: please wait ...
Error as follows: [Oracle @ node1 admin] $ lsnrctl start LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 26-JUL-2010 05:42:32 Copyright (c) 1991, 2005, Oracle. All rights reserved. Starting / oracle/product/10.2.0/db_1/bin/tnslsnr: please wait ...
1. Monitoring case of waiting select event, sum (decode (wait_Time, 0,0,1)) "Prev", sum (decode (wait_Time, 0,1,0)) "Curr", count (*) "Tot" from v $ session_Wait group by event order by 4; 2. Rollback contention situatio ...
Oracle database management script description Oracle data dictionary is a database in a very important part in providing the relevant information in the database, it is all Oracle users (from the application end-user, application developer to design ...
Rman connection to an Oracle database. The Oracle rman recovery catalog database catalog of the connection rn At the same time to connect to the recovery catalog database and production database $ Rman target sys / password @ oracle_name catalog rman ...
Rman connection to an Oracle database. The Oracle rman recovery catalog database catalog of the connection rn At the same time to connect to the recovery catalog database and production database $ Rman target sys / password @ oracle_name catalog rman ...
bash-3.00 $ sqlplus "/ as sysdba" rn SQL * Plus: Release 10.2.0.2.0 - Production on Fri Jul 23 19:00:38 2010 rn Copyright (c) 1982, 2005, Oracle. All Rights Reserved. rn Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2. ...
oracle create table space in the often encountered when the data file exceeds the limit of large numbers, how to solve this problem? This limit by two parameters one is maxdatafiles, one db_files. maxdatafiles in the control file specified, db_files ...
See whether the archive and modify oracle database archiving mode Oracle is divided into non-archive mode (NOARCHIVELOG) and archive mode (ARCHIVELOG). Non-archive mode archive log not generated, although the save hard disk space, but Select the back ...
To protect the security of Oracle Database Previous / Next 2010-04-14 17:25:20 / Personal Category: oracle View (10) / Comments (0) / Rate (0 / 0) Each organization should develop a safety standard, safe and right or wrong, this is only to comply wit ...
? ORACLE database users and permissions management ?? ?? ORACLE is a multi-user system, which allows many users to share system resources. To ensure the security of database systems, database management system is configured with a good security mecha ...
5 Install PSU 10.2.0.4.2 This example is based on the 10.2.0.4 version 2009-10-22 (Metalink 756671.1) announced the installation of Oracle Recommended Patches. The PSU (Patch Set Update) is based on the 10.2.0.4 version of the second cumulative patch ...
The basic concept of ORACLE database (1-24) 1. ORACLE database architecture 2. ORACLE database installation process 3. ORACLE database initialization parameters 4. ORACLE database, network services and monitor 5. ORACLE database data dictionary and d ...
The basic concept of ORACLE database (1-24) 1. ORACLE database architecture 2. ORACLE database installation process 3. ORACLE database initialization parameters 4. ORACLE database, network services and monitor 5. ORACLE database data dictionary and d ...
First, back up on the ORACLE database 2, confirmed the Home directory ORACLE database installation path Third, close the database: SQLPLUS / NOLOG CONN / AS SYSDBA SHUTDOWN IMMEDIATE ORACLE stop all running services 4, extract the installation packag ...
Start the database using sqlplus sqlplus / nolog SQL> connect system / change_on_install as sysdba SQL> startup Stop the database using sqlplus $ ORACLE_HOME / bin / sqlplus / nolog SQL> connect system / change_on_install as sysdba SQL> s ...
oracle database character set change A, oracle server-side character set query select userenv ('language') from dual Which is server-side character set NLS_CHARACTERSET NLS_LANGUAGE form for the server-side character display B, query oracle c ...
1. Set / etc / oratab testdb2: / opt/oracle/product/9.2.0: Y The last option should be changed from N Y 2. Test dbstart and dbshut command dbstart and dbshut will check / etc / oratab settings, if set to Y, then the implementation or off, if set to N, the
1. Set / etc / oratab testdb2: / opt/oracle/product/9.2.0: Y The last option should be changed from N Y 2. Test dbstart and dbshut command dbstart and dbshut will check / etc / oratab settings, if set to Y, then the implementation or off, if set to N, the
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 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 ...
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 ...
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 ...
Experimental] [] [FGA] [audit the audit function to use Oracle database monitoring suspicious operations Previous / Next 2009-08-26 20:54:23 / Personal Category: Troubleshooting and Analysis View (470) / Comments (1) / rate (0 / 0) Look at Oracle' ...
Verifying Security Access with Auditing http://download.oracle.com/docs/cd/B28359_01/network.111/b28531/auditing.htm # BCGEHHCA 1 \ on the SYSDBA \ SYSOPER privileges audit: 1) Open method: Auditing SYS Administrative Users You can fully audit sessio ...
Experimental] [] [FGA] [audit the audit function to use Oracle database monitoring suspicious operations Previous / Next 2009-08-26 20:54:23 / Personal Category: Troubleshooting and Analysis View (470) / Comments (1) / rate (0 / 0) Look at Oracle' ...
A few simple steps to improve Oracle performance substantially - I optimized the database three resort. Database optimization discussions can be a permanent theme. Optimization of personnel experienced Oracle performance issues are usually those who ...
Role: multiple oracle database logic as a database, that can be operated in a database to another database object Simple syntax: CREATE [PUBLIC] DATABASE LINK dblink CONNECT TO user IDENTIFIED BY password USING 'connect_string'; DROP [PUBLIC] ...
1. Insert Table Data insert into table name (item1, item2 ...) values (data1, data2 ....); insert into table name (item1, item2 ...) (select item1, item2 ... from table 2 where ...); 2. Modify data update table name set item1 = newData where ...; 3. ...
concept of oracle database SCN First of all, here we will introduce the concept of four SCN. 1, the system checkpoint scn When a checkpoint action is completed, Oracle took the system checkpoint SCN stored in control file. select checkpoint_change # from
ORACLE database administrator should be as follows on the ORACLE database system for regular monitoring: (1). Day running of the ORACLE database, log files, backup, the data Library space usage, system resource usage, it was discovered and resolved Proble
8 important script to monitor Oracle database: Check the availability of examples Check the availability of the listener Check the alert log file error message Log file in the store empty place full of old log files before Analysis of table and index for
Oracle database table type Source: http://www.matrix.org.cn/thread.shtml?topicId=26691&forumId=36 Table 6.1 Types 1. Heap organized table 2. Index-organized table 3. Clustered table 4. Hash clustered table 5. Nested table 6. Temporary table 7. Object
[Oracle] to explore ways to import data from ORACLE database, Author: Wan-Bo (Wanbo.cn) Date :19-Jan-2005 Source: http://www.dbanotes.net Version: 1.00 -------------------------------------------------- ----------------------------------------------- ...
Oracle database system based initialization parameter file init.ora parameters set to configure their own startup, each instance starts, first read the parameter file to set the different parameters. Oracle system parameters, according to the system ...
ORACLE database diagnostic methods --- Frequently Asked Questions (FAQs error Article ) 1 ORA-12571, ORA-03113, ORA-03114, ORA-01041 Features: client (proxy or application server) there are times even the wrong type of fault Reason: If the occasional ...
Oracle Database HOWTO By: Paul Haigh, paul@nailed.demon.co.uk Translator: Zeng dot-com, a9504480@graduate.hku.hk Version 1.2, August 4, 1998 (translation Date: August 31, 1998) _________________________________________________________________ In the Linux
ԭ ijhttp: / / www.oracle.com/technology/global/cn/pub/articles/smiley_10gdb_install.html DBALinux Linux x86 κ וו Oracle ݿ 10 g ߣ John Smiley ѧκ RHEL 2.1RHEL 3 SLES 8 Θ ͷ וו Oracle ݿ 10 g Ļ ֪ ʶ Ŀ ¼ 1 ֣וו Linux RHEL 2.1 RHEL 3 SLES 8 2 ֣ Oracle Linux ֤ ...
ORACLE database, there are two types of backup methods. The first category is physical backup, the method to achieve a complete database recovery, but the database must run in return blocking mode (business database in the non-return block mode), and ...
