数据库在安装完成后,在启动时,报错误:ORA-01078: failure in processing system parameters 1[oracle@localhost ~]$ sqlplus /nolog 2SQL*Plus: Release 10.2.0.4.0 - Production on Fri Dec 2 15:56:00 2011 3Copyright (c) 1982, 2007, Oracle. All Rights Reserved. 4SQL> conn /as sysdba; 5Connected to an idle instance. 6SQL> startup 7ORA-01078: failure in processing system parameters 8LRM-00109: could not open parameter file '/opt/oracle/product/10g/dbs/initnis.ora' 9从上面报的错误不难看出是缺少了文件initnis.ora,于是执行cp /opt/oracle/admin/gaxt/pfile/init.ora.1122011151513 /opt/oracle/product/10g/dbs/initnis.ora 10重新启动, 11SQL> conn /as sysdba; 12Connected to an idle instance. 13SQL> startup 14ORACLE instance started.……
DML—-Data Manipulation Language 数据操纵语言 如insert,delete,update,select(插入、删除、修改、检索) DDL—-Data Definition Language 数据库定义语言 如 create procedure之类 DCL—-Data Control Language 数据库控制语言 如grant,deny,revoke等,只有管理员才有这样的权限。……