在oracle 11g 中 shutdown后无法用startup打开

发布网友 发布时间：2022-04-13 20:40

我来回答

共4个回答

热心网友 时间：2022-04-13 22:10

可能是你监听设置的问题， 即便是加了 @orcl也应该提示 connected to an idle instance. 你可以用conn /as sysdba 来尝试登录 然后使用 startup启动数据库。

热心网友 时间：2022-04-13 23:28

你加@orcl是要连接到TNSNAME为ORCL的远程库
如果你ORACLE 在本机安装的，你要连接到本机的oracle
你只需要conn / as sysdba就可以了

热心网友 时间：2022-04-14 01:02

Solution Description:
=====================

The hostdef extension referred to is a structure which was added to the control
structure for the client/server communication.

It is accessed via a pointer in the original structure.
When the communication between the client and the server goes awry, this can
result in ORA-1041 and ORA-3113 errors.

The ORA-1041 is flagged when the POINTER to the EXTENSION structure for the
HOST DEFinition (for the communication channel between the client and the
server) has been nulled. This can occur when the connection gets lost 'for some
reason' and hence the procere to investigate is the same as for ORA-3113.

Explanation:
============

The hostdef extension refers to the structures used to maintain the
client/server communication channel.
把当前sqlplus 关闭再重新进入或重启～～

热心网友 时间：2022-04-14 02:54

去掉 @orcl 然后再打开。