Question

Asked on 2010-10-26 at 06:15:28ID: 26792353

SP2-0750

by: hussainkhan22500

Rating8.5Very Good

I have installed new oracle 10g software with database and when  I am trying to open its giving error.
My Oracle_home=C:\oracle\product\10.2.0\db_1
My software is present in C:\Khan\database

C:\Documents and Settings\Administrator>set ORACLE_HOME= c:\oracle\product\10.2.
0\db_1

C:\Documents and Settings\Administrator>echo %ORACLE_HOME%
 c:\oracle\product\10.2.0\db_1

C:\Documents and Settings\Administrator>set ORACLE_SID=oracle10

C:\Documents and Settings\Administrator>echo %ORACLE_SID%
oracle10

C:\Documents and Settings\Administrator>sqlplus "/ as sysdba"
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

C:\Documents and Settings\Administrator>set ORACLE_HOME=c:\khan\database

C:\Documents and Settings\Administrator>sqlplus "/ as sysdba"
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

C:\Documents and Settings\Administrator>set ORACLE_HOME=c:\khan

C:\Documents and Settings\Administrator>sqlplus "/ as sysdba"
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

C:\Documents and Settings\Administrator>sqlplus /nolog
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

  1. How to permanently set numwidth in sqlplus
    Is there a way to permanently set numwidth in sqlplus (not just for the session)? When I login as system and set numwidth to 15 it only keeps it as 15 as long as I'm logged in. If I log out and log back in the reverts back to 10.
  2. Oracle ODP.Net  Setting Null Date
    Using VS2008, c# and ODP.Net(2.111.7.20) In the following procedure a_end_date may or may not be null. If the input string is null, I tried to set a_end_date to null. It is giving error. The same result if I try to set it to dbNull. How do I set null to a date field Thanks Suresh public string InsertOnlin…
  3. Oracle character set
    Hey I need to change character set for my oracle database. What is the general methode to change the oracle database character set for any database.
  4. How & Where to start stdying Oracle 11i Techn…
    Hi Experts, I have around 10 years of experience in IT, All these years I was working through Microsoft Technologies, starting from VC++ to ASP.NET Web apps. Now my company is asking me to switch to Oracle, I am also interested in this switching, I want some help from you all in the following: (1) How to make this swicthing …
  5. Triggers not firing - troubleshooting
    On Oracle 11g Enterprise I have rather large compound triggers that I discovered were not firing this morning (and maybe never were, I'm setting up a new server and the trigger structure worked on the old one), so I created a simpler compound trigger to test: CREATE OR REPLACE TRIGGER "test" FOR INSERT OR DELET…

Solution

Sign up now to view this solution! It's quick, easy, and secure to subscribe. We will return you to this solution, unlocked, when you’re done.

About this Solution
View This Solution - Start Your 30 Day Free Trial
Zone
Troubleshooting
Tags
SP2-0750
Participating Experts
1
Solution Grade
A

Replies

 by: slightwv

Posted on 2010-10-26 at 06:45:55ID: 34786735

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: hussainkhan22

Posted on 2010-10-26 at 07:26:22ID: 34786736

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: slightwv

Posted on 2010-10-26 at 07:30:07ID: 34786737

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: hussainkhan22

Posted on 2010-10-26 at 07:45:06ID: 34786738

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: slightwv

Posted on 2010-10-26 at 08:02:50ID: 34786739

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: hussainkhan22

Posted on 2010-10-26 at 08:29:56ID: 34786740

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: slightwv

Posted on 2010-10-26 at 08:32:35ID: 34786741

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: slightwv

Posted on 2010-10-26 at 08:33:54ID: 34786742

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: hussainkhan22

Posted on 2010-10-26 at 09:27:35ID: 34786743

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: slightwv

Posted on 2010-10-26 at 09:29:50ID: 34786744

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: hussainkhan22

Posted on 2010-10-26 at 09:34:19ID: 34786745

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: slightwv

Posted on 2010-10-26 at 09:46:38ID: 34786746

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: hussainkhan22

Posted on 2010-10-26 at 10:10:59ID: 34786747

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by:

Posted on 2010-10-26 at 10:15:52ID: 34786748

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: hussainkhan22

Posted on 2010-10-26 at 10:27:26ID: 34786749

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: slightwv

Posted on 2010-10-26 at 10:32:30ID: 34786750

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

Stay Connected

Oracle Around the Web

The latest Oracle news, tips, and tricks

Oracle Unveils Netra SPARC T3 Servers

New Carrier-Grade Blade and Rackmount Servers Deliver Better Performance, Density and Power Efficiency for the Communications Industry ...

read more

Oracle fixes 21 flaws in Java SE, Java for Business

Oracle is fixing 21 flaws in its Java SE and Java for Business products in its February critical patch update issued this week ...

read more

Obama’s Silicon Valley “Tech Supper”

Why was he there? Who wasn’t invited and why? What did they talk about? Why was he really there? These are the questions being debated ...

read more

Featured Oracle Experts

slightwv

slightwv has answered more than 2,000 Oracle questions and oversees database management within the U.S. Government. Slightwv

sdstuber

A regular presenter at the Collaborate conference, Oracle developer sdstuber is a top expert in PL/SQL and Oracle 9, 10 and 11. sdstuber

Testimonials

What users are saying about our experts

"The Oracle gurus provide answers, solutions and valuable workarounds"

User: schwertner

"Wow! Excellent, valuable explanation. Hats off to you"

User: aseshu70

"Solution worked fantastic and performs excellent! Thanks heaps"

User: klausbrandlhuber

Top Experts

  1. sdstuber

    2,000

    0 points yesterday

    Profile

BrowseBecome an Expert