:::互联网信息技术研究中心:::

SQL> startup nomount pfile=/u01/app/oracle/admin/orcl/pfile/init.ora.11920112840

ORACLE 例程已经启动。

Total System Global Area  595591168 bytes
Fixed Size                  1291940 bytes
Variable Size             167774556 bytes
Database Buffers          419430400 bytes
Redo Buffers                7094272 bytes
SQL> CREATE CONTROLFILE REUSE DATABASE “ORCL” NORESETLOGS NOARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 3
MAXDATAFILES 32
MAXINSTANCES 16
MAXLOGHISTORY 1600
LOGFILE
GROUP 1 (‘/u01/app/oracle/oradata/orcl/redo01.log’) size 20480k ,
GROUP 2 (‘/u01/app/oracle/oradata/orcl/redo02.log’) size 20480k,
GROUP 3 (‘/u01/app/oracle/oradata/orcl/redo03.log’) size 20480k
DATAFILE
‘/u01/app/oracle/oradata/orcl/UNDOTBS01.DBF’,
‘/u01/app/oracle/oradata/orcl/SYSTEM01.DBF’,
‘/u01/app/oracle/oradata/orcl/SYSAUX01.DBF’,
‘/u01/app/oracle/oradata/orcl/USERS01.DBF’
CHARACTER SET ZHS16GBK;

控制文件已创建。 (more…)

一. 查看数据文件
SQL> select name from v$datafile;

NAME
——————————————————–
/u01/app/oracle/oradata/orcl/SYSTEM01.DBF
/u01/app/oracle/oradata/orcl/UNDOTBS01.DBF
/u01/app/oracle/oradata/orcl/SYSAUX01.DBF
/u01/app/oracle/oradata/orcl/USERS01.DBF

二. 查看控件文件
SQL> select name from v$controlfile;

NAME
———————————————————-
/u01/app/oracle/oradata/orcl/CONTROL01.CTL
/u01/app/oracle/oradata/orcl/CONTROL02.CTL
/u01/app/oracle/oradata/orcl/CONTROL03.CTL

三. 查看日志文件
 
SQL> select member from v$logfile;

MEMBER
————————————————–
/u01/app/oracle/oradata/orcl/REDO03.LOG
/u01/app/oracle/oradata/orcl/REDO02.LOG
/u01/app/oracle/oradata/orcl/REDO01.LOG

Microsoft Windows [版本 6.1.7601]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。

C:UsersAdministrator>sqlplus /nolog

SQL*Plus: Release 10.2.0.3.0 – Production on 星期二 2月 28 09:16:01 2012

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

SQL> conn /as sysdba
ERROR:
ORA-01031: insufficient privileges

ORA-01031:提示权限不足，因为使用的是windows怀疑是不是用户组或者用户权限问题，于是做了以下尝试
右键我的电脑-管理-本地用户和组-组-在右边找到ora_dba组-双击打开-添加-高级-立即查找-找到当前用户添加

(more…)