sqlplus killed

Tags:
Database
DB2
Oracle
when i say SQLPLUS at $ prompt it is saying KILLED, hence i could not able to connect to my database. can anybody clear me how to connect to my database

Answer Wiki

Thanks. We'll let you know when a new response is added.

I seem to remember this behaviour when you don’t have the correct environment set up.
$ORACLE_HOME amongst others must be set up.
Talk to your DBA, there should be a script to set up all your necessary environment.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Bit4man
    Sounds to me like a very bad installation. Relink your sqlplus executables. Check your system resources - do you have any memory left? Linux/Unix will start killing off processes randomly if it's out of memory.
    0 pointsBadges:
    report
  • Posorio
    First thing display your environment. I think the "set" command gives you this since, you are probably using a Korn or Bourne shell. Pipe the output to a file and send it back to us. The SQLPLUS is also an alias. I think if you type "alias" you'll have a list of aliases and this should include what SQLPLUS actually points to. It should point to a real executable file under the $ORACLE_HOME/bin directory. I seem to remember having this behaviour when using two versions of Oracle in the same machine. And the environment was not set up correctly, I was using HPUX.
    0 pointsBadges:
    report
  • Madhavikota
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/sqlplus-killed/ (0) Comments Read [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following