OraFAQ Forum: Server Utilities » Exp in Oracle 12c

Home » RDBMS Server » Server Utilities » Exp in Oracle 12c (Oracle 12c. - 12.1.0.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Exp in Oracle 12c [message #666114]

Mon, 16 October 2017 06:16

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...

Report message to a moderator

Re: Exp in Oracle 12c [message #666116 is a reply to message #666114]

Mon, 16 October 2017 06:31

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: Exp in Oracle 12c [message #666117 is a reply to message #666116]

Mon, 16 October 2017 06:42

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

Report message to a moderator

Re: Exp in Oracle 12c [message #666118 is a reply to message #666117]

Mon, 16 October 2017 06:48

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: Exp in Oracle 12c [message #666120 is a reply to message #666118]

Mon, 16 October 2017 07:06

snehalgandhi
Messages: 43
Registered: February 2011
Location: Ahmedabad

Member

Dump file results are stored in /backup/exptest.dmp and /backup/exptest.log

Report message to a moderator

Re: Exp in Oracle 12c [message #666121 is a reply to message #666120]

Mon, 16 October 2017 07:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

post results from OS commands below

ls -ld /backup/
ls -l /backup/*

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 02:56:40 CST 2024