oca 11g

During the installation of 11g, this machine encountered the need to install the loop adapter. My system is Windows 2003 Server. in the network environment of the lab, IP addresses are automatically allocated by DHCP. If Oracle finds that your machine is using DHCP, install the Microsoft loopback adapter to provide a static IP address. For details about the installation method, see: 1. Click start, and then click Control Panel ".2. If you are in t

11g error ORA-27102: outofmemoryLinuxError: 22: Invalidargument 11g Error ORA-27102: out of memory Linux Error: 22: Invalid argument It's okay to install a 11g game, and install the software dbca to create a database. Everything works normally. An error occurred when I started the service today. [Oracle @ OEL54db11gR2 dbs] $ sqlplus/as sysdbaSQL * Plus: Rele

Oracle 11g client Configuration First download several compressed packages from OTN For: http://www.oracle.com/technology/software/tech/oci/instantclient/index.html Then select different downloads based on your platform. I installed them in rhel5, so I chose Linux x86 and downloaded the following two packages: Instantclient-basic-linux32-11.1.0.7.zip basic package that provides OCI, occi and JDBC-OCI applicationsProgram.Instantclient-sdk-linux

from the master database to the Standby DB:SQL> alter system set log_archive_dest_state_2 = defer;Re-enable log transmission after flashing back:SQL> alter system set log_archive_dest_state_2 = enable; Oracle 11g environment:The steps are simpler. The new features of Snapshot Standby Database are added to the 11g, which is actually a package of the above 10g functions, the only difference is that archive l

" user./U01/oracle/product/11.2/db_1/root. shTo execute the configuration scripts:1. Open a terminal window2. Log in as "root"3. Run the scripts The cloning of OraDb11g_home1 was successful.Please check '/u01/oracle/oraInventory/logs/cloneActions2013-10-28_02-45-44PM.log' for more details.Run root. sh as the root user.[Root @ rac2 tmp] # sh/u01/oracle/product/11.2/db_1/root. shCheck/u01/oracle/product/11.2/db_1/install/root_rac2_2013-10-28_14-50-29.log for the output of root scriptCloning is com

New Features of 11g rman blockrecover, rmanblockrecover Reference:New Rman Blockrecover command in 11g (Recover upload uption list) (Document ID 1390759.1) New Features of 11g rman blockrecover:Note: The blockrecover command for 10 Gb is discarded, but it is still supported. Rman> Recover datafile Rman> Recover tablespace Example: SQL>SELECT DBMS_UTILITY.MAKE_

Navicat for Oracle connection to Oracle 11G operation process, navicat11g Procedure for connecting Navicat for Oracle to Oracle at 11 GB 1. Change the Oracle configuration file After installing Oracle 11g, you need to change the listener. ora and tnsnames. ora files under the C: \ Oracle Installation Base directory \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN. Remember to back up the two files first. T

The concept of SCAN (Single Client Access Name) is introduced in the Oracle 11g RAC cluster, that is, the Single Client Access Name of the cluster. SCAN provides a single host name for the client to access the Oracle database running in the cluster. If you add or delete nodes in a cluster, you do not need to change the TNS configuration of the client that uses SCAN. No matter which nodes are contained in the cluster, SCAN resources and their associate

, Oracle. All rights reserved.Connect:Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data MiningAnd Real Application Testing optionsSQL> shutdown the immediate database has been disabled. The database has been detached.The ORACLE routine has been disabled.SQL> startupThe ORACLE routine has been started.Total System Global Area 1.7108E + 10 bytesFixed Size 2101632 bytesV

The concept of SCAN (Single Client Access Name) is introduced in the Oracle 11g RAC cluster, that is, the Single Client Access Name of the cluster. SCAN provides a single host name for the client to access the Oracle database running in the cluster. If you add or delete nodes in a cluster, you do not need to change the TNS configuration of the client that uses SCAN. No matter which nodes are contained in the cluster, SCAN resources and their associate

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/topics/winsoft-085727.htmlStep 2: Decompress the fileStep 3: configure system environment v

In Oracle versions earlier than 11g, if you want to set the table to read-only, you can grant the SELECT object permission to these users, but the table owner still reads and writes the table. Oracle 11g allows the TABLE to be marked as read-only through the alter table command. You can use the following command to set the read and write permissions of a table: Alter table table_name read only; Alter table

How to SetOracle11gImport backup10g 11g Export Statement: expdp userid ='Facial/Facial@OrclAs sysdba 'schemas = facial directory = DATA_PUMP_DIRdumpfile = aa. dmp logfile = aa. log version = 10.2.0.1.0 The red text is rewritten as needed. For example, my usersFacialThe password isFacial, Database sid isOrclThe username to be exported by schemas isFacialTo import it to the Oracle database of version 10.2.0.1.0. Aa. dmp and aa. log will be generated in

Redhat 6.2 installation of the Oracle 11g client and Analysis of problems encountered, oracle11gOracle 11.2.0.1.0 client (32 bit) was installed on Redhat6.2 (64 bit) yesterday. The following are some problems encountered during installation and the handling process records.First, extract the installation package and generate a client directory. When runInstaller is run, an error is reported. The error is as follows:[Oracle @ Ptyjkweb oracle] $ ls-ltot

Notes for installing Oracle 11g RAC This article is only used to record some issues that occur during the installation of Oracle RAC at ordinary times. If you encounter minor issues, we will also add them.1. HAIP hosts file dual-inline Nic configuration example: # Vi/etc/hosts127.0.0.1 localhost. localdomain localhost192.168.0.6 db1192.168.0.7 db2192.168.0.8 db1-vip192.168.0.9 db2-vip10.10.10.10 db1-priv120.20.000010 db1-priv210.10.10.20 db2-priv1Mega

Oracle 11g R2 rac rman backup script example 1. Switch RAC to archive Mode 1. Modify the archive mode of the database. Generally, archive is configured and the flash back area is used when RAC is installed. you can skip the steps below if you have configured archive. SQL> alter system set cluster_database = false scope = spfile sid = '*'; 2. Shut down all instances (shutdown on both sides) SQL> shutdown immediate Or directly close all instances.$ Srvc

Oracle lab environment setup (Windows + Oracle 11g) I. systems and software Windows 7 + Oracle 11g 2. Prepare the installation environment Prepare for ORACLE Installation 1. Delete Environment Variables D: \ oracle \ product \ 11.2.0 \ dbhome_1 \ bin \ Note: Only some oracle environment variables are deleted. Others must be retained. 2. Clear the Registry A. SOFTWARE Item: HKEY_LOCAL_MACHINE \ SOFTWARE \ O

Permission handling for installing Oracle 11g OS in Win7 64bit In general, we choose to install Oracle databases in traditional server operating systems such as Linux and AIX. Even in Windows, server versions such as 2008 and 2012 are used as the installation media. In Windows 7, it is generally not recommended to install the Oracle server version. So for friends who need to study and test Oracle in Windows 7, virtual machine + Windows client is a goo

Oracle 11g R2 (GI) Startup Process 11gR2 cluster management software (GI) startup sequence and diagnostic methods In this article, we will introduce the Starting sequence of 11gR2GI and introduce common problems and corresponding solutions during GI startup. Basically, we can divide the GI startup process into three phases: ohasd, cluster building, and resource startup. First, the ohasd stage. 1. scripts in the/etc/inittab File H1: 35: respawn:/etc/in

Install Oracle 11g in RedHat Linux 6.0 Steps for installing Oracle in Linux Preparations before installation Transmit oracle to the root directory through ssh (this installation is under VMware) Installation Package for Linux for Oracle 11g RedHat 6.0 Virtual Machine 1. Create users and groups Groupadd oinstall Groupadd dba Useradd-goinstall-G dba-m oracle Passwd oracle (Oracle user login is used below) 2.