Skip to content
David Buzinkai

zavisko.com

  • Curriculum Vitae
  • Oracle WIKI
  • SAP WIKI
zavisko.com

Installation 10g

zaviskoSeptember 18, 2015March 26, 2017Leave a comment
Pre-installation steps Check free space. For installation of oracle you will need at least following space: 4GB at $ORACLE_HOME (etc....
Read More

Duplicate database (Schema only)

zaviskoSeptember 17, 2015March 25, 2017Leave a comment
Copying schemas w/o user passwords This scenario is used when different passwords are used in source and target databases and...
Read More

Duplicate database (Current incarnation)

zaviskoSeptember 16, 2015March 25, 2017Leave a comment
To proceed with this tutorial you need to have target database. If you want to duplicate database to completely new...
Read More

Create a new database

zaviskoSeptember 14, 2015March 25, 2017Leave a comment
Set the SID Set the unique SID of new database at your environment. Example of UNIX command: #example of C...
Read More

Object compilation

zaviskoSeptember 14, 2015March 25, 2017Leave a comment
Check for uncompiled or wrongly compiled objects Execute this SQL command: COLUMN object_name FORMAT A30 SELECT owner, object_type, object_name, status...
Read More

Add new redolog group

zaviskoSeptember 14, 2015March 25, 2017Leave a comment
Check for existing redolog groups On UNIX filesystem redologs are stored in folder /oracle/<SID>/origlog<X> and mirrored in folder /oracle/<SID>/mirrlog<X> You...
Read More

Posts navigation

1 2 3
zavisko.com
Proudly powered by WordPress | Theme: refur by teFox.