oracle11g steps to create a data warehouse (illustrated)

Source: Internet
Author: User

I was the first time to install the orgal11g Data Warehouse, in the installation process, there are many problems. The installation process and the problem-solving solution are documented. If there is any shortage, please criticize the advice.
1. Ensure that the orcal11g is installed in the system. Because of the limitations, I install both the server and the client on the local machine. The local environment is as follows.

Use the SYSDBA link to log into the ORCL database. Success.


The Start menu for installing Orcale 11G is as follows.


1. Select Repository Assistant Start installation


2. The default selection is to manage the warehouse Builder (warehouse builder) workspace.


3. Enter local machine name, default port number, enter service name


4. Select Default New workspace.


5. Create a new user

6. Error entering username password randomly. You should enter the database administrator user name.


When the input database administrator user still complains. You should test for server-side links in the net manager for problems.


Link test failed.

Landing test with Pl/sql failed.
A local service host name error was found and the local machine host name was modified.


Save the test and find that the service is OK but the user is locked.


Solution: Use SYSDBA link to login ORCL database. Success.


Unlock users with commands in Pl/sql. Alter user SYSTEM account unlock;
A password error was found. Alter user system identified by system, using commands to modify passwords.


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.