oracle 11g book

password management, unlocking the usual Scott account and entering the password. As shown in figure: 14. Unlock Scott account, remove the front green tick, and enter the password. You can also enter the usual short password, do not have to press Oracle recommended 8-bit above the size of the number, trouble. Oh. As shown in figure: Note: Sys/system, while modifying the new password, confirm the password. 15. Similarly, passwords that do not c

New Features of Oracle 11g-HM (Hang Manager) In this article, we will introduce the new features of Oracle 11g-hang Manager. We need to note that HM only exists in the RAC database. When we diagnose database problems, we often encounter database/process hang problems. For hang problems, there are two common causes. Dea

1, download Oracle 11g R2 for Windows version Download Address: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html This includes two compressed packages: Win64_11gr2_database_1of2.zip,win64_11gr2_database_2of2.zip 2, the two compressed packets to the same directory, that is, "database", and then click the Extract directory under the "setup.exe" file: 3. In the "Config

following options: ASM This is the preferred storage option for Oracle and is the only configuration supported in the RAC Standard Edition OCFS2 Bare devices are not recommended, not only because they are deprecated by the new Linux kernel, but also not supported in Oracle 11.2 Network File System (NFS) The Red Hat Global file System is only supported in Red Hat and

Routine maintenance and troubleshooting of Oracle 11G R2 slave uard 1. for the Forced Logging mode, there are some DDL statements that can avoid writing redo logs by specifying the NOLOGGING clause (the purpose is to increase the speed, which is indeed effective in some cases). After specifying the database as the force logging mode, the database records all operations except the temporary tablespace or tem

How to completely uninstall oracle 11g ?, Uninstall oracle11g 1. Choose "start"> "Settings"> "Control Panel"> "Administrative Tools"> "services" to stop all Oracle services. 2. Start-> Program-> Oracle-OraHome81-> Oracle Installation Products-> Universal Installer, and clic

> list datafilecopy all; rman> Delete Expired backupcopy; Rman> crosscheck datafilecopy All; rman> Delete Expired backupcopy;If this is due to the Flash recovery area capacity limit, you can modify the path and capacity of the flash recovery area:Sql> alter system set db_recovery_file_dest= '/data/app/oracle/test ';Sql> alter system set db_recovery_file_dest_size=10g;Rman Incremental BackupWhen you use Backup database, it is a full-library backup, whi

After successfully installing the Oracle 11g Database, you will find that your computer runs slowly, and your computer with low configuration may even experience very bad conditions, by disabling non-essential Oracle services, you can speed up your computer. So what should we do? After Oracle

Oracle Clusterware 11g 2nd and later versions. For Oracle 11g 2nd and later versions, password-free SSH is required. This command writes the DSA public key ~ /. Ssh/id_dsa.pub file to write the private key ~ /. Ssh/id_dsa file. Do not distribute the private key to any user who has no permission to install the

Description This article installs the Oracle 11g Dataguard physical repository and tests the 11g Dataguard physical Repository's new feature active Data Guard, which is a function of Oracle Database Enterprise Edition, which requires the amount External authorization, this article is for testing only. First, the envi

the following query: [Email protected] rc.d]$ find-name ' k*oracledb ' ./rc2.d/k10oracledb ./rc4.d/k10oracledb ./rc6.d/k10oracledb ./rc1.d/k10oracledb ./rc0.d/k10oracledb [Email protected] rc.d]$ find-name ' s*oracledb ' ./rc5.d/s80oracledb ./rc3.d/s80oracledb [Email protected] rc.d]$ chkconfig--list oracledb OracleDB 0:off 1:off 2:off 3:on 4:off 5:on 6:off As in the previous OracleDB file, the first two lines of comments may not be written, you can use the file link: # ln-s/etc/init.d/oracledb

　　 1. First download the oracle 11g x64 bit package from the official website. : Http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_1of2.zip Http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_2of2.zip 2. Installation Package detection and Installation [root@struggle ~]# rpm -q binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel glibc glibc-commo

by the system after the user's operation, so there is no need to adjust the temporary table space, but when the concurrent users are very much and the operation is more complex, There may be a shortage of temporary table space. At this point, the database administrator can add temporary files to increase the temporary table space.If you need to add temporary files, you can use the Add tempfile clause.If you need to modify the size of the temporary file, you can use the Resize keyword.You can al

Imitating the example of Oracle performance diagnostics in two experiments, the book says that if you don't use relies_on, the change action on the object that the function depends on does not cause the result cache to fail operation (Result_cache relies_on (test1, TEST2), the test proves wrong, the function F1 () does not use relies_on, but the changes on the table affect the function. C:\Documents and Set

, Next.Set the user name.Turn on the 1521 listening port.Enable archiving? Determines whether or not a selection is made based on the actual need to archive logs. The default is checked.Then click the OK button to start creating the database as shown in:The database is created.3. Simple verificationSqlplus/as sysdba? #进入oracle数据库Conn/as sysdba;? ? #连接用户Alter user Scott identified by Tiger account unlock; #解锁用户Conn Scott/tigerSql> select * from dept;?