oracle 11g

Label:I installed Oracle 11g Enterprise this morning and found that it was too much memory, considering the Express version of MS SQL, so I was thinking about trying to try the Oracle 11g Express version, which is the ex version. The following are the specific installation steps. 1, download

Oracle 11g, oracle11g General requirements for software environments RHEL 5. x System and RHEL 6. x System Graphical desktop environment + development tools + Chinese Java support -- When installing in RHEL 6. x, ksh needs to use the 5. x software package instead. Preparations: Yum install yum * Yum groupinstall "X Window System" "desktop platform" "Chinese support" "development tools" [Root @ dbserver ~]

Installing Oracle 11g R2 silently in CentOS I,Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.htmlOracle 11g online documentation:Http://www.oracle.com/pls/db112/homepage Ii. System RequirementsMemory: 1 GB (minimum official requirement: 1 GB)Hard Disk: 40 GB (4.29G and 1.7G data files required for Enterprise Edition installation) Ch

] $SCP-R/home/oracle/product/dbs 192.183.3.145:/home/oracle/product/dbs3.2.3Copy listening Files [Email protected]~] $SCP-R/home/oracle/product/network/admin/*.ora 192.183.3.145:/home/oracle/product/network/ admin/3.3To modify a listening configuration file3.4TNS configuration file 3.5Modifying a parameter file

Tags: Linux oracle 11gOracle 11g installation on Linux Create the required users and groups Vim mk_user.sh GROUPADD-G 501 OinstallGROUPADD-G 502 DBAGROUPADD-G 503 OperUseradd-u 501-g oinstall-g Dba,oper Oracle SH mk_user.sh Create the desired directoryVim mk_dir.sh Mkdir-p/u01/app/orainventoryChmod-r 775/u01/app/orainventoryMkdir-p/

64-bit Windows 8/7 32-bit PLSQL connection 64-bit Oracle 11g, plsql11g64-bit Windows 8/7 32-bit PL/SQL connection 64-bit Oracle 11gNote: Oracle's oci. dll is 64-bit after installation, while 32-bit application PL/SQL Developer cannot loadSolutionStep 1: Download the Instant Client for Microsoft Windows (32-bit) package address: http://www.oracle.com/technetwork/t

necessary to modify the Yum source, you can useHttp://mirrors.163.com/http://mirrors.sohu.com of these 2 domestic sources.Execute the following command. Cd/etc/yum.repos.dMV Centos-base.repo Centos-base.repo.bakwget Http://mirrors.163.com/.help/CentOS-Base-163.repo or wget Http://mirrors.sohu.com/help/CentOS-Base-sohu.repoRun the Yum Makecache build cache4 Console page Some of the text on the button is garbled solution (such as login screen: Login button)Workaround:EM garbled is caused by Java,

Then unzipClick setup.exeI'm using the default installation D drive.The database password is Wangxiaofei.NextFirst, on your own Windows 7 flagship edition, Oracle 11g prompts you for errors when "product-specific prerequisite condition checks":In, we can see that when Oracle checks the operating system compatibility, it does not pass the check, at this time, we c

Oracle provides the scott user's re-creation script, and the 11G uses the script to create scott. The simple operation is as follows: SQL> select * from dba_users where username = 'Scott '; ------ SCOTT has been manually deleted. No rows selectedSQL> exitDisconnected from Oracle Database 11g Enterprise Edition Release

/s99oracle11Ln-s/etc/init.d/oracle11/etc/rc.d/rc5.d/s99oracle11Ln-s/etc/init.d/oracle11/etc/rc.d/rc0.d/k10oracle11Ln-s/etc/init.d/oracle11/etc/rc.d/rc1.d/k10oracle11Ln-s/etc/init.d/oracle11/etc/rc.d/rc6.d/k10oracle11Effect and execution Chkconfig--add Oracle11 is the same.Here, so the setup process is over, let's test it out:#cd/ETC/INIT.DSH oracle11 startAfter executing, look at the Oracle11log file in the/var/log directory, is there a script to start the branch output information?SH oracle11 s

Tags: open fast overwrite selected format finish home record Select1. Find the Repository control file path FirstFind the path to the control file on the repository first, as in the main library, but just in case, check is OK. Sql> select name from V$controlfile;NAME--------------------------------------------------------------------------------/oracle/app/oracle/oradata/powerdes/control01.

/[emailprotected] /service Take bash for example, such as the above password [email protected] situation, at this time need to write:sqlplus username/\ "[email protected]\ ] because "itself is a meta-character in bash. To pass "itself as part of a reference to Sqlplus." It must be escaped. finally recommend a ORACLEDBA book, the book has a lot of Oracle terminology and principles of very clear, just a slightly rough translation, it is recommended to

Oracle 11g Data Loading Methods Data Loading: SQL * LOADER External table Import/Export SQL * LOADER: SQL * LOADER is an Oracle tool that can load data from external data files to databases. The command for running SQL * LOADER is sqlldr. Two Sqlldr usage methods: 1. Use only one control file, which contains data 2. Use a control file (as a template) and a

Selection:32-bit memory is a bottleneck, it is already 64-digit era. Use 64-bit CentOS6 and 64-bit Oracle 11g R2In the virtual machine installation, use the Hostonly way to set up the networkNote: The Internet adapter will be able to set up ICS (Internet Connection Sharing) to VMware network Adapter VMnet1So for the virtual machine, the gateway is 192.168.137.1,IP address please also set in 192.168.137.0/24

Label:1. Environmental information:System:Oracle-linux 5.7 Database version:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionPL/SQL Release 11.2.0.3.0-productionCORE 11.2.0.3.0 ProductionTNS for Linux:version 11.2.0.3.0-productionNlsrtl Version 11.2.0.3.0-production Main Library: 192.168.12.31 Sid:yoon Db_unique_name:yoonLibrary: 192.168.12.231 Sid:yoon DB_UNIQUE_NAME:YOONDG 2. Check if DG is installed:Sql> SELECT * from v$op

Oracle oinstall 30416896 Jan 22:05 temp01.dbf-rw-r-----1 Oracle Oinstall 110108672 Jan 24 22:05 UNDOTBS01.DBF-RW-R-----1 Oracle oinstall 26222592 Jan 22:05 users01.dbf[[emailprotected] prod]$ Exit[emailnbs p;protected]> ALTER DATABASE Open;alter database Open*error at line 1:ora-03113:end-of-file on communication channelpr Ocess id:2951session id:125 Serial Numb

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

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