Page 1 of 1
Error 6 initializing SQL*Plus
Posted: Fri Nov 21, 2008 3:32 am
by svpurna
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.
Posted: Fri Nov 21, 2008 8:28 am
by chulett
Welcome!
If everything was set correctly, this error wouldn't occur. Have you configured your dsenv file correctly for Oracle?
Posted: Sun Nov 23, 2008 11:53 pm
by svpurna
thanks a lot for reply.
I can run the other jobs in this project with the same setup and all.
Posted: Mon Nov 24, 2008 2:38 am
by ArndW
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?
Posted: Mon Nov 24, 2008 2:57 am
by svpurna
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..
Posted: Mon Nov 24, 2008 5:27 am
by ArndW
The same problem, the Oracle settings need to be set in your shell script as well.
Posted: Mon Nov 24, 2008 8:15 am
by chulett
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.