centos 安装oracle 11g r2（三）-----表空间创建

[@H_874_23@[email protected] ~@H_874_23@]@H_874_23@$ lsnrctl start

@H_403_6@LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 01-DEC-2017 09:25:48

@H_403_6@Copyright (C) 1991,2009,Oracle. All rights reserved.

@H_403_6@StarTing /data/Oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...
......
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 01-DEC-2017 09:25:48
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /data/Oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File
/data/Oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints SumMary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
The listener supports no services
The command completed successfully

[@H_874_23@[email protected] ~@H_874_23@]@H_874_23@$ sqlplus /@H_874_23@ as@H_874_23@ sysdba

@H_403_6@sql*Plus: Release 11.2.0.1.0 Production on Fri Dec 1 09:25:51 2017

@H_403_6@Copyright (C) 1982,Oracle. All rights reserved.

@H_403_6@Connected to an idle instance.

sql>@H_874_23@ startup

@H_403_6@OracLE instance started.

@H_403_6@@R_944_10586@l System Global Area 1586708480 bytes
Fixed Size 2213736 bytes
Variable Size 922749080 bytes
Database Buffers 654311424 bytes
Redo Buffers 7434240 bytes
Database mounted.
Database opened.

sql>@H_874_23@ create@H_874_23@ tablespace tjyd DATAFILE ‘@H_874_23@/data/Oracle/oradata/BDCS/tjyd.dbf@H_874_23@‘@H_874_23@ size 128M autoextend on@H_874_23@ next@H_874_23@ 256M @H_888_31@maxsize 2048M extent management local;

sql>@H_874_23@ CREATE@H_874_23@ USER@H_874_23@ tjyd IDENTIFIED BY@H_874_23@ tjyd ACCOUNT UNLOCK DEFAULT@H_874_23@ TABLESPACE tjyd;

sql>@H_874_23@ GRANT@H_874_23@ CONNECT,resourcE TO@H_874_23@ tjyd; 

sql>@H_874_23@ GRANT@H_874_23@ DBA TO@H_874_23@ tjyd; 

sql>@H_874_23@ exit@H_874_23@ 

Disconnected from@H_874_23@ Oracle Database@H_874_23@ 11g Enterprise Edition Release 11.2@H_874_23@.0.1@H_874_23@.0@H_874_23@ -@H_874_23@ 64bit@H_874_23@ Production
@H_874_23@With@H_874_23@ the Partitioning,OLAP,Data Mining and@H_874_23@ Real@H_874_23@ Application TesTing options
@H_874_23@[@H_874_23@[email protected] ~@H_874_23@]@H_874_23@$