Manually create a database and solve ora

Manually create a database and solve the ora-01092 and ora-12560 for the first time to manually create a database today, encountered a lot of problems, are a bit want to give up, usually is the use of DatabaseconfigurationAssistant to create, the following describes the process of creating an oracle database, the errors encountered during the creation process, and the solutions. installation environment: Operation

Manually create a database and solve the ora-01092 and ora-12560 today the first time to manually create a database, encountered a lot of problems, are a bit want to give up, usually is the use of Databaseconfiguration Assistant to create, the following describes the process of creating an oracle database, the errors encountered during the creation process, and the solutions. installation environment: Operation

Manual database creation and resolution ora-01092 and ora-12560

The first time I created a database manually today, I had a lot of problems and wanted to give up. I usually used Databaseconfiguration Assistant to create a database, the following describes the process of creating an oracle database, the errors encountered during the creation process, and the solutions.

Installation environment:

Operating System: Window xp professional

Database Version: Oracle Database 10g Release 10.1.0.2.0-Production

Installation steps:

1. first, I copied init from the existing database. ora, to modify it (mainly to change the location where some database files are stored and the database name), and create a directory for storing database files (data files, control files, log files, archive log files)

2. set oracle_home, set ORACLE_HOME = directory name

3. Create a new instance, oradim new-sid syspwd password

4. Modify ORACLE_SID in the registry to the new instance name.-- Otherwise the ora-12560: TNS: protocol will appear when you log on to the database like sqlplus/as sysdba after creating the databaseAdaptererror

5. log in as sys, startup pfile = nomount just created

6. Create a database

(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,
(10) group 3 'd: \ oradate \ db \ redo03.log 'size10m
(11) datafile 'd: \ oradate \ db \ system01.dbf 'size100m
(12) sysaux datafile 'd: \ oradate \ db \ sysaux01.dbf' size 50 m
(13) undo tablespace UNDOTBS1
(14) datafile 'd: \ oradate \ db \ undo01.dbf' size40m
(15) default temporary tablespace temp
(16) tempfile 'd: \ oradate \ db \ temp01.dbf 'size20m
(17) extent management local uniform size128k
(18) character set ZHS16GBK
(19) national character set AL16UTF16

-- (12) is required. It is created according to ocp031 at the beginning of writing. It is always said that sysauxdatafiles is required, I can't remember). Later I went online and found out that the sysaux tablespace must be specified when creating a database in 10 Gb.

-- (13) Note that the name of the undo tablespace must be UNDOTBS1.
Otherwise, the ora-1092 will appear at startup, and the specific error in alter. log 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_371_trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-30012: undo tablespace 'undotbs1 'does not exist or of wrongtype

When this error message is displayed, rename undo tablespace to UNDOTBS1. As a result, the database is successfully installed.

Internet looking for ora-01092, in fact there is a eldest brother has given a solution, but at that time did not go to view carefully, then after loading the database to see a ora-01092 solution, I found myself busy for a long time. People have already prepared a solution, but they won't use it. After the database is built, I looked back at the article.

The creation of this database is complete, followed by the installation script, and many scripts are not installed successfully.

(11) -- The system tablespace is insufficient.

Error message in Alert. log

ORA-1653: unable to extend table SYS. OBJ $ by 13in TablespaceSYSTEM -- I don't know what it means at the beginning. This should be a prompt that the system tablespace is not large enough. This error is reported when I create a data table myself, later, it was normal to increase the system tablespace (the answer was also found online)

The last problem was found when sqlplus was installed. helpbld was used when sqlplus was installed on the Internet. SQL and helpus. SQL, But I was prompted to enter the second parameter when I run the script. I didn't know what to enter. Later I went to view helpbld. SQL and hlpbld. SQL source file, it is found that the former requires two parameters, the latter only needs to enter one parameter, then hlpbld is used. SQL to create the parameter helpus. SQL

Finally, create a spfile.

Create spfile from pfile = initial file path

This is the whole process of creating a database today.