Several errors and solutions encountered during manual creation of Oracle, oracle Solutions

Source: Internet
Author: User

Several errors and solutions encountered during manual creation of Oracle, oracle Solutions

There are a lot of errors when you create an Oracle database manually. This process is really disappointing. But when you see that the database is successfully created, you are very happy, now I will list all my problems and hope you can learn from each other.


Error 1:


This is because the current user does not have the permission to log on again.


Error 2:


The prompt here is for a long time. Only later can we find that there is no space in the middle of this statement. Therefore, we need to set the password and entries separately.

 

(3) when starting a routine, the following command appears:

 

 

This is because Oracle is running and the Oracle-related services cannot be closed later. Finally, execute this statement.

Shutdown immediate, run conn sys/a as sysdba, and then run startup nomount.

Close the routine.

 

 

 

(4) when running the script, there is always an error, that is, the current sid is jxgl and the database to be created is jxgl2. Use the command

Show parameter name finds that db_name is always jxgl


Enter the command set oracle_sid = jxgl2 as the administrator in cmd, so that the current instance name is jxgl2.

 

(6) This error always occurs when running the script. Modify tnsnames later. ora, add a listener for jxgl2, and create a new folder jxgl2 in D: \ oracle11g \ zjq \ flash_recovery_area.

 

 

(7) This message appears when you enter DBConsole.



Then run the command set ORACLE_NAME = orcl.

 

 



In short, it took two days to create an Oracle database using the command line. I am also drunk. It is really troublesome.

Related Article

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.