oracle考试试题.docxVIP

数据库软件安装设置主机的DNS和主机名相关信息/etc/hosts/etc/sysconfig/network创建必要的用户组和安装目录注：重启生效安装数据库软件Section 0Using the CREATE DATABASE command,create a database using the specifications scripts besides those listed below.the database name is PRODthe instance name is PRODensure the value for the ORACLE_SID environmental variable ORACLE_SID=PRODthe passwords for SYS and system shall be ORACLEthere is sample file named initPORD.ora /home/oracle/ to the appropriate directory and modified as required, to user for your databasecreate the system tablespace locally manageduser the directory structure found under the following directory which simulate multiple path (disk1-disk5):/u01/app/oracle/oradata/PROD/do not run any other scriptsensure your database is open for access.在目录$ORACLE_BASE/admin下创建PROD,并在$ORACLE_BASE/admin/PROD下创建adump/bdump/cdump/udump在目录$ORACLE_BASE/oradata下创建PROD,并在该目录下创建disk1/disk2/disk3/disk4/disk5目录用于存放数据在目录$ORACLE_HOME/dbs目录下创建初始化文件initPROD.oraStartup nomount下建立spfile文件并启动实例关闭数据库，并重新启动，目的是使用spfile文件启动数据库.Startup nomount下设置相关参数:创建密码文件:Nomount模式下创建数据库:Database setup and undo management1、Run the minimum require scripts to complete the basic configuration of database.Connect:sys/ORACLE as system [startup]SQL@?/rdbms/admin/catalog.sql#创建数据库字典文件SQL@?/rdbms/admin/catproc.sql#创建数据库基本存储过程及包SQL@?/rdbms/admin/catblock.sqlSQL@?/rdbms/admin/catoctk.sqlSQL@?/rdbms/admin/owminst.plbConnect:system/oracleSQL@?/sqlplus/admin/pupbld.sql启动错误信息:ORA-00704: 引导程序进程失败ORA-39700: 必须用 UPGRADE 选项打开数据库解决方案:SQLstartup upgrade #启动数据库SQLshow parameter sql_trace; #查看是否打开日志记录SQLalter system set sql_trace=true scope=spfile;SQLshutdown immediate #关闭数据库再次启动数据库,报错,看日志信息SQLstartupORA-01092:ORACLE实例终止,强行断开连接查看xxx.trc日志文件：PARSING IN CURSOR #5 len=63 dep=1 uid=0 oct=3 lid=0 tim=1226366925317451 hv=3748897726 ad=3fb20db8SELECT NULL FROM REGISTRY$ WHERE CID=CATPROC AND VERSION = :1我们发现这是因为没有执行cataproc.sql脚本文件.SQLstartup upgradeSQL@?/rdbms/admin/cataproc.sqlSQLshutdown immediate2、Set up automatic undo