Report message to a moderator Re: Error 6 initializing SQL*Plus [message #596774 is a reply to message #596773] Thu, 26 September 2013 05:17 John Watson Messages: 6429Registered: January sag47 View Public Profile View LQ Blog View Review Entries View HCL Entries View LQ Wiki Contributions Visit sag47's homepage! What feature of QFT requires the C in the CPT theorem? Posted by Said Rasel at 22:35 Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: Database Administration, SQLPLUS problem Newer Post Older Post Home Subscribe to: Post Comments (Atom) Search This http://axishost.net/error-6/error-6-initializing-sql-plus-linux.php
How do hackers find the IP address of devices? Does Zootopia have an intentional Breaking Bad reference? Registration is quick, simple and absolutely free. You are currently viewing LQ as a guest. https://community.oracle.com/thread/853565
Are o͞o and ü interchangeable? 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. If so, is there a reference procedure somewhere? Pull up OUI from either home and select the environment tab.
You'll need to relink the Oracle executable files after an OS upgrade (see How to Relink Oracle Database Software on UNIX (Doc ID 131321.1) on MOS). Proof of infinitely many prime numbers Limits at infinity by rationalizing How to cope with too slow Wi-Fi at hotel? I don't have anything in the database, I just want to install and use Oracle-XE. Sp2-0667: Message File Sp1
Like Show 0 Likes(0) Actions 3. Using -njo and -cxjo for family members Trying to create safe website where security is handled by the website and not the user TreePlot does not give a "binary-looking" tree for Why is cell potential defined as E0[Reduction]-E0[Oxidation] and not the reverse? Awesome Inc.
asked 3 years ago viewed 33528 times active 10 months ago Related 5Sqlplus parameterized query via file3Login Problem as SYSDBA ORA-010311sqlplus not working on opensuse1SQLPlus times out when connecting to an Sp2-0750: You May Need To Set Oracle_home To Your Oracle Software Directory Whenever I go to command line and invoke ./sqlplus hr, it comes back with the following error: Error 6 initializing SQL*Plus Message file sp1
Password Linux - Newbie This Linux forum is for members that are new to Linux. http://dba.stackexchange.com/questions/47592/message-file-not-found-when-starting-sqlplus [email protected]:/$ export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0 [email protected]:/$ echo $ORACLE_HOME /usr/lib/oracle/xe/app/oracle/product/10.2.0 [email protected]:/$ /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus "/ as sysdba" Error 6 initializing SQL*Plus Message file sp1
Code: which sqlplus sag47 View Public Profile View LQ Blog View Review Entries View HCL Entries View LQ Wiki Contributions Visit sag47's homepage! his comment is here What's its name? All in all, not very professional. If you'd like to contribute content, let us know. How To Set Oracle_home In Linux
Find More Posts by sag47 View Blog 01-04-2015, 11:11 PM #6 santosh0782 Member Registered: Nov 2013 Posts: 132 Original Poster Rep: Thanks a lot, have modified the script as That ORACLE_HOME path /u01/app/oracle/product/11.2.0 is exactly what's mapped in the offcial oracle-xe-11.2.0-1.0.x86_64.rpm file. –Devy Jun 20 '14 at 21:20 add a comment| up vote 5 down vote You have to set When I try to start sqlplus command I get Code: -bash-4.1$ ./sqlplus /as sysdba Error 6 initializing SQL*Plus SP2-0667: Message file sp1
Enter user-name: /as sysdba Connected to an idle instance. How To Set Oracle Path In Windows Thanks & Regards, Alok Thaker share|improve this answer answered Sep 15 '13 at 9:03 linux_fanatic 2,7962918 $ export ORACLE_HOME=/home/snd/instantclient_12_1 $ export PATH=$ORACLE_HOME/bin:$PATH $ export LD_LIBRARY_PATH=$ORACLE_HOME/lib64 $ sqlplus / as Easiest fix is to add the user to the dba group. –Phil Aug 6 '13 at 18:46 add a comment| 5 Answers 5 active oldest votes up vote 2 down vote
Numerous servers running Oracle 10gr2 on Windows and 10gr2 RAC on Linux4. Is it safe to make backup of wallet? Report message to a moderator Re: Error 6 initializing SQL*Plus [message #596823 is a reply to message #596815] Thu, 26 September 2013 08:22 shekhar.salunkhe Messages: 154Registered: January 2008 How To Set Oracle_home To Your Oracle Software Directory If so, they will need to be set in the cron job too.
If there is, then: setx ORACLE_SID "" Close command prompt and open a new one, double-check that %ORACLE_HOME% and %ORACLE_SID" are unset. 5. 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 Browse other questions tagged sqlplus or ask your own question. navigate here And you must enclose your copy/paste within [code] tags.
What is the difference between SAN and SNI SSL certificates? On many UNIX platforms, LD_LIBRARY_PATH is the appropriate environment variable. Your ORACLE_HOME seems to be incorrectly set: /opt/oracle/112/baza instead of /opt/oracle/112/baza/software . 2. From SAME comand prompt: sqlplus
evo2 View Public Profile View LQ Blog View Review Entries View HCL Entries Find More Posts by evo2 01-05-2015, 10:30 PM #9 santosh0782 Member Registered: Nov 2013 Posts: 132 Menu HomeAboutMy InformationBooksImportant Links HomeMessage file sp1.msb not found Error 6 initializingSQL*Plus Message file sp1.msb not found Error 6 initializingSQL*Plus September 6, 2010June 18, 2011 areda oracle, Unix/LinuxOracle, Unix/Linux Problem: When But I thought that ORACLE_HOME was useless with instant client !? –Stef Sep 15 '13 at 9:11 add a comment| 3 Answers 3 active oldest votes up vote 0 down vote sag47 View Public Profile View LQ Blog View Review Entries View HCL Entries View LQ Wiki Contributions Visit sag47's homepage!
I have worked on that 2 days. Can Homeowners insurance be cancelled for non-removal of tree debris? santosh0782 View Public Profile View LQ Blog View Review Entries View HCL Entries Find More Posts by santosh0782 01-02-2015, 01:33 AM #2 sag47 Senior Member Registered: Sep 2009 Location: Otherwise ODBC manager will be not able to load/find the driver.