标签云
asm 恢复 asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 kfed MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2662 ORA-600 2663 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 ORACLE恢复 Oracle 恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (100)
- 数据库 (1,598)
- DB2 (22)
- MySQL (70)
- Oracle (1,463)
- Data Guard (49)
- EXADATA (7)
- GoldenGate (21)
- ORA-xxxxx (158)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (13)
- ORACLE 21C (3)
- Oracle ASM (65)
- Oracle Bug (7)
- Oracle RAC (47)
- Oracle 安全 (6)
- Oracle 开发 (27)
- Oracle 监听 (27)
- Oracle备份恢复 (530)
- Oracle安装升级 (84)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (75)
- PostgreSQL (18)
- PostgreSQL恢复 (6)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (36)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (19)
-
最近发表
- PostgreSQL解析wal日志之—walminer
- Oracle 19c/21c最新patch信息-202404
- PostgreSQL恢复系列:pg_filedump批量处理
- PostgreSQL部分主要字典信息
- PostgreSQL恢复系列:pg_filedump恢复字典构造
- PostgreSQL 16 源码安装
- ORA-00742 ORA-00312 恢复
- 数据库open成功后报ORA-00353 ORA-00354错误引起的一系列问题(本质ntfs文件系统异常)
- ORA-600 ktsiseginfo1故障
- ORA-00600: internal error code, arguments: [16703], [1403], [4] 原因
- 最近遇到几起ORA-600 16703故障(tab$被清空),请引起重视
- ORA-600 2662快速恢复之Patch scn工具
- TNS-12518: TNS:listener could not hand off client connection
- ora.storage无法启动报ORA-12514故障处理
- 断电引起文件scn异常数据库恢复
- ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
- .[hudsonL@cock.li].mkp勒索加密数据库完美恢复
- 模拟带库实现rman远程备份
- 又一例:ORA-600 kclchkblk_4和2662故障
- Oracle误删除数据文件恢复
月归档:十一月 2011
ORA-09968, ORA-01102 When Starting a Database
一、网友错误
pub上网友遇到一个问题
Tue Nov 22 10:31:19 2011 ALTER DATABASE MOUNT Tue Nov 22 10:31:19 2011 sculkget: failed to lock /u01/app/oracle/product/10.2.01/db_1/dbs/lkORCL exclusive sculkget: lock held by PID: 26308 Tue Nov 22 10:31:19 2011 ORA-09968: unable to lock file Linux Error: 11: Resource temporarily unavailable Additional information: 26308 Tue Nov 22 10:31:19 2011 ORA-1102 signalled during: ALTER DATABASE MOUNT...
我给的建议是重启数据库解决,其实重启数据库是关闭了当前开启的实例,然后开启报错的实例,所以重启成功
二、错误重现
Tue Nov 22 10:31:19 2011 ALTER DATABASE MOUNT Tue Nov 22 10:31:19 2011 sculkget: failed to lock /u01/app/oracle/product/10.2.01/db_1/dbs/lkORCL exclusive sculkget: lock held by PID: 26308 Tue Nov 22 10:31:19 2011 ORA-09968: unable to lock file Linux Error: 11: Resource temporarily unavailable Additional information: 26308 Tue Nov 22 10:31:19 2011 ORA-1102 signalled during: ALTER DATABASE MOUNT... [oracle@ECP-UC-DB1 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.4.0 - Production on Wed Nov 23 09:07:21 2011 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select status from v$instance; STATUS ------------ OPEN SQL> show parameter name ; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_file_name_convert string db_name string test db_unique_name string test global_names boolean FALSE instance_name string test lock_name_space string log_file_name_convert string service_names string test SQL> show parameter control; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ control_file_record_keep_time integer 7 control_files string /opt/oracle/oradata/test/contr ol01.ctl SQL> create pfile='/tmp/t_pfile' from spfile; File created. SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@ECP-UC-DB1 ~]$ vi /tmp/t_pfile *.__db_cache_size=67108864 *.__java_pool_size=4194304 *.__large_pool_size=4194304 *.__shared_pool_size=117440512 *.__streams_pool_size=8388608 *.archive_lag_target=0 *.audit_file_dest='/opt/oracle/admin/test/adump' *.background_dump_dest='/opt/oracle/admin/test/bdump' *.compatible='10.2.0.3.0' *.control_files='/opt/oracle/oradata/test/control01.ctl' *.core_dump_dest='/opt/oracle/admin/test/cdump' *.db_block_size=8192 *.db_domain='' *.db_file_multiblock_read_count=16 *.db_name='test' *.db_recovery_file_dest='/opt/oracle/flash_recovery_area' *.db_recovery_file_dest_size=2147483648 *.dispatchers='(PROTOCOL=TCP) (SERVICE=testXDB)' *.job_queue_processes=10 *.log_archive_dest_1='location=/opt/oracle/oradata/test/archivelog' *.open_cursors=1000 *.pga_aggregate_target=66060288 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=209715200 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/opt/oracle/admin/test/udump' ~ ~ "/tmp/t_pfile" 28L, 1043C written [oracle@ECP-UC-DB1 ~]$ export ORACLE_SID=tt1 [oracle@ECP-UC-DB1 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.4.0 - Production on Wed Nov 23 09:10:47 2011 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to an idle instance. SQL> startup pfile='/tmp/t_pfile' mount; ORACLE instance started. Total System Global Area 209715200 bytes Fixed Size 2082784 bytes Variable Size 134219808 bytes Database Buffers 67108864 bytes Redo Buffers 6303744 bytes ORA-01102: cannot mount database in EXCLUSIVE mode SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@ECP-UC-DB1 ~]$ more /opt/oracle/admin/test/bdump/alert_tt1.log Wed Nov 23 09:11:26 2011 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Shared memory segment for instance monitoring created Picked latch-free SCN scheme 3 Autotune of undo retention is turned on. IMODE=BR ILAT =18 LICENSE_MAX_USERS = 0 SYS auditing is disabled ksdpec: called for event 13740 prior to event group initialization Starting up ORACLE RDBMS Version: 10.2.0.4.0. System parameters with non-default values: processes = 150 __shared_pool_size = 117440512 __large_pool_size = 4194304 __java_pool_size = 4194304 __streams_pool_size = 8388608 sga_target = 209715200 control_files = /opt/oracle/oradata/test/control01.ctl db_block_size = 8192 __db_cache_size = 67108864 compatible = 10.2.0.3.0 log_archive_dest_1 = location=/opt/oracle/oradata/test/archivelog archive_lag_target = 0 db_file_multiblock_read_count= 16 db_recovery_file_dest = /opt/oracle/flash_recovery_area db_recovery_file_dest_size= 2147483648 undo_management = AUTO undo_tablespace = UNDOTBS1 remote_login_passwordfile= EXCLUSIVE db_domain = dispatchers = (PROTOCOL=TCP) (SERVICE=testXDB) job_queue_processes = 10 background_dump_dest = /opt/oracle/admin/test/bdump user_dump_dest = /opt/oracle/admin/test/udump core_dump_dest = /opt/oracle/admin/test/cdump audit_file_dest = /opt/oracle/admin/test/adump db_name = test open_cursors = 1000 pga_aggregate_target = 66060288 PMON started with pid=2, OS id=28086 PSP0 started with pid=3, OS id=28088 MMAN started with pid=4, OS id=28090 DBW0 started with pid=5, OS id=28092 LGWR started with pid=6, OS id=28094 CKPT started with pid=7, OS id=28096 SMON started with pid=8, OS id=28098 RECO started with pid=9, OS id=28100 CJQ0 started with pid=10, OS id=28102 MMON started with pid=11, OS id=28104 Wed Nov 23 09:11:28 2011 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... MMNL started with pid=12, OS id=28106 Wed Nov 23 09:11:28 2011 starting up 1 shared server(s) ... Wed Nov 23 09:11:28 2011 ALTER DATABASE MOUNT Wed Nov 23 09:11:28 2011 sculkget: failed to lock /opt/oracle/product/10.2.0/db_1/dbs/lkTEST exclusive sculkget: lock held by PID: 12339 Wed Nov 23 09:11:28 2011 ORA-09968: unable to lock file Linux-x86_64 Error: 11: Resource temporarily unavailable Additional information: 12339 Wed Nov 23 09:11:28 2011 ORA-1102 signalled during: ALTER DATABASE MOUNT...
通过这个试验,再现了网友的ORA-09968, ORA-01102错误
三、MOS解释
ORA-09968, ORA-01102 When Starting a Database
发表在 ORA-xxxxx
评论关闭
OGG Troubleshooting TCP/IP Errors In Open Systems
经常和ogg打交道的同仁们,WARNING OGG-01223 TCP/IP error 111这个错误肯定不陌生,今天发现MOS上关于WARNING OGG-01223 TCP/IP error 111错误处理思路及其方案的文档写的非常好,看了之后深受启发,贡献出来给大家
WARNING OGG-01223 TCP/IP error 111
//files.xifenfei.com/wp-content/uploads/2011/11/WARNING_OGG-01223_TCPIP_error_111.pdf
发表在 GoldenGate
评论关闭
ERROR OGG-01224 TCP/IP error 110 (Connection timed out); retries exceeded.
Cause
This is generally due due to basic issues like: * The remote manager process is not running or is running with incorrect port number * The RMTHOST parameter in the pump extract is not configured correctly. In other cases, the issue could be due to firewalls that forbid the connection, blocking certain ports or processes. This is generally seen when there is a firewall between the source and target machine and either the ports are not open or just the manager port is open.
Solution
The Extract, Replicat and Ggsci processes use ports normally starting at port 7840 and ascend sequentially. The ggsci command 'send manager getportinfo detail ' will retrieve the current list of ports that have been allocated by Manager and their corresponding process IDs. If you have some port restrictions, then you could use the DYNAMICPORTLIST with some range so that the collector process will allocate the ports from that range. In general to overcome this issue, we could do something like below 1. Change the target manager parameter file to use something like the following port 7809 dynamicportlist 7810-7820 2. Stop and start the manager 3. Open ports 7809 through 7820 in the firewall 4. Re-start the source pump The port range used in dynamicportlist(7810-7820) and the manager port 7809 is just an example. You can define your own ports there and have them open.
发表在 GoldenGate
评论关闭