Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2003
    Posts
    12

    Unanswered: Importing into windows 2k oracle 8.1.7i

    Hi I am trying to import an oracle database into oracle

    i type

    imp

    i get asked user and pwd:

    when i enter them I get an error::

    C:\Documents and Settings\Administrator>imp

    Import: Release 8.1.7.0.0 - Production on Fri Mar 21 16:06:48 2003

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    Username: system
    Password:

    IMP-00058: ORACLE error 12560 encountered
    ORA-12560: TNS:protocol adapter error
    IMP-00000: Import terminated unsuccessfully

    I tried to TNS ping incase this was the issue:


    C:\Documents and Settings\Administrator>tnsping cd-oracle

    TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 21-MAR-20
    03 16:04:07

    (c) Copyright 1997 Oracle Corporation. All rights reserved.

    Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=cd-oracle)(PORT=1521))
    OK (30 msec)

    which works so I can TNS ping the server.


    any ideas completly stuck.

  2. #2
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118
    use

    C:\Documents and Settings\Administrator>imp

    Import: Release 8.1.7.0.0 - Production on Fri Mar 21 16:06:48 2003

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    Username: system@cd-oracle
    Password:

    Remi
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

  3. #3
    Join Date
    Mar 2003
    Posts
    12
    ok i did:

    imp system/manager file=CON0.exp log=import_CON0.log full=y ignore=y commit=y


    and it shot off but errored all over the shop.

    errors like user doesnt exist etc etc.

    then the final insult:

    it has removed system manager account so now i cant get into my db

  4. #4
    Join Date
    Sep 2002
    Location
    Ohio
    Posts
    204
    Are you sure it removed the system account? I've never heard of the before. Could it be that the import changed the system password to whatever it was in the source database? This is more likely.

    If you know the system password from the source database, try logging in with that password. If not, try logging in as sys and changing the system password. If that fails, try logging in as internal and doing the same.

    Please post results. I'd be really surprised if the system account was truly deleted.

    HTH,
    Patrick

  5. #5
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi Patrick / Ken-doh

    Yes - surprising I know, but doing an import as SYS of a full export of SYS from another DB will overwrite SYS's password (or so I believe from experience of a client sending me a dump and me doing a full import).

    I've never felt like going back and confirming it :-) but the parameter "full=y" on system is a dangerous setting. I have also fallen prey to that one. Get the password for system on the imported database and you should have access back to your "sys" on your system. (Then look for all the cr*p that got imported) into sys on your database.

    HTH
    Bill
    Last edited by billm; 03-21-03 at 20:39.

  6. #6
    Join Date
    Mar 2003
    Posts
    12
    thanks for the reply

    I guessed that is what happend - However

    the import failed !!! and as a result I now have 0 passwords and am having to reinstall.

    Should I call the database and the machine the same as the database I am importing from?? would this cause a problem?


    any advice is greatly appreciated

    i am using

    imp system/manager file=CON0.exp log=import_CON0.log full=y ignore=y commit=y

    should I change this?? any suggestions
    thanks
    Last edited by Ken-doh; 03-24-03 at 07:44.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •