ORA-00000 normal, successful completion
来源:互联网 发布:淘宝免费模块代码 编辑:程序博客网 时间:2024/04/30 14:01
当hosts文件配置错误时,用sqlplus登录后startup nomount,就会报错ORA-00000
[oracle11g@xulq dbs]$ sqlplus "/ as sysdba"
SQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 21 13:48:32 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected.
SQL> startup nomount
ORA-00000: normal, successful completion
SQL> alter database mount;
ERROR:
ORA-01012: not logged on
SQL>
[root@xulq etc]# cat hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
10.19.205.30 xulq1
修改host文件后:
[root@xulq etc]# cat hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
10.19.205.30 xulq
再次启动:
SQL> startup nomount
ORACLE instance started.
Total System Global Area 1052274688 bytes
Fixed Size 2259840 bytes
Variable Size 1023411328 bytes
Database Buffers 20971520 bytes
Redo Buffers 5632000 bytes
SQL>
正常。
另外,除了写错,如果丢失hosts文件,startup nomount时也会同样报错ORA-00000
[oracle11g@xulq dbs]$ sqlplus "/ as sysdba"
SQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 21 13:48:32 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected.
SQL> startup nomount
ORA-00000: normal, successful completion
SQL> alter database mount;
ERROR:
ORA-01012: not logged on
SQL>
[root@xulq etc]# cat hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
10.19.205.30 xulq1
修改host文件后:
[root@xulq etc]# cat hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
10.19.205.30 xulq
再次启动:
SQL> startup nomount
ORACLE instance started.
Total System Global Area 1052274688 bytes
Fixed Size 2259840 bytes
Variable Size 1023411328 bytes
Database Buffers 20971520 bytes
Redo Buffers 5632000 bytes
SQL>
正常。
另外,除了写错,如果丢失hosts文件,startup nomount时也会同样报错ORA-00000
0 0
- ORA-00000 normal, successful completion
- ORA-00000 normal, successful completion处理
- 使用SYS用户启动oracle 报错: ora-00000 normal, successful completion
- ORA-0000 normal successful completion 【SQLCODE and SQLERRM】
- sqlplus normal 登录 ORA-01017
- SUCCESSFUL!
- successful
- Completion
- completion
- completion
- completion
- normal
- Normal
- ora-00000
- completion使用方法
- Matrix Completion
- linux completion
- completion使用方法
- 实用!开发者的 Vim 插件(二)
- WebService接口之soap
- NMEA0813协议简介
- nonline space filtering
- java连接redis 的问题
- ORA-00000 normal, successful completion
- python导出数据demo之样式设置
- 词袋模型和空间金字塔模型
- view 事件分发机制
- CUDA 学习(二十二)、优化策略7: 自调优应用程序
- SSH的优势和劣势
- Python语言编写BP神经网络
- mysql错误
- CocoaPods pod install的时候报错:invalid byte sequence in UTF-8 (ArgumentError)解决办法