Trouble logging in

[hbar]

Sorry to burden everybody with a silly login problem, but I can't wrap my mind around it. I can tnsping all my servers from the command line, but I can only log in via pl/sql developer on one of them.

So, how do I know which tnsnames.ora file my command window is using (and also, how do you change which oracle home is the "active" one?)

I only have one oracle home, so all of this seems moot, but at the same time, it doesn't make any sense. Anybody have any ideas?

Thanks

 

[CTzen]

>So, how do I know which tnsnames.ora file my command window is using

Help -> Support Info -> Info

>(and also, how do you change which oracle home is the "active" one?)

1. Tools -> Preferences -> Oracle -> Connection -> Oracle Home

2. Command line parameter, e.g. C:\apps\PLSQLDeveloper\plsqldev.exe oraclehome=OracleClient920

 

[hbar]

Ha, I meant how do you change it in a dos prompt. At any rate, I uninstalled the client, re-installed, then restarted my mosheen, and now we're working again. Thanks anyhoo.

 

[CTzen]

I wrote a script to change ORACLE_HOME at CMD prompt to switch between 9i/10g version.

[17:03:04][Slava@pc:~]
$ type -p oraenv.cmd
/cygdrive/c/WINDOWS/system32/oraenv.cmd
[17:03:11][Slava@pc:~]
$ cat $(type -p oraenv.cmd)
@echo off
rem -----------------------------
rem   Set up Oracle environment
rem -----------------------------

if "(%1)" == "()" goto help
if "(%1)" == "(-h)" goto help
if "(%1)" == "(/h)" goto help
if "(%1)" == "(-?)" goto help
if "(%1)" == "(/?)" goto help

if (%1) == (9i) set ORACLE_HOME=d:\oracle.2.0\client
if (%1) == (10g) set ORACLE_HOME=d:\oracle.2.0\server
set PATH=%ORACLE_HOME%\bin;%PATH%
goto exit

:help
echo Usage: %0 ^<^9i^|^10g^>^

:exit

[17:03:24][Slava@pc:~]
$

Works like this

[C:\]oraenv 9i && echo %ORACLE_HOME% && echo "%@search[sqlplus.exe]"
d:\oracle.2.0\client
"D:\oracle.2.0\client\bin\sqlplus.exe"

[C:\]oraenv 10g && echo %ORACLE_HOME% && echo "%@search[sqlplus.exe]"
d:\oracle.2.0\server
"D:\oracle.2.0\server\bin\sqlplus.exe"

 

[Joachim Rupik]

or you can use:

Oracle Locator Express a small tray utility.

 

[hbar]

Ok, that's pretty cool. Thanks!