Install Oracle10g and ToadforOracle

Source: Internet
Author: User
I used Oracle three years ago and simply "used it". It mainly refers to some database operations and does not include the creation of some stored procedures. So I only know a little about Oracle, at that time, all the items in the database in that company were under the responsibility of those consultants. In addition, I just went to that company, so I just made some additions, deletions, changes, and queries.

I used Oracle three years ago and simply "used it". It mainly refers to some database operations and does not include the creation of some stored procedures. So I only know a little about Oracle, at that time, all the items in the database in that company were under the responsibility of those consultants. In addition, I just went to that company, so I just made some additions, deletions, changes, and queries.

I used Oracle three years ago and simply "used it". It mainly refers to some database operations and does not include the creation of some stored procedures. So I only know a little about Oracle, at that time, in that company, all the items in the database were under the responsibility of those consultants. In addition, I just went to that company, so I just did some operations to add, delete, modify, and query, it's really embarrassing to generate some reports. I have organized a simple development framework that only supports SQL Server databases. Two friends once contacted me to support Oracle, because the existing databases in their company are Oracle, it cannot be changed. Recently I am busy, so I want to see how difficult it is to use Oracle for this program. Today I installed the Oracle 10g version and wrote down some of the installation tips and steps, it would be better if you could help everyone. If you have any help, please click "recommendation". If you have any suggestions, please pay attention to them. Let's discuss and make progress together. The text is relatively small, because the picture is more realistic:

Because the environment is different, the size cannot be unified. Please wait...

First install Oracle

Create Database files through DCA,

After the database is created, we need to install the English version of Quest Toad for Oracle v9.1.0.62,

Use Quest Toad for Oracle to operate databases,

After the Quest Toad for Oracle v9.1.0.62 English version is installed, we create a user through SQLPLUS

Authorization is required after the user is created. Otherwise, the user cannot log on to the database, let alone operate the database:

Open Quest Toad for Oracle and enter the user name and password to connect to the database.

If the message "unable to parse the specified connection identifier" is displayed, you may need to configure a local listener,

To configure a listener, follow these steps:

If the connection fails, check whether the password is incorrect. Click "Change Logon" to change the user name and password.

First, create a table and select from the menu,

DataBase-Create-Table

After the data table is created, Insert a test record, as shown in. We can see that our records have been added. Note that if the current account is not authorized by SYSDBA, therefore, the table cannot be operated. At that time, I did not Insert the table. This SQL statement was executed all the time and no error was prompted. Later I found that I was not authorized to operate the table, therefore, you can use SQLPLUS to grant permissions.

You can also use the SQLPLUS command to operate the database.


Http://www.cnblogs.com/allen0118/archive/2012/12/07/2807435.html

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.