ADRCI incompatible schema version

This issue arises when migrating from Oracle 12.1 to 12.2.

I could not easily find the info how to fix this issue, so I’ll share it in case someone else stumbles upon it.

adrci> show log
DIA-48494: ADR home is not set, the corresponding operation cannot be done
adrci>

adrci> show homes
ADR Homes:
diag/netcman/hostname/cman_hostname.domainname
adrci>

adrci> set homepath diag/netcman/hostname/cman_hostname.domainname
adrci> purge -age 129600 -type ALERT
DIA-49803: Purge not possible due to incompatible schema version.

adrci> set homepath diag/netcman/hostname/cman_hostname.domainname
adrci> migrate schema
Schema migrated.
adrci> purge -age 129600 -type ALERT
adrci>

Done!

Oracle datapump status

Oracle logoDuring a import run of a +100GB Oracle database I was curious what the current progress was. I discovered you can press Ctrl+C to go to an interactive command mode during a import of export using datapump (impdp of expdp). In the interactive you can request the current status of the job(s). It is also possible to stop, start and resume jobs. For all options just type ‘HELP’. See the example below:

Import> status

Job: SYS_IMPORT_FULL_02
Operation: IMPORT
Mode: FULL
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /usr/local/oracle/import/a01act-20140811-%u.dmp
Dump File: /usr/local/oracle/import/a01act-20140811-01.dmp
Dump File: /usr/local/oracle/import/a01act-20140811-02.dmp
<cut>
Dump File: /usr/local/oracle/import/a01act-20140811-50.dmp
Dump File: /usr/local/oracle/import/a01act-20140811-51.dmp

Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: ****
Object Name: PTL*****
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 1
Completed Rows: 122,772
Completed Bytes: 102,619,789,192
Percent Done: 49
Worker Parallelism: 1

Import>

So I’m almost halfway now.

To return to the logging mode:

Import> CONTINUE_CLIENT

VirtualBox snapshots using the CLI

oracle-virtualbox-logoThis is how I use the VirtualBox snapshot option on my headless server. I use this feature for creating a restore point for a critical mail server upgrade I will soon post about. Because I will use this option more often it comes handy when recorded somewhere.

Specs:

  • Debian 6.0.6 “Squeeze”
  • Virtualbox 4.1.22-80657

See the Virtualbox snapshot syntax below

VBoxManage snapshot         |
take  [--description ] [--pause] |
delete | |
restore | |
restorecurrent |
edit ||--current
[--name ]
[--description ] |
list [--details|--machinereadable]
showvminfo |

(more…)