Tuesday, July 21, 2015

Open Cygwin Terminal in Windows Explorer

I like opening a terminal session under Linux file explorer.  I want to have the same in Windows Explorer.

Second round with hard working of Googling, I made it for another DBA Knife !

Again, playing with registry .






References:

http://scottiestech.info/2009/11/15/addyourownprogramtothewindowsexplorerrightclickcontextmenu/
http://www.vultaire.net/blog/2013/06/18/simpletrickscyghereopencygwinshellhere/

Right Click and Zip with PeaZip in windows 7

Feeling not convenient in Windows Explorer, which can only extract a .zip file, but can't zip a file or directory.  Due to license issue, I have to use open source PeaZip to do the compression job.

After hard working with Google, here are my new member of DBA Knife.

For selected file.



For selected directory


Note that the double quota of %1, which allows space with a file/directory name.


Thursday, August 28, 2014

cygwin wget over corprate proxy

liqy@testserver1 /bin
$ export http_proxy="http://domain1\liqy:password1@proxy1:8080/"

$ echo $http_proxy
http://domain1\liqy:password1@proxy1:8080/

liqy@testserver1 /bin
$ wget http://apt-cyg.googlecode.com/svn/trunk/apt-cyg
--2014-08-26 11:10:43--  http://apt-cyg.googlecode.com/svn/trunk/apt-cyg
Resolving proxy1 (proxy1)... 10.33.90.91
Connecting to proxy1 (proxy1)|10.33.90.91|:8080... connected.
Proxy request sent, awaiting response... 200 OK
Length: 10572 (10K) [text/plain]
Saving to: ‘apt-cyg.1’

100%[======================================>] 10,572      --.-K/s   in 0.001s

2014-08-26 11:10:43 (17.6 MB/s) - ‘apt-cyg.1’ saved [10572/10572]

Friday, August 22, 2014

impact of SYS password change to data guard

when SYS password is changed, password file changed accordingly.

If it is not sync to standby site, archived log transfer failed as shown below.

-- at primary site

Wed Aug 20 11:14:24 2014
Archived Log entry 2743 added for thread 1 sequence 5263 ID 0x69704abb dest 1:
Archived Log entry 2744 added for thread 1 sequence 5264 ID 0x69704abb dest 1:
Wed Aug 20 11:14:47 2014
Starting background process SMCO
Wed Aug 20 11:14:47 2014
SMCO started with pid=33, OS id=15785
Wed Aug 20 11:15:44 2014
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
      returning error ORA-16191
------------------------------------------------------------
PING[ARC1]: Heartbeat failed to connect to standby 'dg'. Error is 16191.
Wed Aug 20 11:16:45 2014
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
      returning error ORA-16191
------------------------------------------------------------
PING[ARC1]: Heartbeat failed to connect to standby 'dg'. Error is 16191.
Wed Aug 20 11:16:56 2014
Thread 1 advanced to log sequence 5266 (LGWR switch)
  Current log# 2 seq# 5266 mem# 0: /u01/oradata/DG/redo02.log
Wed Aug 20 11:16:56 2014
Archived Log entry 2745 added for thread 1 sequence 5265 ID 0x69704abb dest 1:
Wed Aug 20 11:16:57 2014
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
      returning error ORA-16191
------------------------------------------------------------
FAL[server, ARC3]: Error 16191 creating remote archivelog file 'dg'
FAL[server, ARC3]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance DGS - Archival Error. Archiver continuing.


--at standby site

ARC8: Becoming the 'no FAL' ARCH
ARC1: Becoming the heartbeat ARCH
ARC1: Becoming the active heartbeat ARCH
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
      returning error ORA-16191
------------------------------------------------------------
FAL[client, ARC9]: Error 16191 connecting to dgs for fetching gap sequence




Monday, July 14, 2014

alter system disconnect session for shared server session

Understanding this command can help to kill shared server session, 
e.g. alter system disconnect session '  11, 14521' immediate;


However, this didn't seem to work in my production situation. The session was not gone until we stopped application end. 
Any comments ?

Friday, July 11, 2014

ORA-01114

ORA-00603: ORACLE server session terminated by fatal error
ORA-24557: error 1114 encountered while handling error 1114; exiting server process
ORA-01114: IO error writing block to file 204 (block # 76928)


ERROR at line 1:
ORA-12801: error signaled in parallel query server P037
ORA-01114: IO error writing block to file (block # )
ORA-01114: IO error writing block to file 1527 (block # 3126400)
ORA-27072: File I/O error
Additional information: 4
Additional information: 3126400
Additional information: -1 



Hit above error, even run  a small query irregardless off 300GB TEMP space.

Please refer to my reply here



Monday, June 16, 2014

RMAN-06172

due to backupset is copied from HP-UX to Linux64 platform.