How to include roles and grants into datapump export

For sure one way to do it, would be this one: Prepare the parameters file first: FULL=YES INCLUDE=SCHEMA:”IN (SELECT ‘PUBLIC’ FROM DUAL UNION SELECT username FROM dba_users WHERE username in (‘DB_USER1′,’DB_USER2’))” INCLUDE=PUBLIC_SYNONYM/SYNONYM:”IN (SELECT synonym_name FROM dba_synonyms WHERE owner = ‘PUBLIC’ AND table_owner in (‘DB_USER1′,’DB_USER2’))” DIRECTORY=DATA_PUMP_DIR DUMPFILE=orcl_expdp.dmp LOGFILE=orcl_expdp.log INCLUDE=ROLE:”IN (select role from dba_roles where role in…

How to include roles and grants into datapump export

For sure one way to do it, would be this one: Prepare the parameters file first: FULL=YES INCLUDE=SCHEMA:”IN (SELECT ‘PUBLIC’ FROM DUAL UNION SELECT username FROM dba_users WHERE username in (‘DB_USER1′,’DB_USER2’))” INCLUDE=PUBLIC_SYNONYM/SYNONYM:”IN (SELECT synonym_name FROM dba_synonyms WHERE owner = ‘PUBLIC’ AND table_owner in (‘DB_USER1′,’DB_USER2’))” DIRECTORY=DATA_PUMP_DIR DUMPFILE=orcl_expdp.dmp LOGFILE=orcl_expdp.log INCLUDE=ROLE:”IN (select role from dba_roles where role in…

X11 forwarding request failed on channel 0

I got this error while trying to redirect my display to the local host. marius$ ssh -X oracle@rac1 Warning: the ECDSA host key for ‘rac1’ differs from the key for the IP address ‘192.168.100.101’ Offending key for IP in /Users/marius/.ssh/known_hosts:10 Matching host key in /Users/marius/.ssh/known_hosts:13 Are you sure you want to continue connecting (yes/no)? yes…

Oracle RAC12c on OL 7 using Virtualbox

Assumptions: – You have already installed OL7 on a virtual machine – assigned at least 4G of memory, otherwise the CVU will complain. – 2 network cards =============== BEGIN ERRORS DESCRIPTION ======================= Note: Along the installation of the CLusterware 12cR1 I encountered couple of issues. This is actually the 2nd one, but should be fixed…