Error 6 initializing SQL*Plus

svpurna · Post by **svpurna** » Fri Nov 21, 2008 3:32 am

Recently we have migrated our jobs to new server and imported the project to that server. It was running successfully before. Even now we are able to connect to sql but we are getting this error now. We did check for envorinmental variables in the profile and everything is set.

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

Please Help.

chulett · Post by **chulett** » Fri Nov 21, 2008 8:28 am

Welcome!

If everything was set correctly, this error wouldn't occur. Have you configured your dsenv file correctly for Oracle?

svpurna · Post by **svpurna** » Sun Nov 23, 2008 11:53 pm

thanks a lot for reply.

I can run the other jobs in this project with the same setup and all.

ArndW · Post by **ArndW** » Mon Nov 24, 2008 2:38 am

But do the other jobs access ORACLE? It sounds like a dsenv file problem that needs to be corrected by adding the Oracle libraries, paths and environment variables. When you run the job, the ENV settings are displayed. IS "ORACLE_HOME" set there?

svpurna · Post by **svpurna** » Mon Nov 24, 2008 2:57 am

We have used oracle stage in other jobs which are running fine. This particular error is popping up when executing a UNIX script with uses sqlplus..

ArndW · Post by **ArndW** » Mon Nov 24, 2008 5:27 am

The same problem, the Oracle settings need to be set in your shell script as well.

chulett · Post by **chulett** » Mon Nov 24, 2008 8:15 am

Exactly. Your script can make no assumptions about where it is or what environment variables are available. Source your dsenv file in the script or do something to set the proper variables up.