ITPub博客

连接数据库的几种方式：语法：cx_Oracle.connect('username','pwd','IP/HOSTNAME:PORT/TNSNAME')import cx_Oracledb1=cx_Oracle.connect('yang','yang','127.0.0.1:1523/yangdb')db2=cx_Oracle.connect('yang/yang@1...

申明：本文转载自：http://czmmiao.iteye.com/blog/1763055IPC Send timeout故障现象RAC 数据库上比较常见的一种问题就是“IPC Send timeout”。数据库Alert log中出现了“IPC Send timeout”之后，经常会伴随着ora-29740 或者 "Waiting for clusterware split-brain resolution"等，数据库实例会因此异常终止...

You can create a physical standby of a multitenant container database (CDB) just as you can create a physical standby of a regular primary database. The following are some of the behavioral differences to be aware of when you create and use a physical standby of a CDB:创建一个多租户的CDB环境...

SQL> SELECT NAME,VALUE,DISPLAY_VALUE,ISPDB_MODIFIABLE FROM v$parameter WHERE ISPDB_MODIFIABLE='TRUE';NAMEVALUEDISPLAY_VALUEISPDBsessions472...

The Oracle database uses the LOG_ARCHIVE_TRACE initialization parameter to enable and control the generation of comprehensive trace information for log archiving and redo transport activity.The additional tracing that is output when LOG_ARCHIVE_TRACE is set to a non-z...

Oracle 12C rac DataGuard环境部署。

关于DGbroker的配置网上有太多资料了，此处在不做详细介绍配置，贴一片metalink上的文章共大家参考学习。1. Prerequisits,Start the Dataguard broker DMON process. ----------启动dg_brokerOn Primary and Standby,SQL> alter system set dg_broker_start=true sid='*';  2. Connect to DGMG...

Standard distributions are available as compressed tar files, Zip archives, or RPM packages. Distribution files have names of the form mysql-VERSION.tar.gz, mysql-VERSION.zip, or mysql-VERSION.rpm, where VERSION is a number like 5.7.14. File names for source d...

APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterLinux x86-64SYMPTOMSDynamically added new disks to storage using udev rules(as per the docs note 414897.1, 1528148.1, 371814.1 etc).During start_udev, udev has deleted the public network interface a...

在AIX6.1下安装ORACLE11.2.0.4 RAC的时候，在节点2执行root.sh报错如下：[root@oratest02:/oracle/]#sh /oracle/app/11.2.0/grid_1/root.shPerforming root user operation for Oracle 11g The following environment variables are set as:    ORACLE_OWNER= grid    ORACLE_HOME=  ...

enq: IV - contention9294.14.37.4OtherIn this DocumentSymptomsCauseSolutionReference...

[root@jttmsvura02 bin]# ./wsadmin.sh -conntpe NONE -lang jythonWASX7209I: 浣跨. SOAP 杩..?ㄨ??ュ.?.. jttmsvura02CellManager01 涓..杩.??.mgr?.?杩.??.被anagerWASX7411W: 蹇界.浠ヤ??.??.?.」锛.-conntpe, NONE]WASX7031I: 瑕..?.府?╋?璇疯??ワ??.rint Help.help()?wsadmin>AdminTask.changeHostName('[inter...

最近系统检查发现有个系统一直在报错：ORA-03137: TTC 协议内部错误: [12333] [48] [9] [91] [] [] [] []检查trc文件发现有如下问题：ump file /oracle/app/db/diag/rdbms/oracle1/oracle1/incident/incdir_7497/oracle1_ora_17113_i7497.trcOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Product...

In this DocumentSymptomsCauseSolutionReferencesAPPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.2 and laterInformation in this document ap...

原文：http://blog.csdn.net/haibusuanyun/article/details/46926973近期在多个大型系统中遇到此问题，一般来说如果客户端未反映异常的话可以忽略的。如果是客户端登陆时遇到ORA-12170: TNS:Connect timeout occurred，可以参考 http://blog.csdn.net/haibusuanyun/article/details/14517211#t12###############参考MOS...

昨晚对一套RAC系统顺利进行了PSU补丁包的安装后，在启动数据库时报错如下：    Mon Oct 19 17:52:31 2015ALTER SYSTEM SET local_listener=' (ADDRESS=(PROTOCOL=TCP)(HOST=10.0.61.96)(PORT=1526))' SCOPE=MEMORY SID='hbdbuat1';This instance was first to mountNOTE: Loaded library: SystemO...

准备过节了，对系统做了一次全面的检查，也发现了不少的问题，对某一台RAC检查时发现如下错误：<br />2015-08-23 04:34:18.962:<br />[client(18715)]CRS-0009:log file "/oracle/app/11.2.0/grid/log/d4jt6csvpra04/client/olsnodes.log" reopened<br />2015-08-23 04:34:18.962:<br />[client(18715)]CRS-0019:file r...

<h2 class="km" style="font-family:Arial, Helvetica, sans-serif;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:#C4D1E6;font-size:16px;color:#FFFFFF;text-transform:uppercase;padding-top:6px;padding-bottom:6px;padding-left:8px;line-height:normal;white-space:normal;background-colo...

<h2 class="km" style="font-family:Arial, Helvetica, sans-serif;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:#C4D1E6;font-size:16px;color:#FFFFFF;text-transform:uppercase;padding-top:6px;padding-bottom:6px;padding-left:8px;line-height:normal;white-space:normal;background-colo...

资料来源:http://blog.chinaunix.net/uid-15866552-id-3579958.html                      &n...