DB2数据库连接问题求助
db2inst1@linux-o2dw:~> db2 connect to sample user db2inst1 using db2inst1
Database Connection Information
Database server = DB2/LINUXX8664 10.5.5
SQL authorization ID = DB2INST1
Local database alias = SAMPLE
db2inst1@linux-o2dw:~> db2 -td@ -vf /opt/db2/1.db2_database.sql
drop database sample
SQL30082N Security processing failed with reason "3" ("PASSWORD MISSING").
SQLSTATE=08001
CREATE DATABASE sample USING CODESET UTF-8 TERRITORY US CATALOG TABLESPACE MANAGED BY SYSTEM USING ( '/oradata/catlogspace' ) EXTENTSIZE 32 PREFETCHSIZE 64 USER TABLESPACE MANAGED BY SYSTEM USING ('/oradata/usertablespace') EXTENTSIZE 32 PREFETCHSIZE 64 TEMPORARY TABLESPACE MANAGED BY SYSTEM USING ('/oradata/tempspace') EXTENTSIZE 32 PREFETCHSIZE 64
SQL1047N The application is already connected to another database.
9同行回答
另外我贴上脚本里面的内容 帮忙看看 谢谢
drop database sample
@
CREATE DATABASE sample
USING CODESET UTF-8 TERRITORY US
CATALOG TABLESPACE
MANAGED BY SYSTEM
USING ( \'/oradata/catlogspace\' )
EXTENTSIZE 32
PREFETCHSIZE 64
USER TABLESPACE
MANAGED BY SYSTEM
USING (\'/oradata/usertablespace\')
EXTENTSIZE 32
PREFETCHSIZE 64
TEMPORARY TABLESPACE
MANAGED BY SYSTEM
USING (\'/oradata/tempspace\')
EXTENTSIZE 32
PREFETCHSIZE 64
@
收起- 不是很明白 但是这是在客户端上执行的操作
- 从远端执行命令后 发生如下错误 SQL30082N Security processing failed with reason "3" ("PASSWORD MISSING"). SQLSTATE=08001 从服务器本端执行正常
- [此评论已删除]
- 在服务器端执行 也是在db2inst1这个用户下操作的吗 ？
- 对的
- 你可能登录的是本地的实例用户db2inst1吧？ 这和服务器上的实例用户是两码事 。 如果你登录的是本地的实例用户，要drop远程的数据库，先连接远程编目的实例然后再操作试试