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 make it happen.

1. Add SQL server data source in /etc/odbc.ini
   [SQLserver.source.A]
   Driver=Easysoft ODBC-SQL Server
   Description=Easysoft SQL Server ODBC driver case
   Server=SQLserverA
   Port=5023
   Database=SQLado100
   User=
   Password=
   note: i don’t recommend give password here
2. Ensure above SQL Server connection is good
   $ isql -v <db_name> <username> <passwd>

   Read more…
   

how to lookup Oracle report server over network?

Whenever creating new report server, it is good idea to check out if its name is already used. Does Oracle provide such tool? yes, this script is rwdiag.sh.

Usage:

$ ./rwdiag.sh

REP-50507 Invalid number/type of arguments specified

Usage : rwdiag.sh -find <server-name> | -findAll [-conf <config-filename>] [-timeout <timeout in  sec>]

                  OR 

        rwdiag.sh -monitor [-log <log-filename>] [-conf <config-filename>]

Example:

$ ./asinst_1/config/reports/bin/rwdiag.sh -findAll
Reading the rwnetwork.conf from : ./asinst_1/config/ReportsToolsComponent/ReportsTools/rwnetwork.conf
Broadcast mechanism used to locate servers
------------------------------------------
Channel address = 228.5.6.7
Channel port  = 14022

(1) Name = rep_mydomain_dev : Type = server : Host = dev1
(2) Name = rep_mydomain_prod : Type = server : Host = prod2

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 not available for verifying prerequisites on this operating system distribution”
Official Solution: The bug is fixed in 12.1.0.1 GI PSU1 , 12.1.0.2
Official Workaround: install redhat-release-6Server-1.noarch.rpm

But, if I have CVU only on a new server and has no access to install RPM, what shall I do? I created customized CVU patch in github as another solution ( …read more…)

How to fix Samsung note 3 “Your Internet Connection is Unstable”

It is kind of annoying that this message keeping pop out in Samsung note 3. It comes out for a while and never stop though WI-FI connection is fine!  Here is the solution ( …read more…)

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: ===========================================================
>> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
>> RMAN-00571: ===========================================================
>> RMAN-03002: failure of backup plus archivelog command at 09/06/2011 02:00:03
>> RMAN-20204: translation not started

The interesting thing is all other databases in the same server got RMAN backup successfully. Hmm, the special database is RMAN catalog databases with multiple catalog schema inside. It is natural that I turned on RMAN DEBUG to collect more information…(read full story)

 

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 what Oracle said and the full story (..read more..)

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 Standby database.

I got page from primary database (10.2.0.4 on Linux X86_64) as follows:
ORA-16086: standby database does not contain available standby log files
Then standby database page me as follows as well:
No standby redo logfiles selected (reason:6)
ORA-16086: standby database does not contain available standby log files

See how this issue found and solved ( …read more…)

 

Solution: ftp: u: unknown option when run FTP from crontab

It is because multiple ftp program in the system! I figure it after developer told me this interesting issue. /user/bin/ftp and /usr/kerberos/bin/ftp coexisted there, the former doesn’t support -u option. Please specify absolute path and set up correct $PATH in your ftp execution.

Here example [..Read More…]