Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Ora 9iAS install

Posted on 2004-08-17
13
Medium Priority
?
2,268 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
  • 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 2000 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Suggested Courses

886 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