RSS

oracle database 11g upgrade with opatch error code 74 file is in using

if you meet the errors, the simplest way is just renanme those list files with error code 74.

here how i fix them, just rename all list files.

ren C:\ORACLE~1\product\112~1.0\dbhome_1\bin\oracell11.dll  oracell11.dllo
ren C:\ORACLE~1\product\112~1.0\dbhome_1\bin\oraasmclnt11.dll  oraasmclnt11.dllo
ren C:\ORACLE~1\product\112~1.0\dbhome_1\bin\orapls11.dll  orapls11.dllo
ren C:\ORACLE~1\product\112~1.0\dbhome_1\bin\orageneric11.dll  orageneric11.dllo
ren C:\ORACLE~1\product\112~1.0\dbhome_1\bin\oraclient11.dll  oraclient11.dllo
ren C:\ORACLE~1\product\112~1.0\dbhome_1\bin\oracommon11.dll  oracommon11.dllo
ren C:\ORACLE~1\product\112~1.0\dbhome_1\bin\oraplc11.dll  oraplc11.dllo
ren C:\ORACLE~1\product\112~1.0\dbhome_1\bin\oraplp11.dll  oraplp11.dllo
ren C:\ORACLE~1\product\112~1.0\dbhome_1\bin\oraxml11.dll  oraxml11.dllo
ren C:\ORACLE~1\product\112~1.0\dbhome_1\bin\orannzsbb11.dll  orannzsbb11.dllo
ren C:\ORACLE~1\product\112~1.0\dbhome_1\bin\orazt11.dll  orazt11.dllo
ren C:\ORACLE~1\product\112~1.0\dbhome_1\bin\oraztkg11.dll  oraztkg11.dllo
ren C:\ORACLE~1\product\112~1.0\dbhome_1\bin\oran11.dll  oran11.dllo
ren C:\ORACLE~1\product\112~1.0\dbhome_1\bin\orantcp11.dll  orantcp11.dllo
ren C:\ORACLE~1\product\112~1.0\dbhome_1\bin\oranl11.dll  oranl11.dllo
ren C:\ORACLE~1\product\112~1.0\dbhome_1\bin\orancrypt11.dll  orancrypt11.dllo
ren C:\ORACLE~1\product\112~1.0\dbhome_1\bin\orahasgen11.dll  orahasgen11.dllo
ren C:\ORACLE~1\product\112~1.0\dbhome_1\bin\oraocr11.dll  oraocr11.dllo
ren C:\ORACLE~1\product\112~1.0\dbhome_1\bin\oraocrb11.dll  oraocrb11.dllo
ren C:\ORACLE~1\product\112~1.0\dbhome_1\bin\oraocrutl11.dll  oraocrutl11.dllo

this method is much easier than other articles on the internet even on support.oracle.com

those files are not actually been used as you can test it by rename one file first. And during the opatch process, those files will be replaced with new version. It means even you delete those files should also be ok.

This article only suppose that you are meet the same issue as mine.

1 stop oracle services. use “net start | findstr -i ora” [need]

2 stop msdtc service. [maybe need]

3 if you like me use fail safe. then go to cluadmin offline the service role under cluster resource. [not sure it is need]

 
Leave a comment

Posted by on October 9, 2015 in others

 

oracle fail safe 4.1.1on windows 2012 r2 installation issue

Creating sample database “sample” on node “znbb-itmp-21”
Friday, October 2, 2015

Versions
Fail Safe Manager 4.1.1.0
Fail Safe API 4.1.1.0
Fail Safe Server 4.1.1.0

Nodes
znbb-itmp-21 Windows Server V6.2
znbb-itmp-22 Windows Server V6.2

8:50:34 PM FS-10905: znbb-itmp-21 : Starting the creation of standalone resource sample
8:50:34 PM FS-10371: znbb-itmp-21 : Performing initialization processing
8:50:34 PM FS-10371: znbb-itmp-22 : Performing initialization processing
8:50:34 PM FS-10374: znbb-itmp-21 : Gathering cluster information needed to perform the specified operation
8:50:34 PM FS-10374: znbb-itmp-22 : Gathering cluster information needed to perform the specified operation
8:50:34 PM FS-10375: znbb-itmp-21 : Analyzing cluster information needed to perform the specified operation
8:50:34 PM FS-10378: znbb-itmp-21 : Preparing for configuration of resource sample
8:50:34 PM OCIEnvNlsCreate failed
8:50:34 PM FS-10999: An internal programming error has occurred
8:50:34 PM FS-10818: The Oracle Database resource provider failed during preparation for configuration processing for resource sample
8:50:34 PM FS-10890: Oracle Services for MSCS failed during the createStandalone operation
8:50:34 PM FS-10497: Starting clusterwide rollback of the operation
8:50:34 PM FS-10488: znbb-itmp-21 : Starting rollback of operation
8:50:34 PM FS-10489: znbb-itmp-21 : Completed rollback of operation
8:50:34 PM FS-10495: Clusterwide rollback of the operation has been completed
8:50:34 PM The clusterwide operation failed.
———————————
you should install the new patch set 1 , download it from oracle support website.
————————————————————–
Oracle Fail Safe Patch Set Notes
Release 4.1.1, Patch Set 1 (4.1.1.2) for Microsoft Windows
——————————————————————————

April 2015

Fixed Bugs
==========
——————————————————————————
Fixed in BUG
Release Number Description
——————————————————————————
4.1.1.1 20635389 OCIEnvNlsCreate failed Error when Database 12c not Installed
4.1.1.1 20633529 Modifying Resource Property Fails with FS-10718, 0xD: The data is invalid
4.1.1.1 20662316 Startup of Database Cluster Resource Times Out with FS-10727 or FS-10436 Error
4.1.1.1 20662774 Validate Group Fails with Error FS-11412
4.1.1.1 20686726 Fail Safe Manager Crashes with “Value does not fall within the expected range”
4.1.1.2 20866996 Starting Standby Database for Read Only With Apply Fails with ORA-1406

 
1 Comment

Posted by on October 2, 2015 in others

 

repair file and folder permission is corrupt

today find my windows 10 10130 is fail to boot on due to the double boot windows 8.1 repair the windows 10 disk and repaired the disk which has no issue and in the end the whole windows 10 disk can not be accessed.

after try manually GUI fix the folder and file permissions it does not help too much (Take Ownership And Grant Permissions To Access Files & Folders).

While after some research, the cmdlet tools helps

takeown /f e:\* /R /A

icacls E:\* /grant administrators:(F) /inheritance:e /t

it is much faster than the gui operation.

 

Windows OS version numbers

Client Operating System Version Number Server Operation System
Windows 1.0 1.04
Windows 2.0 2.11
Windows 3.0 3
Windows NT 3.1 3.10.528
Windows for Workgroups 3.11 3.11
Windows NT Workstation 3.5 3.5.807
Windows NT Workstation 3.51 3.51.1057
Windows 95 4.0.950
Windows NT Workstation 4.0 4.0.1381
Windows 98 4.1.1998
Windows 98 Second Edition 4.1.2222
Windows Me 4.90.3000
Windows 2000 Professional 5.0.2195
Windows XP 5.1.2600
Windows XP x64 Edition (AMD64/EM64T) 5.2.3790 Windows Server 2003
Windows Vista 6.0.6000
Windows Vista with Service Pack 1 6.0.6001 Windows Server 2008
Windows 7 6.1.7600 Windows Server 2008 R2
Windows 7 with Service Pack 1 6.1.7601 Windows Server 2008 R2 with Service Pack 1
Windows 8 6.2.9200 Windows Server 2012
Windows 8.1 6.3.9200 Windows Server 2012 R2
Windows 8.1 with Update 1 6.3.9600
 
Leave a comment

Posted by on September 15, 2014 in Windows, Windows Server

 

project portfolio dashboard

while the whole idea is coming from chandoo, i just refresh it and make it to my own.

1 - CopyIt looks much simpler and useful until I change it as below for daily use.

1 - Copy

 
Leave a comment

Posted by on July 11, 2014 in others