Error 6 Initializing Sql Plus Cron
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without error 6 initializing sqlplus windows it enabled. Please turn JavaScript back on and reload
Sqlplus Error 6 Initializing Sql*plus
this page. Please enter a title. You can not post a blank message. Please type sqlplus oracle_home your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 6 Replies Latest reply on Nov 15, 2011 12:20 PM by meser Error in Running cronjob in Linux 860697 Nov 15, 2011 6:30 AM I am trying to execute a stored procedure from a shell script. My script is like this #!/bin/sh ORA_USER=plsql ORA_PASS=oracle /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus -s /nolog << EOF connect $ORA_USER/$ORA_PASS exec insert_cron_test; exit; EOF; When I run this script from terminal it works fine.But when I add this in a cronjob it gives the following error:- Error 6 initializing SQL*Plus Message file sp1
Scripting Unix shell scripting - KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and shell scripts and shell scripting languages here. Search Forums Show Threads Show Posts Tag Search Advanced Search Unanswered Threads Find All Thanked Posts Go to Page... learn linux and unix commands - unix shell scripting Issue Running UNIX process from CRON !! Shell Programming and Scripting Thread Tools Search this Thread Display Modes #1 01-01-2013 Oracle_User Registered User Join Date: Feb 2011 Last Activity: 17 May 2013, 4:17 AM EDT Posts: 21 Thanks: 3 Thanked 0 Times in 0 Posts Issue Running UNIX process from CRON !! Experts, https://community.oracle.com/thread/2312270 Not sure whether the problem described here is related with Unix or is it with Oracle Installation. Here is the description of the issue: A new Unix server is setup as a part of Unix and Oracle upgradation activity for one of the Application, I work on. One strange thing is happening while running the processes on the new server from CRON file. The CRON is kicking the process but not able to complete it. Unlike http://www.unix.com/shell-programming-and-scripting/211527-issue-running-unix-process-cron.html it is giving the below message: Code: sqlplus: Command not found However, running the process manually is working fine (ORACLE_HOME, ORACLE_SID and PATH is working fine). I further digged the issue and found as below: Code: Error 6 initializing SQL*Plus SP2-0667: Message file sp1
HCL Search Reviews Search ISOs Go to Page... LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie [SOLVED] Error with Unix script User Name Remember http://www.linuxquestions.org/questions/linux-newbie-8/error-with-unix-script-4175529782/ Me? Password Linux - Newbie This Linux forum is for members that http://stackoverflow.com/questions/18643085/error-6-initializing-sqlplus-in-unix are new to Linux. Just starting out and have a question? If it is not in the man pages or the how-to's this is the place! Notices Welcome to LinuxQuestions.org, a friendly and active Linux Community. You are currently viewing LQ as a guest. By joining our community you will error 6 have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today! Note that registered members see fewer ads, and ContentLink is completely disabled once you log in. Are you new to LinuxQuestions.org? Visit the following links: Site Howto | Site FAQ error 6 initializing | Sitemap | Register Now If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here. Having a problem logging in? Please visit this page to clear all LQ-related cookies. Introduction to Linux - A Hands on Guide This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and getting started guide, with exercises at the end of each chapter. For more advanced trainees it can be a desktop reference, and a collection of the base knowledge needed to proceed with system and network administration. This book contains many real life examples derived from the author's experience as a Linux system and network administrator, trainer and consultant. They hope these examples will help you to get a better understanding of the Linux system and that you feel encouraged to try out things on your own. Click Here to receive this Complete Guide absolutely free. Page 1 of 2 1 2 > Search this Thread 01-02-2015, 12:44 AM #1 santosh0782 Membe
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error 6 initializing SQL*Plus in UNIX up vote 1 down vote favorite I am getting the belwo mentioned error while trying to open sqlplus from UNIX server. 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 Please advise. sqlplus share|improve this question asked Sep 5 '13 at 18:03 Jai 3115 possible duplicate of How to correctly set the ORACLE_HOME variable on Ubuntu 9.x? –user2062950 Sep 5 '13 at 18:11 add a comment| active oldest votes Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook. Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Browse other questions tagged sqlplus or ask your own question. asked 3 years ago viewed 1224 times Related 4EXPORT AS INSERT STATEMENTS: But in SQL Plus the line overrides 2500 characters!2Error 6 Initializing SQL*Plus0SQL*PLUS SET Command0SQL*Plus 'crashes' with insert query on remote connection5How to install SQLPLUS (Oracle DB API) on Windows 20082sqlplus fails to start. wants *.msb files0Default username and password for SQL*Plus in Ubuntu 14.04?0How to download sqlplus for running sql commands in windows 8?0oracle 11g - sql plus not opening after installing oracle 11g-2getting error 'invalid username /password ; login denied ' while connecting to database from sql plus Hot Network Questions Is it permitted to not take Ph.D. students who have girlfriends/are married/don't come in weekends...? Can Homeowners insurance be cancelled for non-removal of tree debris? Which news about the second Higgs mode (or the mysterious particle) anticipated to be seen at LHC around 750 GeV? Does Zootopia have an intentional Breaking Bad reference? Standard way for novice to prevent small round plug from