Steps for creating an Oracle database manually

Source: Internet
Author: User

Steps for creating an Oracle database manually
Write initialization parameter file settings operating system environment variable create instance connect database as Administrator Start instance create database run data dictionary script Oracle network configuration (Client Connected 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 autocreateinstance.png sid is the Oracle "ID card number" Administrator identity in the operating system to connect to the database sqlplus utility to log on to the database. In the doscommand, enter sqlplus/nolog, but the login status is only to connect to the database as the database administrator. enter 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 because the configuration file needs to be found during database startup., 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 the corresponding binary file to overwrite the old binary file create databae create database script three file control file data file redo log file create database zhouytdatafile 'C: \ oracle \ product \ 10.2.0 \ db_2 \ system_01.dbf 'size 100 m Autoextend on next 10 m maxsize unlimitedsysaux datafile 'C: \ oracle \ product \ 10.2.0 \ db_2 \ zhouyt \ systemaux_0 1. dbf 'size 60 m Autoextend on next 10 m maxsize unlimitedlogfilegroup 1 ('C: \ oracle \ product \ 10.2.0 \ db_2 \ zhouyt \ log_1_01.rdo ') size 10 m, group 2 ('C: \ oracle \ product \ 10.2.0 \ db_2 \ zhouyt \ log_2_01.rdo ') size 10 mcharacter 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

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.