IMPORT PROBLEMS WITH DUMP FILE

[treedstang]

I just installed oracle 8i on a win2k system. I used the default preconfigured database setup.

This is what I typeD to import dump file.

imp system/manager@auafin full=y file=auafin22mar00.dmp.z

was that correct?? and yes the dump file name is that long do I need to rename it or anything?

Here's the error message

IMP-00037: CHARACTER SET MARKER UNKNOWN
IMP-00000: IMPORT TERMINATED UNSUCESSFULLY

[treedstang]

Oh yeah I forgot to mention that the dump file came from oracle 7.3.4 Sun System

[sreddy]

Is that dumpfile is compressed or uncompressed. I have mentioned to use 8i binaries for imp. Executables binaries should match with version of database.

wants to take 734 exp - use 734 exp utility
wants to imp on 816 imp - use 816 imp utility

Strange Message, which I have never seen for exp/imp.

[treedstang]

Ok Sreddy I'm rilling now the import is goin on right now as I right this email. I'm getting a lot of error messages take a look at the messages and tell me if I should stop it and start over with a 8.1.6 dump file that I just recieved or is this something unrelated to oracle versions take a look..

__________________________________________________

Connected to: Personal Oracle8i Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production

Export file created by EXPORT:V07.03.04 via conventional path
IMP-00017: following statement failed with ORACLE error 1119:
"CREATE TABLESPACE "AUAFINDATA" DATAFILE '/data1/oradata/AUAFIN/AUAFINdat1."
"dbf' SIZE 1258291200 DEFAULT STORAGE (INITIAL 40960 NEXT 40960 MINEXT"
"ENTS 1 MAXEXTENTS 505 PCTINCREASE 50) ONLINE PERMANENT"
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/data1/oradata/AUAFIN/AUAFINdat1.dbf'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
IMP-00017: following statement failed with ORACLE error 1119:
"CREATE TABLESPACE "SQLIDX" DATAFILE '/data1/oradata/AUAFIN/AUAFINidx1.dbf'"
" SIZE 943718400 DEFAULT STORAGE (INITIAL 40960 NEXT 40960 MINEXTENTS "
"1 MAXEXTENTS 505 PCTINCREASE 50) ONLINE PERMANENT"
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/data1/oradata/AUAFIN/AUAFINidx1.dbf'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
IMP-00017: following statement failed with ORACLE error 1119:
"CREATE TABLESPACE "ROLLBACK" DATAFILE '/data1/oradata/AUAFIN/AUAFINrbs1.db"
"f' SIZE 419430400 DEFAULT STORAGE (INITIAL 40960 NEXT 40960 MINEXTENT"
"S 1 MAXEXTENTS 505 PCTINCREASE 50) ONLINE PERMANENT"
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/data1/oradata/AUAFIN/AUAFINrbs1.dbf'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
IMP-00017: following statement failed with ORACLE error 1119:
"CREATE TABLESPACE "TEMPDB" DATAFILE '/data1/oradata/AUAFIN/AUAFINtmp1.dbf'"
" SIZE 335544320 DEFAULT STORAGE (INITIAL 40960 NEXT 40960 MINEXTENTS "
"1 MAXEXTENTS 505 PCTINCREASE 50) ONLINE TEMPORARY"

___________________________________________________

This bottom piece looks like it's having problems granting rights to the users

___________________________________________________


IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'LASHLEY' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "GLBUDGETACCTS" TO "LASHLEY""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'LASHLEY' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT UPDATE ON "GLBUDGETACCTS" TO "LASHLEY""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'LASHLEY' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
___________________________________________________

it's doing that for everyone in the database

[pando]

if you wanna import to create the tablespaces you have to "made up" the path for them for example if you want to create a file in c:\temp\test and this directory does not exist then obviously you will get errors, import wont make directories, it only creates files and if path is incorrect then you get erros, seems like you are importing from an unix dump file into personal oracle, create the tablespaces manually before you run import

[treedstang]

Thats exactly what I did pando..

Since it's almost done should I let it keep going?

What state will the database be in once it's complete will be usable??

[pando]

what did you do...? create the tablespaces manually? with same name I hope. If you have done this then just let import going, the errors you are getting would be just warnings

[treedstang]

Your right on the Money Panda!!! I finished the import and all I got was warnings. I'm able to connect to the database Via Sqlplus and other oracle tools.

I am expericening a another problem. When try to access the database with third party apps like cognos report writer I get

this error message


ORA-12154

My financial package hangs when I attempt to login. Seem strange the only thing I can connect to the imported database with is oracle tools only any reason why?


Thanks

[sreddy]

ora 12154 refers tnsnames.ora/listener.ora etc.
You might need to run catalog.sql and catproc.sql as userid SYS/INTERNAL and try accessing db.

[treedstang]

Where do I find the catalog.sql and catproc.sql so I can get this started ASAP


Thanks for you help again