* RE: Invoking SQL*Plus from within cygwin
@ 2001-09-19 9:40 Jacob Vennervald Madsen
0 siblings, 0 replies; 11+ messages in thread
From: Jacob Vennervald Madsen @ 2001-09-19 9:40 UTC (permalink / raw)
To: Upat54wo; +Cc: cygwin
If you want to connect to a remote Oracle DB you need NET8 to do so.
Jacob
-----Original Message-----
From: Upat54wo@aol.com [ mailto:Upat54wo@aol.com ]
Sent: 19. september 2001 18:27
To: alecclews@yahoo.com; troy.noble@channelpoint.com
Cc: cygwin@cygwin.com
Subject: Re: Invoking SQL*Plus from within cygwin
The latest good news is sqlplus no longer crashes - I actually get a
password prompt, so I am much closer than before. Thanks for all the
hints.
I do still have a problem, though. I am getting ORA-012560 -
TNS:protocol adaptor error
From my experience on UNIX, I had a registry entry TNS_ADMIN which
contained the path of tnsnames.ora. I don't see any registry or NT
environment variables on the server or client which performs the same
function. I've added both and re-tried but I still receive the same
message.
I don't have Oracle installed on my client. Do I need to have NET8
installed locally? Remember I can run sqlplus from the cmd prompt and
sqlplusw from a shortcut mapped to the server without any problems.
Thanks again for all the help.
In a message dated Wed, 19 Sep 2001 9:05:39 AM Eastern Daylight Time,
"Alec Clews" <alecclews@yahoo.com> writes:
> OK,
>
> Unset all env variables except the path. SQLPLus should pick em up
from the
> Registry OK. I'm geussing it's because SQLPlus cannot grog the cygwin
mount
> point in ORACLE_HOME etc.
>
> Alternative is to set ORACLE_HOME etc using NT notation (not sure
about
> LD_LIBRARY_PATH. Assume you don't need it for SQLPlus
>
> Let me know how you go
>
>
--
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Bug reporting: http://cygwin.com/bugs.html
Documentation: http://cygwin.com/docs.html
FAQ: http://cygwin.com/faq/
--
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Bug reporting: http://cygwin.com/bugs.html
Documentation: http://cygwin.com/docs.html
FAQ: http://cygwin.com/faq/
^ permalink raw reply [flat|nested] 11+ messages in thread
* Re: Invoking SQL*Plus from within cygwin
2001-09-19 9:27 Upat54wo
2001-09-19 9:33 ` Larry Hall (RFK Partners, Inc)
@ 2001-09-19 11:19 ` Dr. Volker Zell
1 sibling, 0 replies; 11+ messages in thread
From: Dr. Volker Zell @ 2001-09-19 11:19 UTC (permalink / raw)
To: Upat54wo; +Cc: cygwin
>>>>> "Upat54wo" == Upat54wo <Upat54wo@aol.com> writes:
Upat54wo> The latest good news is sqlplus no longer crashes - I actually get a password prompt, so I am much closer than before. Thanks for all the hints.
Upat54wo> I do still have a problem, though. I am getting ORA-012560 - TNS:protocol adaptor error
Believe me, if you have setup Oracle in a correct way (see the Oracle documentation)
including Net8 (or whatever version you have) then working from inside a cygwin environment
is no problem. Just be sure to set the following environment before you start your bash shell.
This is what I have:
[503]> env | grep ORA
ORACLE_SID=VZ (needed for local connects)
ORACLE_HOME=C:/oracle/o817 "
[504]> env | grep TNS
TNS_ADMIN=C:/oracle/admin (only needed if you have configured Net8 and have your tnsnames.ora
in an unusual place)
[505]> env | grep LOCAL (not deede at all, but useful sometimes)
LOCAL=vz
Ciao
Volker
--
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Bug reporting: http://cygwin.com/bugs.html
Documentation: http://cygwin.com/docs.html
FAQ: http://cygwin.com/faq/
^ permalink raw reply [flat|nested] 11+ messages in thread
* Re: Invoking SQL*Plus from within cygwin
2001-09-19 9:27 Upat54wo
@ 2001-09-19 9:33 ` Larry Hall (RFK Partners, Inc)
2001-09-19 11:19 ` Dr. Volker Zell
1 sibling, 0 replies; 11+ messages in thread
From: Larry Hall (RFK Partners, Inc) @ 2001-09-19 9:33 UTC (permalink / raw)
To: Upat54wo, alecclews, troy.noble; +Cc: cygwin
Hm, is this issue really Cygwin related? I'm wondering if there isn't a
better forum to take it to. It sounds to me like the remaining issues
have to do with setting up your environment with the proper configuration
that Oracle requires, which is an installation issue that you just happen
to notice with Cygwin. Another more Oracle-specific forum may be more
helpful to you than this one. Just a thought.
Larry Hall lhall@rfk.com
RFK Partners, Inc. http://www.rfk.com
118 Washington Street (508) 893-9779 - RFK Office
Holliston, MA 01746 (508) 893-9889 - FAX
At 12:26 PM 9/19/2001, Upat54wo@aol.com wrote:
>The latest good news is sqlplus no longer crashes - I actually get a password prompt, so I am much closer than before. Thanks for all the hints.
>
>I do still have a problem, though. I am getting ORA-012560 - TNS:protocol adaptor error
>
> >From my experience on UNIX, I had a registry entry TNS_ADMIN which contained the path of tnsnames.ora. I don't see any registry or NT environment variables on the server or client which performs the same function. I've added both and re-tried but I still receive the same message.
>
>I don't have Oracle installed on my client. Do I need to have NET8 installed locally? Remember I can run sqlplus from the cmd prompt and sqlplusw from a shortcut mapped to the server without any problems.
>
>Thanks again for all the help.
>
>In a message dated Wed, 19 Sep 2001 9:05:39 AM Eastern Daylight Time, "Alec Clews" <alecclews@yahoo.com> writes:
>
> > OK,
> >
> > Unset all env variables except the path. SQLPLus should pick em up from the
> > Registry OK. I'm geussing it's because SQLPlus cannot grog the cygwin mount
> > point in ORACLE_HOME etc.
> >
> > Alternative is to set ORACLE_HOME etc using NT notation (not sure about
> > LD_LIBRARY_PATH. Assume you don't need it for SQLPlus
> >
> > Let me know how you go
> >
> >
>
>
>--
>Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
>Bug reporting: http://cygwin.com/bugs.html
>Documentation: http://cygwin.com/docs.html
>FAQ: http://cygwin.com/faq/
--
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Bug reporting: http://cygwin.com/bugs.html
Documentation: http://cygwin.com/docs.html
FAQ: http://cygwin.com/faq/
^ permalink raw reply [flat|nested] 11+ messages in thread
* Re: Invoking SQL*Plus from within cygwin
2001-09-18 16:32 Upat54wo
2001-09-19 6:05 ` Alec Clews
@ 2001-09-19 9:28 ` Reid Thompson
1 sibling, 0 replies; 11+ messages in thread
From: Reid Thompson @ 2001-09-19 9:28 UTC (permalink / raw)
To: Upat54wo, cygwin
Likely obvious, but, you state .profile rather than
.bashrc --- so be sure that you are sourcing your
.profile
--- Upat54wo@aol.com wrote:
> In a message dated Tue, 18 Sep 2001 5:45:48 PM
> Eastern Daylight Time, Alec Clews
> <alecclews@yahoo.com> writes:
>
> > G'Day,
> >
> > This works for me (I'm using W2K). Provding Oracle
> is installed OK it
> > _should_ pick up Oracle_Home from the registry.
> Just make sure you have
> > the correct path set up (do you have multiple
> Oracle Homes?).
>
> I have the following environment variables set in
> bash within my .profile:
>
> ORACLE_HOME=/cygdrive/k/oracle
> ORACLE_SID=fprd
> LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
> PATH=$ORACLE_HOME/bin:$PATH
>
> I have set $ORACLE_HOME and LD_LIBRARY_PATH up as NT
> environment variables using /cygdrvie/k/oracle.
>
> When I look at the registry, though, I see
> ORACLE_HOME referred to as K:\ORACLE (no cygdrive/x)
>
> The K: drive is a mapped drive from the server were
> the database resides. I do not have Oracle
> installed on my client per se.
>
> Any ideas?
>
> > Can you run sqlplus from the NT command prompt
> (cmd.exe)? If the answer
> > is yes then look at any path differences and other
> environment differences.
>
> Yes I can run sqlplus from the dos cmd line.
>
> >
> > Do you get any error mesages from sqlplus when you
> run it?
>
> No messages other than the Dr. Watson box.
>
> >
> > What version of Oracle are you using?
> >
>
> 8.1.7.1.4 for NT
>
> Thanks for the help - I really appreciate it....
>
> > Cheers
> > --
> > Alec Clews, <alecclews@yahoo.com>, Melbourne,
> Australia
> > Fax +61-(3)8621-6920
> http://www.geocities.com/alecclews/
> >
> >
> > Troy Noble wrote:
> >
> > > Did you define ORACLE_HOME in your environment?
> And is your Oracle
> > > bin directory on your PATH when running in bash?
> > >
> > > I've seen the Dr. Watson type error you are
> describing when one of
> > > the two above things wasn't set up properly... I
> can't remember
> > > which. Sorry.
> > >
> > > So check your PATH and make sure ORACLE_HOME is
> defined and that might
> > > do it for you. Can't recall if I had set
> ORACLE_HOME only in my .bashrc
> > > or if I also had to put it in my NT environment
> variables. From quick
> > > inspection, it looks like I did both.
> > >
> > > -----Original Message-----
> > > From: Upat54wo@aol.com [ mailto:Upat54wo@aol.com ]
> > > Sent: Tuesday, September 18, 2001 8:01 AM
> > > To: cygwin@cygwin.com
> > > Subject: Invoking SQL*Plus from within cygwin
> > >
> > >
> > > I have installed the latest and greatest CygWin
> on an NT 4 sp 6. Finally
> > > even got cron to work with the help of the NT
> admins.
> > >
> > > Now I am trying to run Oracle's sqlplus (for NT)
> from within a Cygwin
> > > terminal window and am receive an error which
> produces a Dr. Watson type
> > > dump. I have attached the dump.
> > >
> > > Am I being a bit naive about running an NT
> program under Cgywin? I'd
> > > appreciate someone looking at the dump and
> giving me any insights on getting
> > > this to work. I have shell scripts which help
> to reduce and automate a
> > > DBA's workload, but they all log on to a
> database to perform their work
> > > using sqlplus.
> >
> >
> >
> >
> >
>
_________________________________________________________
> > Do You Yahoo!?
> > Get your free @yahoo.com address at
> http://mail.yahoo.com
>
>
>
> --
> Unsubscribe info:
> http://cygwin.com/ml/#unsubscribe-simple
> Bug reporting: http://cygwin.com/bugs.html
> Documentation: http://cygwin.com/docs.html
> FAQ: http://cygwin.com/faq/
>
__________________________________________________
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
--
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Bug reporting: http://cygwin.com/bugs.html
Documentation: http://cygwin.com/docs.html
FAQ: http://cygwin.com/faq/
^ permalink raw reply [flat|nested] 11+ messages in thread
* Re: Invoking SQL*Plus from within cygwin
@ 2001-09-19 9:27 Upat54wo
2001-09-19 9:33 ` Larry Hall (RFK Partners, Inc)
2001-09-19 11:19 ` Dr. Volker Zell
0 siblings, 2 replies; 11+ messages in thread
From: Upat54wo @ 2001-09-19 9:27 UTC (permalink / raw)
To: alecclews, troy.noble; +Cc: cygwin
The latest good news is sqlplus no longer crashes - I actually get a password prompt, so I am much closer than before. Thanks for all the hints.
I do still have a problem, though. I am getting ORA-012560 - TNS:protocol adaptor error
From my experience on UNIX, I had a registry entry TNS_ADMIN which contained the path of tnsnames.ora. I don't see any registry or NT environment variables on the server or client which performs the same function. I've added both and re-tried but I still receive the same message.
I don't have Oracle installed on my client. Do I need to have NET8 installed locally? Remember I can run sqlplus from the cmd prompt and sqlplusw from a shortcut mapped to the server without any problems.
Thanks again for all the help.
In a message dated Wed, 19 Sep 2001 9:05:39 AM Eastern Daylight Time, "Alec Clews" <alecclews@yahoo.com> writes:
> OK,
>
> Unset all env variables except the path. SQLPLus should pick em up from the
> Registry OK. I'm geussing it's because SQLPlus cannot grog the cygwin mount
> point in ORACLE_HOME etc.
>
> Alternative is to set ORACLE_HOME etc using NT notation (not sure about
> LD_LIBRARY_PATH. Assume you don't need it for SQLPlus
>
> Let me know how you go
>
>
--
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Bug reporting: http://cygwin.com/bugs.html
Documentation: http://cygwin.com/docs.html
FAQ: http://cygwin.com/faq/
^ permalink raw reply [flat|nested] 11+ messages in thread
* Re: Invoking SQL*Plus from within cygwin
2001-09-18 16:32 Upat54wo
@ 2001-09-19 6:05 ` Alec Clews
2001-09-19 9:28 ` Reid Thompson
1 sibling, 0 replies; 11+ messages in thread
From: Alec Clews @ 2001-09-19 6:05 UTC (permalink / raw)
To: Upat54wo, troy.noble; +Cc: cygwin
OK,
Unset all env variables except the path. SQLPLus should pick em up from the
Registry OK. I'm geussing it's because SQLPlus cannot grog the cygwin mount
point in ORACLE_HOME etc.
Alternative is to set ORACLE_HOME etc using NT notation (not sure about
LD_LIBRARY_PATH. Assume you don't need it for SQLPlus
Let me know how you go
---
Alec Clews, <alecclews@yahoo.com>, Melbourne, Australia
Home Page < http://www.geocities.com/alecclews/
> In a message dated Tue, 18 Sep 2001 5:45:48 PM Eastern Daylight Time,
Alec Clews <alecclews@yahoo.com> writes:
>
> >
> > This works for me (I'm using W2K). Provding Oracle is installed OK it
> > _should_ pick up Oracle_Home from the registry. Just make sure you have
> > the correct path set up (do you have multiple Oracle Homes?).
>
> I have the following environment variables set in bash within my .profile:
>
> ORACLE_HOME=/cygdrive/k/oracle
> ORACLE_SID=fprd
> LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
> PATH=$ORACLE_HOME/bin:$PATH
>
> I have set $ORACLE_HOME and LD_LIBRARY_PATH up as NT environment variables
using /cygdrvie/k/oracle.
>
> When I look at the registry, though, I see ORACLE_HOME referred to as
K:\ORACLE (no cygdrive/x)
>
> The K: drive is a mapped drive from the server were the database resides.
I do not have Oracle installed on my client per se.
>
> Any ideas?
>
> > Can you run sqlplus from the NT command prompt (cmd.exe)? If the answer
> > is yes then look at any path differences and other environment
differences.
>
> Yes I can run sqlplus from the dos cmd line.
>
> >
> > Do you get any error mesages from sqlplus when you run it?
>
> No messages other than the Dr. Watson box.
>
> >
> > What version of Oracle are you using?
> >
>
> 8.1.7.1.4 for NT
>
> >
> > Troy Noble wrote:
> >
> > > Did you define ORACLE_HOME in your environment? And is your Oracle
> > > bin directory on your PATH when running in bash?
> > >
> > > I've seen the Dr. Watson type error you are describing when one of
> > > the two above things wasn't set up properly... I can't remember
> > > which. Sorry.
> > >
> > > So check your PATH and make sure ORACLE_HOME is defined and that might
> > > do it for you. Can't recall if I had set ORACLE_HOME only in my
.bashrc
> > > or if I also had to put it in my NT environment variables. From quick
> > > inspection, it looks like I did both.
> > >
> > > -----Original Message-----
> > > From: Upat54wo@aol.com [ mailto:Upat54wo@aol.com ]
> > > Sent: Tuesday, September 18, 2001 8:01 AM
> > > To: cygwin@cygwin.com
> > > Subject: Invoking SQL*Plus from within cygwin
> > >
> > >
> > > I have installed the latest and greatest CygWin on an NT 4 sp 6.
Finally
> > > even got cron to work with the help of the NT admins.
> > >
> > > Now I am trying to run Oracle's sqlplus (for NT) from within a Cygwin
> > > terminal window and am receive an error which produces a Dr. Watson
type
> > > dump. I have attached the dump.
> > >
> > > Am I being a bit naive about running an NT program under Cgywin? I'd
> > > appreciate someone looking at the dump and giving me any insights on
getting
> > > this to work. I have shell scripts which help to reduce and automate
a
> > > DBA's workload, but they all log on to a database to perform their
work
> > > using sqlplus.
> >
> >
> >
> >
> > _________________________________________________________
> > Do You Yahoo!?
> > Get your free @yahoo.com address at http://mail.yahoo.com
>
>
>
> --
> Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
> Bug reporting: http://cygwin.com/bugs.html
> Documentation: http://cygwin.com/docs.html
> FAQ: http://cygwin.com/faq/
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Bug reporting: http://cygwin.com/bugs.html
Documentation: http://cygwin.com/docs.html
FAQ: http://cygwin.com/faq/
^ permalink raw reply [flat|nested] 11+ messages in thread
* Re: Invoking SQL*Plus from within cygwin
@ 2001-09-18 16:32 Upat54wo
2001-09-19 6:05 ` Alec Clews
2001-09-19 9:28 ` Reid Thompson
0 siblings, 2 replies; 11+ messages in thread
From: Upat54wo @ 2001-09-18 16:32 UTC (permalink / raw)
To: alecclews, troy.noble; +Cc: cygwin
In a message dated Tue, 18 Sep 2001 5:45:48 PM Eastern Daylight Time, Alec Clews <alecclews@yahoo.com> writes:
> G'Day,
>
> This works for me (I'm using W2K). Provding Oracle is installed OK it
> _should_ pick up Oracle_Home from the registry. Just make sure you have
> the correct path set up (do you have multiple Oracle Homes?).
I have the following environment variables set in bash within my .profile:
ORACLE_HOME=/cygdrive/k/oracle
ORACLE_SID=fprd
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
PATH=$ORACLE_HOME/bin:$PATH
I have set $ORACLE_HOME and LD_LIBRARY_PATH up as NT environment variables using /cygdrvie/k/oracle.
When I look at the registry, though, I see ORACLE_HOME referred to as K:\ORACLE (no cygdrive/x)
The K: drive is a mapped drive from the server were the database resides. I do not have Oracle installed on my client per se.
Any ideas?
> Can you run sqlplus from the NT command prompt (cmd.exe)? If the answer
> is yes then look at any path differences and other environment differences.
Yes I can run sqlplus from the dos cmd line.
>
> Do you get any error mesages from sqlplus when you run it?
No messages other than the Dr. Watson box.
>
> What version of Oracle are you using?
>
8.1.7.1.4 for NT
Thanks for the help - I really appreciate it....
> Cheers
> --
> Alec Clews, <alecclews@yahoo.com>, Melbourne, Australia
> Fax +61-(3)8621-6920 http://www.geocities.com/alecclews/
>
>
> Troy Noble wrote:
>
> > Did you define ORACLE_HOME in your environment? And is your Oracle
> > bin directory on your PATH when running in bash?
> >
> > I've seen the Dr. Watson type error you are describing when one of
> > the two above things wasn't set up properly... I can't remember
> > which. Sorry.
> >
> > So check your PATH and make sure ORACLE_HOME is defined and that might
> > do it for you. Can't recall if I had set ORACLE_HOME only in my .bashrc
> > or if I also had to put it in my NT environment variables. From quick
> > inspection, it looks like I did both.
> >
> > -----Original Message-----
> > From: Upat54wo@aol.com [ mailto:Upat54wo@aol.com ]
> > Sent: Tuesday, September 18, 2001 8:01 AM
> > To: cygwin@cygwin.com
> > Subject: Invoking SQL*Plus from within cygwin
> >
> >
> > I have installed the latest and greatest CygWin on an NT 4 sp 6. Finally
> > even got cron to work with the help of the NT admins.
> >
> > Now I am trying to run Oracle's sqlplus (for NT) from within a Cygwin
> > terminal window and am receive an error which produces a Dr. Watson type
> > dump. I have attached the dump.
> >
> > Am I being a bit naive about running an NT program under Cgywin? I'd
> > appreciate someone looking at the dump and giving me any insights on getting
> > this to work. I have shell scripts which help to reduce and automate a
> > DBA's workload, but they all log on to a database to perform their work
> > using sqlplus.
>
>
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
--
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Bug reporting: http://cygwin.com/bugs.html
Documentation: http://cygwin.com/docs.html
FAQ: http://cygwin.com/faq/
^ permalink raw reply [flat|nested] 11+ messages in thread
* Re: Invoking SQL*Plus from within cygwin
2001-09-18 8:44 Troy Noble
@ 2001-09-18 14:45 ` Alec Clews
0 siblings, 0 replies; 11+ messages in thread
From: Alec Clews @ 2001-09-18 14:45 UTC (permalink / raw)
To: Troy Noble; +Cc: 'Upat54wo@aol.com', cygwin
G'Day,
This works for me (I'm using W2K). Provding Oracle is installed OK it
_should_ pick up Oracle_Home from the registry. Just make sure you have
the correct path set up (do you have multiple Oracle Homes?).
Can you run sqlplus from the NT command prompt (cmd.exe)? If the answer
is yes then look at any path differences and other environment differences.
Do you get any error mesages from sqlplus when you run it?
What version of Oracle are you using?
Cheers
--
Alec Clews, <alecclews@yahoo.com>, Melbourne, Australia
Fax +61-(3)8621-6920 http://www.geocities.com/alecclews/
Troy Noble wrote:
> Did you define ORACLE_HOME in your environment? And is your Oracle
> bin directory on your PATH when running in bash?
>
> I've seen the Dr. Watson type error you are describing when one of
> the two above things wasn't set up properly... I can't remember
> which. Sorry.
>
> So check your PATH and make sure ORACLE_HOME is defined and that might
> do it for you. Can't recall if I had set ORACLE_HOME only in my .bashrc
> or if I also had to put it in my NT environment variables. From quick
> inspection, it looks like I did both.
>
> -----Original Message-----
> From: Upat54wo@aol.com [ mailto:Upat54wo@aol.com ]
> Sent: Tuesday, September 18, 2001 8:01 AM
> To: cygwin@cygwin.com
> Subject: Invoking SQL*Plus from within cygwin
>
>
> I have installed the latest and greatest CygWin on an NT 4 sp 6. Finally
> even got cron to work with the help of the NT admins.
>
> Now I am trying to run Oracle's sqlplus (for NT) from within a Cygwin
> terminal window and am receive an error which produces a Dr. Watson type
> dump. I have attached the dump.
>
> Am I being a bit naive about running an NT program under Cgywin? I'd
> appreciate someone looking at the dump and giving me any insights on getting
> this to work. I have shell scripts which help to reduce and automate a
> DBA's workload, but they all log on to a database to perform their work
> using sqlplus.
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Bug reporting: http://cygwin.com/bugs.html
Documentation: http://cygwin.com/docs.html
FAQ: http://cygwin.com/faq/
^ permalink raw reply [flat|nested] 11+ messages in thread
* RE: Invoking SQL*Plus from within cygwin
@ 2001-09-18 8:44 Troy Noble
2001-09-18 14:45 ` Alec Clews
0 siblings, 1 reply; 11+ messages in thread
From: Troy Noble @ 2001-09-18 8:44 UTC (permalink / raw)
To: 'Upat54wo@aol.com', cygwin
Did you define ORACLE_HOME in your environment? And is your Oracle
bin directory on your PATH when running in bash?
I've seen the Dr. Watson type error you are describing when one of
the two above things wasn't set up properly... I can't remember
which. Sorry.
So check your PATH and make sure ORACLE_HOME is defined and that might
do it for you. Can't recall if I had set ORACLE_HOME only in my .bashrc
or if I also had to put it in my NT environment variables. From quick
inspection, it looks like I did both.
YMMV,
Troy
-----Original Message-----
From: Upat54wo@aol.com [ mailto:Upat54wo@aol.com ]
Sent: Tuesday, September 18, 2001 8:01 AM
To: cygwin@cygwin.com
Subject: Invoking SQL*Plus from within cygwin
I have installed the latest and greatest CygWin on an NT 4 sp 6. Finally
even got cron to work with the help of the NT admins.
Now I am trying to run Oracle's sqlplus (for NT) from within a Cygwin
terminal window and am receive an error which produces a Dr. Watson type
dump. I have attached the dump.
Am I being a bit naive about running an NT program under Cgywin? I'd
appreciate someone looking at the dump and giving me any insights on getting
this to work. I have shell scripts which help to reduce and automate a
DBA's workload, but they all log on to a database to perform their work
using sqlplus.
Thanks!
--
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Bug reporting: http://cygwin.com/bugs.html
Documentation: http://cygwin.com/docs.html
FAQ: http://cygwin.com/faq/
^ permalink raw reply [flat|nested] 11+ messages in thread
* Re: Invoking SQL*Plus from within cygwin
2001-09-18 7:02 Upat54wo
@ 2001-09-18 8:28 ` Larry Hall (RFK Partners, Inc)
0 siblings, 0 replies; 11+ messages in thread
From: Larry Hall (RFK Partners, Inc) @ 2001-09-18 8:28 UTC (permalink / raw)
To: Upat54wo, cygwin
At 10:00 AM 9/18/2001, Upat54wo@aol.com wrote:
>I have installed the latest and greatest CygWin on an NT 4 sp 6. Finally even got cron to work with the help of the NT admins.
>
>Now I am trying to run Oracle's sqlplus (for NT) from within a Cygwin terminal window and am receive an error which produces a Dr. Watson type dump. I have attached the dump.
>
>Am I being a bit naive about running an NT program under Cgywin? I'd appreciate someone looking at the dump and giving me any insights on getting this to work. I have shell scripts which help to reduce and automate a DBA's workload, but they all log on to a database to perform their work using sqlplus.
>
>Thanks!
I suggest you report this error to Oracle. The dump you sent clearly
indicates that sqlplus.exe crashed while accessing an invalid memory
location. This is a problem with sqlplus.exe, not Cygwin. The fact that
it's visible while using bash is completely coincidental. It's a bug
in sqlplus.exe.
Larry Hall lhall@rfk.com
RFK Partners, Inc. http://www.rfk.com
118 Washington Street (508) 893-9779 - RFK Office
Holliston, MA 01746 (508) 893-9889 - FAX
--
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple
Bug reporting: http://cygwin.com/bugs.html
Documentation: http://cygwin.com/docs.html
FAQ: http://cygwin.com/faq/
^ permalink raw reply [flat|nested] 11+ messages in thread
* Invoking SQL*Plus from within cygwin
@ 2001-09-18 7:02 Upat54wo
2001-09-18 8:28 ` Larry Hall (RFK Partners, Inc)
0 siblings, 1 reply; 11+ messages in thread
From: Upat54wo @ 2001-09-18 7:02 UTC (permalink / raw)
To: cygwin
[-- Attachment #1: Type: text/plain, Size: 626 bytes --]
I have installed the latest and greatest CygWin on an NT 4 sp 6. Finally even got cron to work with the help of the NT admins.
Now I am trying to run Oracle's sqlplus (for NT) from within a Cygwin terminal window and am receive an error which produces a Dr. Watson type dump. I have attached the dump.
Am I being a bit naive about running an NT program under Cgywin? I'd appreciate someone looking at the dump and giving me any insights on getting this to work. I have shell scripts which help to reduce and automate a DBA's workload, but they all log on to a database to perform their work using sqlplus.
Thanks!
[-- Attachment #2: drwtsn32.txt --]
[-- Type: text/plain, Size: 6455 bytes --]
Microsoft (R) Windows NT (TM) Version 4.00 DrWtsn32
Copyright (C) 1985-1996 Microsoft Corp. All rights reserved.
Application exception occurred:
App: exe\sqlplus.dbg (pid=191)
When: 9/18/2001 @ 8:21:11.945
Exception number: c0000005 (access violation)
*----> System Information <----*
Computer Name: KCM50257
User Name: dtj011
Number of Processors: 1
Processor Type: x86 Family 6 Model 8 Stepping 6
Windows Version: 4.0
Current Build: 1381
Service Pack: 6
Current Type: Uniprocessor Free
Registered Organization: KCM
Registered Owner: PCLAB
*----> Task List <----*
0 Idle.exe
2 System.exe
20 SMSS.exe
24 CSRSS.exe
34 WINLOGON.exe
40 SERVICES.exe
43 LSASS.exe
69 SPOOLSS.exe
81 amgrsrvc.exe
93 Mcshield.exe
105 VsTskMgr.exe
96 RPCSS.exe
116 Wuser32.exe
144 clisvcl.exe
158 PSTORES.exe
160 mstask.exe
171 WinMgmt.exe
302 NDDEAGNT.exe
232 EXPLORER.exe
283 systray.exe
314 launch32.exe
292 LOADWC.exe
265 shstat.exe
340 FINDFAST.exe
330 OSA.exe
266 SMSMon32.exe
310 cygrunsrv.exe
218 cron.exe
155 OUTLOOK.exe
312 MAPISP32.exe
227 IEXPLORE.exe
290 CMD.exe
242 bash.exe
286 SMSAPM32.exe
200 Ezsql.exe
311 bash.exe
191 sqlplus.exe
288 DRWTSN32.exe
0 _Total.exe
(00400000 - 00466000) exe\sqlplus.dbg
(77f60000 - 77fbe000) dll\ntdll.dbg
(60400000 - 60506000) dll\oraclient8.dbg
(60600000 - 60686000) dll\oracore8.dbg
(60800000 - 60850000) dll\oranls8.dbg
(77f00000 - 77f5e000) dll\kernel32.dbg
(78000000 - 78040000)
(77dc0000 - 77dff000) dll\advapi32.dbg
(77e70000 - 77ec5000) dll\user32.dbg
(77ed0000 - 77efc000) dll\gdi32.dbg
(77e10000 - 77e67000) dll\rpcrt4.dbg
(77fd0000 - 77ffa000) dll\winmm.dbg
(00230000 - 00236000) dll\oravsn8.dbg
(60200000 - 60265000) dll\oracommon8.dbg
(60000000 - 60122000) dll\orageneric8.dbg
(60a00000 - 60a2b000) dll\oranl8.dbg
(60b00000 - 60ba9000) dll\oran8.dbg
(60e00000 - 60e10000) dll\orancrypt8.dbg
(61100000 - 61137000) dll\oranro8.dbg
(776b0000 - 776c4000) dll\ws2_32.dbg
(776a0000 - 776a7000) dll\ws2help.dbg
(00240000 - 002a1000) dll\orannzsbb8.dbg
(61500000 - 6150e000) dll\oranldap8.dbg
(61700000 - 61720000) dll\oraldapclnt8.dbg
(776d0000 - 776d8000) dll\wsock32.dbg
(77b20000 - 77bd7000) dll\ole32.dbg
(65340000 - 653d2000) oleaut32.dbg
(61900000 - 61906000) dll\oranhost8.dbg
(62100000 - 62106000) dll\oranoname8.dbg
(002b0000 - 002b6000) dll\orancds8.dbg
(62300000 - 62306000) dll\orantns8.dbg
(62500000 - 62508000) dll\orannds8.dbg
(002c0000 - 002c7000) dll\oranms.dbg
(002d0000 - 002e1000) dll\oranmsp.dbg
(62700000 - 62740000) dll\oratrace8.dbg
(62900000 - 62b24000) dll\orapls8.dbg
(63100000 - 63108000) dll\oraslax8.dbg
(60350000 - 60356000) dll\orawtc8.dbg
(63200000 - 63273000) dll\orasql8.dbg
(6bc00000 - 6bc11000) ..\..\bin\i386\free\SMNT40.dll
State Dump for Thread Id 0x12f
eax=004717b0 ebx=780230dd ecx=004717c0 edx=0012d30c esi=00000000 edi=004717c0
eip=004057e7 esp=0012d2a4 ebp=00000001 iopl=0 nv up ei pl nz na po nc
cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000 efl=00000206
function: <nosymbols>
004057ce 90 nop
004057cf 90 nop
004057d0 83ec48 sub esp,0x48
004057d3 53 push ebx
004057d4 55 push ebp
004057d5 8b1d84404500 mov ebx,[00454084] ds:00454084=780230dd
004057db 56 push esi
004057dc 8b35ac1b4600 mov esi,[00461bac] ds:00461bac=00000000
004057e2 57 push edi
004057e3 8b7c245c mov edi,[esp+0x5c] ss:0143bcab=????????
FAULT ->004057e7 f6460301 test byte ptr [esi+0x3],0x1 ds:0130ea06=??
004057eb 743e jz 0040582b
004057ed f60601 test byte ptr [esi],0x1 ds:00000000=??
004057f0 7506 jnz 004057f8
004057f2 f6460101 test byte ptr [esi+0x1],0x1 ds:0130ea06=??
004057f6 7433 jz 0040582b
004057f8 8b4c2460 mov ecx,[esp+0x60] ss:0143bcab=????????
004057fc 8b5620 mov edx,[esi+0x20] ds:0130ea06=????????
004057ff 8d442464 lea eax,[esp+0x64] ss:0143bcab=????????
00405803 50 push eax
00405804 51 push ecx
00405805 52 push edx
*----> Stack Back Trace <----*
FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
00000001 00000000 00000000 00000000 00000000 00000000 sqlplus!<nosymbols>
*----> Raw Stack Dump <----*
0012d2a4 b0 17 47 00 c0 17 47 00 - 01 00 00 00 00 00 00 00 ..G...G.........
0012d2b4 03 00 00 00 40 ba 45 00 - 00 00 00 00 f8 d2 12 00 ....@.E.........
0012d2c4 c8 2b 02 78 d8 d2 12 00 - 29 b9 45 00 0c d3 12 00 .+.x....).E.....
0012d2d4 c0 17 47 00 31 d3 12 00 - d9 ff ff 7f 0c d3 12 00 ..G.1...........
0012d2e4 42 00 00 00 c0 17 47 00 - 00 00 00 00 6c 78 00 00 B.....G.....lx..
0012d2f4 8c d3 12 00 01 00 00 00 - 21 a6 42 00 c0 17 47 00 ........!.B...G.
0012d304 2c b9 45 00 0c d3 12 00 - 4d 65 73 73 61 67 65 20 ,.E.....Message
0012d314 66 69 6c 65 20 53 50 31 - 3c 6c 61 6e 67 3e 2e 6d file SP1<lang>.m
0012d324 73 62 20 6e 6f 74 20 66 - 6f 75 6e 64 2e 00 12 00 sb not found....
0012d334 d0 17 47 00 68 d3 12 00 - 00 00 00 00 00 00 00 00 ..G.h...........
0012d344 01 00 00 00 bb c5 42 00 - b0 28 46 00 38 ba 45 00 ......B..(F.8.E.
0012d354 40 ba 45 00 00 00 00 00 - d9 c5 42 00 b0 17 47 00 @.E.......B...G.
0012d364 40 ba 45 00 00 00 00 00 - 94 00 00 00 94 02 00 00 @.E.............
0012d374 94 03 00 00 94 06 00 00 - 03 00 02 00 02 00 01 00 ................
0012d384 01 00 00 00 00 00 00 00 - 00 00 03 00 03 00 03 00 ................
0012d394 03 00 03 00 03 00 03 00 - 76 06 82 02 2e 2c 2e 2c ........v....,.,
0012d3a4 2c 24 00 00 00 00 00 00 - 00 00 00 00 01 00 00 00 ,$..............
0012d3b4 2d 00 00 00 00 00 00 00 - 00 00 00 00 01 00 00 00 -...............
0012d3c4 2b 00 00 00 00 00 00 00 - 00 00 00 00 01 00 00 00 +...............
0012d3d4 44 44 2d 4d 4f 4e 2d 59 - 59 00 00 00 00 00 00 00 DD-MON-YY.......
^ permalink raw reply [flat|nested] 11+ messages in thread
end of thread, other threads:[~2001-09-19 11:19 UTC | newest]
Thread overview: 11+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2001-09-19 9:40 Invoking SQL*Plus from within cygwin Jacob Vennervald Madsen
-- strict thread matches above, loose matches on Subject: below --
2001-09-19 9:27 Upat54wo
2001-09-19 9:33 ` Larry Hall (RFK Partners, Inc)
2001-09-19 11:19 ` Dr. Volker Zell
2001-09-18 16:32 Upat54wo
2001-09-19 6:05 ` Alec Clews
2001-09-19 9:28 ` Reid Thompson
2001-09-18 8:44 Troy Noble
2001-09-18 14:45 ` Alec Clews
2001-09-18 7:02 Upat54wo
2001-09-18 8:28 ` Larry Hall (RFK Partners, Inc)
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).