Computer Hope

Software => BSD, Linux, and Unix => Topic started by: userj on October 16, 2007, 02:06:41 PM

Title: Basic Unix shell question
Post by: userj on October 16, 2007, 02:06:41 PM

I am working from home, so I use remote connection to the Oracle db hosted on Solaris. I open shell, log in to database and run a stored database procedure (which I wrote, and which runs fine from the office).  The problem is that I get timed out from my shell pretty fast and that (somewhat to my surprise) causes an error in the stored procedure execution. 

My first question is, can my connection actually affect the stored procedure execution?

Second question is more general: Is there any command in Unix to help me kind of say "forget about the connection/shell, you don't need it. Just execute the stored database procedure?"

Thanks a lot!

Title: Re: Basic Unix shell question
Post by: userj on October 17, 2007, 10:05:43 AM

You guys know what "database" is?  ::)

Title: Re: Basic Unix shell question
Post by: michaewlewis on October 17, 2007, 10:48:55 AM

I've never used Oracle... just mysql. and I've never had to remote into another linux box. So I've no clue how to troubleshoot it.... sorry.
Have you checked the obvious yet? like network connection settings and remote access settings?
What distro are you using?
What shell are you using?

Title: Re: Basic Unix shell question
Post by: contrex on October 22, 2007, 03:03:28 AM

Quote from: userj on October 17, 2007, 10:05:43 AM

You guys know what "database" is?  ::)

Do you know what "manners" are?