Home » RDBMS Server » Server Utilities » IMP utility not able to import
IMP utility not able to import [message #303689] Sun, 02 March 2008 01:18 Go to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Hi,

I have installed multiple Oracles on my computer (in different homes)

10G was the first installation and 9i was the second. The IMP utility is by default the 9i version and it is not letting me connect to the 10g database it gives error " Could resolve service name' I assume that it is looking into tnsnames.ora file of 9i..

How can I make it to point towards 10g tnsnames file while using IMP on 10g?

- Das
Re: IMP utility not able to import [message #303700 is a reply to message #303689] Sun, 02 March 2008 02:27 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

SET PATH variable.
Re: IMP utility not able to import [message #303728 is a reply to message #303700] Sun, 02 March 2008 07:30 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Thanks..

I tried the following after going to the command prompt

set oracle_path=d:\10g_home


This is where my 10g is installed then tried to use import utility

imp -help


but it still uses 9i and then also tried importing with username and password of 10g but it gives me the same error "" Could resolve service name'

imp das/das@dbase2 full=n show=y file=d:\d.dmp


am I doing something wrong

- Das
Re: IMP utility not able to import [message #303730 is a reply to message #303728] Sun, 02 March 2008 07:46 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

it is not ORACLE_PATH it is ONLY "PATH".

set like
CMD>set ORACLE_HOME=oracle_home_os_path
CMD>set PATH=%ORACLE_HOME%/bin
Re: IMP utility not able to import [message #303731 is a reply to message #303730] Sun, 02 March 2008 08:18 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
BINGO...Thanks

Until my next roadblock

- Das
Re: IMP utility not able to import [message #303793 is a reply to message #303731] Sun, 02 March 2008 21:46 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Hi,

not able to access the IMP utility again. Did the following

cmd>set oracle_home=d:\oracle
cmd>set path=d:\oracle\product\10.2.0\db_1\bin
cmd> imp -help


Quote:
Error Message 100 not found; No file for product=RDBMS, facility=IMP Rele...

Verify that Oracle_home is properly set
IMP 00000 Message 0 not found; No file for product=RDBMS, facility=IMP Rele...



I read in the posts to set Oracle_base variable as well so

cmd>set oracle_home=d:\oracle
cmd>set path=d:\oracle\product\10.2.0\db_1\bin
cmd>set oracle_base=d:\oracle
cmd> imp -help


Still the same error. What can be the reason for the same?


- Das
Re: IMP utility not able to import [message #303794 is a reply to message #303689] Sun, 02 March 2008 21:52 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
>What can be the reason for the same?
user error

do

d:
\oracle\product\10.2.0\db_1\bin\imp help=yes

[Updated on: Sun, 02 March 2008 21:52] by Moderator

Report message to a moderator

Re: IMP utility not able to import [message #303795 is a reply to message #303794] Sun, 02 March 2008 21:57 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Thanks..now it is showing 10.2.0 in the error but still the error

Quote:

Error Message 100 not found; No file for product=RDBMS, facility=IMP Release 10.2.0

Verify that Oracle_home is properly set
IMP 00000 Message 0 not found; No file for product=RDBMS, facility=IMP Release 10.2.0


persists. I tried setting oracle_home and oracle_base but did not help

can you tell me why?

- Das
Re: IMP utility not able to import [message #303798 is a reply to message #303689] Sun, 02 March 2008 22:25 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Set correct ORACLE_HOME. By the way oracle_home=d:\oracle is not the correct home I think. It should be like /oracle/product/10.2.0/db_1

Re: IMP utility not able to import [message #303805 is a reply to message #303798] Sun, 02 March 2008 22:46 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Yes..you were right, now I am able to open the IMP utility of 10g properly

but I am still not able to connect to the 10g database I tried

imp das/das@dbase2 file=d.dmp full=n show=y


Quote:
Error - Ora-12538 TNS: No such protocol adapter
Import terminated unsuccessfully


I tried setting the path to tnsnames file but even then the same error..

What can be the remedial measure?

- Das
Re: IMP utility not able to import [message #303808 is a reply to message #303805] Sun, 02 March 2008 22:59 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Try to set TNS_ADMIN variable to point ORACLE 10g home network directory.
Re: IMP utility not able to import [message #303809 is a reply to message #303689] Sun, 02 March 2008 23:00 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
>What can be the remedial measure?
I give up in trying to guess what you have or what you are really trying to do.

Because you have two different versions of Oracle installed,
you have 2 listener.ora files & 2 tnsnames.ora files.
Who knows how they are configured or what is being(ab)used?

If you have only 1 computer system & you are logged directly onto that system you have NO/ZERO need to use SQL*Net (@dbase2).
Re: IMP utility not able to import [message #303810 is a reply to message #303689] Sun, 02 March 2008 23:01 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

What is the value of protocol parameter in tnanames.ora? Ensure that if it contains TCP then you have TCP/IP installed in your machine.

I assume that you have properly set your ORACLE_HOME.
Re: IMP utility not able to import [message #303814 is a reply to message #303808] Sun, 02 March 2008 23:18 Go to previous message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Thanks again..the tns_Admin did it


Previous Topic: Import analyse
Next Topic: IT Manager
Goto Forum:
  


Current Time: Sat Dec 03 14:17:42 CST 2016

Total time taken to generate the page: 0.12792 seconds