Any idea for the issue below ?
It looks like the extract process can't connect to the database:
>> 2013-10-03 13:14:53 ERROR OGG-00664 Oracle GoldenGate Capture for Oracle, extp.prm: OCI Error beginning session (status = 1034-ORA-01034: ORACLE not available
Verify the dblogin info in the prm file, include the "setenv" for ORACLE_SID, etc, in the prm file. Include the report file here, it's essential for troubleshooting this. Try in ggsci to run "dblogin", "list tables *", etc.
please can you provide param files of extract and pump..????
Make sure your ORACLE_HOME and ORACLE_SID env variables are set correctly.