Показаны сообщения с ярлыком update. Показать все сообщения
Показаны сообщения с ярлыком update. Показать все сообщения

воскресенье, 3 августа 2014 г.

Update subversion from 1.5 to 1.6 on Centos 5.x

Stop service
# service svnserve stop

Update subversion using yum
# yum update subversion

Check the configuration svnserve daemon (/home/svn - repo home)
# cat /etc/sysconfig/svnserve
OPTIONS="-r /home/svn"

Upgrade svn repo
# svnadmin upgrade /home/svn/rep

Stat svnserve
# service svnserve start

You can compact repo to reduce the size
# svnadmin pack /home/svn/rep



вторник, 15 июля 2014 г.

Upgrade Oracle 10.2.0 to 11.2.0 Tips

While installing you got:
BEGIN wmsys.owm_mig_pkg.moveWMMetaData; END;
*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at "WMSYS.OWM_MIG_PKG", line 1579
ORA-06512: at "WMSYS.OWM_MIG_PKG", line 1596
ORA-06512: at line 1

ignore this accoding to
ORA-00942 during database upgrade of Oracle Workspace Manager (Doc ID 1399508.1)

public synonym X$KGLLK and invalid view SYS.X_$KGLLK can be dropped in 11G.
So drop the views and any synonyms related to $kslei as they are not used in 11g.
see Invalid X_$ Views & Synonyms After Upgrading to 11g (Doc ID 878623.1)

четверг, 31 октября 2013 г.

Oracle Grid Standalone update 11.2.0.3 to 11.2.0.4


Backup ASM spfile
$srvctl config asm
ASM home: /u01/app/oracle/product/11.2.0/grid
ASM listener: LISTENER
Spfile: +DATA/asm/asmparameterfile/registry.253.811613369
ASM diskgroup discovery string: /dev/oracleasm/disks/*

$asmcmd
spbackup +DATA/ASM/ASMPARAMETERFILE/REGISTRY.253.811613369 /home/oracle/init+ASM.ora.backup

Backup OLR:
The default backup location for the OLR is in the path Grid_home/cdata/host_name

#ocrconfig –local –manualbackup

To restore OLR:
# crsctl stop crs
# ocrconfig -local -restore file_name
# ocrcheck -local
# crsctl start crs
$ cluvfy comp olr

Begin update
Shutdown the database, oem.
. oraenv prompt dbsid
$emctl stop dbconsole
$srvctl stop database -d dbsid

$unset ORA_CRS_HOME
$unset ORACLE_BASE
$unset ORACLE_HOME
$unset ORACLE_SID
Recommended practice is to upgrade an Oracle ASM instance with Oracle Universal Installer or asmca (after install new GI home) ./runInstaller

Confirm that asm, listener, database, oem are running.
. oraenv
+ASM
$crsctl stat res -t

. oraenv
dbsid
$srvctl start database -d dbsid
$emctl start dbconsole


воскресенье, 27 октября 2013 г.

Oracle update 11.2.0.3 to 11.2.0.4

I have Grid Standalone installation 11.2.0.3 and Oracle Database 11.2.0.3
I plan update to 11.2.0.4
Patching end date for 11.2.0.3 is 27-Aug-2015.

1. Need PSU (Doc ID 1392633.1) and Latest Opatch to apply.
Oracle Grid Infrastructure Patch Set Update 11.2.0.3.8 (Includes Database PSU 11.2.0.3.8) - 17272731
2. Download Patch Set 11.2.0.4 13390677

Pre-Upgrade Utility Note 884522.1

Use DBUA for out-of-place installation


to be continued ...