Oracle 11g 启动和挂载

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/18247040/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-10 05:13:13  来源:igfitidea点击:

Oracle 11g startup and mount

oraclestartupshutdown

提问by Dolphin

When i stop Oracle 11g

当我停止 Oracle 11g

SQL> shutdown immediate;

and i execute:

我执行:

SQL> startup mount;

Error:

错误:

ORA-24324 service handle not initialized
ORA-01041: internal error, hostdef extension name not exists

Where's wrong?

哪里错了?

回答by Dolphin

fix it:

修理它:

Connect to DB: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

连接到数据库:Oracle 数据库 11g 企业版 11.1.0.6.0 版 - 具有分区、OLAP、数据挖掘和实际应用测试选项的生产

SQL> shutdown immediate;

Database aready shutdown.

数据库暂时关闭。

Aready uninstall database.

Aready卸载数据库。

ORACLE instance aready close.

ORACLE 实例已经关闭。

SQL> startup nomount;

ORA-12514: TNS: listner process can't recognize current service of connection describe string监听程序

ORA-12514: TNS: 侦听器进程无法识别连接描述字符串监听程序的当前服务

SQL> startup nomount;

ORA-24324: service handle not initialized

ORA-24324: 服务句柄未初始化

ORA-01041: internal error, hostdef extension name not exists

ORA-01041: 内部错误,hostdef 扩展名不存在

SQL> conn sys/sys as sysdba;

Aready connect to idle instance

Aready连接到空闲实例

SQL> startup;

ORACLE instance started。

ORACLE 实例启动。

Total System Global Area  535662592 bytes
Fixed Size                  1334380 bytes
Variable Size             234881940 bytes
Database Buffers          293601280 bytes
Redo Buffers                5844992 bytes

Database loaded over

数据库加载完毕

回答by said

You Can Simply Modify the ..\NETWORK\ADMIN\sqlnet.ora

您可以简单地修改 ..\NETWORK\ADMIN\sqlnet.ora

make SQLNET.AUTHENTICATION_SERVICES= (NULL)

制作 SQLNET.AUTHENTICATION_SERVICES= (NULL)

that will solve Your Problem

这将解决您的问题