| IMP utility not able to import [message #303689] |
Sun, 02 March 2008 01:18  |
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 #303728 is a reply to message #303700] |
Sun, 02 March 2008 07:30  |
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
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 #303793 is a reply to message #303731] |
Sun, 02 March 2008 21:46 |
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 #303795 is a reply to message #303794] |
Sun, 02 March 2008 21:57 |
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 #303805 is a reply to message #303798] |
Sun, 02 March 2008 22:46 |
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
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
