Category Archives: Oracle database
Create database link from oracle to SQL server
I would introduce how to get SQL server data from Oracle database. Database link over Oracle gateway is the answer. In following example, I used Oracle ODBC gateway (it is free !) and easysoft ODBC driver on Linux together to … Continue reading
Oracle 12c cluvfy bug on Linux 6 – Reference data is not available for verifying prerequisites on this operating system distribution
It is not a surprise to see above error message when run Oracle Cluster Verification Utility (CVU) on Linux 6. Why? It is a bug mentiond in Oracle MOS note 1567127.1 “RHEL6: 12c OUI INS-13001: CVU Fails: Reference data is … Continue reading
Oracle 12c silent installation
It is straightforward with following response file. [oracle@12c database]$ vi 12c_install.rsp oracle.install.option=INSTALL_DB_SWONLY oracle.install.db.InstallEdition=EE UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/oracle/app/oraInventory ORACLE_HOME=/oracle/app/oracle/product/12.1.0/dbhome_2 ORACLE_BASE=/oracle/app/oracle DECLINE_SECURITY_UPDATES=true oracle.installer.autoupdates.option=SKIP_UPDATES oracle.install.db.DBA_GROUP=dba oracle.install.db.OPER_GROUP=dba oracle.install.db.BACKUPDBA_GROUP=dba oracle.install.db.DGDBA_GROUP=dba oracle.install.db.KMDBA_GROUP=dba (..read more..)
Install Oracle 7 on Windows NT
It takes me to old story, right? install Oracle 7.3.4 on Windows NT. However, it is so straightforward. see “Install Oracle 7 on Windows NT“.
Workaround for RMAN-20204: translation not started
I tested ‘open resetlogs’ is the quick workaround if RMAN stuck with “RMAN-20204: translation not started“. Well, it caught my attention when I saw “RMAN-20204: translation not started” in RMAN log file, of course, RMAN aborted right away. >> RMAN-00571: … Continue reading
Oracle Bug: ORA-600 [krbmror_sameline_2]
Well, I got page again today, “RMAN backup failed” shows off in the title. It eventually proved RMAN session hit Oracle bug in 11.2.0.1 though RMAN finished backup successfully. It is because RMAN scripts has “set echo on”, LoL. See … Continue reading
ORA-16086: standby database does not contain available standby log files – Standby database FRA filled up
Well, Oracle Metalink covered some scenarios where error messages shows off like this: “ORA-16086: standby database does not contain available standby log files” (see MOS 1155773.1). However, I got new reason for this: Flash recovery area is filled up in … Continue reading
When did I apply Oracle patch? – opatch history file
When did you apply Oracle patch? It is not on notebook It was in Oracle OPatch history file $ORACLE_HOME/cfgtoollogs/opatch/opatch_history.txt. Example: $ head -10 opatch_history.txt Date & Time : Thu May 26 14:47:22 EDT 2011 Oracle Home : /oracle/db/11.2.0 OPatch Ver. … Continue reading
solution: -bash: ulimit: open files: cannot modify limit: Operation not permitted
It is interesting when I login to oracle in Linux and see this message on screen: “-bash: ulimit: open files: cannot modify limit: Operation not permitted“. It hit the maximum open files value in Unix/Linux user shell resource limitation. Then … Continue reading
Oracle 11gR2 silent installation
Oracle silent installation is straightforward though it always change a little with every major release. Here I show you tricks and tips during Oracle 11gR2 silent installation. [ read full article] Command /2 tricks/ directory_path/runInstaller -silent [-noconfig] -responseFile absolute_path/response_file It … Continue reading
老庞闲话 