oracle 11g

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

Installation and configuration of EM in Oracle 10g and 11g I set up an Oracle environment locally. I first installed the database with EM. After the installation, I wanted to modify the listener port and replace the port 15521 with another one, as a result, several parameter files are modified in the directory, and EM cannot be started directly. Finally, I analyz

Oracle 11g online recovery temporary tablespace -- Database versionSQL> select * from v $ version; BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionPL/SQL Release 11.2.0.1.0-ProductionCORE 11.2.0.1.0 Productio

Oracle 11g password expired locked reporting ORA-28000 the account is locked I. Reasons for triggering this error and Related Factors It is because "PASSWORD_LIFE_TIME = 180 days" is set in the default profile in Oracle 11g by default. in Oracle

; Ple.com: 1521SQL>! Lsnrctl status LSNRCTL for Linux: Version 11.2.0.4.0-Production on 19-FEB-2014 20:54:52 Copyright (c) 1991,201 3, Oracle. All rights reserved. Connecting to (ADDRESS = (PROTOCOL = tcp) (HOST =) (PORT = 1521 ))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.4.0-ProductionStart Date 19-FEB-2014 20:03:17Uptime 0 days 0 hr. 51 min. 35 secTrace Level offSecurity ON: Local OS Authent

Oracle 11g PL/SQL function result cache, oracle11g Two experiments have been conducted to simulate the Oracle Performance Diagnosis art. The book says that if you don't need RELIES_ON, then the changes to the objects on which the function depends will not result in the invalid result cache operation (result_cache RELIES_ON (test1, test2). The test proves that thi

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

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

. But I used the netca command to re-create the listener and then tested the expdp to find the same problem. 2. Final Solution:Su-oracle users can view the listening file and find the following problems:[Oracle @ linuxtest admin] $ cat tnsnames. oraCat: tnsnames. ora: Permission denied The prompt is that the permission is insufficient. It was previously viewed under the root user, so I did not notice this p

First, if the Oracle database is installed, this is roughly the directory:D:\oracle\product\11.2.0\client_1\oui\jlib\classes12.jar orD:\oracle\product\11.2.0\dbhome_1\oui\jlib\classes12.jarAttention:For Oracle11 Jdbc\lib There is no Classer12.jar file (Note: I installed in the Windows8 11g, this file is present, import