oracle database 11g certification

of new products. Finally, hardware is evolving, such as the maturing of flash technology, where flash memory can be used as a cache between disk and memory, or a complete replacement for disk. And the memory price is getting lower and bigger, the in-memory cache or database is more and more widely used, which can bring the order of magnitude performance improvement to the application. The IO problems faced by the

I recently looked at a blog and found that Oracle 11g provided the new feature of user rename. In a 10g environment, if you want to rename a user, you should first create a new user and authorize it, import all objects under the original user and delete the old user! Next we will introduce this new feature in the 11g rac environment! 1. Create a test user xxx and

registry key, all the keys that contain Oracle.11. My Computer----high-level----environment variables, delete environment variables classpath and path for Oracle settings.12. Remove all Oracle-related groups and icons from the desktop, startup Group, and Programs menu.13. Delete all Oracle-related directories (if not

variable Nls_lang, and the value is simplified Chinese_china. Zhs16gbkIf you do not know the Oracle language of the remote database, you can ssh or telnet to the remote machine, enter it at the command interface, and connect to the database using the command line.SELECT * from Nls_instance_parameters;View the value of Nls_languageNls_languageNls_territory5. Down

Oracle 11g manually create a database in windows 1. Create a required directory www.2cto.com D: \ app \ Administrator \ admin \ jxg12_20104350121 2. create a database file storage directory under oradata D: \ app \ Administrator \ oradata 3. create the initialization parameter file D: \ app \ Administrator \ admin \ jx

Today, a friend asked me why 11g exp files cannot be imported into 9I? Due to the incompatibility of exp/imp tools, when importing a database of a higher version to a lower version, you need to use the exp/imp tool of a lower version for import and export. A friend used 9i exp to export 11G data and then import imp to 9i. The import is normal. However, I reported

Tags: python oracle cx-oraclePreparation: 1, download the corresponding version of Oracle-instantclient (I here is 11.2.0.1.0)http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html2. Installation-ivh oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.rpm3. Configure Environment variablesLD

Applies To:Oracle Database - Enterprise Edition - Version 10.2.0.5 and laterInformation in this document applies to any platform.CauseA hang is possible in earlier versions of RDBMS as a result of an unpublished bug fixed in the following versions: 12.1.0.1 (Base Release) 11.2.0.2 (Server Patch Set) 11.1.0.7 Patch 42 on Windows PlatformsDocument 9776608.8 Bug 9776608 - Hang from concurrent login to same account with a wrong passwordEven with

instance started.Total System Global Area 835104768 bytesFixed Size 2257840 bytesVariable Size 536874064 bytesDatabase Buffers 289406976 bytesRedo Buffers Copy hot-prepared data files to the original data file directory[[emailprotected] PROD]$ cp /home/oracle/bak/*.dbf ./ ——拷贝数据文件到以前的数据文件目录[[emailprotected] PROD]$ exitexit[emailprotected]> select open_mode from v$database;

First select your system version, 32-bit system Select 32-bit, 64-bit system can use 32-bit can also use 64-bit, recommended 64 bits! Oracle Database 11g 2nd edition (11.2.0.1.0) for Microsoft Windows (32-bit)Http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_database_1of2.zipHttp://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_database_2of2

; Dbms_output.put_line ('time is:'| | Mnttime); --Set Serveroutput on/off turns on or off the screen display dbms_output.put_line ('ok, im fine' ); end; /You can save the statement to a file and then call it with the "@/path/filename.sql".Substitution variables:SELECT empno, ename from EMP WHERE deptno= Department number;If the replacement variable provides data for a numeric column, you can drink it directly, or if you provide data for a character type or a date type, you ne

should now is able to test the forward and reverse lookups using the "nslookup" command. The output below shows the forward and reverse lookups of the SCAN address.# nslookup Rac-scan.localdomainserver:192.168.0.4address:192.168.0.4#53Name:rac-scan.localdomainaddress:192.168.0.121Name:rac-scan.localdomainaddress:192.168.0.122Name:rac-scan.localdomainAddress:192.168.0.123# nslookup 192.168.0.121server:192.168.0.4address:192.168.0.4#53121.0.168.192.in-addr.arpa name = Rac-scan.localdomain.# nsloo

ORACLE 11G Official documentation Demonstration: Search for manual database creation statements, oracle11g Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright. Deep Blue blog: http://blog.csdn.net/huangyanlong/articl

Summary of issues encountered when connecting to a remote database using oracle11g Net Manager.1 on Win7 System Start menu-"oracle-oradb11g_home1--" configuration and porting tools--"Net Manager650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6C/70/wKiom1VJfCeT43DDAALPPt3imWc076.jpg "title=" Net Manager.png "alt=" Wkiom1vjfcet43ddaalppt3imwc076.jpg "/>2 Click Service Naming-Open the Service Naming

Database Installation After Oracle cluster installation, the next is the most important database installation, the entire database installation is not very difficult, the user as an Oracle user login RAC1 master node, the extracted file installation. After the main node ins

1. installation environment: Fedora 10 (kernel version: 2.6.27.5-117. fc10.i686) Oracle Database 11g Release 2 (11.2.0.1.0) (Register and download the corresponding Linux x86 version on the Oracle website) 2. References: Oracle Database