-
编辑 删除
解决client端的ORA-01882错误
环境描述： Serve端： Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production PL/SQL Release 11.2.0.3.0 - Production CORE 11.2.0.3.0 Production TNS for Linux: Version 11.2.0.3.0 - Production NLSRTL Version 11.2.0.3.0 - Production Client端: SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 12月 13 10:44:26 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved. 通过PL/SQL连接服务器查询时报：ora-01882错误，错误原因是Client端的time zonesID太旧导致的。
-
编辑 删除
记录获得ORACLE的transaction ID
工作中需要根据Oracle某个transaction的ID查找其他的信息，如何获得transaction ID可能也是许多朋友的疑问，在存储加以说明，只需要调用一下过程就可以得到：dbms_transaction.LOCAL_TRANSACTION_IDExample:SQL> delete from isc_$clob;203 rows deletedSQL> select dbms_transaction.LOCAL_TRANSACTION_ID from dual;LOCAL_TRANSACTION_ID--------------------------------------------------------------------------------10.3.501549[@more@]
-
编辑 删除
记一次ORA-24247错误
在oracle11gR2里发送邮件的时候报错：ORA-24247: 网络访问被访问控制列表 (ACL) 拒绝ORA-06512: 在 "SYS.PROCSENDEMAIL", line 730ORA-06512: 在 "SC.ISC_UTIL", line 452ORA-06512: 在 line 1这是因为Oracle 数据库 11g有一个新的解决方案：您可以将执行权限程序包授予任何人，但要控制他们可以调用的资源。例如，utl_tcp 可限制为仅调用几个 IP地址，这种机制称为访问控制列表 (ACL)。如果主机在 ACL 中，用户可以在 utl_tcp 中使用；但是仅仅拥有对 utl_tcp的执行权限是不够的。因此，恶意进程不可能取代 utl_
-
编辑 删除
OCR File and Voting Disk Administration by Example - (Oracle 10g)
OCR File and Voting Disk Administration by Example - (Oracle 10g)by Jeff Hunter, Sr. Database AdministratorContentsOverviewExample ConfigurationAdministering the OCR FileView OCR Configuration InformationAdd an OCR FileRelocate an OCR FileRepair an OCR File on a Local NodeRemove an OCR FileBackup the OCR FileAutomatic OCR BackupsManual OCR ExportsRecover the OCR FileRecover OCR from Valid OCR MirrorRecover OCR from Automatically Generated Physical BackupRecover OCR from an OCR Expor
-
编辑 删除
记一次ORA-12545: Connect failed because target host or object does not exist
通过sqlplus 连接RAC，偶尔报：ORA-12545: Connect failed because target host or object does not exist[@more@] 原因是因为local_listener没有设置，分别在两个节点设置local_listener参数问题变可以解决：法一：alter system set LOCAL_LISTENER="(ADDRESS=(PROTOCOL=TCP)(HOST=xxxx)(PORT=1521))" scope=both sid='node1';alter system set LOCAL_LISTENER="(ADDRESS=(PROTOCOL=TCP)(HOST=xxxx)(PORT=1521))" scope=both sid='node2';法二：tnsnames.ora内加入local_listeners=(ADDRESS_LIST=(ADDRESS=(P
-
编辑 删除
记一次EXPDP遇到的ORA-39097错误
环境描述： 需要通过EXPDP将数据备份到远端的cifs设备上,但是在进行备份的时候，写入文件报错：;;;Export: Release 10.2.0.4.0 - 64bit Production on 星期二, 20 3月, 2012 3:30:01 Copyright (c) 2003, 2007, Oracle. All rights reserved.;;;Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsORA-39097: Data Pump job encountered unexpected error -31643ORA-39065: unexpected master process ex
-
编辑 删除
ndoutils启动报:Could not bind socket: Address already in use
[root@node1 bin]# ./ndo2db-3x -c ../etc/ndo2db.cfgCould not bind socket: Address already in use[root@node1 bin]# 解决方式:rm /nagios/var/ndo.sock重新启，OK！[@more@]
-
编辑 删除
提取rpm文件内容
Quickest way to get going would be to use rpm2cpio rpm2cpio package.rpm > package.cpio cpio -idumv < package.cpio That last op will create a tree containing folders and files that come with the package. You could do a dry run in /tmp and copy everything into place, or, alternatively (and might I add, at your own risk) run it in "/" so that the files are copied into the correct locations. You might also need to add any custom library paths to /etc/ld.so.[d |
