Export Hanging, Please Advise

[jgmagnus]

I have an Export script that exports a schema.
It seems to be hanging and I have no idea why.
When I run the script it hangs when doing the definitions. PLease see below:

Export done in US7ASCII character set and US7ASCII NCHAR character set
Note: indexes on tables will not be exported

About to export specified users ...
. exporting foreign function library names for user V0109
. exporting object type definitions for user V0109


-- It hangs on thet last line
I run 8.0.6 on Unix Solaris.

thanks,
Magnus

[sreddy]

What kinda data you have in the databse ? its usuall data or graphical, spatial data ? Are you sure have run catexp.sql for that databse(I guess, You did). You have O_H and O_SID set correctly ? Post back your exp script ..

[jgmagnus]

This was a cron-job that ran every morning to backup the database/schema. It used to work fine, but I just noticed that that last few Exports have no data in them.

here is some data:
#!/bin/sh
#
# JGM 7/5/2000, Edited Tablespace 8/28/2000
# This script exports tablespace contents for V0105
#
#
# First set the path
#
PATH=$PATH:/u01/app/oracle/product/8.0.6/bin:/opt/oracle/bin:/export/home/oracle/tools:/export/home/orac
le/dba;export PATH
ORACLE_BASE=/u01/app/oracle;export ORACLE_BASE
BACKUP_HOME=/u04/oradata/AP01/exports
ORACLE_HOME=/u01/app/oracle/product/8.0.6;export ORACLE_HOME
ORACLE_SID=AP01;export ORACLE_SID
HOME=/export/home/oracle;export HOME
#
# EXPORT database
#
exp system/*password* file=/$BACKUP_HOME/db_`date '+%m%d%H%Y'`.dmp parfile=/$BACKUP_HOME/db_export.par
#


now my parfile is:
shamrock% more $BACKUP_HOME/db_export.par
owner=V0109
direct=Y
rows=y
consistent=y
grants=y
indexes=n
constraints=y
log=/u04/oradata/AP01/exports/exp_log.log


thanks for the help.
- Magnus

[sreddy]

I don't see anything wrong. Did anything chnage recently ? Why don't you try interactively running export at prompt but, not thru script to figure out where the problem is. That way we can conclude the problem is with/not with script and environment you are setting up in the script.

[jgmagnus]

I tried the export at command prompt and it hangs in exactly the same place. Strange. Could it be the system resources? The unix box has been up and running for over 6-8 months ...

where it hangs:
. exporting foreign function library names for user V0109
. exporting object type definitions for user V0109


then NOTHING. I left it running for over an hour.
It's just basic data, no clobs or lobs or anything.

- Magnus

[sreddy]

At this point something strike my mind. I don't see nowhere you mentioned buffer size in your script. Could you try with little bigger buffer size. Could be problem with buffer size...

Find buffer size on Solariis from following thread command.
[url]http://www.dbasupport.com/forums/showthread.php?threadid=6926[/url]

[Dave_A]

At the risk of stating the obvious, have you checked that there is sufficient space on your disk to take the export file?

[jgmagnus]

Looked like there was a problem with the system resources.

I shutdown the DB, rebooted the server, started up the DB, took cold-backups, and now everything works fine. The server had been up for 8-10 months so I thought maybe it just needed a bounce. Haven't really figured it out, but it works now ;-P

The buffer size seems to be fine, but I would admit that I am fairly ignorant on how to manipulate that parameter.
There was plenty of disk space though.

Thanks for the help.
- Magnus

[sreddy]

I think its 248 days bug with Oracle being Up. Was your database was up for 248 days by any chance ?

[jgmagnus]

The database MAYBE was up for around that amount of time.
We went LIVE last July and I don't think the DB has been down since then. That would be pretty close to 248.

- Magnus