3,490
社区成员
发帖
与我相关
我的任务
分享
sqlplus / as sysdba <<!
---建立实例级表空间
create tablespace toadrbs datafile '/home/oracle/oradata/toadzw/toadrbs01.dbf'
size 300m
autoextend on next 50m maxsize 500m
default storage( initial 20m next 20m minextents 2 maxextents 249
pctincrease 5 );
----建立用户级表空间
create tablespace toadzw datafile '/home/oracle/oradata/toadzw/toadzw_01.dbf'
size 300m
autoextend on next 50m maxsize 500m
default storage( initial 12k next 12k minextents 2 maxextents unlimited
pctincrease 5 );
----建立用户级索引表空间
create tablespace toadzw_idx datafile '/home/oracle/oradata/toadzw/toadzw_idx01.dbf'
size 300m
autoextend on next 50m maxsize 500m
default storage( initial 12k next 12k minextents 2 maxextents unlimited
pctincrease 5 );
---建立回滚段
create public rollback segment toadrbs01 tablespace toadrbs
storage( initial 10m next 10m optimal 20m );
create public rollback segment toadrbs02 tablespace toadrbs
storage( initial 10m next 10m optimal 20m );
create public rollback segment toadrbs03 tablespace toadrbs
storage( initial 10m next 10m optimal 20m );
create public rollback segment toadrbs04 tablespace toadrbs
storage( initial 10m next 10m optimal 20m );
alter rollback segment toadrbs01 online;
alter rollback segment toadrbs02 online;
alter rollback segment toadrbs03 online;
alter rollback segment toadrbs04 online;
!
sqlplus / as sysdba <<!
create user toadzw identified by toadzw ;
grant resource , connect , create session to toadzw;
grant dba to toadzw ;
alter user toadzw default tablespace TOADZW;
alter user toadzw temporary tablespace TEMP ;
!
可是我重新启动数据库后使用sqldevelopment 中添加.ora文件TOADZW =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.9.63)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = toadzw)
)
)
可是总说后台没有监听12514错误;如何解决;