1. Oracle 11g R2 Installation Manual (graphic tutorial) for Windows1. Download the Oracle 11g R2 for Windows version, as followsOfficial website:Http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_database_1of2.zipHttp://download.oracle.com/otn/nt/oracle11g/112010
NextReport a prompt, found that the listener is running, the purpose to achieve, select NoGo back to configure the main page, select the Local network service name configuration, click NextIn the drop-down box, select Orcl NextService Name Fill ORCL NextSelect TCP Nexthostname complete localhost, using standard port number 1521 nextCheck to test nextShow the test is unsuccessful, it's OK, click Change Login, Test success will not point the next stepFill in the account and password that we confi
to resolve it:1, error code: ORA-1254, the listener is not started or the listener is corrupted.If the listener does not start, the service Oracleoradb11g_home1tnslistener is started in the system service;If the listener is corrupted, then configure a listener using the listener configuration in the Net Configuration Assistant Tool Wizard (you need to delete the original listener).2. When connecting, use the service name instead of the SID.3. Error code: ora-12154,
Oracle 11g R2 installation tutorial, oracle11g
I,
Note that Oracle is divided into two files. After downloading, extract the two files to the same directory.
In the path name, it is best not to show Chinese characters or irregular characters such as spaces.
Official Address: Beijing.
Win 32-bit operating system: http:/
shown in, click Next.
Management options. Click Next directly, as shown in.
Database storage. Click Next directly, as shown in.
Backup and recovery. If you need to back up your data, enable automatic backup, and select "Do not enable automatic backup" here, as shown in, click Next.
Scheme password. For ease of testing, the same password is used here, and the actual deployment can be done at your own discretion.
Profile. After you complete the prerequisite check, click Finish to start
Graphic tutorial on connecting eclipse to oracle 11g Database
Eclipse is an open-source and Java-based scalable development platform. Eclipse comes with a standard plug-in set, including Java Development Kit (JDK ).
1. First, create a project DB, right-click the DB, and select Build Path --> Configure Build Path.
Use Add External JARs .. to select ojdbc14.jar un
Tags: Oracle proxy Server Windows database1. Download the Oracle 11g R2 for Windows version, the official website is as follows:Http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_database_1of2.zip Http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_database_2of2.zip2. Extract the two compressed packages to the same directory (in the same fo
, as shown in.
Database storage. Click Next directly, as shown in.
Backup and recovery. If you need to back up your data, enable automatic backup, and select "Do not enable automatic backup" here, as shown in, click Next.
Scheme password. For ease of testing, the same password is used here, and the actual deployment can be done at your own discretion.
Profile. After you complete the prerequisite check, click Finish to start the installation formally, as shown in, click Next.
Install th
the management password to contain at least one uppercase letter, a lowercase letters and a number, otherwise you will be prompted to warn, correct input and click "Next" to continue. 9. The Prerequisite Check dialog box appears, select Ignore All and click Next to continue. 10. Then click "Finish" to start the installation. 11. The installation screen looks like this: 12. When the above progress reaches 100%, a line dialog will appear, please be patient and wait for it to complete. After
normal.
Path:d:\app\administrator\product\11.2.0\client_1;d:\app\administrator\product\11.2.0\dbhome_1\bin; ...
The fourth is Oracle_sid (ORCL instance name, which is the name of the database at installation time)
Oracle_sid:orcl
The fifth one is oracle_home.
Oracle_home: You can not set, if the settings must be correct, otherwise can not be used.
If you forget the instance name at Oracle installation, you can open the registration view, as sho
www.osyunwei.com Warm reminder: qihang01 original content Copyright, reproduced, please indicate the source and the original link
6, restore the operating system identification
Vi /etc/redhat-release #edit
Put: redhat-4
Modified as: CentOS release 5.8 (Final)
:wq! #Save exit
7, change the system default startup level is 3
Vi /etc/inittab #edit
Id:3:initdefault: #改5为3
:wq! #Save exit
8, test
Shutdown -r now #restart the system
Service oracle
With the rapid development of Oracle technology and the market, the number of people working in Oracle DBA is getting bigger and bigger. I can see from some posts that I often post on forums and communities, many people are eager to work in this field now or in the future, and the market demand is also very large, but it is not hard to see that each company has h
-"Succeeded" items that have been checked and click "Next.
Select "Install Software Only" and Install the database through dbca after installation. Next step. You can also select "Create a Database" in this step to install the Database.
Set all groups to dba. Next step.
Click "Install" now. The process will take a long time and the system will slow down. Therefore, you 'd better take a book and have a cup of coffee. Sometimes the system will become
the next step. Select "Install Software only", and so on after loading and then through the DBCA to install the database, next. You can also choose Create a database in this step to install the databases. Set all groups to: DBA, next. Now you can point to "Install": The process will wait a long time, and the system slows down, so you'd better take a book and have a cup of coffee. Sometimes the system will become very slow, like to crash, this do not
Install Oracle 11g R2 + RAC + ASM in Oracle Linux 6.4
I. Version descriptionMany articles related to the Internet are found, but they are not very specific. Therefore, the detailed version is used to make the article more practical.This is the RAC environment of Oracle 11g R
Oracle users have relatively large permissions. Therefore, you may need to use non-oracle users to manage related databases. In particular, it is necessary for multiple individuals to add different users to the system or database, and then add these users to the dba group. These users can also set different environment variables based on their preferences. This a
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.