Oracle Database Discussions

Hello all,

I'm having problems importing from a database instance on an 11Gr1 RAC server, to a newly created instance on a 11Gr2 server.
Looking through the logs, looks like the problem right off to bat is...it can't create the tablespaces...? I thought it could create the tablespaces if they weren't there already...?

First errors in the log look like:

Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/********@instancename DIRECTORY=DPDUMP PARFILE=instancename _impdp.par
Processing object type DATABASE_EXPORT/TABLESPACE
ORA-39083: Object type TABLESPACE failed to create with error:
ORA-02236: invalid file name
Failing sql is:
CREATE TABLESPACE "L_DATA_01" DATAFILE SIZE 4294967296 AUTOEXTEND ON NEXT 4294967296 MAXSIZE 16384M LOGGING ONLINE PER
MANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 134217728 DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO
ORA-39083: Object type TABLESPACE failed to create with error:
ORA-02236: invalid file name
Failing sql is:
CREATE TABLESPACE "L_INDEX_01" DATAFILE SIZE 2147483648 AUTOEXTEND ON NEXT 2147483648 MAXSIZE 8192M LOGGING ONLINE PER
MANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 134217728 DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO
ORA-39083: Object type TABLESPACE failed to create with error:
ORA-02236: invalid file name

And so on...of course...everything else failed after this.

I'm not sure what the problem is?

My import parfile looks like this:

DUMPFILE=INSTANCENAME_08_26_2010.dpdmp
LOGFILE=INSTANCENAME_04_15_2010.implog
REUSE_DATAFILES=Y
EXCLUDE=SYNONYM:"IN ('SYSCATALOG', 'CATALOG', 'TAB', 'COL', 'TABQUOTAS', 'SYSFILES', 'PUBLICSYN')"

The files names match for the dumpfile...double checked that.

My export parfile looks like this (from the 11Gr1 server)

FULL=Y
INCLUDE=ROLE:"NOT IN ('CONNECT', 'RESOURCE', 'DBA', 'SELECT_CATALOG_ROLE', 'EXECUTE_CATALOG_ROLE', 'DELETE_CATALOG_ROL
E', 'EXP_FULL_DATABASE', 'IMP_FULL_DATABASE', 'RECOVERY_CATALOG_OWNER', 'GATHER_SYSTEM_STATISTICS', 'LOGSTDBY_ADMINIST
RATOR', 'AQ_ADMINISTRATOR_ROLE', 'AQ_USER_ROLE', 'GLOBAL_AQ_USER_ROLE', 'SCHEDULER_ADMIN', 'HS_ADMIN_ROLE', 'OEM_ADVIS
OR', 'OEM_MONITOR', 'WM_ADMIN_ROLE', 'JAVAUSERPRIV', 'JAVAIDPRIV', 'JAVASYSPRIV', 'JAVADEBUGPRIV', 'EJBCLIENT', 'JAVA_
ADMIN', 'JAVA_DEPLOY')"
INCLUDE=DB_LINK
INCLUDE=PROFILE
INCLUDE=SCHEMA:"NOT IN ('SYSTEM', 'OUTLN', 'TSMSYS')"
INCLUDE=TABLESPACE:"NOT IN ('SYSTEM', 'SYSAUX', 'UNDOTBS1', 'UNDOTBS2', 'TEMP', 'USERS')"
INCLUDE=JOB
INCLUDE=PASSWORD_VERIFY_FUNCTION
CLUSTER=N
DUMPFILE=INSTANCENAME_08_26_2010.dpdmp
LOGFILE=INSTANCENAME_08_26_2010.dplog

Can anyone find something I'm doing wrong here?

I've done expdp and impdp...and never had a problem like this before....

Possibly the tablespaces WERE already set up before I got to them...but I don't think this was the case all the time, and it worked.

Thank you,

cayenne

PS. Had to mention..yes, I have verified that on the database the directory has been created with the proper name and path...and read/write was granted to system.

Edited by: cayenne on Aug 27, 2010 12:38 PM