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

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.