connect access to oracle 11g

to the specified instanceOracle RAC load Balancing test (combined with server-side vs. client)Oracle RAC server-side Connection load balancing (load Balance)Oracle RAC Client Connection Load balancer (load Balance)Non-default port listening configuration under ORACLE RAC (Listener.ora Tnsnames.ora)ORACLE RAC Listener

-Firewall-1-INPUT -m state –state NEW -m udp -p udp –dport 177 -j ACCEPT :wq! #Save exit Service iptables restart #restart Gdm-restart #restart Shutdown -r now #restart the system Second, install Xmanager on the Windows client system 1. Download and install Xmanager Enterprise 3 Http://www.onlinedown.net/soft/32684.htm #英语原版 Http://www.downxia.com/downinfo/19164.html #汉化包 2. After downloading the installation software, open Xmanager Enterprise 3, then open Xbrowser, as shown below: I

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

in the same directory to extract the two files, will generate a database directory. Here, using the graphical installation method, you need to configure the Xserver,windows client configuration locally to refer to this link: http://tryingstuff.blog.51cto.com/4603492/1958772To switch to an Oracle user, add an environment variable:Export Oracle_base=/data/app/oracleConfigure x:Export display=192.168.20.171:0.0Xhost +

folder, Oracle installation script, product manuals and other documents are located in this folderUnzip Linux.x64_11gR2_database_1of2.zip Unzip Linux.x64_11gR2_database_2of2.zipOracle 11g is installed primarily through the Runinstaller script, and access to the Web page welcome.html can be consulted in the product manuals, including product descriptions, release

export or after the import recompile. The stored procedure did not import successfully, so I finally took advantage of Navicat to import the stored procedure successfully.Note: (1) To ensure that two databases have the same character set, if the difference will be an error. I checked the next two database character sets are the same, so I'm not sure what is wrong with the specific report. To view the database character set:SELECT * from V$nls_parameters WHERE PARAMETER in (' Nls_characterset ',

-list_repos_details Oracle Enterprise Manager 11g Release 1 Grid Control Copyright (c) 1996,201 0 Oracle Corporation. All rights reserved. Repository Connect Descriptor :( DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.65.14) (PORT = 6688) (CONNECT_DATA = (SID = emrep ))) Repository Host: Rep

Oracle 11g Data guard based on the same host 1. Restrictions on logical standby DatabasesThere are many restrictions on the logical standby database. For example, some special data types such as object, nested table, rowid, object type, and custom data type are not supported, andIt supports segment compression and does not support a lot of things such as some specific DDL statements. For more information,

. Note: If the slave database is open, the alarm log displays: ORA-16058: Alarm information for the slave database instance not loaded. Steps for installing Oracle 11gR2 in vmwarevm Install Oracle 11g XE R2 In Debian Important configuration parameters of Oracle Data Guard Configure

/dbhome_1/ Database location:/opt/oracle/oradata/ Product list:/opt/oracle/oraInventory/ SHAPE \ * MERGEFORMAT SHAPE \ * MERGEFORMAT Verify installation result Access the database using sqlplus from the command line Access https: // dbserver: 1158/em/from a browser/ Username sys, administrative password, conne

EMCOMMAND:RM $ORACLE _home/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs/*.gif5. Stop and restart DbconsoleCommandEmctl Stop DbconsoleEmctl Start DbconsoleGo to the browser again to refresh the EM, found that the button is no longer garbled5:1521 11,582 ports not open cause other machines to access the Web control side and not connect to O

scripts as the root user. [Root @ Pet ~] #/OraInventory/orainstRoot. sh [Root @ Pet ~] #/Oracle_11g/oracle/root. sh After the script is run, the Oracle 11g R2 database software has been installed. After installation, click Close to exit the installation page. 8: Set the listener Use in a terminalNetcaCommand to start creating a listener. Set the listene

This paper is compiled from Oracle documentation Warehouse Builder 11g Architecture and components Oracle Warehouse Builder is an information integration tool that can transform data into high-quality information using an Oracle database. The Oracle database is the central

directory as an oracle user and execute the installation command: -bash-4.1$ su oracle-bash-4.1$ cd /home/OracleInstaller/database-bash-4.1$ ./runInstaller You can enter the welcome page for oracle 11g database installation. Note: (1) if you use a non-root user (or remote) for installation, you must log on to the ro

SELinux bit:[Root @ localhost ~] # GetenforceEnforcing[Root @ localhost ~] # Setenforce 0[Root @ localhost ~] # GetenforcePermissive[Oracle @ localhost ~] # Sqlplus xfdb/xfdb @ mydbSQL * Plus: Release 11.1.0.7.0-production on Wed JUN 17 16:37:06 2009Copyright (c) 1982,200 8, Oracle. All rights reserved.Connected:Oracle Database 11g Enterprise Edition Release 11.

or ASM. Block devices and bare devices will no longer be supported in Oracle12. Oracle strongly recommends using at least 3 voting disks in a different location. When using ASM to manage voting disks, you need to be aware of the redundancy levels of disk groups and failure groups. Note that all copies of voting disk are in one disk group, and you cannot distribute voting disks across multiple disk groups. When using an externally redundant disk group

)notnull, acc_namevarchar2(50)notnull, acc_locvarchar2(5), acc_branchnumber(2)generatedalwaysas (to_number(substr(to_char(acc_no),1,2))); Use a virtual column as the partition key: SQL>CREATETABLEaccounts (acc_nonumber(10)notnull, acc_namevarchar2(50)notnull, acc_locvarchar2(5), acc_branchnumber(2)generatedalwaysas (to_number(substr(to_char(acc_no),1,2))) partitionbylist(acc_branch); Partition recommender Oracle

provide, and for I/O intensive applications, this mechanism determines that subsequent expansions can only be Scale up type, For hardware costs, developer requirements, maintenance costs are relatively high. Oracle is clearly aware of this problem, in Oracle's MAA (Maximum availability Architecture) architecture, using ASM to consolidate the capabilities of multiple storage devices, so that the RAC-bottom shared storage devices have the ability to sc

,timeo=600,rsize=32768,wsize=32768,actimeo =0 0 0 Nas1:/shared_home/u01/app/oracle/product/11.2.0/db_1 NFS rw,bg,hard,nointr,tcp,vers=3,timeo=600,rsize=32768, Wsize=32768,actimeo=0 0 0 Nas1:/shared_data/u01/oradata NFS rw,bg,hard,nointr,tcp,vers=3,timeo=600,rsize=32768,wsize=32768,actimeo=0 0 0 Mount NFS on two nodes Mount/u01/shared_config Mount/u01/app/11.2.0/grid Mount/u01/app/oracle/product/11.2.0/db_1

about Oracle RAC, seeUse crs_setperm to modify the resource owner and permissions of RAC.Use crs_profile to manage RAC resource configuration filesRAC database startup and ShutdownOracle RAC servicesServices in Oracle Database 10gMigrate datbase from single instance to Oracle RACConnect Oracle RAC to a specified insta