Solved

Ora 9iAS install

Posted on 2004-08-17
13
2,231 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
 
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

708 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now