Oracle Database

Oracle Database Construction notes by hand (not through the graphical interface)

+ Hand-built database + oracle 9i ================================================== ================================= + + Set the environment variable + + View. Profile of the configuration is correct: export ORACLE_BASE = / opt / oracle export ORAC ...

Notes the steps switch oracle database

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 ...

Red Hat Cluster Suite cluster Oracle Database

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 ...

Oracle database through the process to obtain all the tables and table structure (including comments)

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 ...

The use of Oracle database package

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 ...

Oracle database cluster architect courses (UOA)

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 ...

Oracle Database OS authentication with the password file validation

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 ...

Oracle database instance creation. Delete. Modification

http://blog.sina.com.cn/s/blog_405bdbdd0100d771.html

Handling two oracle database accidentally deleted data files of the failure process

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 ...

oracle database connection code

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 on ORACLE database monitoring solution (TNS-12537: TNS: connection ..)

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 on the ORACLE database monitoring solution (TNS-12537: TNS: connection ..)

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 ...

Oracle database performance monitoring SQL summary

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 tool SQL * LOAD load data chart

Oracle database management script description

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 Oracle database

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 ...

Oracle database connection 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 ...

Oracle database query is working in the archive mode

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. ...

On the oracle database parameters and maxdatafiles parameters db_files

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

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

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 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 ...

Steps to install Oracle Database PSU 10.2.0.4.2

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 ...

oracle database basic concepts of statistics

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 concepts of oracle database statistics

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 ...

Detailed steps ORACLE database upgrade

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 and stop oracle database

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 changes

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 ...

Configuring Oracle database and monitoring system from the start with Linux

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

Configuration with Oracle database and monitor Linux systems from the start

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

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 ...

oracle database set to restricted mode learning ------

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 ...

oracle database monitoring tools (software)

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 ...

oracle database SQL query used classical

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 ...

[Experiment] [audit] [FGA] using Oracle database audit function monitors suspicious operations

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' ...

oracle database audit

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] [audit] [FGA] using Oracle database audit function monitors suspicious operations

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' ...

Optimizing Oracle database to improve performance significantly

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 ...

oracle database link Help

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] ...

oracle database-related commands

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

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 maintenance

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

Oracle database monitoring shell script used

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

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

To explore ways to import data from ORACLE database,

[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 parameters (including hidden and abandoned)

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 )

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

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

In the Linux x86 to install Oracle Database 10g (from ORACLE Network)

ԭ 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 Backup Methods

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 ...
Recent
Recent Entries
Tag Cloud
Random Entries
Latest Comments