Solved

Ora 9iAS install

Posted on 2004-08-17
13
2,247 Views
Last Modified: 2008-03-17
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
Comment
Question by:tecumsehjoe
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
13 Comments
 

Author Comment

by:tecumsehjoe
ID: 11824237
I apologize, i dont think it is correct to include 'the rest of a successful install'
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 11824470
your ORACLE_HOME is set incorrectly.

you need to set ORACLE_HOME to infra instance.


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

Author Comment

by:tecumsehjoe
ID: 11825459
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
Independent Software Vendors: 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!

 
LVL 23

Expert Comment

by:seazodiac
ID: 11825509
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
 

Author Comment

by:tecumsehjoe
ID: 11825634
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
 

Author Comment

by:tecumsehjoe
ID: 11825731
ok silly me (told you under developed brain), i set the home correctly BUT I am still getting the same results as before
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 11826124
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
 

Author Comment

by:tecumsehjoe
ID: 11826211
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
 
LVL 23

Expert Comment

by:seazodiac
ID: 11826272
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
 

Author Comment

by:tecumsehjoe
ID: 11826326
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
 
LVL 23

Accepted Solution

by:
seazodiac earned 500 total points
ID: 11826346
try to run this command (replace username and password with real ones)

imp userid=<username/password>@IASDB.JP  file=exp.dmp
0
 

Author Comment

by:tecumsehjoe
ID: 11826376
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
 
LVL 23

Expert Comment

by:seazodiac
ID: 11826404
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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many‚Ķ
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question