Ora 9iAS install

I apologize, i dont think it is correct to include 'the rest of a successful install'

your ORACLE_HOME is set incorrectly.

you need to set ORACLE_HOME to infra instance.


then run "imp" (please note, in small cases)

what do you mean my oracle_home is set incorrectly?  How do i set it to infra?  Please provide a little more detail for my under developed simple mind.  thanx!

if you are on UNIX-variant;

try :

$ export ORACLE_HOME=<infra oracle home dir>
$ export ORACLE_SID=infra

then run imp


in windows,

C:\> set ORACLE_HOME=<INFRA install home>
C:\> set ORACLE_SID=infra

then run imp command,

or go to INFRA ORACLE_HOME/bin directory, to invoke imp there.

so i went to = start - run - cmd
at the 'C:\Documents and Settings\<user name>> prompt i typed in
'set ORACLE_HOME=Ora9ias_home'
it returned the prompt without any notices, i then typed
'set ORACLE_SID=infra'
I get the message;
'Message 100 not found; No message file for product=RDBMS, facility=IMP: Release 9.0.1.3.1 - Production on Tue Aug 17 17:21:14 2004
<c> Copyright 2001 Oracle Corpo
Invalid format of the Import utility name
Verify that ORACLE_HOME is properly set
Import terminated unsuccessfully
IMP-00000: Message 0 not found: No message file for product=RDBMS, facility=IMP'

then im back at the command prompt.  Please keep in mind that my computer was formatted and the OS was reinstalled.  Then the only steps i took were the ones listed above.

Please help, and thanx again

ok silly me (told you under developed brain), i set the home correctly BUT I am still getting the same results as before

this command does not sound right, 'set ORACLE_HOME=Ora9ias_home'

you should set ORACLE_HOME to a file path pointing to Ora9ias_home

and you did not tell me what the exact command you are trying to run is ...

can you be more detail-oriented? just tell me exactly what you want to do..

for example,
what's the command you have run to get the error message?



when you run imp,

you have to specify the USERID


this is an example:

imp userid=<username/password>@infra file=exp.dmp

right, you got me on the command i originally posted, i fixed that and set it to the actual path and i am still getting that same error.
 
to get this error I have just been going to the command prompt and typing 'imp' and letting it ask me for the username / password.

I have now gone to the directory containing the .dmp (via command prompt).  At the prompt i typed 'imp userid=<username/password>@infra file=exp.dmp"

This time i get the following error;
IMP-00058: ORACLE error 12154 encountered
ORA 12154: TNS: could not resolve service name
IMP-00000: Import terminated unsuccessfully

Ok, then you have TNS problem, which is easier to fix.

take a look at "infra" ORACLE_HOME/network/admin

there should be a TNSNAMES.ORA file in there.

there should be an entry pointing to infra in that file, can you confirm this? or can you post the contents of that file here?

also give me the HOSTNAME information

sounds good to me, there are two tnsnames.ora, being that there are two different homes;

# TNSNAMES.ORA Network Configuration File: d:\ora9ias\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

IASDB.JP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = petstore)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = iasdb.jp.petstore)
    )
  )

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

EXTPROC_CONNECTION_DATA.JP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

and

# TNSNAMES.ORA Network Configuration File: d:\ora9ias_bi\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

REP_JP =
  (ADDRESS = (PROTOCOL = tcp)(HOST = jp)(PORT = 1950))


DISCODEMO.JP =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = jp.petstore)(PORT = 1521))
    (CONNECT_DATA =
      (SERVICE_NAME = iasdb.jp.petstore)
    )
  )

So infra is not in there, correct?  The name of the computer is petstore and 'jp' was added (as described above) due to the warning when installing the infrastructure.  So, along with the fix for this can you provide the reason?  Appreciating this, ALOT!

ok, when i tried this it gave me a IMP-00031 error saying i must specify FULL=Y or FROMUSER/TOUSER or TABLES arguments and of course IMP-00000 Import terminated unsuccessfully.  I then tried the same only appending 'FULL=Y' and it begins...
At the end I got a IMP-00003 ORACLE error 942
ORA-00942 table or view does not exist
about to enable constraints....
Import terminated successfully with warnings.

Now can you give me a recap here of what has happend, from how i set this up and the resulting errors, to an explination of your beliefs of why this happend, and am i in the clear with this import?

I guess you used Oracle9iAS , in this version, you are stuck with the database name iasdb.

that's why you have an instance name IASDB.JP in your tnsnames.ora.

when you import, what username do you use?

you should use "SYSTEM" in any event.

the error message is ignorable since you see the message at the end

Import terminated successfully with warnings.
                          **********


you import process will use TNSNAMES.ORA as a source to connect database source.

that's all.