Oracle

Now, the computer is installed with Oracle10g.   First, make it clear that if the computer is not added to the domain, then the installation of Oracle10g is quite smooth. (My ThinkPad E40 was successfully installed)   During the installation

Install Oracle 10g in Windows 7. The orcale version used is 10 Gb. Step 1: Download from the orcale official website, for: http://download.oracle.com/otn/nt/oracle10g/10203/10203_vista_w2k8_x86_production_db.zip You can directly copy it to thunder

My RAC Virtual Machine reported that diskgroup space was insufficient during Backup yesterday, so I added asmdisk to my schedule. When installing RAC, I had 2 ASM diskgroups + DG, respectively, + recoverydest: Now + recoverydest has insufficient

Example:Recently, the company has a project that involves data migration:The source database environment is: RedHat as 4 Oracle 10.2.0.1 (64-bit) Single Instance (bare device), hardware platform (IBM x3650)Target Database: AIX 5.3. Oracle 10.2.0.4 (6

SQL * loader is a tool used to import external data from Oracle databases. it is similar to the load tool of DB2, but has more options. It supports variable loading modes, optional loading and multi-Table loading. How to use SQL * LoaderWe can use

Errors encountered during Oracle usage and PLSQL script debugging and solutions. Update constantly...           ORA-20000 to solve the problem:   ORA-20000: Because of overflow, the general method is to set a value larger. Set long 10000;

I. Key application servers and transaction processing products: Oracle WebLogic suite Oracle WebLogic application Grid Oracle tuxedo Oracle coherence Data Grid Oracle jrockit JVM Oracle jrockit Mission Control Oracle jrockit Real Time

Document directory Preliminary steps Using bind variables There are several relatively easy steps you can take to improve performance. From the user's perspective, one of the most frequently used interfaces with a

The Oracle database server is the core of the entire system. Its performance directly affects the performance of the entire system. To adjust the performance of the Oracle database server, we mainly consider the following aspects: 1. Adjusting the

For Oracle DBAs, table space monitoring is an important task of daily and regular monitoring. Table space monitoring includes table space status, data files, table space usage, and remaining conditions. 1. Table space list: SQL> select * from V $

Sorts and retrieves the first letter of Chinese pinyin according to the first letter of Chinese pinyin. This section describes the function of ranking by Chinese characters including the first letter, strokes, and radicals. [nlssort ]: 1) First

1 Oracle L3 permission system [review]   1. Oracle's permission system is divided into three levels: Role role, system, and object. The following is a simple description: Ü Object Privilege is the minimum granularity object of the

Just installed Oracle Application Server, login to find the password is wrong, fainted! Let's take a look at how to reset the password. It's easy to find it. Stop the ap first. You can use the command (opmnctl stopall) or menu (stop SOA suite

The procedure is as follows: 1. master database operations 1. Modify the attributes of the master database: Alter system force logging; # View status Select force_logging from V $ database; 2. Change the database to archive mode: Archive log

The procedure is as follows: // // 1. After installationOracle 11g R2 for x64 LinuxCopy the occi header file and library file:// (1). Copy the header file// Mkdir-P ~ /OCCI-11gR2-X64/include// CP $ ORACLE_HOME/rdbms/public /*~ /Occi/include///// (2).

Article 1 Oracle Architecture Overview Let's take a look at a picture.  This figure shows the architecture of Oracle 9i. It looks complicated. Yes, yes. Now let's take a look:I. Databases, tablespaces, and data files1. DatabaseA database is a

Technorati label: Be, Backup Exec, Veritas, backup 1.1 create job-Oracle full backup according to policy, difference to tape, restore (OK) This test is performed in the actual generation environment, and the tape library is used for backup. Then,

The undo mechanism is a clever feature of Oracle and one of the difficulties in learning oracle. Next we will learn more about it internally. Session 1: Scott user, initiates a transaction hr@ORCL> conn scott/oracleConnected.scott@ORCL> UPDATE emp

Ora-38301 error, recycle bin A colleague told me a few days ago that there was a serverTablespaceCannot be deleted. Let's see. Log on to the server and delete the tablespace,DatabaseSame timeOra-00604AndOra-38301Error. At first, I thought

System Environment: 1. Operating System: Windows 2003 Server 2. Database: Oracle9i Release 9.0.1.1.1 3. installation path: D:/Oracle database creation steps: 1. manually create related directories D:/Oracle/admin/orarman D:/Oracle/admin/orarman/Arch