1.选择一张表视图，双击->选项卡Columns->Customize columns and filter(快捷键Ctrl+U)->选择(Name,Comment[注释],Data Type,Length,Precision,Primary,Foreign Key,Mandatory->ok
1.File->Reverse Enginner->Database->
2.选择数据库(share the DBMS definition)
3.Using a data source->
4.选择Connection profile->Configure…->
5.Connection Profile->Add Data Source->
6.Connection type(JDBC)->DBMS type(Oracle)->User name(user)->Password(password)->JDBC driver class(oracle.jdbc.OracleDriver)->JDBC connection URL(jdbc:oracle:thin:@192.168.50.248:1521:RACDB1)->JDBC driver jar file(请选择对应版本的的odbc14.jar，不要用自带的)->点击OK
7.wait…
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组-双击打开-添加-高级-立即查找-找到当前用户添加
