17,140
社区成员
发帖
与我相关
我的任务
分享请问用exp导出数据库时提示12520错误是怎么回事
具体提示如下：
exp-00056:遇到oracle错误12520
ora-12520:tns:监听程序无法找到需要的服务类型的可用句柄
exp-0000:导出终止失败
exp-00056:遇到oracle错误12520
ora-12520:tns:监听程序无法找到需要的服务类型的可用句柄
exp-0000:导出终止失败
...全文
请发表友善的回复…
发表回复
zonelive 2004-10-19
- 打赏
- 举报
少了@sid
zwj0712 2004-09-30
- 打赏
- 举报
要连接的时候加上你的数据库连接名
比如
用户/密码◎oral
比如
用户/密码◎oral
jack_4826 2004-09-30
- 打赏
- 举报
你先连接数据库试试！
qiansl 2004-09-30
- 打赏
- 举报
数据库连接不上
wangsaokui 2004-09-30
- 打赏
- 举报
检查这个文件tnsnames.ora中是否包含你数据库的SID
like:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 20.39.69.20)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = HAPL4)
)
)
like:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 20.39.69.20)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = HAPL4)
)
)
freddy2003 2004-09-30
- 打赏
- 举报
我估计你没有指定数据库的SID
CMD 进入DOS
导出
exp user/password@数据ID owner=方案名 file=c:\a.dmp log=c:\a.log
文件就在C:下
在你的数据库导入
先建一用户user
imp user/password@数据ID file=c:\a.dmp log=c:\a.log full=y
CMD 进入DOS
导出
exp user/password@数据ID owner=方案名 file=c:\a.dmp log=c:\a.log
文件就在C:下
在你的数据库导入
先建一用户user
imp user/password@数据ID file=c:\a.dmp log=c:\a.log full=y
holy_phoenix 2004-09-30
- 打赏
- 举报
ORA-12520: TNS:listener could not find available handler for requested type of server
Cause: None of the known and available service handlers for requested type of server (dedicated or shared) are appropriate for the client connection.
Action: Run &quo;lsnrctl services&quo; to ensure that the instance(s) have registered with the listener and that the appropriate handlers are accepting connections.
Cause: None of the known and available service handlers for requested type of server (dedicated or shared) are appropriate for the client connection.
Action: Run &quo;lsnrctl services&quo; to ensure that the instance(s) have registered with the listener and that the appropriate handlers are accepting connections.
bzszp 2004-09-30
- 打赏
- 举报
可以连接到数据库吗？
wangsaokui 2004-09-30
- 打赏
- 举报
在命令行下运行 “tnsping 你的服务名称”
响应是正常的吗？
响应是正常的吗？
