Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

[Solved] OraclSP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting [Solved] OraclSP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
# 1  
Old 06-19-2012
[Solved] OraclSP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
Code:
rflow@ucabclg1pp]netech$ sqlplus
Error 6 initializing SQL*Plus
Message file sp1.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

Smilie
while connecting to database i am getting the above error.

---------- Post updated at 08:49 AM ---------- Previous update was at 08:48 AM ----------

This error can be rectified by adding the ORACLE_HOME in your .profile file .

Code:
stty erase ^H
stty erase ^?
HOST=`hostname`

export ORACLE_HOME=/s00/oracle/product/9.2.0

Moderator's Comments:
Mod Comment Please use next time code tags for your code and data
Last edited by radoulov; 06-19-2012 at 11:00 AM.. Reason: Marked as solved.
# 2  
Old 06-19-2012
Don't forget to set ORACLE_SID too.
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. AIX

How to set owner and permission for files/directory in directory in this case?

Hi. My example: I have a filesystem /log. Everyday, log files are copied to /log. I'd like to set owner and permission for files and directories in /log like that chown -R log_adm /log/* chmod -R 544 /log/*It's OK, but just at that time. When a new log file or new directory is created in /log,... (8 Replies)
Discussion started by: bobochacha29
8 Replies

2. UNIX for Dummies Questions & Answers

[Solved] Replace first two set of space(s) with tab

My data is jumbled up in the following way. I want to replace only the first two occurrences of space sets (may be a single space also) in every line with a single tab, please help. I want to be able to import the tab delimited columns into excel. Input a b c d e f g h i line1 j k ... (1 Reply)
Discussion started by: gina.lizar
1 Replies

3. UNIX for Dummies Questions & Answers

[SOLVED] How to set a default of 200000 as scrollback size in Putty ?

Putty release : 0.61 For saved sessions , you can configure Scrollback size just once using "Lines of Scrollback" in the 'Window' menu For a non-saved session (an ad-hoc session ) , If you want a higer scrollback size for a putty session , you have to set the "Lines of Scrollback" manually... (4 Replies)
Discussion started by: kraljic
4 Replies

4. Solaris

How to set password for vnc software installed in windows machine?

i want user to prompt for password when ever he tries to login into solaris box using vnc software. is it possible.. each time the user tries to access a solaris box should be prompted for password. and each user can set his own password for his session? if all the above are possible which... (3 Replies)
Discussion started by: chidori
3 Replies

5. UNIX for Advanced & Expert Users

Free UNIX software with oracle

Hi Friends, is there any site for download the UNIX operating system with Oracle database. if yes, Please send me the link for download the free Oracle software in UNIX environment. Thanks MPS (1 Reply)
Discussion started by: psiva_arul
1 Replies

6. UNIX for Dummies Questions & Answers

ORACLE_HOME environment variable not set!

hi, i am new to perl: os : Linux i wrote simple perl script to select from table i am getting this error and how to set ORACLE_HOME environment variable : script: #!usr/bin/perl use DBI; use Mail::Sendmail; #use Date::Calc; use MIME::QuotedPrint; use HTML::Entities; use POSIX... (2 Replies)
Discussion started by: prakash.gr
2 Replies

7. Shell Programming and Scripting

Help to set the oracle environment????

Hi, I am trying to set the environment for my oracle database. I have 5 database in an unix box. My idea is to create 5 files for each database with the following script on it. After logging into the unix box ...just by typing the database name....the enviornment for the database... (2 Replies)
Discussion started by: castlerock
2 Replies

8. UNIX for Dummies Questions & Answers

How can i set up Software disk mirroring(Raid1) in SCO 5.0.5 with two SCSI harddisk ?

thank u very much, (1 Reply)
Discussion started by: coralsea
1 Replies
Login or Register to Ask a Question