Home > IT Answers > Database > sqlplus killed
Madhavikota
0 pts.
 sqlplus killed
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

Software/Hardware used:
ASKED: November 14, 2005  3:44 AM
UPDATED: November 15, 2005  4:12 AM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  November 14, 2005  4:05 am  by  Posorio   0 pts.
All Answer Wiki Contributors:  Posorio   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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.

Bit4man
 0 pts.
 

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.

Posorio
 0 pts.