Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

999

积分

1

好友

942

主题
1#
发表于 2017-4-12 18:02:08 | 查看: 1902| 回复: 1
ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist错误,前一天才安装可以用,第二天登陆不了了。

alert.log:


***********************************************************************

Fatal NI connect error 12641, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
        TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
        Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
        Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
Time: 10-10月-2014 22:31:57
Tracing not turned on.
Tns error struct:
    ns main err code: 12641
   
TNS-12641: 验证服务无法初始化
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
opiodr aborting process unknown ospid (3964) as a result of ORA-609
Fri Oct 10 22:32:11 2014


***********************************************************************

Fatal NI connect error 12641, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
        TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
        Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
        Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
Time: 10-10月-2014 22:32:11
Tracing not turned on.
Tns error struct:
    ns main err code: 12641
   
TNS-12641: 验证服务无法初始化
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
opiodr aborting process unknown ospid (1668) as a result of ORA-609
Fri Oct 10 22:32:13 2014


***********************************************************************

Fatal NI connect error 12641, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
        TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
        Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
        Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
Time: 10-10月-2014 22:32:13
Tracing not turned on.
Tns error struct:
    ns main err code: 12641
   
TNS-12641: 验证服务无法初始化
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
opiodr aborting process unknown ospid (3760) as a result of ORA-609
Fri Oct 10 22:32:26 2014


***********************************************************************

Fatal NI connect error 12641, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
        TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
        Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
        Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
Time: 10-10月-2014 22:32:26
Tracing not turned on.
Tns error struct:
    ns main err code: 12641
   
TNS-12641: 验证服务无法初始化
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
opiodr aborting process unknown ospid (4776) as a result of ORA-609
Fri Oct 10 22:32:46 2014



***********************************************************************

Fatal NI connect error 12638, connecting to:
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

VERSION INFORMATION:
        TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
        Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
Time: 11-10月-2014 21:54:38
Tracing not turned on.
Tns error struct:
    ns main err code: 12638
   
TNS-12638: 身份证明检索失败
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
Mon Oct 13 09:16:30 2014
Adjusting the default value of parameter parallel_max_servers
from 160 to 135 due to the value of parameter processes (150)
Starting ORACLE instance (normal)
Mon Oct 13 09:17:00 2014
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Mon Oct 13 09:17:12 2014
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Mon Oct 13 09:17:34 2014
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEORCL.ORA
System parameters with non-default values:
processes                = 150
memory_target            = 1616M
control_files            = "E:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01.CTL"
control_files            = "E:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL"
db_block_size            = 8192
compatible               = "11.2.0.0.0"
db_recovery_file_dest    = "E:\app\Administrator\fast_recovery_area"
db_recovery_file_dest_size= 4062M
undo_tablespace          = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain                = ""
dispatchers            = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
local_listener         = "LISTENER_ORCL"
audit_file_dest          = "E:\APP\ADMINISTRATOR\ADMIN\ORCL\ADUMP"
audit_trail            = "DB"
db_name                  = "orcl"
open_cursors             = 300
diagnostic_dest          = "E:\APP\ADMINISTRATOR"
Mon Oct 13 09:19:27 2014
USER (ospid: 2676): terminating the instance due to error 119
Instance terminated by USER, pid = 2676
Mon Oct 13 20:38:29 2014
Adjusting the default value of parameter parallel_max_servers
from 160 to 135 due to the value of parameter processes (150)
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEORCL.ORA
System parameters with non-default values:
processes                = 150
memory_target            = 1616M
control_files            = "E:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01.CTL"
control_files            = "E:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL"
db_block_size            = 8192
compatible               = "11.2.0.0.0"
db_recovery_file_dest    = "E:\app\Administrator\fast_recovery_area"
db_recovery_file_dest_size= 4062M
undo_tablespace          = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain                = ""
dispatchers            = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
local_listener         = "LISTENER_ORCL"
audit_file_dest          = "E:\APP\ADMINISTRATOR\ADMIN\ORCL\ADUMP"
audit_trail            = "DB"
db_name                  = "orcl"
open_cursors             = 300
diagnostic_dest          = "E:\APP\ADMINISTRATOR"
Mon Oct 13 20:40:35 2014
USER (ospid: 2168): terminating the instance due to error 119
Instance terminated by USER, pid = 2168
Mon Oct 13 21:02:28 2014
Adjusting the default value of parameter parallel_max_servers
from 160 to 135 due to the value of parameter processes (150)
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEORCL.ORA
System parameters with non-default values:
processes                = 150
memory_target            = 1616M
control_files            = "E:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01.CTL"
control_files            = "E:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL"
db_block_size            = 8192
compatible               = "11.2.0.0.0"
db_recovery_file_dest    = "E:\app\Administrator\fast_recovery_area"
db_recovery_file_dest_size= 4062M
undo_tablespace          = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain                = ""
dispatchers            = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
local_listener         = "LISTENER_ORCL"
audit_file_dest          = "E:\APP\ADMINISTRATOR\ADMIN\ORCL\ADUMP"
audit_trail            = "DB"
db_name                  = "orcl"
open_cursors             = 300
diagnostic_dest          = "E:\APP\ADMINISTRATOR"
Mon Oct 13 21:03:06 2014
License high water mark = 0
USER (ospid: 956): terminating the instance
Instance terminated by USER, pid = 956
Mon Oct 13 21:03:09 2014
Adjusting the default value of parameter parallel_max_servers
from 160 to 135 due to the value of parameter processes (150)
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
2#
发表于 2017-4-12 18:02:35
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEORCL.ORA
System parameters with non-default values:
processes                = 150
memory_target            = 1616M
control_files            = "E:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01.CTL"
control_files            = "E:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL"
db_block_size            = 8192
compatible               = "11.2.0.0.0"
db_recovery_file_dest    = "E:\app\Administrator\fast_recovery_area"
db_recovery_file_dest_size= 4062M
undo_tablespace          = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain                = ""
dispatchers            = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
local_listener         = "LISTENER_ORCL"
audit_file_dest          = "E:\APP\ADMINISTRATOR\ADMIN\ORCL\ADUMP"
audit_trail            = "DB"
db_name                  = "orcl"
open_cursors             = 300
diagnostic_dest          = "E:\APP\ADMINISTRATOR"
Mon Oct 13 21:03:55 2014
USER (ospid: 4184): terminating the instance due to error 119
Instance terminated by USER, pid = 4184
Mon Oct 13 21:07:34 2014
Adjusting the default value of parameter parallel_max_servers
from 160 to 135 due to the value of parameter processes (150)
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEORCL.ORA
System parameters with non-default values:
processes                = 150
memory_target            = 1616M
control_files            = "E:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01.CTL"
control_files            = "E:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL"
db_block_size            = 8192
compatible               = "11.2.0.0.0"
db_recovery_file_dest    = "E:\app\Administrator\fast_recovery_area"
db_recovery_file_dest_size= 4062M
undo_tablespace          = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain                = ""
dispatchers            = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
local_listener         = "LISTENER_ORCL"
audit_file_dest          = "E:\APP\ADMINISTRATOR\ADMIN\ORCL\ADUMP"
audit_trail            = "DB"
db_name                  = "orcl"
open_cursors             = 300
diagnostic_dest          = "E:\APP\ADMINISTRATOR"
Mon Oct 13 21:08:16 2014
USER (ospid: 4752): terminating the instance due to error 119
Instance terminated by USER, pid = 4752

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-20 16:54 , Processed in 0.046963 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569