DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: confused tnsnames.ora

  1. #1
    Join Date
    Feb 2007
    Posts
    212

    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.

  2. #2
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    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.

  3. #3
    Join Date
    Feb 2007
    Posts
    212
    Thanks dear...it worked ....but still why does Oracle get confused of the
    two oracle /bin paths

  4. #4
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    Quote 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

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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

  6. #6
    Join Date
    Feb 2007
    Posts
    212
    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
  •  


Click Here to Expand Forum to Full Width