-
confused tnsnames.ora
Hi Dear Friends,
I have installed both Oracle 10gR2 and Oracle 10gXE on my windows 2003
server.
I am just confused because when I issue this command:
sqlplus system/oracle (it will logon to R2)
But if I issue
imp system/oracle (it will logon to XE)
when in fact i did NOT put any connect string
Where did it gone wrong.
Last edited by jennifer2007; 04-24-2007 at 09:35 PM.
-
Try Setting SID before you do any of the above:
set oracle_sid=
imp system/oracle ...
Also, you can try one of the following:
1. Right MyComputer>Advanced>Enivronment variables and set the default SID which you want and try the imp command.
-
Thanks dear...it worked ....but still why does Oracle get confused of the
two oracle /bin paths
-
Originally Posted by jennifer2007
Thanks dear...it worked ....but still why does Oracle get confused of the
two oracle /bin paths
You can set the ORACLE_HOME which you want it to be default in the environment variables window as you did for the default ORACLE_SID
-
oracle doesn't get confused, your OS does. It is picking up the imp from your PATH. Specify /full/path/to/file/imp to use the correct one (I'm guessing it's missing from XE).
Jeff Hunter
-
Thanks jeff dear ...below is the value of my OS path in top order:
D:\oracle\product\10.2.0\db\bin;
D:\oracle\product\10.2.0\db\jlib;
D:\oraclexe\app\oracle\product\10.2.0\server\bin;
D:\oracle\product\10.2.0\client_1\bin;
D:\oracle\product\10.2.0\db_2\bin;
- more here -
My understanding is...my default Oracle Home is>
D:\oracle\product\10.2.0\db\bin because it is the first in line.
My default tnsnames.ora and listener.ora will be pick from this home
(am i right?)
I am confused between the 2 BINs here....
the first (D:\oracle\product\10.2.0\db\bin) and
the fifth (D:\oracle\product\10.2.0\db_2\bin)
Are these two the home of my 10gR2EE?
The first doesnt constain imp.exe while the fifth has, thats why the OS
gets the second imp.exe located at my XE bin home.
One more question....
if I delete all the home path and retain my client home...
D:\oracle\product\10.2.0\client_1\bin
which database does it connect to when I issue sqlplus or imp
at dos prompt, w/o providing a connect string?
Thanks
Last edited by jennifer2007; 04-24-2007 at 09:50 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|