Versions Compared

Version Old Version 12 New Version 13
Changes made by

Jaimes Booth

Jaimes Booth

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

1. Logon as the oracle user

No Format
su - oracle

 

2. Setup the OE schema in the database

...

c. Logout of the database.

No Format
SQL> exit

 

3. Setup the correct TNS alias. Edit /home/oracle/app/oracle/product/11.2.0/dbhome_2/network/admin/tnsnames.ora

...

Note

Test if the TNS alias is working:

No Format
$ tnsping ttorcl_src
TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 11-JAN-2014 13:39:13
Copyright (c) 1997, 2010, Oracle.  All rights reserved.
Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = source-int)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl))) 
OK (0 msec)

 

4. Bring the database in archivelog mode. This is a requirement for Dbvisit Replicate

...

No Format
SQL> archive log list
Database log mode	       Archive Mode
Automatic archival	       Enabled
Archive destination	       USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     613
Next log sequence to archive   615
Current log sequence	       615

 

5. Ensure the archive log files are managed and not filling up and stopping the database. Install a script that manages the archive logs

...