Svetoslav Gyurov - Svetoslav Gyurov technical blog (Page 3)

OEM 12c installation fails if parallel_max_servers too high

Just a quick post regarding OEM 12c installation where recently I had to install OEM 12c and during the repository configuration step the installation fails with error: ORA-12801: error signaled in parallel query server P151 This was caused by a known bug which requires decreasing the number of parallel queries

11.2

Consider database timezone when created during DST

Not long time ago customer asked me to create new a database and refresh it from production. Nothing special here database was quickly created and then refreshed using network import for few schemas. Few weeks later I’ve been told that the database has a timestamp problem. The date and

11.2

RMAN fails to allocate channel with Tivoli Storage Manager

I was recently configuring backup on the customers Exadata with IBM TSM Data Protection for Oracle and run into weird RMAN error. The configuration was Oracle Database 11.2, TSM client version 6.1 and TSM Server version 5.5 and this was the error: [oracle@oraexa01 ~]$ rman target / Recovery

12.1

Oracle GI 12.1 error when using NFS

I had quite an interesting case recently where I had to build stretch cluster for a customer using Oracle GI 12.1 and placing quorum voting disk on NFS. There is a document at OTN regarding the stretch clusters and using NFS as a third location for voting disk but

emdiag

EMDIAG Repvfy 12c kit - basics

Second post in the series of emdiag repvfy kit about the basics of the tool. Having the kit already installed in earlier post it is time now to get some basics before we start troubleshooting. There are three main commands with repvfy: verify - repository-wide verification analyze - objects specific

emcli

Why my EM12c is giving Metric evaluation error for Exadata cell targets?

As part of my Cloud Control journey I encountered a strange problem where I got the following error for few Exadata Storage Server (cell) targets: Metric evaluation error start - oracle.sysman.emSDK.agent.fetchlet.exception.FetchletException: em_error=Failed to execute_exadata_response.pl ssh -q -o ConnectTimeout=60

emdiag

EMDIAG Repvfy 12c kit - installation

Recently I’m doing a lot of OEM stuff for a customer and I’ve decided to tidy and clean up a little bit. The OEM version was 12cR2 and it was used for monitoring few Exadata’s and had around 650 targets. I planned to upgrade OEM to 12cR3,

dba

Upgrade to Oracle Enterprise Manager Cloud Control 12c Release 3 (12.1.0.3)

Just a quick wrap up on EM12cR3 upgrade. I have to say that I was pleasantly surprised that everything went so smooth. I didn’t expected anything else, but with so how many products and components we have there I got few things in mind. The version I got was

emcli

Oracle EM auto discovery fails if the host is under blackout

During Exadata project I had to put some order and tidy up the Enterprise Manager targets. I’ve decided to discover all targets, promote the one which are missing and delete old/stale one. I’ve got strange error and decided to share it if someone hit it. I’m

A new beginning

It has been long since my last post and the time has come to resume my postings and refresh my blog. A lot of things happened last few months, I’ve been really busy working on many different projects, graduate university and the very big step – relocate to London with

java

Missing IPV6 address for local network interfaces causes service timeout

Year ago I installed Weblogic server + Oralce database server for a customer. Few months later my colleagues asked me whether something has changed in the environment or if something happened at the data center, because they started to see Java exceptions for unknown hostname for a web service they were

apex

How to run standalone Oracle APEX Listener 2.0 with Oracle 11g XE and APEX 4.1.1

This is short guide on how to run standalone Oracle APEX Listener 2.0 beta with Oracle 11g XE. I’m using Oracle Enterprise Linux 5.7 for running Oracle APEX Listener and Oracle Database 11g XE with APEX 4.1.1. Although running APEX Listener standalone is not supported

oraclevm

How I run Oracle VM 2.2 guests with custom network configuration

Recently I was given three virtual machines running Oracle Enterprise Linux 5 and Oracle 11gR2 RAC on Oracle VM 2.2.1, copied straight from /OVS/running_pool/. I had to get these machines up and running at my lab environment, but I found hard to setup the network. I’

10.2

Failed creating physical standby database

These days I’m implementing Oracle Dataguard for two Oracle databases 10.2 as part of disaster recovery project, one of them is around 1.7TB, not yet production. As part of the DG setup backups have to be available for both primary and standby. I preferred to use ASM

10.2

Oracle Database 10.2 datapump job fails because of invalid queue

Recently I had to clone one schema from Oracle Database 10.2.0.3 on HP-UX to 10.2.0.4 on Linux. The first problem came when I tried to export it and got the following errors: UDE-00008: operation generated ORACLE error 31623 ORA-31623: a job is not attached

apex

Oracle 11g XE listener does not start when there is another database running

If for any reason you have a two databases running on the same server and one of them is Oracle 11g Express Edition then you will get surprised that listener of XE is not started automatically during boot if there is another listener already running. Debugging the startup script I

apex

Not able to update Web service process in APEX 4.1

Last month I created a simple APEX application with enabled mobile support and latest version of jQuery, which integrates with HP Service Manager through web services. The purpose was to give option for company engineers to open and update incidents through mobile in few easy steps. The first step was

apex

Automatically backup Oracle APEX applications to Subversion

In continue of my previous posts about APEX and Subversion I made a short script using APEXExport utility to automate and backup APEX to Subversion repository. I'm using Oracle Express Edition 11.2, which by default doesn't have the APEXExport utility. That's why you need first to create the directory

10.2

ASM diskgroup unable to mount because of duplicate disk

This is something I would like to share for a long time, but for one or another reason I didn't. The error is nothing special, but then I run into very interesting case. This happen when I had to shutdown one server for maintenance and then boot it again. Once

11.2

Unable to create ASM disk under OEL 6.x

It was busy month and I'm behind with my blog posts. First of all Happy New Year to all of you and wish you all the best through the new year! This is a short note for installing Oracle Database with ASM under Oracle Enterprise Linux 6.x, which is

11.2

Database 11.2 bug causes huge number of alert log entries

Few days ago I received a call from customer about problem with their EM console and messages about file system full. They run DB 11.2.0.2 on OEL 5.7 and had only binaries installation at that file system and the database itself was using ASM. I quickly

lvm

Troubleshooting ASM 11.2 disk discovery

I was doing some installation at customer site when they asked if there anything specific to run GI 11.2 on HP-UX as this was their first interaction with 11g. Of course I replied that there is nothing specific, just to make sure the ownership of the raw disk is

bgoug

BGOUG starts tomorrow

It's less than a day, tomorrow starts the Bulgarian Oracle User Group (BGOUG) conference. I've been looking for so long for this conference as I missed OOW this year. The conference will took place at Hisarya (near Plovdiv) for three days where there are session only at Friday and Saturday.

apache

Configuring PHP with Oracle support on Oracle Enterprise Linux

In case you need to run PHP with Oracle support this is how to do it with Oracle Enterprise Linux 5.x. I assume that Apache and PHP are already installed. First you need to download the source of latest version of oci8 driver, here. Also you need to download

svn

How to integrate Oracle SQL Data Modeler with Subversion

It's not necessary to work on a big project to use SVN. Keeping your design into SVN repository is very useful and good practice. By doing so you could easily see what changes you've made to the design and in case of accident you could restore any older version and