Manual creation procedure for Oracle 10 Gb Database

Manual creation procedure for Oracle 10 Gb Database
Manual creation procedure for Oracle database write initialization parameter file set operating system environment variable create instance connect database as Administrator Start instance create database run data dictionary script Oracle network configuration (client connect to server) the initialization parameter file is copied from % ORACLE_HOME % \ admin \ sample \ pfile initsmpl. add the ora file to the $ ORACLE_HOME % \ database directory and change it to init <sid>. Assume It is changed to initzhouyt. ora. (init is a text file) for initzhouyt. add the parameter * instance_name = zhouyt * db_domain = hdu.edu.cn to modify the parameter * db_name = zhouyt * db_block_size = 8192 (8 kM) * remote_login_passwordfile = exclusive operating system environment variable setting the operating system environment variable oracle_sid points to the database instance name set oracle_sid = zhouyt. This command is only valid currently in the window dos window, when the window is closed, it becomes invalid. If you want to keep the window valid, you need to modify the instance creation utility oradim in the system environment variable by entering the oradim-new-sid zhouyt-intpwd sys123 command in the DOS window (sys is the administrator) -startmode autosid is the Oracle "ID number" in the operating system. The Administrator connects to the database sqlplus utility to log on to the database. In the doscommand, enter sqlplus/nolog. Only the logon status is based on the database administrator's identity to connect to the database. run the connect sys/sys123 as sysdba command to log on as the database administrator. you can install the database startup instance to convert the text initialization parameter file pfile to the binary initialization parameter file spfile. The configuration file needs to be found when the database is started, by default, you can search for binary files or manually start text files. You do not need to enter the create spfile from pfile command in this step. (An error will be reported, because text files are older than Oracle 10 Gb), we need to modify the configuration file initzhouyt. ora
SPFILEZHOUYT will be generated in the % ORACLE_HOME % \ database file. the ora file starts the instance command startup nomount in the form of nomount, and an error will occur. After we modify the text file as prompted, if we continue to start it according to startup nomount, we need to generate a binary file to overwrite the old binary file and comment % seed_control % create databae create DATABASE script three files control file data file redo log file

create database zhouytdatafile     'C:\oracle\product\10.2.0\db_2\zhouyt\system_01.dbf' size 100m      Autoextend on next 10m maxsize unlimitedsysaux datafile     'C:\oracle\product\10.2.0\db_2\zhouyt\systemaux_01.dbf' size 60m      Autoextend on next 10m maxsize unlimitedlogfilegroup 1 ('C:\oracle\product\10.2.0\db_2\zhouyt\log_1_01.rdo') size 10m,group 2 ('C:\oracle\product\10.2.0\db_2\zhouyt\log_2_01.rdo') size 10mcharacter set zhs16gbk;

 

Make sure that the directory file "db_2 \ zhouyt" generates two data files and two redo log files. What about the control file? After running the data dictionary script _ database creation, the system generates two administrator users sys and system to run three data dictionary scripts catalog. SQL creates common data dictionary views and synonyms in the system (sys logon); catproc. SQL creates PL/SQL usage environments, and creates several PL/SQL packages for extending the RDBMS functions (sys logon); pupbld. SQL is required when using the SQL * PLUS environment (system logon) in the command line, enter @ Add the absolute path of the script file. The Second Script process is the same as the first one. To execute the third script, you need to switch to the system user connect system/manager // code @ C: \ oracle \ product \ 10.2.0 \ db_2 \ sqlplus \ admin \ pupbld. create scott mode in SQL @ C: \ oracle \ product \ 10.2.0 \ db_2 \ RDBMS \ ADMIN \ scott. SQL