Microsoft Windows [版本 6.1.7601]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。
C:\Users\Administrator>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.4.0 - Production on 25-4月 -2017 17:3
0:31
Copyright (c) 1991, 2013, Oracle. All rights reserved.
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.48.0.19)(PORT=1521)))
LISTENER 的 STATUS
------------------------
别名 LISTENER
版本 TNSLSNR for 64-bit Windows: Version 11.2.0.4.0 - Produ
ction
启动日期 24-4月 -2017 16:27:59
正常运行时间 1 天 1 小时 2 分 32 秒
跟踪级别 off
安全性 ON: Local OS Authentication
SNMP OFF
监听程序参数文件 E:\app\Administrator\product\11.2.0\dbhome_1\network\a
dmin\listener.ora
监听程序日志文件 E:\app\Administrator\product\11.2.0\dbhome_1\log\diag\
tnslsnr\WINDOWS-ATSO81J\listener\alert\log.xml
监听端点概要...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.48.0.19)(PORT=1521)))
服务摘要..
服务 "ahdb" 包含 1 个实例。
实例 "ahdb", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
命令执行成功
C:\Users\Administrator>set ORACLE_SID=ahdb
C:\Users\Administrator>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on 星期二 4月 25 17:30:48 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> drop user dbframework_gz cascade;
drop user dbframework_gz cascade
*
第 1 行出现错误:
ORA-01940: 无法删除当前连接的用户
SQL> shutdown immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup;
ORACLE 例程已经启动。
Total System Global Area 4.1154E+10 bytes
Fixed Size 2290160 bytes
Variable Size 5502930448 bytes
Database Buffers 3.5568E+10 bytes
Redo Buffers 81580032 bytes
数据库装载完毕。
数据库已经打开。
SQL> drop user dbframework_gz cascade;
用户已删除。
SQL> create user dbframework_gz identified by dbframework_gz369 default tablespa
2 ce dbframework_gz TEMPORARY TABLESPACE TEMP;
create user dbframework_gz identified by dbframework_gz369 default tablespa
*
第 1 行出现错误:
ORA-00921: 意外的 SQL 命令结尾
SQL> create user dbframework_gz identified by dbframework_gz369 default tablespa
ce dbframework_gz TEMPORARY TABLESPACE TEMP;
用户已创建。
SQL> grant dba to dbframework_gz;
授权成功。
SQL> exit
从 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断
开
C:\Users\Administrator>create directory dpdump12 as 'E:\AHBAK';
'create' 不是内部或外部命令,也不是可运行的程序
或批处理文件。
C:\Users\Administrator>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on 星期二 4月 25 17:41:08 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create directory dpdump12 as 'E:\AHBAK'
2
SQL> create directory dpdump12 as 'E:\AHBAK';
目录已创建。
SQL> grant read,write on directory dpdump12 to dbframework_gz;
授权成功。
SQL>
SQL>
SQL> exit
从 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断
开
C:\Users\Administrator>impdp dbframework_gz/dbframework_gz369 directory=dpdump1
2 dumpfile=AH20170425.DUMP logfile=AH20170425.log
Import: Release 11.2.0.4.0 - Production on 星期二 4月 25 17:42:48 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。
C:\Users\Administrator>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.4.0 - Production on 25-4月 -2017 17:3
0:31
Copyright (c) 1991, 2013, Oracle. All rights reserved.
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.48.0.19)(PORT=1521)))
LISTENER 的 STATUS
------------------------
别名 LISTENER
版本 TNSLSNR for 64-bit Windows: Version 11.2.0.4.0 - Produ
ction
启动日期 24-4月 -2017 16:27:59
正常运行时间 1 天 1 小时 2 分 32 秒
跟踪级别 off
安全性 ON: Local OS Authentication
SNMP OFF
监听程序参数文件 E:\app\Administrator\product\11.2.0\dbhome_1\network\a
dmin\listener.ora
监听程序日志文件 E:\app\Administrator\product\11.2.0\dbhome_1\log\diag\
tnslsnr\WINDOWS-ATSO81J\listener\alert\log.xml
监听端点概要...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.48.0.19)(PORT=1521)))
服务摘要..
服务 "ahdb" 包含 1 个实例。
实例 "ahdb", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
命令执行成功
C:\Users\Administrator>set ORACLE_SID=ahdb
C:\Users\Administrator>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on 星期二 4月 25 17:30:48 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> drop user dbframework_gz cascade;
drop user dbframework_gz cascade
*
第 1 行出现错误:
ORA-01940: 无法删除当前连接的用户
SQL> shutdown immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup;
ORACLE 例程已经启动。
Total System Global Area 4.1154E+10 bytes
Fixed Size 2290160 bytes
Variable Size 5502930448 bytes
Database Buffers 3.5568E+10 bytes
Redo Buffers 81580032 bytes
数据库装载完毕。
数据库已经打开。
SQL> drop user dbframework_gz cascade;
用户已删除。
SQL> create user dbframework_gz identified by dbframework_gz369 default tablespa
2 ce dbframework_gz TEMPORARY TABLESPACE TEMP;
create user dbframework_gz identified by dbframework_gz369 default tablespa
*
第 1 行出现错误:
ORA-00921: 意外的 SQL 命令结尾
SQL> create user dbframework_gz identified by dbframework_gz369 default tablespa
ce dbframework_gz TEMPORARY TABLESPACE TEMP;
用户已创建。
SQL> grant dba to dbframework_gz;
授权成功。
SQL> exit
从 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断
开
C:\Users\Administrator>create directory dpdump12 as 'E:\AHBAK';
'create' 不是内部或外部命令,也不是可运行的程序
或批处理文件。
C:\Users\Administrator>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on 星期二 4月 25 17:41:08 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create directory dpdump12 as 'E:\AHBAK'
2
SQL> create directory dpdump12 as 'E:\AHBAK';
目录已创建。
SQL> grant read,write on directory dpdump12 to dbframework_gz;
授权成功。
SQL>
SQL>
SQL> exit
从 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断
开
C:\Users\Administrator>impdp dbframework_gz/dbframework_gz369 directory=dpdump1
2 dumpfile=AH20170425.DUMP logfile=AH20170425.log
Import: Release 11.2.0.4.0 - Production on 星期二 4月 25 17:42:48 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options