oracle创建数据库步骤

1、oracle安装成功后， cmd sqlplus，然后system/orcl as sysdba

2、更改scott的密码，scott的默认密码是tiger

SQL> alter user scott account unlock;

用户已更改。

SQL> commit;

SQL> conn scott/tiger

ERROR:

ORA-28001: the password has expired

更改 scott 的口令 新口令:youotech 重新键入新口令:youotech 口令已更改 已连接。

3、oracle查看版本

select * from v$version;

select * from product_component_version;

4 http://blog.csdn.net/wangjialiang/article/details/7867791

http://blog.csdn.net/cl000001/article/details/4312150

5、使用Database Configuration Assistant创建数据库,可以使用cmd dbca进入

6、http://www.cnblogs.com/heige/p/3544762.html

cmd sqlplus，然后system/orcl as sysdba

create temporary tablespace NS_temp

tempfile 'D:\app\administrator\oradata\NS\NS_temp.dbf'

size 50m

autoextend on

next 50m maxsize 20480m

extent management local;

create tablespace NS_data

logging

datafile 'D:\app\administrator\oradata\NS\NS_data.dbf'

size 50m

autoextend on

next 50m maxsize 20480m

extent management local;

create user NS identified by NS

default tablespace NS_data

temporary tablespace NS_temp;

grant create session to NS;

grant create table to NS;

7、配置客户端tnsnames.ora文件

8、关闭防火墙

9、http://blog.csdn.net/kingliu_leo/article/details/4276791