amendments

Single-instance and RAC to create the ORACLE STREAM (2)

After completion of parameter settings, the following to start the master and backup database is set to archive mode. The reason why this part of the single opening is due to single-instance database is set to archive mode and ORACLE RAC is set to ar ...

After the resumption of different machines to solve ORA-01152 error

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== rn RMAN-03002: failure of backup command at 09/02/2009 02:21:47 rn ORA-19625: error identifying file / u03/oracle / archivelog/2009_08_31/1_3783_634497921.dbf rn ==== Ended in er ...

oracle user profile is used

rn Profile file by using the user defined attributes, such as for product users to establish a profile document rn create profile product_profile limit SESSIONS_PER_USER 1; --- set the user can establish a session of the profile rn alter user product ...

RHEL5 Oracle10g (10.2.0.1) x86_64 installation steps

RHEL5 Oracle10g (10.2.0.1) x86_64 installation steps 1. To ensure that there is no problem with the network, especially the network card settings, set the network adapter on the host name. Modify / etc / hosts file to 127.0.0.1 modify settings for th ...

Oracle Database initialization parameter changes to note

Generally only in large-scale application or performance data, according to the Treasury decreased only need to change the initialization parameters. So from this perspective, the adjustment of parameters to initialize Oracle database is a high-level ...

RMAN conducted through the bare equipment and file system data file transfer between

Easy to be an example to introduce how to use data files Rman bare equipment and file system conversion. 1. EYGLE set up equipment used to test bare table space 2. Use RMAN to back up the COPY function of the bare device file for the file system file ...

RMAN to bare through the file system equipment and data files between the migration

To be a brief example of how to use data files for Rman bare equipment and file system conversion. 1. EYGLE the establishment of the use of test equipment bare table space 2. Use RMAN to back up the COPY function of the bare device file for the file ...

Oracle XDB relax resolve port conflict of 8080

In this paper, carried: http://www.enet.com.cn/article/2008/0306/A20080306175452.shtml Oracle 9i from the start, Oracle includes the installation of the default XDB. After starting the database, Oracle XDB's http service will automatically take u ...

[To] Oracle stored procedure to send mail, and to support user authentication. The Chinese title and content - to amend By-laws

Oracle stored procedure to send mail, and supports user authentication, the Chinese title and content Oracle stored procedure in the implementation, we may hope that its own e-mail to complete the implementation of the results, especially in the capt ...

Parameter file on the oracle

rn Parameter file on the oracle rn rn In general, the default init.ora parameter file in the following directory: rn Unix platform: $ (ORACLE_HOME) / dbs rn Windows platform: $ ORACLE_HOMEdatabase rn rn Oralce start the process to read parameter file ...
Recent
Recent Entries
Tag Cloud
Random Entries
Latest Comments