Home » RDBMS Server » Server Utilities » probem_using_import_export_when_Installing_form_developer (oracle 10g and forms 10g with windows xp sp2)
probem_using_import_export_when_Installing_form_developer [message #495397] Fri, 18 February 2011 11:48 Go to next message
m_shehpar
Messages: 73
Registered: October 2010
Location: Pakistan
Member
hi all,

i have a very strange problem. when i created a database with the name "hbfm" and used import/export utility it worked all fine but when i installed form developer and then again tried to use import/export utility it gave me an error:

IMP-00058: ORACLE error 12560 ecountered
ORA-12560: TNS:protocol adapter error
IMP-00000: Import terminated unsuccessfully

and the strange thing is that when i again created the database with the name "orcl" (plus form developer) it worked all fine. i tried to recreate the database with the name "hbfm" and then install form developer the problem persisted with the import/export utility.

i reconfigured listner configuration, naming method configuration, local net service name configuration using net configuration assistant but all in vain

please help me out of this delima if somebody can. i use:
oracle database 10g Enterprise edition release 10.2.0.1.0 and
Forms [32 bit] Version 10.1.2.0.2

regards...
Re: probem_using_import_export_when_Installing_form_developer [message #495398 is a reply to message #495397] Fri, 18 February 2011 12:06 Go to previous messageGo to next message
Michel Cadot
Messages: 67546
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORACLE_HOME, ORACLE_SID, PATH... is or are not correctly set.

Regards
Michel
Re: probem_using_import_export_when_Installing_form_developer [message #495415 is a reply to message #495397] Fri, 18 February 2011 21:49 Go to previous messageGo to next message
m_shehpar
Messages: 73
Registered: October 2010
Location: Pakistan
Member
hi michel,

can i ask how to reset them??? i wonder what is wrong with the database name??? why does is it work when the database name is "orcl" and not when the name is some thing else....

hoping for your kind help,
regards
Re: probem_using_import_export_when_Installing_form_developer [message #495417 is a reply to message #495415] Fri, 18 February 2011 22:24 Go to previous messageGo to next message
BlackSwan
Messages: 26756
Registered: January 2009
Location: SoCal
Senior Member
You have multiple ORACLE_HOME.
The environment variables are not in a consistent state.
open Command Window & issue OS command below

SET

COPY results then PASTE all back here
Re: probem_using_import_export_when_Installing_form_developer [message #495452 is a reply to message #495417] Sat, 19 February 2011 11:31 Go to previous messageGo to next message
m_shehpar
Messages: 73
Registered: October 2010
Location: Pakistan
Member
hi,

can you please tell me the OS command to set the enironment variable, and bring it in a consistent state???


waiting for your reply,

regards
Re: probem_using_import_export_when_Installing_form_developer [message #495453 is a reply to message #495452] Sat, 19 February 2011 11:43 Go to previous messageGo to next message
Littlefoot
Messages: 21623
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
SET is the command. Or via Control panel - System - Advanced - Environment variables.
Re: probem_using_import_export_when_Installing_form_developer [message #495456 is a reply to message #495453] Sat, 19 February 2011 12:28 Go to previous messageGo to next message
m_shehpar
Messages: 73
Registered: October 2010
Location: Pakistan
Member
thanks to all of you for your kind help. i did my job.

since i am new to this forum can u tell me how to close a topic??? is there any criteria to assign credit to the person answering the question (as like in the other disscussion forums???). i didnt find any thing about this in the orafaq forum guide
Re: probem_using_import_export_when_Installing_form_developer [message #495458 is a reply to message #495456] Sat, 19 February 2011 12:53 Go to previous message
Michel Cadot
Messages: 67546
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
can u tell me how to close a topic?

A topic is never closed, anyone can add a new answer if something new comes.

Quote:
is there any criteria to assign credit to the person answering the question

This is not the choice we made. We do not rate people or posts.

Regards
Michel

[Updated on: Sat, 19 February 2011 12:54]

Report message to a moderator

Previous Topic: Creating a SQL Loader ctl file with over 1000 columns
Next Topic: data pump
Goto Forum:
  


Current Time: Sun Nov 29 05:22:45 CST 2020