Home » RDBMS Server » Server Utilities » Exp in Oracle 12c (Oracle 12c. - 12.1.0.2)
Exp in Oracle 12c [message #666114] Mon, 16 October 2017 06:16 Go to next message
snehalgandhi
Messages: 43
Registered: February 2011
Location: Ahmedabad
Member
I have recently installed Oracle 12c (12.1.0.2) on OpenSuse machine. I am trying to take backup of the database by using exp utility with system user (exp system/password file=exp log=exp full=y statistics=none consistent=y).
Whole backup is done successfully but at the end i am getting an error as below
EXP-00008: ORACLE error 29280 encountered
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 41
ORA-06512: at "SYS.UTL_FILE", line 478
ORA-06512: at "SYS.DBMS_AW_EXP", line 95
ORA-06512: at "SYS.DBMS_AW_EXP", line 1183
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling SYS.DBMS_AW_EXP.instance_extended_info_exp for object 85562

Can anyone please help me with this...

Re: Exp in Oracle 12c [message #666116 is a reply to message #666114] Mon, 16 October 2017 06:31 Go to previous messageGo to next message
BlackSwan
Messages: 25751
Registered: January 2009
Location: SoCal
Senior Member
snehalgandhi wrote on Mon, 16 October 2017 04:16
I have recently installed Oracle 12c (12.1.0.2) on OpenSuse machine. I am trying to take backup of the database by using exp utility with system user (exp system/password file=exp log=exp full=y statistics=none consistent=y).
Whole backup is done successfully but at the end i am getting an error as below
EXP-00008: ORACLE error 29280 encountered
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 41
ORA-06512: at "SYS.UTL_FILE", line 478
ORA-06512: at "SYS.DBMS_AW_EXP", line 95
ORA-06512: at "SYS.DBMS_AW_EXP", line 1183
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling SYS.DBMS_AW_EXP.instance_extended_info_exp for object 85562

Can anyone please help me with this...

above does NOT look successful to me.

Which file in what directory contains the dump file results?
Re: Exp in Oracle 12c [message #666117 is a reply to message #666116] Mon, 16 October 2017 06:42 Go to previous messageGo to next message
snehalgandhi
Messages: 43
Registered: February 2011
Location: Ahmedabad
Member
Yes the backup is with warnings.
The directory in which i am taking backup is /backup.

Also please not that i am using traditional exp and not expdp
Re: Exp in Oracle 12c [message #666118 is a reply to message #666117] Mon, 16 October 2017 06:48 Go to previous messageGo to next message
BlackSwan
Messages: 25751
Registered: January 2009
Location: SoCal
Senior Member
snehalgandhi wrote on Mon, 16 October 2017 04:42
Yes the backup is with warnings.
The directory in which i am taking backup is /backup.

Also please not that i am using traditional exp and not expdp
What differentiates warnings from errors?

Which file in what directory contains the dump file results?
Re: Exp in Oracle 12c [message #666120 is a reply to message #666118] Mon, 16 October 2017 07:06 Go to previous messageGo to next message
snehalgandhi
Messages: 43
Registered: February 2011
Location: Ahmedabad
Member
Dump file results are stored in /backup/exptest.dmp and /backup/exptest.log
Re: Exp in Oracle 12c [message #666121 is a reply to message #666120] Mon, 16 October 2017 07:14 Go to previous message
BlackSwan
Messages: 25751
Registered: January 2009
Location: SoCal
Senior Member
post results from OS commands below

ls -ld /backup/
ls -l /backup/*
Previous Topic: IMP-00017: following statement failed with ORACLE error 922
Next Topic: Re: Load WKT using sql*loader (split from http://www.orafaq.com/forum/t/155866/ by bb)
Goto Forum:
  


Current Time: Sun Dec 17 09:00:37 CST 2017

Total time taken to generate the page: 0.05312 seconds