VMCD.ORG

Problem : Fatal NI Connect Error 12170, ‘TNS-12535: TNS:operation timed out’ Reported in 11g Alert Log

December 1, 2011 network, oracle No comments

Applies to:

Oracle Net Services – Version: 11.1.0.6 to 11.2.0.2 – Release: 11.1 to 11.2
Oracle Server – Enterprise Edition – Version: 11.1.0.6 to 11.2.0.2 [Release: 11.1 to 11.2]
Information in this document applies to any platform.
TNS-12170, ORA-12170, TNS-12535, TNS-00505 alert.log
Sympt[……]

[转] Oracle 10g RAC中的DRM问题及关闭

December 1, 2011 Internals, oracle, RAC 2 comments RAC

在RAC环境中，Oracle使用GRD（Global Resource Service）来记录各个RAC节点的资源信息，具体通过GCS（Global Cache Service）和GES（Global Enqueue Service）这两个服务进行管理。
由于在RAC中每个节点都有自己的SGA和buffer cache，为了保证Cache资源的一致性和提高性能，GCS和GES会指定RAC中的一个instance来管理Cache，这个节点这时就是Resource Master。
在10g以前，Cache资源是不能在各个节点间移动的，除非重启或者某节点因为其他异常被RAC驱逐等情况。而10g的[……]

Oracle 登录方式以及验证

November 30, 2011 maintain, oracle No comments Oracle authentication

数据库用sysdba登录的验证有两种方式，一种是通过os认证，一种是通过密码文件验证；登录方式有两种，一种是在数据库主机直接登录（用os认证的方式），一种是通过网络远程登录；需要设置的参数有两个，一个是SQLNET.AUTHENTICATION_SERVICES，一个是REMOTE_LOGIN_PASSWORDFILE。

os认证：如果启用了os认证，以sysdba登录，那么我们只要用oracle软件的安装用户就能登录：sqlplus “/ as sysdba”。如果我们要禁用os认证，只利用密码文件登录，我们首先要有一个密码文件：

D:\oracle\ora92\database[……]

Script: search datafile segments in order For resizing datafiles

November 27, 2011 maintain, oracle 1 comment scripts

下面脚本可以检测datafile 中创建segment的次序，以利于以后move object 进而resize datafile大小之用

block_id * 8代表 blocksize=8092

SQL>SET ECHO off FEEDBACK off HEADING on NUMWIDTH 10
SQL>DEFINE TABLESPACE=’&1′;
SQL>DEFINE FILE_ID=&2;

———————————
DECLARE
v_prior_file_name VARCHAR2(513);[……]

10g Flashback Version Query & Flashback Transaction Query

November 26, 2011 maintain, oracle No comments flashback

Flashback Version Query:
—————————-

Using undo data stored in the database, one can now view the changes to one or more rows along with all the metadata of the changes. Flashback version query allows the versions of a specific row to be tracked during a window of time using the[……]

随便写写

November 24, 2011 system No comments

刚上班就重感冒，什么资料都不想看,感觉节奏很快慢慢适应吧[……]

new life

November 17, 2011 system No comments life, new life

换工作了，跳到了互联网行业，乙方的工作让我受益良多，新的工作充满了挑战，GL![……]

Oracle 9i 单节点文件系统升级到 10g RAC

November 10, 2011 migration, oracle, RAC No comments RAC

最近做了一次Oracle 9i 升级到10g RAC 的测试，现做如下简要记录：
1.查看目前数据库版本

SQL> select * from v$version;

BANNER
—————————————————————-
Oracle9i Enterprise Edition Release 9.2.0.4.0 – Production
PL/SQL Release 9.2.0.4.0 – Production
CORE 9.2.0.3.0 Production[……]

[转] Know More about Oracle PGA Memory

November 8, 2011 Internals, oracle 9 comments pga

Question :

1. How can we know available PGA and temporary tablespace before we issue a huge operation?
2. Can we estimate PGA and temporary tablespace for a huge operation?
3. As we know, there is limitation for a user process. Can we set unlimited and how to do it?

We say:

PROPOSED SOLUT[……]