List tables which have specific column with number of rows for a given requirement.

select q'[select ']'||table_name||q'[' as table_name, count(*) from ]'||table_name||q'[ where COL1='VAL1';]' from dba_tab_columns where column_name='COL1' and upper(owner) ='USER';

Exclude specific tables from expdp

Here is the command

expdp user/password@sid schemas=schema_name include=TABLE:"IN ('TABLE1', 'TABLE2')" 

directory=DATAPUMP_DIR dumpfile=user_date.dmp logfile=user_date.log

Some operating systems need special characters to be escaped

include=TABLE:\"IN (\'TABLE1\', \'TABLE2\')"

Or

include=TABLE:\"IN \(\'TABLE1\', \'TABLE2\'\)"
  

Update a table column using a sequence

create table duplicate as select * from original
alter table duplicate add ID number;
create sequence seq1

set pagesize 0

set linesize 200

spool update.sql
select 'update duplicate set ID='||seq1.nextval||q'[ where rowid=']'||rowid||q'[';]' from duplicate;

spool off

>@update.sql

/OVS is empty after installing Oracle VM Server

Had to pull your hair to figure out why /OVS is empty after a fresh installation of Oracle VM Server? Well It's the default behavior in OVM Server 3.0.3, unlike 2.2.0.
It can be and should be done via Oracle VM Manager.
Click here to see how I found it out.

OVM-1004 XML-RPC Client Call Oracle VM Agent API 'register_server' error: exceptions.Exception:method "register_server" is not supported, please try again later.

If you get this error when you try to create a new server pool, then you are probably using two different versions of VM Server and  VM Manager which are not compatible. Look! error is misleading. This won't get resolved even if you try again a bit later, until you  have right packages installed.

Click here to see how I found this out. 

VM Manager 3.0.3 on SuSE 11

Today I tried installing VM Manager 3.0.3 on SuSE 11 and got the following.

Oracle VM Manager can only be installed on a 64 bit Oracle Linux version 5.5 and higher.
Current version is 'SuSE' version '11'
**** WARNING: Recommended memory for the Oracle VM Manager server installation is 3950 MB RAM*
Configuration verification failed

 Solution:
Error says it all. Have OL 5.5 or higher!

Can't connect to Oracle VM Manager home page

This is a firewall issue!

Open http access

system-config-securitylevel-tui -q -p 8888

Open https access

system-config-securitylevel-tui -q -p 4443

Disable iptables altogether!

service iptables stop