Oracle 10g Error 6 Initializing Sql Plus
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and
Error 6 Initializing Sqlplus Unix
policies of this site About Us Learn more about Stack Overflow the how to set oracle_home in unix company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags tns:net service name is incorrectly specified Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only https://community.oracle.com/thread/853565 takes a minute: Sign up How to correctly set the ORACLE_HOME variable on Ubuntu 9.x? up vote 36 down vote favorite 12 I have the same problem as listed here: http://stackoverflow.com/questions/52239/oracle-lost-sysdba-password although I did not lose the password, I entered it twice in the configure script originally, and then when I went to login (localhost:8080/apex, password not accepted. I don't have http://stackoverflow.com/questions/2747462/how-to-correctly-set-the-oracle-home-variable-on-ubuntu-9-x anything in the database, I just want to install and use Oracle-XE. I have tried apt-get removing it twice and reinstalling, but if I try to run /etc/init.d/oracle-xe configure again and I get "Oracle Database 10g Express Edition is already configured" despite the second time removing any folders I could find for Oracle XE. I tried running sqlplus "/ as sysdba" but all I get is: 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 I tried setting the variable via export. (also tried set). Tried: export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus and all the subdirectories of that. Same error every time. What is the ORACLE_HOME supposed to be set to? The only reference I have seen either just say general or say the above up to the version number then "/db_1". I do no thave a db_1. Let me know if you need any clarification. I don't understand what I did wrong in this process. oracle oracle-xe share|improve this question edited May 2 '10 at 9:56 APC 87.3k1384184 asked Apr 30 '1
[message #596761] Thu, 26 September 2013 04:10 shekhar.salunkhe Messages: 154Registered: January 2008 Location: Pune Senior Member Hi All, I have created oracle 11 XE http://www.orafaq.com/forum/t/189652/ .. Once it is created it was running fine. I have worked on that 2 days. Problem is occured when I restart my machine.. I m getting below error: http://oracle-solution.blogspot.com/2014/08/error-6-initializing-sqlplus-sp2-0667.html 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 I have checked the forum in which it error 6 is mentioned that ORACLE_HOME is not properly set. I tried that one alot of time. Even now environment variable shows proper value. Please help me out. Thanks Report message to a moderator Re: Error 6 initializing SQL*Plus [message #596762 is a reply to message #596761] Thu, 26 September 2013 04:17 John Watson Messages: 6471Registered: January 2010 error 6 initializing Location: Global Village Senior Member Please can you show you current settings for the environment variables ORACLE_HOME and PATH? Then the command WHERE SQLPLUS, and the error? Like this:c:\users\john> c:\users\john>echo %ORACLE_HOME% c:\app\oracle\product\12.1.0\dbhome_1 c:\users\john>echo %PATH% c:\app\oracle\product\12.1.0\dbhome_1\bin;C:\app\oracle\product\12.1.0\dbhome_1\bin;C:\app\oracl in\bin;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\Windows\ tem32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\OpenCL SDK\2 Intel\OpenCL SDK\2.0\bin\x64;C:\Program Files\Sony\VAIO Improvement;C:\Program Files (x86)\Sony\ am Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Managem am Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Inte IPT;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files (x86)\Intel\OpenCL SDK\ )\PuTTY;"c:\Program Files\Windows NT\Accessories";C:\Program Files (x86)\Nmap c:\users\john>where sqlplus c:\app\oracle\product\12.1.0\dbhome_1\BIN\sqlplus.exe C:\app\oracle\product\11.2.0\db112\BIN\sqlplus.exe c:\users\john>sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Thu Sep 26 10:16:59 2013 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options orclz>Use a CMD prompt and SQL*Plus, copy paste the results, enclosed within [code] tags Report message to a moderator Re: Error 6 initializing SQL*Plus [message #596773 is a reply to message #596762] Thu, 26 September 2013 05:13 shekhar.salunkhe Messages: 154Registered: January 2008 Location: