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
Oracle 11g startup and mount
提问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
这将解决您的问题