export from db where sysaux needs recovery

Whenever sysaux goes to recovery state, you won’t be able to do the exp or expdp. You will get error like ‘not able to read/write sysaux’ datafiles. If you don’t have the archivelog to recover the sysaux, then you can follow below steps to atleast get the exp work. expdp doesn’t work still.


Shutdown immediate;
startup upgrade
@?/rdbms/admin/catnoqm.sql
shutdown immediate
startup


There you go, your export will work. Pls note, you may have to rebuild to have perfect system.

Importing oracle trusted certificate into oracle wallets

Importing oracle trusted certificate into oracle wallets

 

I am assuming user is created trusted certificate and hand over to you. As a oracle dba

 you have to import the trusted certificate in the oracle database server.

 

How to import user trusted certificate into oracle wallets

1. Create wallet
1. Syntax: orapki wallet create -wallet
2. $orapki wallet create -wallet ‘/home/oracle/admin/WALLETS’
1. Enter password:
2.  Enter password again:
3. copy/ftp the user trusted certificate to database server temp location
1. /tmp/testwallet_ssl.cer
4. To add a trusted certificate to an Oracle wallet:
1. Syntax:  orapki wallet add -wallet -trusted_cert -cert
2. $orapki wallet add -wallet ‘/home/oracle/admin/WALLETS’ -trusted_cert -cert ‘/tmp/testwallet_ssl.cer’
5. To view an Oracle wallet:
1.  Syntax:  orapki wallet display -wallet
2. $orapki wallet display -wallet ‘/home/oracle/product/WALLETS/oracle’

 

some useful link

https://apexapps.oracle.com/pls/apex/f?p=44785:1:6886471140158490

Golden gate tutorial

• Creating the Oracle Database Release 12c (12.1.0.1.0) Instance for Data Synchronization Using Oracle GoldenGate 12c on Linux
• Installing Oracle GoldenGate for Oracle 12.1.2 on Linux EL 6.x/RHEL 6.x/CentOS 6.x
•  Configuring Integrated Extract and Integrated Replicat Using Oracle GoldenGate 12c on Linux

Vagrant - easy to configure, reproducible, and portable work environments

Vagrant provides easy to configure, reproducible, and portable work environments



https://www.vagrantup.com/

http://www.cyberciti.biz/cloud-computing/use-vagrant-to-create-small-virtual-lab-on-linux-osx/

https://dennypc.wordpress.com/2014/06/09/creating-a-windows-box-with-vagrant-1-6/

Getting Started with Docker on Oracle Linux

Learn how to customize a Docker container image and use it to instantiate application instances across different Linux servers. This article describes how to create a Dockerfile, how to allocate runtime resources to containers, and how to establish a communication channel between two containers (for example, between web server and database containers).

Docker containers wrap up a piece of software in a complete filesystem that contains everything it needs to run: code, runtime, system tools, system libraries 

• https://community.oracle.com/docs/DOC-914969
• Getting to know Docker – a better way to do virtualization?
• Installing the Oracle database in docker

 

Common Docker commands

Commands	Purpose
docker info	information
docker images	images
docker ps -a	List all containers
docker rm $(docker ps -a -q)	Remove containers
docker rmi $(docker images)	Remove images
docker save mynewimage > /tmp/mynewimage.tar	Export images
docker load < /tmp/mynewimage.tar	Import images

docker pull oracle/nosql

Linux Containers

Linux Containers

Linux Containers (LXC) allow running multiple isolated Linux instances (containers) on the same host.

• Lightweight and resource-friendly
• Run multiple versions of an operating system on a single server
• Rapid and Easy deployment

Installing Oracle Linux containers

https://blogs.oracle.com/OTNGarage/entry/linux_container_lxc_part_2

Installing Oracle on Linux containers

https://bdrouvot.wordpress.com/2014/04/25/reduce-resource-consumption-and-clone-in-seconds-your-oracle-virtual-environment-on-your-laptop-using-linux-containers-and-btrfs/

Oracle Migration (Windows 10g to Linux 11g ) Using storage move

Oracle Migration (Windows 10g to Linux 11g ) Using storage move.

Describes steps for migration Opera Databases 10.2.0.4 on Windows to 11.2.0.3  on Linux Red Hat Enterprise Linux using Storage Disk copy

Steps in Windows side

1) Check disks and ASM Diskgroups in Windows environment.

select disk_number,name, parth for v$asm_disk;

Check for invalid objects

select owner, count(*) from dba_objects where status='INVALID'
2) Run the 11g pre upgrade script
@%oracle_home%\rdbms\admin\utlu112s.sql

3) Shutdown database
shutdown immediate

4) Dismount ASM diskgroup
alter diskgroup dismount all;

DC STORAGE ASM DISK MOVE FROM WINDOWS TO LINUX

Steps in Linux side

1) as grid user
oracleasm scandisks
oracleasm listdisks

sqlplus / as sysasm
alter diskgroup DATADG mount;

2) as oracle user
startup mount pfile='/home/oracle/initopera_pre.ora'
alter database open upgrade
@?/rdbms/admin/catupgrd
@?/rdbms/admin/utlu112s.sql
@?/rdbms/admin/utlrp.sql

Database Scripts

Database Scripts

• archive_log_by_size.sql
• asm_rac.txt
• checkINqueue.txt
• dba_scehduler_job.txt
• db_check.sql
• flashback.txt
• freespace.sql
• iops.sql
• killsession.sql
• redo.txt