Create databases manually and resolve ora-01092 and ora-12560____ databases

Source: Internet
Author: User
Tags create database sqlplus
Create databases manually and resolve ora-01092 and ora-12560
Today, the first time to create a database manually, encountered a lot of problems, are a bit want to give up, usually using Databaseconfiguration Assistant to create, I will tell you the process of creating Oracle database and the errors encountered during the creation process and the solution .

Installation Environment:

Operating system: Windows XP Professional

Database version: Oracle database 10g release 10.1.0.2.0-production

Installation steps:

1. First, I copy Init.ora from the original database, modify it (mainly to change the location and database name of the database file), and create the directory (data file, control file, log file, archive log file) of the database file.

2. Set Oracle_home,set oracle_home= directory name

3. Create a new instance, Oradim new-sid sid syspwd Password

4. Modify the Oracle_sid in the registry to the newly created instance name-otherwise (when the database is created and logged on to the database as Sqlplus/as sysdba) Ora-12560:tns:protocol Adaptererror

5. In the SYS identity Landing, startup Pfile= just created the Nomount

6. Start creating the database below

(1) CREATE DATABASE db
(2) Maxlogfiles 10
(3) Maxlogmembers 5
(4) Maxdatafiles 20
(5) Maxloghistory 200
(6) Maxinstances 5
(7) LogFile
(8) Group 1 ' D:\oradate\db\redo01.log ' size10m,
(9) Group 2 ' D:\oradate\db\redo02.log ' size10m,
(a) Group 3 ' D:\oradate\db\redo03.log ' size10m
(one) datafile ' D:\oradate\db\system01.dbf ' size100m
() sysaux datafile ' D:\oradate\db\sysaux01.dbf ' size 50m
(UNDOTBS1) Undo Tablespace
(a) datafile ' D:\oradate\db\undo01.dbf ' size40m
() Default Temporary tablespace Temp
(a) tempfile ' D:\oradate\db\temp01.dbf ' size20m
(Extent management Local uniform size128k
(character) Set ZHS16GBK
National Character Set Al16utf16

--(12) is necessary to start writing in accordance with the ocp031 to create, the old mention is that sysauxdatafiles is necessary-(as if the meaning is almost like this, I also remember not clear), and then on the Internet to find, To know that creating a database in 10g must specify the Sysaux tablespace

--(13) Note that the name of the undo tablespace must be UNDOTBS1
Otherwise, there will be the Ora-1092,alter.log in the startup when the specific error is as follows

ORA-30012 signalled during:create UNDO tablespace undo1datafile ' D:\oradate ...
Sun Apr 08 11:43:56 2007
Errors in file d:\app\admin\db\udump\db_ora_3720.trc:
Ora-00604:error occurred at recursive SQL level 1
Ora-30012:undo tablespace ' UNDOTBS1 ' does not exist or of wrongtype

See this error prompted, try to change the undo Tablespace renamed to UNDOTBS1, the result of the database was installed successfully

On the internet to find ora-01092, in fact, a big brother has given a solution, but then did not look carefully, and then after the database installed to see the ora-01092 solution, only to find himself white busy for a long time, people have written a solution, but is not used, after the completion of the database, And looked back over the article.

The creation of this database is complete, followed by the installation script, and found that many scripts were not successfully installed

(one)--system table space is insufficient. Cause the consequences

Error hints in Alert.log

Ora-1653:unable to extend table SYS. obj$ by 13in Tablespacesystem--at first don't know what meaning, this should be prompted to say that the system table space is not enough, this error is later when you set up the data table, also reported that the system table space is insufficient, Then it was normal to increase the system tablespace (the answer is also found on the Internet)

The final problem is found in the installation of Sqlplus help, the Internet to see the installation of Sqlplus help to use Helpbld.sql and Helpus.sql, but I ran the script to enter the second parameter, I do not know what to lose, Later went to see Helpbld.sql and Hlpbld.sql source files, found that the former is required two parameters, the latter only need to enter a parameter, use Hlpbld.sql to create parameters is Helpus.sql

The last is to create SPFile

Create SPFile from pfile= initial file path

This is the whole process of creating a database today.

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.