Printable View
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
Oh yeah I forgot to mention that the dump file came from oracle 7.3.4 Sun System
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.
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
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
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??
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
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
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.
Where do I find the catalog.sql and catproc.sql so I can get this started ASAP
Thanks for you help again
Why do you get that Q and you wait for an answer/ Just use Unix 'find' command and pick the location thats relevant to vesion of the database to which you imported.
Its in ORACLE_HOME/rdbms/admin directory
And try compiling all the objects of SYS and SYSTEM.
And give a try. If you get 12154 try fixing tnsnames.ora.
Can I ask you a Q ? What made you to have this stuff as your responsibility. Its came on to you in no alternative situation or its your responsibility.
I mean, its hard to manage Just with forum. Especially Weekends. By any chance you have metalink access ? Iam advising you please request for metalink account and then only start working. Up to 70% of the Questions You will find an idea/solution with metalink, may not be direct, atleast indirect.
That helps you keep going with what has to be done, rather wait for some one's answer.
Don't take my Q otherway round. I could feel you having hard time on this. Thats why Iam suggesting...