• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2271
  • Last Modified:

Ora 9iAS install

On a clean, standalone computer I am attempting to follow oracle by example instructions, I have;
added to the primary dns suffix of the computer,
added the ip and host name to the hosts file,
installed the Ora9i AS infrastructure;
     - name = Ora9ias_home
     - path = d:\ora9ias
     - instance name = infra,
installed the BI and forms option
     - name = Ora9ias_bi_home
     - path = d:\ora9ias_bi etc...
During this Oracle has created a DB = iasdb.jp.    
I login to sql as system, create a user, then i go to the c prompt to IMP.  I cant IMP as anybody, I get the message
IMP 00058 Oracle error 12560 encountered
ORA 12560 TNS protocol adapter error
IMP 00000 Import terminated unsuccessfully

Please assist with this along with (if needed) the rest of a successful install?
0
tecumsehjoe
Asked:
tecumsehjoe
  • 7
  • 6
1 Solution
 
tecumsehjoeAuthor Commented:
I apologize, i dont think it is correct to include 'the rest of a successful install'
0
 
seazodiacCommented:
your ORACLE_HOME is set incorrectly.

you need to set ORACLE_HOME to infra instance.


then run "imp" (please note, in small cases)
0
 
tecumsehjoeAuthor Commented:
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!
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
seazodiacCommented:
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.
0
 
tecumsehjoeAuthor Commented:
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
0
 
tecumsehjoeAuthor Commented:
ok silly me (told you under developed brain), i set the home correctly BUT I am still getting the same results as before
0
 
seazodiacCommented:
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
0
 
tecumsehjoeAuthor Commented:
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
0
 
seazodiacCommented:
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
0
 
tecumsehjoeAuthor Commented:
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!
0
 
seazodiacCommented:
try to run this command (replace username and password with real ones)

imp userid=<username/password>@IASDB.JP  file=exp.dmp
0
 
tecumsehjoeAuthor Commented:
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?
0
 
seazodiacCommented:
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.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 7
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now