Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: Basic Unix shell question  (Read 5377 times)

0 Members and 1 Guest are viewing this topic.

userj

  • Guest
Basic Unix shell question
« 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!


userj

  • Guest
Re: Basic Unix shell question
« Reply #1 on: October 17, 2007, 10:05:43 AM »
You guys know what "database" is?  ::)

michaewlewis



    Intermediate
  • Thanked: 26
    • Yes
    • Yes
  • Experience: Expert
  • OS: Unknown
Re: Basic Unix shell question
« Reply #2 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?

contrex

  • Guest
Re: Basic Unix shell question
« Reply #3 on: October 22, 2007, 03:03:28 AM »
You guys know what "database" is?  ::)

Do you know what "manners" are?