Results 1 to 10 of 10
  1. #1
    Join Date
    Sep 2005
    Posts
    7

    Unanswered: Import of DB failed-no log created

    Hi,

    I want to import another DB which was exported as a user.
    So I import it as a user, choose the path of the import (direct to CD-ROM) and the logfile. Then I continue with default settings. I see that a job is created which fails quickly. I want to know why it failed, no logfile was created.

    I am using Oracle 9i. Find the settings of the import below

    best regards,
    Raggi
    -----------------

    Allgemein
    Importdatei: e:\tcmdbuser.dmp
    Importtyp: Benutzer
    Importobjekte: Von Benutzer(n): tcmdbuser
    Verknüpfte Objekte: Mit Datenbankobjekten verknüpfte Berechtigungen , Indizes auf Tabellen, Zeilen mit Tabellendaten, Constraints auf Tabellen

    Erweiterte Optionen
    Log-Datei: d:\IMPORT.LOG

    Job-Informationen
    Name: Import0025
    Beschreibung: Aus Datei importieren e:\tcmdbuser.dmp
    Aktion: Job jetzt weiterleiten

    Ziel(e)
    Test2

    Inhalt von Parameterdatei
    FILE=e:\tcmdbuser.dmp
    LOG=d:\IMPORT.LOG
    FROMUSER=tcmdbuser
    GRANTS=y
    INDEXES=y
    ROWS=y
    CONSTRAINTS=y

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    What happens if you run IMPORT using a simple command line, such as this one:

    IMP username/password@db file=e:\tcmdbuser.dmp

    Does it show any errors?

  3. #3
    Join Date
    Sep 2005
    Posts
    7
    nice idea, Littlefoot! I"ll let you know the results when I am back at the oracle server.

    Other ideas also welcome! I talked now to the Oracle-Admin who gave me the dump. He has no experience with Oracle under windows, he made the dump with Linux. He said it should be pretty straight forward. Just create a user / node. Tell the import the location of the dump and the logfile and that's it. I was wondering why no log was created. The job was forwarded, started and failed quickly without showing errors


    Raggi

  4. #4
    Join Date
    Feb 2004
    Location
    Riyadh
    Posts
    24
    Hi,

    If that happens again, check whether the Database Instance is up and Running or not.
    Also you could even look at the ORACLE_SID that is set in the environment before starting the import. some times it may happen that the SID is different and the Database SID in the .DMP file is different and so it may fail.
    Check this and just post the message the IMPORT utility shows when invoked.

    HTH.

    Regards,
    Sudhakar

  5. #5
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Are you saying that, if

    <SID of an Oracle database where export was performed> and
    <SID of another database into which dump file is to be imported>

    are different, import will fail? If so, I must admit that I've never heard of this before.

  6. #6
    Join Date
    Sep 2005
    Posts
    7
    Now I tried to import on the command line and I got this error:



    IMP-00058: Oracle-error 12514 found
    ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor .

    Then I did : lsnrctl services listener_puntitoR5
    and got:

    Connection (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=puntitoR 5)(PORT=1541)))

    TNS-12541: TNS: no Listener
    TNS-12560: TNS: error in Protocoll adaptor
    TNS-00511: no Listener
    32-bit Windows Error: 61: Unknown error


    Now I paste my .ora-files:

    # LISTENER.ORA Network Configuration File: D:\oracle\ora92

    LISTENER_PUNTITOR5 =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = puntitoR5)(PORT = 1541))
    )

    SID_LIST_LISTENER_PUNTITOR5 =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = Test2)
    (ORACLE_HOME = D:\oracle\ora92)
    (SID_NAME = Test2)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = extproc)
    (PROGRAM = extproc)
    (ENV = D:\oracle\ora92)
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = D:\oracle\ora92)
    )
    )




    # TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\network\admin\tnsnames.ora


    TEST2 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = PUNTITOR5)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = Test2)
    (INSTANCE_NAME = Test2)
    )
    )

    INST1_HTTP =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = puntitoR5)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = SHARED)
    (SERVICE_NAME = MODOSE)
    (PRESENTATION = http://HRService)
    )
    )

  7. #7
    Join Date
    Sep 2005
    Posts
    7
    sorry, double posting
    Last edited by Raggi; 10-04-05 at 16:43.

  8. #8
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    And what was the command line?

    Should be something like this:

    IMP tcmdbuser/password@test2 file=e:\tcmdbuser.dmp

    Message you got said there was no listener. Therefore, try to see its status issuing
    c:\> lsnrctl status

    Start it using
    c:\> lsnrctl start

    or stop it by
    c:\> lsnrctl stop

  9. #9
    Join Date
    Sep 2005
    Posts
    7
    Now the errors mentioned above are solved!

    I used this command: IMP system/password@test2 file=e:\tcmdbuser.dmp

    I get a few errors while importing but I need to look closer what happened, maybe some tablespace were expected which I forgot to create

    I'll go to bed and try again tomorrow

  10. #10
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Well, large export/import operations rarely go without *any* problems; usually it is about grants to users that do not exist on your new system (but existed on system where you took the export file), views' create statements fail and such things; furthermore, problems can be encountered when NLS settings do not match, etc. But, generally speaking, it *should* be OK. More or less.

Posting Permissions

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