Useful Oracle script links

May 15, 2015 Leave a comment

Useful Oracle scripts from Oracle dudes

Tim Hall

http://oracle-base.com/dba/scripts.php

Tanel Poder

http://blog.tanelpoder.com/files/scripts/

Jeffrey Hunter

http://www.idevelopment.info/cgi/ORACLE_dba_scripts.cgi

Kerry Osborne

http://kerryosborne.oracle-guy.com/papers/my_favorite_scripts_2010.zip

Any more let me know and i will add it to the list

Advertisements
Categories: Oracle

How to access a NAT guest from host with VirtualBox

April 30, 2015 Leave a comment
Categories: Oracle

Increasing swap space on Oracle Linux

April 29, 2015 Leave a comment
Categories: Oracle

How to manage LVM volumes on CentOS / RHEL 7 with System Storage Manager

April 29, 2015 Leave a comment
Great post used it to extend my disk  in Oracle linux 7

http://xmodulo.com/manage-lvm-volumes-centos-rhel-7-system-storage-manager.html

how to use LVM in Linux

http://xmodulo.com/use-lvm-linux.html

Categories: Oracle

Clone a database using RMAN DUPLICATE command – using Veritas NetBackup

April 16, 2015 Leave a comment
Categories: Oracle

When installing vcenter 5.5 on windows server 2012 R2 Hangs

April 8, 2015 Leave a comment

vCenter 5.5 is not compatible with Windows Server 2012 R2 so when you run the install it hangs at the following screen

vcenter

to get round the issue I had to copy ocsetup.exe from the c:\windows\system32 directory on a Windows Server 2012 or 2008 R2 server and put it in the c:\windows\system32 directory on your Windows Server 2012 R2 server.

and restart the server

Categories: Oracle

Error: Connection to the current OMS could not be established. Check the log files for further details.

March 24, 2015 1 comment

When you try and setup emcli from your workstation and run the following command


emcli setup -username=sysman -password=xxxxxxx  -url=http://ukem12x01.group.com:7801/em -trustall -autologin

I kept on getting the following error

Error: Connection to the current OMS could not be established. Check the log files for further details.
Log file location is : C:\Users\michael.dsouza\.emcli\.emcli.log

I tried the following and it seemed to setup successfully


$ ./emcli setup -url="http://ukem12x01.group.com:7801/em" -username="sysman" -trustall -novalidate
Oracle Enterprise Manager 12c Release 4.
Copyright (c) 1996, 2014 Oracle Corporation and/or its affiliates. All rights reserved.

Enter password

Emcli setup successful


$ ./emcli status
Oracle Enterprise Manager 12c Release 4 EM CLI.
Copyright (c) 1996, 2014 Oracle Corporation and/or its affiliates. All rights reserved.

Instance Home : C:\Users\michael.dsouza\.emcli
Verb Jars Home : null
Status : Configured
EM CLI Home : C:\emcli\.
EM CLI Version : 12.1.0.4.0
Java Home : C:\Program Files (x86)\Java\jre1.8.0_40
Java Version : 1.8.0_40
Log file : C:\Users\michael.dsouza\.emcli\.emcli.log
EM URL : http://ukem12x01.group.com:7801/em
EM user : sysman
Auto login : false
Trust all certificates : true

Categories: Oracle