. =============================================================================================================== ======= The first step is to stop all Oracle-related services. Right-click "My Computer"--"manage"-"services and Applications"-"services", open the Services window, select Oracle's Services, right-click to select "Stop". The second step, find the Oracle folder under Window, find Universal Inst
Tags: rhel, rhel 5.8, Oracle, Oracle 11gFirst, prefaceRecently to prepare for the exam, ready to review the knowledge of Oracle database, then the premise of learning Oracle is definitely deployed, the current mainstream Oracle ve
I. Problem Description
Install RAC of 11.2.0.1 on Oracle Linux 6.1 and run the root. Sh script when installing grid. The error is as follows:
[Root @ Rac1 bin] #/u01/APP/11.2.0/GRID/root. Sh
Running Oracle 11g root. Sh script...
The following environment variables are Setas:
Oracle_owner = Oracle
ORACLE_HOME =/u01/AP
Label:The Oracle 11g database is installed on Windows 10 and appears many times: a prompt box pops up when the progress bar of the installation is nearing the end. As follows: "Java (TM) 2 Platform standard Edition binary has stopped working; a problem has occurred that causes the program to stop working properly. If a solution is available, Windows closes th
value of the system that installs the Oracle database should be larger than 1/2 of the memory.
Kernel. shmmax = physical memory * 0.8
SHMMNI parameter: set the maximum number of system-level shared memory segments. We recommend that you set the minimum value of Oracle10g to 4096, which can be increased by 4096.
Kernel. shmmni = 4096
SHMALL parameter: Set the total number of pages in the shared memory. If t
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 11G R2 RAC modify archive Mode
The non-archive mode is used by default after the database is created. You need to modify it.
Recommended reading:
Oracle 11g rac ocr and db_unique_name Configuration
Reconfigure and uninstall
, Plsql Developer, bat. Can not be a bat to plsql developer to hack down, is Oracle development did not think of Win7? Baidu Baidu 、、、、 have the following method, the following method is I copy from the various versions out, but completely feasible, I personally tried.Disclaimer: The picture I intercepted from the Internet, because I did not install it, looks a little bitFirst of all: my machine is win7 64-bit flagship version, 64-bit
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
LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/local/lib:Export PATH = $ ORACLE_HOME/bin:/usr/ccs/bin:/etc:/bin:/usr/openwin/bin:/usr/local/bin: /usr/X11R6/bin:Umask 0222. The version is restored to its original state.Vi/etc/redhat-releaseModify this fileRed Hat Enterprise Linux Server release 6.0 (Santiago)3. garbled ProblemExport LANG = en_US before executing./runInstaller
Iii. Configuration and useFinally, how to use and use the two versions of the database
There are two main ways to offload Oracle 11g: One is to use the Oracle Universal Installer management tool, which is simple in wizard mode. Here is the second way to unload the database-----Use the "Deinstall.bat" batch file to unload the database, the following steps:1, fi
Now there is a need to use Exp/imp to import 11g of database data into 9i, to solve this problem generally think of three ways of thinking, try (in fact, from the high version of the server to support the low version of the client principle, you can probably guess the use of 9i client to handle the problem)
Method 1: Export imports all use 11g clients
--
Database partitioning is one of the key functions required by each database. Almost all Oracle databases use the Partition Function to improve query performance. The Oracle 11g Partition Function simplifies the daily management and maintenance of the
The full uninstall mode for Oracle 11g servers and clients has changed with the previous versions:
1. Preparations before uninstallation: Start-> Settings-> Control Panel-> management tools-> servicesStop all Oracle services.
Ii. Batch unload: Run the deinstall. bat batch file of H: \ app \ Administrator \ product \ 1
with the installation. Installing here will have two scripts that need to be executed by the root user. Open the Xshell to execute both scripts as root user. [Email protected] ~]#/orainventory/orainstroot.sh [Email protected] ~]# /oracle_11g/oracle/root.sh Oracle 11g R2 Database software has been installed after
The full uninstall mode for Oracle 11g servers and clients has changed with the previous versions:1. Preparations before uninstallation: Start-> Settings-> Control Panel-> management tools-> servicesStop all Oracle services.Ii. Batch unload: Run the deinstall. bat batch file of H: \ app \ Administrator \ product \ 11.2
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.