This is happening 3rd time with me so I have to
figure out what's wrong . When I issue the givensql first time i get
an error as shown . After that I copy and paste it again and it works second
time . Any clue what should be the reason ? btw, it happens with any sql ..not
just this one .
AK
The only thing that comes to mind is maybe a non-printing character gets
in there and the process of cutting and pasting somehow cleans that
character out. My approach would be to put your SQL in a .SQL file and run
it as a script. See if it happens then. If it does, you can inspect the
Hi!
Yep, I've seen it a lot during trainings, that students are trying to use
arrow characters in sqlplus on unix terminal.
And that leaves non-printable chars into sql command. Copypaste clears them
out.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
You would be getting the TNS protocol adapter error if the instance hasn't been
started -- it is configured to start as a service.
Hemant
At 08:45 AM 19-12-02 -0800, you wrote:
Humm obivioiously Im missing a few brain cells here
Yes, I should know there isnt an exe called connect that would
Only in my office can this happen
Im checking into connecting to the db under the internal account
from a cmd prompt I set oracle_sid=mysid
C: set
oracle_sid=my_sid
C: connect internal
I see cmd issuing
sqlplusw system/password@othersid
So, I add a permanent env_variable called
Are you executing connect internal at the CMD C: prompt ?
Shouldn't it be in the sqlplus prompt ?
See if you've somehow got a CONNECT.BAT file in your path.
If you are executing C: connect internal,
you are probably executing CONNECT.BAT [or CONNECT.EXE
or CONNECT.COM]
Hemant
At 06:39 AM 19-12-02
Humm obivioiously Im missing a few brain cells here
Yes, I should know there isnt an exe called connect that would be native
to the envioriment outside of oracle.
Yes, there was a connect.bat in the path
Duh...
Ok, so lets see how many more vacant brain cells I have
now if I log on to
