备份与恢复

ORA-00000 normal, successful completion

时间:2013-7-20 11:06:23  作者:说歌社区  来源:www.solgle.com  查看:957  评论:0
内容摘要:今天配置dataguard备份库,在启动时遇到错误ORA-00000了,最开始还以为这个不是错误编号,后来一查,还真有这个特别号码。ORA-00000: normal, successful completion[oracle11g@sd1]$ sqlplus sys/*****...
今天配置dataguard备份库,在启动时遇到错误ORA-00000了,最开始还以为这个不是错误编号,后来一查,还真有这个特别号码。
ORA-00000: normal, successful completion
 
[oracle11g@sd1]$ sqlplus sys/********@sd_orcl as sysdba
 
SQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 21 13:48:32 2014
 
Copyright (c) 1986, 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@localhost]# vi /etc/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
 
修改host文件后:
 
[root@localhost]# cat hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1   ps1  localhost localhost.localdomain localhost4 localhost4.localdomain4
192.16.3.5  ps1  localhost localhost.localdomain localhost6 localhost6.localdomain6
 
#ps1为服务器的名称
 
再次启动:
SQL> startup nomount
ORACLE instance started.
 
Total System Global Area 1052274688 bytes
Fixed Size 2259840 bytes
Variable Size 1222151235 bytes
Database Buffers 21812035 bytes
Redo Buffers 6531230 bytes
SQL>
 
该错误一般出现在单机版数据库的情况,因为rac都会去配置hosts,而单机时却容易忽略。
 
 
标签:ORA-00000 normal successful completion 

solgle.com 版权所有,欢迎分享!!!

相关文章
    相关评论
       Copyright © 2013-2020 solgle.com,All rights reserved.[solgle.com] 公安机关备案号:51010802000219
    Email:solgle@solgle.com; weixin:cd1008610000 ICP:蜀ICP备14011070号-1