3
回答
oracle: ORA-01109: database not open
【腾讯云】学生服务器套餐10元/月 >>>   

创建表空间的时候出现:



SQL> @create_tsscdb_tabspace.sql
CREATE TABLESPACE tssc_tab DATAFILE '/home/oracle/oradata/tssc_tab.dbf' SIZE 512M AUTOEXTEND ON NEXT 256M MAXSIZE 2048M
*
ERROR at line 1:
ORA-01109: database not open




CREATE TEMPORARY TABLESPACE tssc_tmp_tab TEMPFILE '/home/oracle/oradata/tssc_tmp_tab.dbf' SIZE 64M AUTOEXTEND ON
*
ERROR at line 1:
ORA-01109: database not open




CREATE user tssc IDENTIFIED BY tssc Default tablespace tssc_tab TEMPORARY tablespace tssc_tmp_tab
                               *
ERROR at line 1:
ORA-01109: database not open




GRANT connect,resource,create session TO tssc
*
ERROR at line 1:
ORA-01109: database not open

举报
jize
发帖于4年前 3回/3K+阅
顶部