Home > Error 6 > Error 6 Initializing Sql Plus Cron

Error 6 Initializing Sql Plus Cron

Contents

Unzip the ODBC Instant Client package, then execute the odbc_update_ini.sh script with Driver Manager installed directory as a command line argument. (For complete syntax, please run "odbc_update_ini.sh" without any command line Blogs Recent Entries Best Entries Best Blogs Blog List Search Blogs Home Forums HCL Reviews Tutorials Articles Register Search Search Forums Advanced Search Search Tags Search LQ Wiki Search Tutorials/Articles Search wants *.msb files1Error 6 initializing SQL*Plus in UNIX1Using Sublime Text 2 Build System with SQL*Plus and Oracle0Unable to update data using SQL*Plus command in shell script0Default username and password for SQL*Plus Re: Error in Running cronjob in Linux Paul M. http://axishost.net/error-6/error-6-initializing.php

I had to explicitly set $ORACLE_HOME path in my script. gopi_20us Programming 2 03-11-2002 06:45 AM All times are GMT -5. Please enter a title. Current through heating element lower than resistance suggests Is [](){} a valid lambda definition? https://community.oracle.com/thread/2312270

Error 6 Initializing Sqlplus Windows

At first cron complained of "sqlplus not found", but when I gave path to sqlplus explicitly I am receiving following errors: Application book_info Script Running, Message file sp1.msb not found Error PATH=.. LEARN MORE Suggested Solutions Title # Comments Views Activity Able to SELECT but not DELETE 4 30 94d just a small ORACLE update query 27 58 48d Extract only part of Can Homeowners insurance be cancelled for non-removal of tree debris?

asked 5 years ago viewed 8731 times active 4 years ago Related 5oracle query - ORA-01652: unable to extend temp segment but only in some versions of sql*plus0SQL*Plus 'crashes' with insert Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the Standard way for novice to prevent small round plug from rolling away while soldering wires to it Why aren't Muggles extinct? Did Umbridge hold prejudices towards muggle-borns before the fall of the Ministry?

Why was Gilderoy Lockhart unable to be cured? Sqlplus Error 6 Initializing Sql*plus Code: env | grep ORACLE Evo2. ORACLE_HOME=... http://www.unix.com/shell-programming-and-scripting/211527-issue-running-unix-process-cron.html To start viewing messages, select the forum that you want to visit from the selection below.

Can Homeowners insurance be cancelled for non-removal of tree debris? one for oracle XE , and the other installation is for oracle middleware –Amro Alfares Jan 15 '15 at 17:00 add a comment| up vote 0 down vote If ORACLE_HOME & sag47 View Public Profile View LQ Blog View Review Entries View HCL Entries View LQ Wiki Contributions Visit sag47's homepage! The time now is 10:55 PM.

Sqlplus Error 6 Initializing Sql*plus

Notices Welcome to LinuxQuestions.org, a friendly and active Linux Community. http://dba.stackexchange.com/questions/47592/message-file-not-found-when-starting-sqlplus E.g. #!/bin/bash # do we have a valid Oracle environment [ "$ORACLE_HOME" = "" ] && . $HOME/.bash_profile ..You can also set the environment in the cron table itself. Error 6 Initializing Sqlplus Windows All Rights Reserved. Sqlplus Oracle_home He has installed Oracle XE 11.2 on Fedora 18.

it should be ORACLE_HOME=/apps/app/oracle/product/10.2/db_1 and not ORACLE_HOME=/apps/app/oracle/product/10.2/db_1/bin Go to Solution 6 Comments LVL 37 Overall: Level 37 Oracle Database 11 Message Active today Expert Comment by:Gerwin Jansen2012-07-14 Try adding ORACLE_HOME his comment is here How do R and Python complement each other in data science? Please turn JavaScript back on and reload this page. Any approximate date we will have Monero wallet with graphical user interface?

When a WebPage (or similar type) uses an ID that matches a breadcrumb ID, why does the WebPage become part of the BreadcrumbList? Why is cell potential defined as E0[Reduction]-E0[Oxidation] and not the reverse? My shell scripts are usually designed to be called through cron and include a section on setting up the PATH and other environment variables. this contact form evo2 View Public Profile View LQ Blog View Review Entries View HCL Entries Find More Posts by evo2 01-05-2015, 10:52 PM #11 santosh0782 Member Registered: Nov 2013 Posts: 132

Shell Programming and Scripting Thread Tools Search this Thread Display Modes

#1 01-01-2013 Oracle_User Registered User Join Date: Feb 2011 Last more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed If ORACLE_HOME is set when running Instant Client applications, it must be set to a directory where Instant Client exists (in this case C:\Oracle\instantclient_11_2).

Re: Error in Running cronjob in Linux 860697 Nov 15, 2011 11:30 AM (in response to Billy~Verreynne) Thanks for your quick reply but nothing works for me...

Thanks Sam ------------------------ To handle yourself, use your head. Forum Operations by The UNIX and Linux Forums MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses Contribute Products BackProducts Gigs Live Careers Vendor Services Groups If so what should it be? LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie [SOLVED] Error with Unix script User Name Remember Me?

Add the directory to the LD_LIBRARY_PATH system environment variable. Does the user you are trying to execute SQL*Plus as have permissions on the directories on $ORACLE_HOME? are also properly set. navigate here Why aren't Muggles extinct?

Train and bus costs in Switzerland Any approximate date we will have Monero wallet with graphical user interface? Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We students who have girlfriends/are married/don't come in weekends...? I do not have $ORACLE_SID path set up.

I now have updated PATH (including the bin directory for Instant Client) and this solved the problem. Using crontab you simply add the environment variables at the top. Topology and the 2016 Nobel Prize in Physics more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile contact us As was mentioned by evo2 the cron environment doesn't source normal user login scripts so all of the environment variables you normally depend on don't exist.

What OS ? Visualize sorting What's the last character in a file? 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 Thanks in advanced. 781Views Tags: none (add) cronjobContent tagged with cronjob, dbaContent tagged with dba, linuxContent tagged with linux This content has been marked as final.

What is the output of the following? Report message to a moderator Previous Topic: Unable to execute shell script from sql Next Topic: About 10g new patch Goto Forum: - SQL & PL/SQLSQL Re: Error in Running cronjob in Linux mseberg Nov 15, 2011 12:15 PM (in response to 860697) Hello; What I do is use a separate .env file : ( Which is One strange thing is happening while running the processes on the new server from CRON file.

Thanks a lot for all your help:-) santosh0782 View Public Profile View LQ Blog View Review Entries View HCL Entries Find More Posts by santosh0782 01-05-2015, 10:17 PM #7